Solutions

A collection of 9 posts

Gmail

Send emails using Gmail API advanced services in Apps Script

Use the build-in Apps Script methods to send emails using Gmail API.

Sheets

Convert JsDoc to JSON used in Sheets' Custom Functions written in Google Apps Script

Use RegEx to quickly identify relevant patterns of JsDoc supported by Sheets Custom Function in Apps Script and convert that into JSON.

Solutions

[Workaround] An alternate to displaying more than 100 widgets/sections.

Working around the 100-widget limit in Card Services, used when building Workspace Add-ons.

Automation

Sync subscribers between Revue & Ghost using Apps Script

Run a 2-way automated sync between your Revue account and Ghost blog while creating a backup of all your subscribers/members in a Google Sheet.

Solutions

Get the redirect location of a URL using Google Apps Script

Have a list of shortened URLs and need their final destination? Use this Custom Function in Google Sheets to extract them all at once.

Solutions

Using UrlFetchApp.fetch vs. fetchAll in Google Apps Script

Make multiple, asynchronous API calls simultaneously using UrlFetchApp.fetchAll in Apps Script.

Sheets

Visually display status when looping through Google Sheets data

Show a processing status in a cell when looping through rows in Google Sheets using Google Apps Script.

Sheets

Format specific word inside a Google Sheet cell using Apps Script

Format (Bold) a single word or a group of words automatically in Sheets, using Google Apps Script.

Sheets

Send personalized appreciation certificate to employees

Automatically customize an existing Google Slide certificate template with employee data in Google Sheets and share them using Gmail.