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.
![[Workaround] An alternate to displaying more than 100 widgets/sections.](/content/images/size/w600/2022/11/more-than-100.gif)
