Tips Programmatically handle long running tasks in Apps Script An approach to process hundreds of thousands of rows of data (say, on Google Sheets) without running into the script execution timeout error.
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.
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.
Add-on Making of Webhooks for Sheets Workspace Add-on Behind the scenes look at what went into creating an Apps Script-native Add-on to generate Webhooks for Google Sheets.
Web App Unnest an object with array values using cartesian product Convert array values from the doGet & doPost event parameters into 2D array when writing them onto a Google Sheet.
Sheets Find precedents of cells with formulas in Google Sheets using Apps Script — Part 1 Enumerate a range in Google Sheets using Google Apps Script and use that to find precedents of cells that contain a formula.
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 Google Sheets Custom Functions for wannabe domain investors (like me) A few of the Custom Functions being used in Sheets, powered by 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.
Data Studio Building a Data Studio dashboard to track Indian COVID-19 cases in realtime Revisiting the power of Google Sheet's native IMPORTHTML function along with some Apps Script magic to visualize COVID-19 cases in India using Data Studio.
Dialogflow Conversational Stats - a way to talk to your data Leverage the power of Dialogflow & connect your data sources with simple Apps Script functions to experience the next-gen approach towards consuming data and shaping insights.
Tips Iterate ~80x faster through spreadsheet using map function in Apps Script Use array map method instead of "for" loops to iterate faster through 2-dimensional spreadsheet data.
Add-on Workbook Statistics - a Google Sheets Add-on built using Apps Script Get stats for your current active sheet & the entire spreadsheet in one place using Workbook Statistics - A G Suite Editor Add-on built using Google Apps Script.
Sheets Display user specific spreadsheet data on a Web App Allow users to only view their data from a spreadsheet with the help of a Google Apps Script web app.
Bot Build a Telegram Bot using Apps Script Launching SphygmoBot - a human "heartbeat" checker Telegram Bot that pings you every 24 hours to see if you're alive and notifies someone in case your response fails.
Web App Autocomplete drop-down options from spreadsheet data Use spreadsheet data to autocomplete Materialize CSS chips & select components using Apps Script.
Calendar Github-like contributions heat map, but for meetings Create a meetings heat map dashboard view using Google's Calendar Chart and Apps Script.
Innovation Password protected Web App Create your very own frontend dashboard that requires a passcode to login, using Google Sheets and Apps Script.
Webhook Managing Ghost's subscriber list Create webhooks to store, access & update Ghost's subscriber list using Google Apps Script.
