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

Google Sheets as a Database - INSERT with Apps Script using POST/GET methods (with ajax example)

Back in 2011 I showed how you can use Google Apps Script to write POST/GET data to a Google Sheet. Over the years a couple of things have changed in Apps Script so I thought it was worth a revisit. This version uses features like LockService, PropertiesService and ContentService to make it more robust and make it possible to do ajax powered form submissions. The post includes a couple of tips that appear to be catching people out including versioning and permissions scope. 

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

Breakpoints and the Apps Script Debugger | Drive Bunny

Breakpoints and the Apps Script Debugger | Drive Bunny | Google Apps Script | Scoop.it
" Using the debugger, you can set break points in the code at places of your choice. When code execution lands on a break point, it halts; while time remains frozen, you can check how your code is operating, examine variable values, read log messages etcetera."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Using Content Assist in Google Apps Script | Drive Bunny

Using Content Assist in Google Apps Script | Drive Bunny | Google Apps Script | Scoop.it

"I always have difficulty remembering the exact syntax of some programming constructs, such as the order of parameters in a function call, or the exact name of a method.


I’ve often abandoned the blinking cursor within the Code Editor to go and look for reference material, either online or printed.

 

Luckily, Google’s Code Editor has something called Content assist to come to the rescue"

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

How to Sell Digital Products Online with Google Drive and PayPal

How to Sell Digital Products Online with Google Drive and PayPal | Google Apps Script | Scoop.it
The guide explains how you can quickly and easily sell digital products like PDF ebooks, music, website themes, etc. through Google Drive, PayPal and Gmail.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Connecting to MySQL Databases using Apps Script | Drive Bunny

Connecting to MySQL Databases using Apps Script | Drive Bunny | Google Apps Script | Scoop.it
" Being able to write to, and read from, [mySQL] databases directly from your Google Sheet can be a huge advantage. In the e-commerce example, for instance, you may want todownload order information for delivery completion, label printing or later sales analysis, or you may choose to upload new data from your spreadsheet to the on-line store including prices, product descriptions and so forth."
more...
No comment yet.
Rescooped by Martin Hawksey from desktop liberation
Scoop.it!

EzyOauth2 - taking some pain out of Apps Script API authentication

EzyOauth2 - taking some pain out of Apps Script API authentication | Google Apps Script | Scoop.it

brucemcpherson's insight:

"If you are writing Apps Script webapps and accessing some of the Google JSON APIs services, you're going to need to deal with oAuth2. This library using the statetokenbuilder should help get it right first time." 


Via brucemcpherson
more...
brucemcpherson's curator insight, June 11, 2:01 PM
If you are writing Apps Script webapps and accessing some of the Google JSON APIs services, you're going to need to deal with oAuth2. This library using the statetokenbuilder should help get it right first time.  
Scooped by Martin Hawksey
Scoop.it!

Joe Marini: Building a Customized News Service with Google Apps Script

"I decided to see if I could write a script that would scan the news sites I read each morning and deliver a customized news feed to my Gmail inbox, along with a summary of my day’s calendar ... The script itself is pretty simple: it scans a set of news feeds, creates links to the stories, scans the headlines for specific words, and calls them out separately from the rest of the news. It also reads my calendar for the day’s events and tells me if I have any upcoming events that I have not yet RSVP’d to. "

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

Jason Anderson : Automatically purge GMail labels with Google Apps Script

Jason Anderson : Automatically purge GMail labels with Google Apps Script | Google Apps Script | Scoop.it
A protip by diurnalist about google apps, gmail, scripting, and automation.
Martin Hawksey's insight:

Nice little Google Apps Script snippet for deleting labeled emails after defined time period  

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

Chaining JavaScript - Google Apps Script

Chaining JavaScript - Google Apps Script | Google Apps Script | Scoop.it
brucemcpherson's insight:

This example shows how to get data from a Fusion table, summarize and sort it, and write it out to a spreadsheet in 'one line' of code. 


Via brucemcpherson
more...
brucemcpherson's curator insight, May 30, 5:24 AM

This example shows how to get data from a Fusion table, summarize and sort it, and write it out to a spreadsheet in 'one line' of code. 

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!

Parallel processing in Apps Script - Desktop Liberation

Parallel processing in Apps Script - Desktop Liberation | Google Apps Script | Scoop.it
" There's no getting away from the fact  that Apps Script is slower than the equivalent client based JavaScript processing. It is fundamentally synchronous in implementation, and also has limits on processing time and a host of other quotas. For a cloud based, free service that's about extending Drive capabilities rather than being scalable in the manner of Google App Engine, I suppose it's normal. But let's see if we can at least subvert at least these two things: * get over the 6 minute maximum execution time for Apps Script *run things in parallel "
Martin Hawksey's insight:
More magic from Bruce Mcpherson
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Some Simple Debugging for Google Apps Script

Some Simple Debugging for Google Apps Script | Google Apps Script | Scoop.it
" In this post I’ll cover some basic techniques that can help you track down and stomp on errors in your Apps Scripts."
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Collaborative Tools Project: Gmail Scheduled Send Email

Collaborative Tools Project: Gmail Scheduled Send Email | Google Apps Script | Scoop.it

"Someone recently asked for the ability to schedule send an email. It was for a link to a class feedback form and ideally they'd like to be able to send it near the end of the class.

We looked at Boomerang, which had issues with authenticating with the York domain, and broke the CSS of Gmail slightly. We tried mx Hero, a Chrome app but after a tip off from a colleague and reading the reviews and discovering it at times didn't send the email, or used http rather than https etc we thought it might be better to look into making our own solution.

Apps Script to the rescue!"

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

Deprecating Script Gallery in the old version of Google Sheets - Google Apps Developer Blog

"Starting today, we are deprecating the option for developers to publish to the script gallery. No new gallery submissions will be accepted or approved, but scripts already present in the gallery will remain accessible (via the old version of Sheets). "

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

Save your Google Voicemail to Google Drive as MP3 Files with Google Apps Script

Save your Google Voicemail to Google Drive as MP3 Files with Google Apps Script | Google Apps Script | Scoop.it
The app will automatically save all your Google Voice voicemail messages in Gmail to your Google Drive as MP3 files along with the transcript.
more...
No comment yet.
Scooped by Martin Hawksey
Scoop.it!

Single drop down with data from separate columns with Google Apps Script

"With the below script you can build a validator from multiple ranges, in both old and new style Google Spreadsheets and you can select different sheets."

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

Minimizing maps directionfinder api calls

Minimizing maps directionfinder api calls | Google Apps Script | Scoop.it
brucemcpherson's insight:

If you are using the Maps.Directions API, and plotting many source/destination points, you may be hitting quota problems (too many calls in too short a time, maximum daily allowance). Here's how to automate the use of waypoints to make your quota go further - reducing the number of API calls required by as much as x 20. 


Via brucemcpherson
more...
brucemcpherson's curator insight, June 9, 12:32 PM

If you are using the Maps.Directions API, and plotting many source/destination points, you may be hitting quota problems (too many calls in too short a time, maximum daily allowance). Here's how to automate the use of waypoints to make your quota go further - reducing the number of API calls required by as much as x 20. 

Scooped by Martin Hawksey
Scoop.it!

Elevate | University Campus Suffolk: Open Badges Generator Update - Source Code

Elevate | University Campus Suffolk: Open Badges Generator Update - Source Code | Google Apps Script | Scoop.it
Open Badges Generator for Google Sites implementation guide and source code
Martin Hawksey's insight:

Nice to see one of my old projects get a new lease of life

more...
No comment yet.
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.