Google Apps Script – Page 8

Pushing Canvas LMS discussion data to Google Analytics (tips on Google Analytics API integration, batch collection and queue time)

April 13, 2016

Integrating third party APIs asynchronously with Google Analytics and batch sending tracking data whilst preserving the original activity timestamp

2 Comments

Making Google Apps work for you: Domain wide customization with your Google Add-ons

March 11, 2016

Having seen Google Apps Script develop over the last 7 years one of the key challenges was distributing custom scripts for others to use in your domain. In 2014 Google released add-ons, a way for developers to package and distribute custom functionality that can be added to your Google Sheets, Documents or Forms through the Google Apps Marketplace or the Add-ons store. This post outlines the basics of publishing add-ons to your own domain.

Migrating Excel VBA Macros to Google Sheets/Apps Script: Data reshaping tip, think batches not rows

February 13, 2016

One of the things to remember when moving from the Excel to the Google Sheets is that every interaction you make with a spreadsheet comes with a performance hit. This requires a slightly different mindset and instead you need to think about things in batches rather than row by row operations.

Redux: Google Apps Script: The Authentic{ated} Playground [GDG Berlin]

December 18, 2015

Whilst recently in Berlin I was invited to GDG Berlin to give a presentation on Google Apps Script. This talk focused on how Apps Script is integrated into the Google ecosystem, for me, one of the big selling points of this product.

#OEB15 Workshop: Creating personal tutoring environments with Google Apps Script

December 7, 2015

Last week I was fortunate to attend OEB 2015 (http://www.online-educa.com/) in Berlin. My contribution to OEB15 was a workshop on ‘Creating personal tutoring environments with Google Apps Script’.

Setting up OAuth2 access with Google Apps Script: Blogger API Example

October 23, 2015

This post details how you can setup a Google Apps Script project to interact with the Blogger API or other Google Developers Console APIs

One Comment

Techtalk: #CiviCon London: Automatic data extraction and custom email reports from CiviCRM using Google Apps Script

October 8, 2015

This post highlights some of the oppourtunities for integrating with CiviCRM from Google Sheets using Google Apps Script

Google Sheets as a Database – Authenticated INSERT with Apps Script using Execution API

October 2, 2015

Getting data into Google Sheets from external sources has been a long held interest of mine. In this post I highlight how the Google Apps Script authenicated playground has got a lot bigger thanks to the Execution API

37 Comments

Making a Google Apps Script powered Twitterwall with schedule and announcements – Part 1

September 18, 2015

Part 1 of how you can modify Remy Sharp’s Twitterwall app to run from Google Drive/Apps Script

Tips on emailing inline Google Charts from Sheets using Apps Script

July 28, 2015

There are various techniques for automatically distributing these using Apps Script and in this post I’m going to highlight one method for emailing inline charts.