Category: Google Apps Script

Running a Google Apps Script function every quarter or x months

One of the great things about Google Apps Script is the way you can automate tasks. I’ve previously written about how I automate reporting and other examples like running backup processes. These usually run daily or once a month which is very straight forward to setup in Google Apps Script. If you want to run […]

Google Apps Script: The Authentic{ated} Mobile Playground (demo of image capture, and .pdf publication)

I was delighted to be able to speak recently at the Edinburgh Mobile Dev Meetup about Google Apps Script. Thanks to Product Forge there’s a recording of my session on YouTube and you can also get my slides as Google Slides or from Slideshare. The start of this talk is my usual Google Apps Script […]

Join us to find out about analytics in Google Add-ons and the new Google App Maker 16 Dec @ 3pm GMT

Back in June 2016 a couple of us in the Google Apps Script community have been putting on a monthly gathering. We are now going into our sixth episode of ‘Totally Unscripted’ which you can join on Friday 16 December at 3pm GMT. Join us for our next instalment of Totally Unscripted. In this show […]

Using the Google Slides API with Google Apps Script

Google recently announced the general availability of the Google Slides API. The announcement was accompanied by video from the new G Suite Dev Show presented by Wesley Chun embedded below, and a post by Wesley on Using the Google Slides API with Python. Wesley mentioned that “If you’re not a Python developer, it’ll be your […]

Redux: How to open a Google Sheet at a specific row for editing

Many years ago I posted a way you could open a Google Sheet at a specific row for editing. This let you do some url wrangling where you could direct someone to open a Google Sheet in what was ‘List View’ and edit the row: Sadly List View disappeared in the Google Sheets update announced […]

Using CiviCRM with Google Script/Google Drive with the new CiviService Google Script Library

At the Association for Learning Technology (ALT) we use the open source CiviCRM for membership and events management. I’ve previously described how we are able to do Custom regular reporting from #CiviCRM with Google Sheets and Google Apps Script which is able to trigger reports from Civi which are emailed to a Gmail account before […]

Working with Github repository files using Google Apps Script: Examples in getting, writing and committing content

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 Github API to commit files to the repository. Given the demise of Google Drive web hosting and the potential usefulness of this approach I’ve extracted […]

2 Comments

Keeping your Twitter Archive fresh and freely hosted on Github Pages

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. Note: As Ken Bauer has discovered Twitter now offers two different archive options – you need to request the one from https://twitter.com/settings/account If you were to ask me which of my […]

67 Comments

Totally Unscripted: A new Google Apps Script community hangout (Hangout On Air Tips)

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 to a new monthly hangout for the Google Apps Script community.  At ALT we’ve started to explore using Google Hangouts On Air for more of […]

TAGS Tricks: Making a searchable location map of your top Twitter contributors with Geocode by Awesome Table

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…

« Previous Page — Next Page »
css.php