Free library
Automate it in Google Sheets and Excel: 16 free recipes
Copy-paste formulas and Apps Script for the chores small businesses ask about most. Each recipe has step-by-step instructions and working code. Script logic is unit-tested before publishing.
- 01
Remove duplicate rows
Keep one row per customer, order or email: a no-code formula view, plus a one-click script that cleans the sheet in place.
- 02
Timestamp on edit
Record 'last updated' (or 'created at') automatically whenever someone changes a row. No trigger setup needed.
- 03
Auto-email on form submit
Get every response in your inbox (with Reply going straight to the customer) and send respondents an instant confirmation.
- 04
Merge CSV files
Drop exports from your shop, bank or CRM into one Drive folder and combine them in one click. Columns are matched by header name.
- 05
Scheduled backups
A dated copy of your spreadsheet every night in a folder you choose, keeping the last 30 and trashing older ones.
- 06
XLOOKUP patterns
Copy-paste lookups for the cases that trip people up: two criteria, whole columns at once, the latest match, tiered pricing.
- 07
QUERY patterns
Build live summaries with one formula: filter, group, pivot and sort, without pivot tables.
- 08
Clean messy data
Formulas to normalize the data you get from forms and exports, plus a one-click script that strips the invisible characters that break lookups.
- 09
Overdue invoice reminders
A daily script that emails clients whose invoices are past due, at most once a week each, and logs when it did. Starts in safe dry-run mode.
- 10
IMPORTRANGE + filter
Show only the rows you need from another file, combine several files into one, or take a stable scheduled snapshot.
- 11
Archive completed rows
Keep your task, order or lead list short: rows marked Done move to an archive tab with the date, instantly.
- 12
Import JSON from an API
Pull data from any JSON API (your store, CRM, or a public dataset) into a tab, flattening nested fields, refreshed hourly.
- 13
Remove duplicates, keep latest
When someone submits a form twice or a record is updated, keep only the newest row per email or ID: a SORTN formula view, an Excel 365 version, and a tested in-place script.
- 14
Email when a cell changes
Email yourself or the person on that row when a status column changes, for example to 'Approved'. Uses an installable trigger, because simple onEdit can't send mail.
- 15
Split full name into first/last
Formulas for every version of Excel and for Google Sheets, including middle names, 'Last, First' lists and extra spaces.
- 16
Highlight duplicates
Custom formulas that color duplicate values, whole duplicate rows, or only the second and later copies, so you can review before deleting anything.
Do it yourself
Recipe Club: $12/month
Prefer to set things up yourself? Join the Recipe Club and get access to a private GitHub repository of ready-made, tested automations for Sheets, Apps Script, Python and Node. Each one comes with setup notes and sample data.
- A new recipe added every week
- Everything in the free library, plus the longer, more complete versions
- Use them in your own business as much as you like
- Cancel anytime by email (or the Stripe customer portal once available)
Recipe Club opens soon: join the waitlist
You'll need a free GitHub account. After checkout, reply with your GitHub username and we'll send the repo invite, usually within one business day.
Or buy a one-time recipe pack ($19–$29)
- Clean Data Pack $19
Dedupe, cleaning, merging and normalizing scripts and formulas for messy exports, with a sample sheet.
Coming soon - Forms & Inbox Pack $19
Form auto-replies, request routing, a lead log and follow-up nudges, ready to paste into Apps Script.
Coming soon - Money Ops Pack $29
Invoice reminders, a monthly revenue dashboard with QUERY, a receipts log and nightly backups.
Coming soon