Google Apps Script Automation Toolkit

Six standalone, heavily commented scripts for Sheets, Gmail, Forms and Drive — built around the things that actually break Apps Script in production.

Get the toolkit — $19One payment. No subscription.

What breaks, and what handles it

The 6-minute execution limit

A script that works on 200 rows dies on 20,000. BatchRunner checkpoints every 50 rows and re-schedules itself.

Gmail's daily quota

Sends stop cleanly before the limit and resume tomorrow, instead of failing halfway through a merge.

Duplicate sends

A Status column written back per row, so a re-run never emails the same person twice.

Concurrent trigger runs

Two triggers firing at once quietly corrupt each other's work. SheetUtils.withLock serialises them.

Flaky APIs

retry does exponential backoff rather than losing the whole run to one 429.

The six files

  • BatchRunner — Processes thousands of rows across multiple runs. Checkpoints progress and re-schedules itself, so the 6-minute execution limit stops being a thing you design around.
  • MailMerge — Personalised Gmail from a Sheet using a Gmail draft as the template. Per-row attachments, a Status column so nothing sends twice, a daily-quota guard and a dry-run mode.
  • GmailToSheet — Logs matching emails to a Sheet, saves attachments to Drive, labels processed threads, never double-logs.
  • FormToPdfEmail — On form submit: fill a Docs template, export a PDF, save it to Drive, email the respondent, write the link back to the row.
  • ApiToSheet — Pulls JSON from any REST API into a Sheet — pagination, retries with backoff, caching, nested-object flattening.
  • SheetUtils — readObjects, writeObjects, dedupe, mergeSheets, upsert, withLock, retry. The helpers every project ends up rewriting.

Try one first, free

SheetUtils — the file the other five depend on — is free and needs nothing from you: github.com/ishubham21/apps-script-sheetutils. If it saves you an afternoon, the other five are $19.

Toolkit — $19

Every file is standalone and commented, with a 2-minute install guide and a worked example. Works with free Gmail and Google Workspace.

Get the toolkit — $19