In a recent post I demonstrated how you can use Google Apps Script to add new tweets to a downloaded Twitter archive hosted on Github Pages. This project used the […]
Google Apps Script
tl;dr How do you keep your downloaded Twitter archive fresh on Github Pages using Google Apps Script? By running this Google Apps Script powered web app. If you were to […]
The day job at the Association for Learning Technology (ALT) and my Google Apps Script hobby made an unexpected collision recently when I was asked by Bruce Mcpherson to contribute […]
In this post I’ll show you how to make a searchable Twitter contributor map like the one below in a couple of clicks, however I feel it’s my duty to educate you first…
Integrating third party APIs asynchronously with Google Analytics and batch sending tracking data whilst preserving the original activity timestamp
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.
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.
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.
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’.
This post details how you can setup a Google Apps Script project to interact with the Blogger API or other Google Developers Console APIs