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
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
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
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
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