Category: Google Sheets

Example JSON output

Google Apps Script Patterns: Writing rows of data to Google Sheets the V8 way

Currently one of the most popular posts on this site is my Google Apps Script Patterns: Writing rows of data to Google Sheets. Given Google’s recent announcement of the general availability of the new V8 runtime I thought it was worth revisiting this particular pattern and using the modern syntax now available to Google Apps Script developers.

Human Data Interaction … and spreadsheets

Human Data Interaction … and spreadsheets: Retaking ownership in the age of surveillance

… if you enjoy this post you might want to register for the online SheetsCon conference 11th – 12th March 2020. Registration is free and there is a great lineup of speakers … and me 😉 On Friday I had the honour of speaking at a @HDINework workshop in Edinburgh for ALT with my boss […]

Send bulk emails with personalised images in G Suite using Google Apps Script

Earlier in the year I managed to get a bulk emailing script published in the G Suite Developer Solutions Gallery. In this post I want to show you how you can extend this script so that you can send personalised images using Gmail, Sheets and Slides. Before you get too excited about the potential of […]

Using Google Slide speaker notes to prepare tweet text

Hacking Google Slides as a voice enabled presentation tool using Google Apps Script

I always enjoy presenting at DevFest as usually it is a reason to explore something new. In the case of DevFest London it was an opportunity to think about how voice interfaces could be used as part of a Google Slide presentation. In this post I’ll share some of the ideas I explored and how they did/didn’t work out.

2 Comments
Mail Merge

Repost: Sending bulk email (mail merge) using Gmail and Google Sheets

Simplify the process of producing visually rich mail merges using Gmail and combining it with data from Google Sheets. With this solution you can automatically populate an email template created as a Gmail draft with data from Google Sheets. Merged emails are sent from your Gmail account allowing you to respond to recipient replies.

Mail Merge

Google Apps Script Patterns: Celebrating 10 years by revisiting mail merge/bulk emailing

TL;DR A new solution for creating and distribute visually rich bulk emails with Gmail and Google Sheets. On 19 August 2019 Google Apps Script celebrated 10 years of general access. Apps Script has come a long way in the 10 years as you can see from the announcement blog post and launch video also embedded […]

Google Apps Script Patterns: Writing custom formulas/functions and handling single and range inputs

Custom functions have been in Google Apps Script since it’s public launch in 2009. These let you extend Google Sheets function list allowing you to create and share your own spreadsheet formula. The official Google Developer docs for Custom Functions are very comprehensive and in this post I just want to highlight one pattern for detecting and handling user inputs.

Using your YouTube subtitles file and Google Sheets to make a video contents jump list

Read how you can use your YouTube subtitle file as an easy way to create a video contents/jump list in YouTube video descriptions and G+ posts

Creating custom branching in Google Forms with Google Apps Script

I was recently asked me if I knew a way to create custom branching in Google Forms. The scenario was they had a list of employee names in a Google Sheet which they wanted to turn into a Google Form drop-down list which when selected would redirect the respondent to their own section of the form.

Machina a machina: An introduction to APIs with Google Sheets

I recently had the pleasure of attending and presenting at MozFest 2017. MozFest had been on my bucket list to attend for a while and the event did not disappoint. My contribution to the event was a session as part of the web literacy space designed to introduce people to APIs. This post has more information and links to resources available for reuse

« Previous Page — Next Page »
css.php