AppsScriptPulse

Solutions, Sheets

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

Tags:
| | 0 Comments |

For some context for seasoned Google Apps Script developers like me until V8 we’ve been working in a bit of an old school JavaScript bubble. With V8 there is an opportunity to write less verbose and more succinct code. To see some of the differences below I’ve copied the Writing JSON data mapped to row headings example from my original post and updated this with a V8 version and will highlight the changes.

This post covers a range of techniques and includes a typical pattern for writing structured data like JSON responses from third party sources.

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

Solutions, Gmail, Sheets, Slides

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

Tags:
| | 0 Comments |

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.

Source: Send bullk emails with personalised images in G Suite using Google Apps Script

Solutions, Slides

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

Tags:
| | 0 Comments |

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.

In practice not all these experiments worked out but hopefully the post contains some useful snippets for navigating Google Slides in the editor, exporting slides as images and extracting text from the speaker notes.

Source: Hacking Google Slides as a voice enabled presentation tool using Google Apps Script – MASHe

Solutions, Gmail, Sheets

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

Tags:
| | 0 Comments |

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.

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

Solutions, Gmail, Sheets

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

Tags:
| | 0 Comments |

Over the last 10 years of Google Apps Scripts there have been a number of bulk email solutions shared by the community. This post revisits some of these examples and shares one of the latest examples from the GSuite Solutions Gallery

TL;DR A new solution for creating and distribute visually rich bulk emails with Gmail and Google Sheets.

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

Solutions, Sheets

Google Apps Script Patterns: Writing rows of data to Google Sheets – MASHe

Tags:
| | 0 Comments |

This is a popular post from 2018….

In the previous post in the Google Apps Script Pattern series we looked at selectively updating rows of data in a Google Sheet. For this post we will look at a couple of patterns for inserting multiple rows of data into Google Sheets.

Source: Google Apps Script Patterns: Writing rows of data to Google Sheets – MASHe

Solutions, Sheets

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

Tags:
| | 0 Comments |

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. This post provides some guidance on writing custom Google Sheet functions that can handle both single and range inputs

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

Community News

G Suite, Apps Script and App Maker posts from Google Next ’19 – MASHe

Tags:
| | 0 Comments |

Summary of posts by other G Suite GDEs highlighting announcements from Google Next ’19

Source: G Suite, Apps Script and App Maker posts from Google Next ’19 – MASHe

Solutions, Chat

An introduction to building Google Hangouts Chat bots with Google Apps Script – MASHe

Tags:
| | 0 Comments |

This post is designed to give an overview of Google Hangouts Chat bot development with Google Apps Script.

Source: An introduction to building Google Hangouts Chat bots with Google Apps Script – MASHe

Solutions

Google Apps Script Patterns: Creating conversational interfaces with Dialogflow – MASHe

Tags:
| | 0 Comments |

In a recent episode of Totally Unscripted I demonstrated how you can use the Dialogflow service as a way to allow you to add conversational interfaces to your Google Apps Script projects. In this post I share some boilerplate and instructions for implementing Dialogflow into G Suite editor add-on projects

Source: Google Apps Script Patterns: Creating conversational interfaces with Dialogflow – MASHe