Google Apps Script
Follow
Find
63.8K views | +33 today
Google Apps Script
The GAS: All things related to Google Apps Script including examples, news and snippets
Curated by Martin Hawksey
Your new post is loading...
Your new post is loading...
Scooped by Martin Hawksey
Scoop.it!

Analyzing site content with Google Apps Script - Excel Liberation

Analyzing site content with Google Apps Script - Excel Liberation | Google Apps Script | Scoop.it
"One the things I wanted to play around with was visualizing this site content with d3. But first I needed to create something which would generate data from the site (any domain site actually). It's easy enough to modify for non-domain sites but I'm starting with domains, since that's what I have."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Down with file attachments! Hail to the Google Docs API update

Down with file attachments! Hail to the Google Docs API update | Google Apps Script | Scoop.it
With massively refreshed Google Docs/Drive APIs, use JavaScript to integrate to your heart's content, create new apps
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Creating a 'full fat' RSS feed for Google Gmail labels (enabling some dark social judo)

Creating a 'full fat' RSS feed for Google Gmail labels (enabling some dark social judo) | Google Apps Script | Scoop.it

In this post I want to cover three things. First I want to introduce a little app I’ve developed which allows you to create a RSS feed for any of your Gmail labels (with the option to remove certain links – useful if you don’t want others unsubscribing you from mailing lists). Secondly I explain how it was made and how you can use it yourself. Finally I want to discuss how this could be used in an open course environment, utilising the vast processing power from services like Twitter and reusing there target marketing emails to your benefit with a bit of ‘dark social judo’.

more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Digest authentication and Google Apps Script

Digest authentication and Google Apps Script | Google Apps Script | Scoop.it

"The other day I was looking around for an example of how to do digest authentication in Google Apps Script (or even plain javascript). I found plenty of theoretical discussions on it, but no actual examples. So here's an implementation walkthrough. ...

What is Digest AuthenticationWorking with GAS, you'll probably be more familiar with oAuth2, which is supported well through the UrlFetchApp class. However some APIS still use Basic authentication, or the slightly more secure Digest Authentication"
Via brucemcpherson
more...
brucemcpherson's curator insight, May 21, 2013 7:03 PM

The other day I was looking around for an example of how to do digest authentication in Google Apps Script (or even plain javascript). I found plenty of theoretical discussions on it, but no actual examples. So here's an implementation walkthrough and code.

Scooped by Martin Hawksey
Scoop.it!

Bruce Mcpherson - Google+ - Google Apps Script. Html service is now 20 times faster!! …

Bruce Mcpherson - Google+ - Google Apps Script. Html service is now 20 times faster!! … | Google Apps Script | Scoop.it
Google Apps Script. Html service is now 20 times faster!!

A few weeks ago I published a post where I had noticed that html service running cajoled code…
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Sergii Kauk - Google+ - What's new in Google Apps Script? #io13

Sergii Kauk - Google+ - What's new in Google Apps Script? #io13 | Google Apps Script | Scoop.it
Pre #io13 Apps Script community member Sergii Kauk has been digging around the Script Editor for new features. Here's what he's discovered so far: "Seems like #io13 will bring us a few cool features. There're DriveApp (with MimeType companion) and FormApp top-level objects already as well as something called BigNumber. In File menu you'll find "Upgrade authorization experience" command which turns authorization flows to OAuth 2. Finally, in doPost event object there's a new key called "postData" which I personally find one of the most interesting because it finally solves that nasty issue #2158 and makes GAS pretty handy for Glass development."
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Mashing up electoral data from scraperwiki - Google Apps Script version

Mashing up electoral data from scraperwiki - Google Apps Script version | Google Apps Script | Scoop.it

Google apps script version of a VBA version of an original mashup of scraperwiki electoral data, mysociety api and openrefine.


Via brucemcpherson
more...
brucemcpherson's curator insight, May 7, 2013 1:26 PM

A Google Apps Script version of a VBA implementation of a post by Tony Hirst on his oUseful blog where he nicely laid out how mashup Open refine plus various APIs to research which candidates were standing for election in the wards in which they live.

Scooped by Martin Hawksey
Scoop.it!

New Question Types in Google Forms and integration with Google Apps Script planned

New Question Types in Google Forms and integration with Google Apps Script planned | Google Apps Script | Scoop.it

"If you're wondering what's next for Google Forms, the source code reveals that Google will add support for rich-text editing, embedding images and that Google Forms will integrate with Fusion Tables and Google Scripts (codename "maestro")."

Martin Hawksey's insight:

HT +Kyle Beatty

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Will Welch - Google+ - I/O Sessions were just published... Looks like updates to apps script to allow more use with forms, drive, and docs

Will Welch - Google+ - I/O Sessions were just published... Looks like updates to apps script to allow more use with forms, drive, and docs | Google Apps Script | Scoop.it
I/O Sessions were just published... Looks like there might be updates to apps script to allow more use with forms, drive, and docs.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Andrew Stillman - Google+ announces studentPageCreator

Andrew Stillman - Google+ announces studentPageCreator | Google Apps Script | Scoop.it
"+Sean Beaverson Inspired me to finally write this script -- can't think of a clever name or an imaginitive GIF yet -- with the working name studentPageCreator"
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Neo4j Blog: Gmail Email analysis with Neo4j - and spreadsheets

Neo4j Blog: Gmail Email analysis with Neo4j - and spreadsheets | Google Apps Script | Scoop.it

"In this blog post, we’ll take a look at how we can actually use Romain’s [Gmail Meter] output, and generate a neo4j database that will allow us to visually and graph-ically explore the email traffic in our gmail inboxes - without doing doing any coding of course"

more...
luiy's curator insight, April 27, 2013 2:33 PM

A bunch of different graphistas have pointed out to me in recent months that there is something funny about Graphs and email. Specifically, about graphs and email analysis. From my work in previous years at security companies, I know that Email Forensics is actually big business. Figuring out who emails whom, about what topics, with what frequency, at what times - is important. Especially when the proverbial sh*t hits the fan and fraud comes to light - like in the Enron case. How do I get insight into email traffic? How do I know what was communicated to who? And how do I get that insight, without spending a true fortune?

So a couple of days ago I came across an article or two that features Gmail Meter. This is of course not one of these powerful enterprise-ready forensics tools, but it is interesting. Written by Romain Vialard, it provides you with a really straightforward way to get all kinds of stats and data about your use of Gmail. It does so using a Google Apps Script, that is available to anyone using Google Docs’ spreadsheet functionality. In this blog post, we’ll take a look at how we can actually use Romain’s output, and generate a neo4j database that will allow us to visually and graph-ically explore the email traffic in our gmail inboxes - without doing doing any coding of course. Because I don’t know how to do that - but I do do spreadsheets, as you know by now.
Scooped by Martin Hawksey
Scoop.it!

[Event] GDG London: Google Apps Scrip Wed, 17 April, 6:30 PM BST

"Join GDG London in Skills Matter on April 17th to discover how to use Google Apps Script to extend Google Apps, with a talk from Google's Arun Nagarajan.

Google Apps Script is a cloud based JavaScript environment which allows you to write powerful applications and workflows to automate, extend and integrate with Google Apps such as Gmail, Docs, Drive, Sheets and more. The development is entirely within a browser and its free and easy to get started. Come learn all the capabilities of Google Apps Script and walk away being able to write your first script."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Excel Liberation.: Google Apps Script "execution time exceeded" woes

"I'm a big fan of Google Apps Script, but I'm really fed up of seeing "Execution time exceeded". Obviously data access times can be unpredictable, and although it can be improved through caching it's never going to be as good as a local Excel Workbook. But once you have the data loaded, how about processing speeds - shouldn't that be comparable ?"

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Google Apps Script for automation of small tasks | Nimble Gecko

" My goal was simple – get a search results page from seek.com.au, load it as DOM, run a CSS select to find the element that I need and write the value of that element into a spreadsheet that I use for tracking/analysis."
more...
brucemcpherson's curator insight, May 29, 2013 6:57 AM

very straightforward intro to scraping with GAS

Scooped by Martin Hawksey
Scoop.it!

Google Apps Script Playlist for I/O Presentations, Unscripted sessions and other videos

Google Apps Script Playlist for I/O Presentations, Unscripted sessions and other videos | Google Apps Script | Scoop.it

"Recordings of Google Apps Script office hours, I/O presentations, and other videos for developers."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Chris Raymond - Google+ QuizPresenter - Google Apps Script in Education

Chris Raymond - Google+ QuizPresenter - Google Apps Script in Education | Google Apps Script | Scoop.it

"The goal is to make a test component that pulls questions from a bank based on tags and assigned student.  You can make questions from a UI or in the spreadsheet.  I think with the hints, answers, reference, explanation widgets I'm (will) building, it will still be better than what can be built in the new FormApp tools. Please offer feedback or let me know if someone has already built a tool like this."

more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Playing with Google Docs sidebar using Google Apps Script

Playing with Google Docs sidebar using Google Apps Script | Google Apps Script | Scoop.it
The Google Apps Script team have recently announced a host of new features. The three that caught my eye were: Script editor added to Google Docs and Forms Addition of the Forms Service which lets ...
Martin Hawksey's insight:

Thought I'd try out sidebar in Google Docs by replicating the MS Word Navigation Pane/Document Map. Didn't get jump navigation to work but reckon with a bit of jQuery I could get it to change document structure. Useful to find the current limitations.

more...
brucemcpherson's curator insight, May 19, 2013 4:42 AM

it's only onlybeen available for 2 days, and already Martin Hawksey has fiddled with it... ;)

Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: New Apps Script features at Google I/O—again!

Google Apps Developer Blog: New Apps Script features at Google I/O—again! | Google Apps Script | Scoop.it
This Wednesday is the start of our annual developer conference, Google I/O, and we can’t wait to share a bunch of new features that will help developers do more with Apps Script. So let’s not wait!
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

+Peter Herrmann Apps Script Tip: Use Alt or Option key + Up/down arrow to move a line in script editor

+Peter Herrmann Apps Script Tip: Use Alt or Option key + Up/down arrow to move a line in script editor | Google Apps Script | Scoop.it
In the IDE, Option - Up/down arrow (Alt - up/down arrow on Windows) moves a line up or down the screen.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Tapping the rhizomes of dotlife: Creating an RSS search feed for Scoop.it posts with Google Apps Script

Tapping the rhizomes of dotlife: Creating an RSS search feed for Scoop.it posts with Google Apps Script | Google Apps Script | Scoop.it
Ready for a ramble? In this post I take you on a journey from my dotbirth, RSS feeds, Chrome Apps, touching upon how I created an RSS feed for Scoopit searches, before kicking the 'Tin Can'
more...
No comment yet.
Rescooped by Martin Hawksey from iGeneration - 21st Century Education
Scoop.it!

Using FormMule and Google Apps to Mark a Quiz

This video describes the process to use the FormMule script to mark a Google Apps Ninja quiz and have the quiz results mailed directly to the student and/or ...

Via Tom D'Amico (@TDOttawa)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: How Apps Script Makes Classroom Observation Quicker and Easier

Recently, Justin Marckel, the assistant principal at Cornatzer Elementary School in North Carolina, asked for help in modifying one of my existing Apps Script examples.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Ivan Kutil - Google+ - Deprecated UiApp widgets (Google Apps Script)

Ivan Kutil - Google+ - Deprecated UiApp widgets (Google Apps Script) | Google Apps Script | Scoop.it
Deprecated UiApp widgets (15.4.2013) - DeckPanel - DecoratedPopupPanel - DockLayoutPanel - DockPanel - StackLayoutPanel, - TabLayoutPanel,
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Geek Out Webinar: Using Google App Scripts and Spreadsheets to Analyze Canvas Usage Data

Friday, April 26, 2013 
8 a.m. PDT / 11 a.m. EDT


Martin Hawksey of Jisc CETIS started playing around with discussion usage data in Canvas when he was participating in the Learning Analytics course in Canvas Network. Using Google's cloud scripting service Google Apps Script,  free for Google Apps and Google account users, he could dig deep into the data and start doing some interesting (and valuable) analysis all from the comfort and familiarity of a spreadsheet.

 

Join us for this free 50-minute technical webinar on Friday, April 26th as Martin details his experience using the Canvas APIs and walks through building scripts to get meaningful Canvas data using Google Apps Script and the Canvas APIs.

Martin Hawksey's insight:

If any of you use Canvas by Instructure (or even just Learning Analytics in general) you might want to tune into this webinar I'm giving on next Friday (26th April) at 4pm BST (8am PDT/11amEDT). In Apps Script terms it won't be too advanced (mainly URLfetch and data reshaping) but might give you some ideas for what you can do in your own organisation.

more...
No comment yet.
Suggested by Shunmugha Sundaram
Scoop.it!

How to Create Your Own Twitter Scheduler with Google Apps Script

How to Create Your Own Twitter Scheduler with Google Apps Script | Google Apps Script | Scoop.it
Learn how to use Google Apps Script to create your own Twitter Scheduler for free. Schedule and send tweets to followers automatically from your Profile.
more...
No comment yet.