Google Apps Script
Follow
Find
63.7K views | +25 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!

Extensions, Add-Ons and Apps, Oh My! How to Utilize Google in Your Classroom - EdSurge

Extensions, Add-Ons and Apps, Oh My! How to Utilize Google in Your Classroom - EdSurge | Google Apps Script | Scoop.it
Google Apps for Education has totally transformed the way we teach and communicate inside and outside of the classroom.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Parallel process orchestration with HtmlService in Google Apps Script - Desktop Liberation

Parallel process orchestration with HtmlService in Google Apps Script - Desktop Liberation | Google Apps Script | Scoop.it

"Here's a framework for automating parallel processing with Google Apps Script. You can do Map/reduce operations, beat the 6 minute limit, and simulate multiuser activity and watch progress in real time. "

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

How To: Get Email Notifications When Any Google Document is Updated

How To: Get Email Notifications When Any Google Document is Updated | Google Apps Script | Scoop.it
Learn how to get automatic email notifications when any shared Google document has been updated or edited by someone.
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Do something in 5 with gas 4- Get your analytics profiles to a spread…

Another in the 'do something useful with Google Apps Script' series. This time you'll see how to use the Analytics service and use exponential backoff to mitig…

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

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet)

TwtrService Example: EasyTweetSheet (lets you send tweets from Google Sheet) | Google Apps Script | Scoop.it
Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.
Martin Hawksey's insight:

Following the publication of TwtrService (Google Apps Script client library for Twitter) here's a basic Google Sheet template we use at +ALT to draft tweets we send during events (instead of just sending them on a schedule we have to control to click a link to send)

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

Do something in 5 with gas 3-simple invoicing app

quick 5 minute tutorial. join multiple databases and create personalized email invoices with google apps script

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

A Google Apps Script to make a QR code for every document in a Google Drive Folder

A Google Apps Script to make a QR code for every document in a Google Drive Folder | Google Apps Script | Scoop.it
" Someone shared this on G+ the other day, and I thought it was really wonderful. Just make a copy of this spreadsheet and you will be able to designate a Google Drive folder to pull from in order to create a QR code for every document in that folder."
Martin Hawksey's insight:
Given the number of files I have in some folders this may time out for me ;)
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Call for Google Apps Script 5 minute tutorials

Call for Google Apps Script 5 minute tutorials | Google Apps Script | Scoop.it
Bruce McPherson: "I'm looking for your submissions to this series.. Anybody want to do a tutorial on something useful you can do in 5 minutes with apps script ?" 
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google Apps Developer Blog: Introducing Add-ons for Google Forms

" Google Forms is a free and simple way to collect information — from quickly polling your friends about who'll be attending your trip to the haunted hayride, to getting thousands of responses to an awareness survey for work. Over the last few months, Forms has been getting a bunch of updates to help you make good looking surveys, like new theme choicesand the ability to create your own personalized themes. To give you even more flexibility and options, we’re introducing add-ons for Forms—new tools, created by developer partners, that deliver even more features to your surveys (just like add-ons for Docs and Sheets)."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Apps Script BetterLog tip: Highlight error rows by using Format > Conditional formatting

Apps Script BetterLog tip: Highlight error rows by using Format > Conditional formatting | Google Apps Script | Scoop.it
BetterLog tip: Highlight error rows by using Format > Conditional formatting
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Do something useful in 5 mins with Google Apps Script ... integrate with Parse.com

Do something useful in 5 mins with Google Apps Script ... integrate with Parse.com | Google Apps Script | Scoop.it
"Here's 2nd in 'do something useful in 5 mins with Google Apps Script'. The first was about how to use a spreadsheet as a database. In case you've got fed up with that by now, here's how to graduate to using a parse.com backend."
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Do something in 5 minutes with gas 1-use spreadsheet as database

Here's one in a series of tutorials where you can do something useful from scratch in 5 minutes using Google Apps Script. This example shows how to use a Googl…

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

Need a better Twitter Archiving Google Sheet? TAGS v6.0 is here!

Need a better Twitter Archiving Google Sheet? TAGS v6.0 is here! | Google Apps Script | Scoop.it
Amazing to think the TAGS (Twitter Archiving Google Sheet) has been going for over 4 years now. Version 6 is a major code rewrite and the most important new feature is a better setup processes. Re...
Martin Hawksey's insight:

More news about the TwtrService library used in this project to follow

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

Getting Started with Google Apps Script

This is a live broadcast of a session of Apps Edu Certified Trainers discussing and sharing resources about Google Apps Script. Focus will be on understandin...
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

A new tab in GAS project properties Scopes

A new tab in GAS project properties Scopes | Google Apps Script | Scoop.it
A new tab in GAS project properties Scopes
Martin Hawksey's insight:

Via +Ivan Kutil

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

Time-consuming tasks and Google Apps Script Add-ons - Google Apps Script Examples

Time-consuming tasks and Google Apps Script Add-ons - Google Apps Script Examples | Google Apps Script | Scoop.it
"It is very easy to overcome that limit, simply by going back and forth between the server and the client side in your add-on. ...."
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Do something useful in Apps Script 5. Get your analytics pageviews to…

Here's how to build on previous tutorials to get your Google Analytics PageView data into a Spreadsheet.

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

Orange Coding: GmailSearchBuilder - A Google Apps Script Library

Orange Coding: GmailSearchBuilder - A Google Apps Script Library | Google Apps Script | Scoop.it
A Google Apps Script service for building Gmail search queries
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Awesome Table + Templates = more awesomeness - Google Apps Script Examples

Awesome Table + Templates = more awesomeness - Google Apps Script Examples | Google Apps Script | Scoop.it

"Awesome Table lets you easily display data from a Google Sheet in many different ways. You can even put some HTML tags in your spreadsheet cells to create beautiful views of those data and display a nice People Directory, Job Board, Training Offering or whatever list you need to display on a site."

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

Free Technology for Teachers: How to Enable and Set Limits on Your Google Forms

Free Technology for Teachers: How to Enable and Set Limits on Your Google Forms | Google Apps Script | Scoop.it
" FormLimiter allows you to set a time for a form to automatically stop accepting responses. You can also use FormLimiter to set a limit on number of responses a form will accept."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

New Google Apps Script Add-on: g(Math) for Forms

New Google Apps Script Add-on: g(Math) for Forms | Google Apps Script | Scoop.it

"g(Math) for Forms has the same functionality as g(Math) for Docs and Sheets. You can create math expressions, graphs, and statistical displays and insert them directly into your Form questions."

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

Use Google Sheets for Multilingual Chat with Speakers of Different Languages

Use Google Sheets for Multilingual Chat with Speakers of Different Languages | Google Apps Script | Scoop.it
Break down the language barrier and have multi-lingual chats with speakers of different languages inside a simple Google Spreadsheet.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

TwtrService: A Twitter API client library for Google Apps Script

The TwtrService library for Google Apps Script centrally stores your Twitter access details allowing them to accessed from multiple script projects without the need for re-authentication.

Martin Hawksey's insight:

This library stores access details as user properties within the library making it easy to use in multiple projects without having to re-authenticate each time

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

Displaying analytics data on site pages using Google Apps Script - Desktop Liberation

Displaying analytics data on site pages using Google Apps Script - Desktop Liberation | Google Apps Script | Scoop.it
This post from Apps Script GDE Bruce Mcpherson steps through the process of collecting and displaying page analytics. Here's the details of what's covered: Getting analytics for the site Getting the pages in the site Matching Analytics to sites pagesDealing with recursion Storing options and parameters Database abstraction of site results Retrieving page data from GAS web service Using a canvas in Google sites Working with hyperlinks in canvas Gadget preferences and parameters Light JSONP implementation
more...
Terry Elliott's curator insight, October 5, 7:24 AM

Not just more info, but actionable info.  Better info.

Scooped by Martin Hawksey
Scoop.it!

Large uptick in database abstraction users this week as scriptDB approaches D day

Large uptick in database abstraction users this week as scriptDB approaches D day | Google Apps Script | Scoop.it

"Large uptick in database abstraction users this week as scriptDB approaches D day."

http://ramblings.mcpher.com/Home/excelquirks/dbabstraction

#gde  … - Bruce Mcpherson - Google+

more...
No comment yet.