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

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

Build a query analysis and visualization tool with G Suite and Zendesk API (Japanese)- Medium

Yuki Tanabe gives an overview of how to use Google Apps Script and Data Studio to create a visualization and analysis tool for services that provide web APIs

Source: G Suite x Zendesk API で問い合わせの分析・可視化ツールを作ってみた – google-cloud-jp – Medium

Record time and activities with Google Sheets, Calendar and Apps Script

Jasper Duizendstra demonstrates how with a little bit of Google Apps Script you can easily use your Google Calendar to keep a record of how much time you spend on tasks and then query/report this via Google Sheets. The post contains instructions and code for getting started

Source: Record time and activities with Google Sheets, Calendar and Apps Script

How to measure latency between Google Apps Script project and Google Cloud Platform regions ~ kutil.org

How to measure latency between Google Apps Script project (with UrlFetchApp) and Google Cloud Platform regions (e.g. if you are choosing region for GCP project)

Source: How to measure latency between Google Apps Script project and Google Cloud Platform regions ~ kutil.org