Sourabh Choraria

Spreadsheet nerd. Apps Script junkie. Workspace Google Developer Expert.

List all functions used on a Google Sheet using Apps Script

Quickly list all the functions being used in a spreadsheet using Google Apps Script. Parse function names from complex / nested formulas too.

Add-on

Link Previews — a Google Workspace add-on for Google Docs

Link Previews enables Google Docs users to convert URLs from multiple 3rd party tools (ex: HubSpot, Notion, Coda, Figma etc.) into smart chips!

Gmail

Send emails using Gmail API advanced services in Apps Script

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

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.

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.

Talks

[Talk # 5] Create, manage and deploy Apps Script projects using their REST APIs

A glimpse into the inner workings of Webhooks for Sheets Workspace Add-on.

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.

Google Chat

Introducing TwiLinks – a Chat app built using Apps Script

Preview tweets and user data when sharing links, along with the ability to follow a specific user or like a particular tweet.

Connector

Connecting 'Tweet counts' API to Data Studio using a Community Connector

A community connector with overridable config parameters to track recent Twitter trends for a query.

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.

OAuth2

Generate code verifier & challenge for OAuth2 with PKCE using Google Apps Script

Here's how you can generate a cryptographically random code verifier, hash it using SHA256 & derive it's BASE64 encoded challenge in Google Apps Script.

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.

Open-source

Introducing validator.gs — an open-source library of string validation for Apps Script projects

The distant cousin of the already existing validator.js npm module.

Videos

Access Notion API with 'OAuth2 for Apps Script' library

Insights from a first-time Apps Script OAuth2 library user when connecting to the Notion API.

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

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.

Add-on

Count von Count — a Google Workspace Add-on built using Apps Script

A global counter that summarises accessible stats about different Workspace services.

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.

Webhook

Web captioner, webhooks and Google Apps Script

Push data from Web Captioner to Google Sheets via webhooks built using Apps Script.

Talks

[Talk # 4] Rapid prototyping

Fail-fast while building business-first, zero-cost solutions with 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.