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

Find Unanswered Emails with Apps Script - Google Apps Developer Blog

"As the CEO of an email productivity company, not a day goes by when I don’t learn about a new email pain point. I love solving email problems for our customers, but many of their problems do not lend themselves to a full browser-extension and server solution, like the products we make. Apps Script is perfect for solving some of these problems in a quick, lightweight, customizable way.

The Awaiting Response script is a perfect example of one of these solutions."

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

Gmail Send Later: Schedule emails to be delivered later

Gmail Send Later: Schedule emails to be delivered later | Google Apps Script | Scoop.it
Gmail send later. A review of an open-source app called Gmail-Delay-Send, allowing you to schedule messages for later delivery.
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Parse.com as a substitute for ScriptDB in Google Apps Script

Parse.com as a substitute for ScriptDB in Google Apps Script | Google Apps Script | Scoop.it
brucemcpherson's insight:

As you will know by now, ScriptDB is now deprecated. A year or so ago, I published some articles on alternatives to ScriptDB on the desktop liberation site, one of which was Parse.com. This has turned out to be one of the most popular topics. Here's how to get started and get your data off scriptDB.


Via brucemcpherson
more...
brucemcpherson's curator insight, May 29, 5:46 AM

As you will know by now, ScriptDB is now deprecated. A year or so ago, I published some articles on alternatives to ScriptDB on the desktop liberation site, one of which was Parse.com. This has turned out to be one of the most popular topics. Here's how to get started and get your data off scriptDB.

Scooped by Martin Hawksey
Scoop.it!

Integrating import.io with Google Apps Script

An introduction into how Google Apps Script can be used with the import.io web data extraction service.

Martin Hawksey's insight:

This post has resulted in a importio client library opening the way for more easy integrations http://support.import.io/knowledgebase/articles/367423

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

Flattening an object with dot syntax - Desktop Liberation

"Sometimes you need to blow out a JavaScript object so that the keys are fully qualified. For example, if you are doing a rest query on some third party database, or to represent a more than 1 level deep object in a two dimension space like a spreadsheet.

 

The problem

 

Your object looks like this 

 

{a:1,b:2,c:{d:3,e:{f:25}}} 

 

but you need it to look like this  

 

{a:1,b:2,"c.d":3,"c.e.f":25} 

 

The code

..."

 

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

Steve Webster - Google+ - Issue dialog for Google Add-ons now includes option to include email address

"Google Apps Script Release Notes 05/08/14:
The "Report an issue" dialog for add-ons now asks users whether they would like to share their name and email address with the developer"

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

Manchester CoderDojo - Scratch, Python and Google Spreadsheets - YouTube

"A quick overview of some connectivity building blocks we may use in the construction of our 'World's Largest CoderDojo Rube Goldberg Machine'."

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

How To: Copy Folder Structure and Contents in Google Drive?

How To: Copy Folder Structure and Contents in Google Drive? | Google Apps Script | Scoop.it
Learn how to copy or duplicate folder structure and contents in Google Drive without the need of desktop application.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Google AdWords Scripts For MCC Accounts Are Here And Ready To Use

Google AdWords Scripts For MCC Accounts Are Here And Ready To Use | Google Apps Script | Scoop.it
After a beta period that started in March, earlier this week, Google rolled out scripts for AdWords MCC accounts to all users. AdWords scripts can be used to automate account maintenance, changes and reporting. The ability to use scripts in MCC (My Client Center) accounts means users can now get the benefits of automation across […]
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Migrating user and script properties - Desktop Liberation

Migrating user and script properties - Desktop Liberation | Google Apps Script | Scoop.it

"The old UserProperties and ScriptProperties services have been deprecated and replaced by the new PropertiesService. In the old service, a user property was available from all scripts to a particular user, and a script property was available to all users of a script. 


In this new service, the getUserProperties() are available to a particular user running the current script, and getScriptProperties() are available to everyone running this script


At some point you'll need to migrate your existing properties to this new PropertiesService. Here's a handy script to do that..." 
Martin Hawksey's insight:

See also this thread for runtime alternative https://plus.google.com/u/0/+BruceMcpherson/posts/CkkDfaB6qr4

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

Arun Nagarajan - Google+ -using Google Apps Script to switch to zero inbox

Arun Nagarajan - Google+ -using Google Apps Script to switch to zero inbox | Google Apps Script | Scoop.it

Arun Nagarajan: "I finally made the switch to zero inbox and its amazing how useful a small#AppsScript  can be. I used to do this silly thing where I marked messages I needed to act on as "unread". Now, if its in my inbox, I need to work on it."

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

Google Groups Directory - Google Apps Script Examples

Google Groups Directory - Google Apps Script Examples | Google Apps Script | Scoop.it
For Google Apps Administrators, deploy this Web App to let your users see the members of each domain Groups / mailing lists.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

How to use the Advanced Drive service and the MailChimp API to send Google Docs in an email.

How to use the Advanced Drive service and the MailChimp API to send Google Docs in an email. | Google Apps Script | Scoop.it

Eric Koleda: "I put together a short sample script that shows how to use the Advanced Drive service and the MailChimp API to send the contents of a Google Doc in an email. "

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

Using import.io as a Database Feed with Google Apps Script

Using import.io as a Database Feed with Google Apps Script | Google Apps Script | Scoop.it

"Getting it into a spreadsheet is a good start, but what if you want to get the data into some other kind of format? A fusion table, an Orchestrate database or some other medium for example. Let’s say you are creating a mobile application that accesses parse.com for its data, and for this application we need some data processed by import.io, perhaps merged with some data from some other source. Here’s how we can use Google Apps Script to achieve that."

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

Updating Google Sheets and Awesome tables with Access queries

Updating Google Sheets and Awesome tables with Access queries | Google Apps Script | Scoop.it

"In the absence of being able currently to connect my local MS Access database direct to Google via JDBC or similar, I have found a method of updating Google Sheets and related Awesome tables with Access data, which uses a combination of Drive, Google Apps Script and a Google Sheet. "

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

Flattening and unflattening objects to spreadsheets - Desktop Liberation

Flattening and unflattening objects to spreadsheets - Desktop Liberation | Google Apps Script | Scoop.it

here's how to flatten and unflatten JavaScript objects so they fit in a Google Spreadsheet


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

How To Use Google Docs And Sheets Add-ons For Writing Papers

How To Use Google Docs And Sheets Add-ons For Writing Papers | Google Apps Script | Scoop.it
Discover which Google Docs and Sheets add-ons are best for writing a paper quickly and efficiently.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Advanced Gmail Filters That Aren’t Available in Gmail

Advanced Gmail Filters That Aren’t Available in Gmail | Google Apps Script | Scoop.it

"Gmail filters help you sort incoming messages based on certain criteria. This tutorials shows how you can setup your own Gmail filters that give you greater control over how your emails are sorted."

Martin Hawksey's insight:

Nice use of Google Apps Script to create advanced gmail filters 

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

Deprecating ScriptDB and Domain Service in Apps Script - Google Apps Developer Blog

"In the last few months, we've added a number of new features to Google Apps Script, includingadd-ons for Sheets and Docs and 7 new advanced services. 

 

We're eager to maintain that momentum — focusing on new features that help you do more with Google Apps. As a result, we're deprecating two Apps Script services for which good replacements exist elsewhere: ScriptDB (a NoSQL database that has been marked as experimental since it was introduced) and the Domain service (which encapsulates the GroupsManager, NicknameManager, and UserManager global objects).

 

Both ScriptDB and the Domain service will be turned off on November 20, 2014."

Martin Hawksey's insight:

Sad news about ScriptDb - it had it's issues like tracking quotas across projects but the NoSQL storage was handy. 

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

Create and share customised templates linked to a master collection sheet

Create and share customised templates linked to a master collection sheet | Google Apps Script | Scoop.it
There are lots of times when it would be useful to create batches of sheets with customised information, share these with specified people automatically, and have any changes that those users make, automatically collected and visible from one...
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

Using crossfilter with Google Apps Script - Desktop Liberation

Using crossfilter with Google Apps Script - Desktop Liberation | Google Apps Script | Scoop.it

crossfilter.js is a great library for playing around with big lumps of data. Here's a GAS library with crossfilter


Via brucemcpherson
more...
brucemcpherson's curator insight, May 8, 11:54 AM

if you like d3.js, you'll like crossfilter

Scooped by Martin Hawksey
Scoop.it!

Waqar Ahmad - Google+ - Google reCaptcha with Google Apps Script

Waqar Ahmad - Google+ - Google reCaptcha with Google Apps Script | Google Apps Script | Scoop.it

"Finally I was able to use Google reCaptcha with Google Apps Script. Anyone interested may look into the source."

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

How to Receive Files in your Google Drive from Anyone

How to Receive Files in your Google Drive from Anyone | Google Apps Script | Scoop.it
You can use Google Drive as a public drop box and receive files directly in Drive from anyone. Guests can even upload files to your Drive folder anonymously.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Google Apps Script to integrate with import.io

Using Google Apps Script to integrate with import.io | Google Apps Script | Scoop.it
This post illustrates how you can integrate the structured web data scraping service import.io with Google Apps Script.
Martin Hawksey's insight:

Extracting data from HTML pages with Google Apps Script can be a bit fiddly. There are a number of web services such as import.io that turn this into a point and click expereince. I particularly like import.io because they appear to have spent time of the developer experience with lots of example code and client libraries. Here's a click look at how you can integrate Google Apps Script with the import.io service 

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

Helpouts by Google – Help with Google Apps Script

Helpouts by Google – Help with Google Apps Script | Google Apps Script | Scoop.it
Beginner to intermediate help with Google Apps Script projects.  Offering assistance with any of the Google APIs or help with UI development / web app deployment  in Google Script. 
more...
No comment yet.