Bootstrapping Tools

Route Form file uploads into the right Drive folder

File-upload questions are one of the best things about Google Forms, right up until week three. Every receipt, contract, and headshot is…

A Doc full of {{Client}} and {{Amount}} placeholders, a sheet row with those headers, and a Drive folder for the finished copies…

A sheet with a file id column and a new-name column, and a pile of Drive files that still say IMG_4021 or Copy of Proposal…

Ops ask we hear a lot: after the nightly sync, dump “status = done” (or last 24h) rows into Exports/2026-09-18.csv without opening Sheets…

Sharing from a script is one line, until the job runs twice and the client gets two “shared with you” emails. shareFileWithEmail…

“What landed in the Inbox folder since last run?” is the start of half the Drive automations we write. listDriveFilesModifiedSince…

Form uploads land in one big “(File responses)” folder. Exports land in My Drive root. moveFileToFolder(fileId, folderOrId) puts a Drive…

After a nightly sync you often want a dated CSV in Drive without opening Sheets. Build the 2D array, turn it into CSV (reuse valuesToCsv…

Operators paste Share links, "Open in new tab" URLs, and bare ids into the same column. extractDriveFileId normalizes that mess into a Drive…

One folder name isn't enough when exports land under Exports/2026/09 or Clients/Acme/Incoming. Walk a slash-separated path from a parent…

Exports, backups, and client drop folders all need a stable place in Drive. This returns the first child folder with that name under a…

In this video, we'll show you how to automate snapshots of your Google Sheets and have those logs stored in a separate Google Drive folder…