Profile

Cover photo
34 followers|5,818 views
AboutPostsPhotosVideos

Stream

GAS

Shared publicly  - 
1
Add a comment...

GAS

Shared publicly  - 
 
"In Using crossfilter with Google Apps Script I showed how to use the powerful crossfilter library to do some data wrangling. But using some of JavaScript's Advanced Array functions, and working with named columns instead of column numbers gives you a lot of wrangling power straight out of the box. "
1
Add a comment...
 
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.

#googleappsscript   #blogpost   #gde  
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 versio...
2
Add a comment...

GAS

Shared publicly  - 
 
Gmail Scheduled Send Email
"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!"

#googleappsscript
"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 u...
1
Add a comment...
 
The app will automatically save all your Google Voice voicemail messages in Gmail to your Google Drive as MP3 files along with the transcript.

#googleappsscript
The app will automatically save all your Google Voice voicemail messages in Gmail to your Google Drive as MP3 files along with the transcript.
1
Add a comment...

GAS

Shared publicly  - 
 
"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."

#googleappsscript
"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."
1
Add a comment...
Have them in circles
34 people
Jonathan Riehm's profile photo
Cristian Conti's profile photo
Keisuke Oohashi's profile photo
Eric Koleda's profile photo
Arco de Bonte's profile photo
Arjun Prakash's profile photo
 
"Pins about Google Apps Scripts/Extensions/Add-ons for Education hand-picked by Pinner Stacy Olson | See more about google drive, extensions and scripts."

#googleappsscript
1
Add a comment...

GAS

Shared publicly  - 
 
"In EzyOauth2 - taking some pain out of Apps Script API authentication, I provided a library to simplify oAuth2, then in EzyOauth2 patterns I showed simple patterns for creating apps. Now you will probably want to have multiple authentication packages for different packages and scopes. Unfortunately, everybody's oAuth2 implementation is a little different, but we can still use a standard pattern to abstract away those differences.

To illustrate, I'm going to add a new oAuth2 package - this time for the soundcloud service. "

#googleappsscript
"In EzyOauth2 - taking some pain out of Apps Script API authentication, I provided a library to simplify oAuth2, then in EzyOauth2 patterns I showed simple patterns for creating apps. Now you will probably want to have multiple authentication packages for different packages and scopes. Unfortunately, everybody's oAuth2 implementation is a little different, but we can still use  a standard pattern to abstract away those differences.  To illustrate...
1
Add a comment...

GAS

Shared publicly  - 
 
Using Content Assist in Google Apps Script
"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"

#googleappsscript
"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"
1
Add a comment...

GAS

Shared publicly  - 
 
"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). "

#googleappsscript
1
Add a comment...

GAS

Shared publicly  - 
 
"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. "
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
1
Add a comment...

GAS

Shared publicly  - 
 
"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. "

#googleappsscript
1
Add a comment...
People
Have them in circles
34 people
Jonathan Riehm's profile photo
Cristian Conti's profile photo
Keisuke Oohashi's profile photo
Eric Koleda's profile photo
Arco de Bonte's profile photo
Arjun Prakash's profile photo
Story
Tagline
The GAS: All things Google Apps Script
Introduction
The Google+ Page for the curated collection of Google Apps Script news and code samples