Google Sheets automation

Build an OKR tracker with progress rollups

Aggregate Northwind's key-result progress into objective-level scores automatically.

Updated Jan 14, 2026

Build a recurring-task generator

Spawn new Northwind task rows on a daily or weekly cadence from a Recurring sheet.

Updated Jan 10, 2026

Build a multi-sheet search-and-jump tool

Find a value across every tab of a workbook and click through to the cell that contains it.

Updated Jan 7, 2026

Auto-rebuild grouped summaries on edit

Refresh pivot-style rollups the instant data changes — no manual recompute.

Updated Jan 4, 2026

Automation Intermediate Sheets Docs

Build a data-quality scorecard

Grade any sheet on completeness, validity, and freshness — surface gaps as a single score.

Updated Dec 31, 2025

Generate a warehouse pick or packing list

Format Northwind order rows into a print-ready pick list grouped by aisle.

Updated Dec 27, 2025

Build a meeting-cost calculator

Multiply attendees, salaries, and duration into a dollar figure — make the cost of meetings visible.

Updated Dec 24, 2025

Build a weighted raffle and winner picker

Draw winners with configurable odds — entries can have weights, e.g. for early-bird bonus.

Updated Dec 20, 2025

Build a shared-expense splitter

Compute who owes whom from a group expense log — Northwind off-site dinner, settled.

Updated Dec 17, 2025

Automation Intermediate Sheets Drive

Build a content calendar with status automation

Move posts through draft → review → scheduled → published based on date and approval columns.

Updated Dec 13, 2025

Auto-import every CSV dropped in a folder

Append new vendor CSV exports into a master sheet automatically — drop the file, walk away.

Updated Dec 10, 2025

Auto-flag stale rows that need review

Highlight records in the Leads sheet that have been untouched for more than 14 days.

Updated Dec 6, 2025

Build a timesheet with automatic overtime rules

Compute regular and overtime hours per entry — anything over 40 hours/week or 8/day flows to overtime.

Updated Dec 3, 2025

Build a lightweight CRM pipeline board

Track deals through stages with stage-totals rolled up automatically — no CRM subscription required.

Updated Nov 29, 2025

Build a tiered commission calculator

Apply progressive rates to a Sales column — 5% to £10k, 8% above, 12% above £50k.

Updated Nov 26, 2025

Build a habit tracker with streak counting

Log daily checkmarks per habit and compute the current streak in a custom column.

Updated Nov 22, 2025

Auto-number invoices and POs without gaps

Assign sequential, gap-free document numbers as new rows appear in the Invoices sheet.

Updated Nov 19, 2025

Automation Intermediate Sheets Gmail

Build a capacity-planning resource grid

Track who's allocated where across weeks — a single matrix view of team load.

Updated Nov 15, 2025

Alert the owner when imported data breaks a rule

Email the data owner whenever a scheduled refresh fails validation — no more silent broken pipelines.

Updated Nov 12, 2025

Build a multi-currency expense consolidator

Normalise Northwind's spend from many currencies to GBP using the live FX function.

Updated Nov 8, 2025

Detect duplicate rows on a composite key

Flag rows in the Invoices sheet that match across (client, invoiceNumber).

Updated Nov 5, 2025

Build a two-way sync between two spreadsheets

Keep a shared client-facing sheet and a private internal sheet in step — both directions.

Updated Nov 1, 2025

Build a weighted scoring and ranking model

Score options by criteria, weight each criterion, and auto-rank — for vendor selection or feature prioritisation.

Updated Oct 29, 2025

See all 34 in Data entry →

Auto-archive completed rows to a Done sheet

Move finished tasks out of the active Projects view and into a Done archive on a schedule.

Updated Oct 25, 2025

Formatting

Apply conditional styles, freeze structure, and clean data.

5 articles

Build a dependent dropdown system

Make the second dropdown filter its options based on the first selection — country → city, client → project.

Updated Sep 17, 2025

Auto-protect ranges after a deadline

Lock cells in the Submissions sheet once a deadline passes — no more late edits.

Updated Sep 13, 2025

Auto-sort a sheet whenever data changes

Keep the Projects sheet ordered by due date without anyone manually sorting.

Updated Sep 10, 2025

Detect and highlight data-entry anomalies

Flag outliers and impossible values on the Expenses sheet the moment a row is added.

Updated Sep 6, 2025

Auto-format new rows to match the table style

Apply borders, fonts, and data validation to appended rows in the Projects sheet automatically.

Updated Sep 3, 2025

Custom functions

Write JavaScript functions usable from any cell.

13 articles

Parse messy mixed-format dates

Normalise inconsistently formatted strings into real date values with a single formula.

Updated Aug 2, 2025

Scrape a web table into cells with one formula

Pull HTML tables into Sheets as a custom function — no IMPORTHTML quirks.

Updated Jul 30, 2025

Mask sensitive columns for shareable copies

Redact PII with a custom function so you can share a copy of the sheet without exposing names, emails, or numbers.

Updated Jul 26, 2025

Build a sentiment-scoring function without AI

Rate text positive or negative with a tiny built-in lexicon — no API key, no quota.

Updated Jul 23, 2025

Build a unit-conversion function library

Convert between any units with one custom formula — kg/lb, km/mi, °C/°F, and the rest.

Updated Jul 19, 2025

Create a readability-scoring function

Rate text columns for reading difficulty with a Flesch reading-ease score in one formula.

Updated Jul 16, 2025

Generate scannable QR codes in cells

Render a QR code per row from its data — for asset tags, event badges, or product labels.

Updated Jul 12, 2025

Add distance and ETA functions with Maps

Fill drive times and distances between two cells inline using the Maps service.

Updated Jul 9, 2025

Validate IBANs, VAT IDs, and SKUs

Check structured identifiers in a cell with a single custom function — no manual lookup.

Updated Jul 5, 2025

Build a working-day math function

Add or count business days excluding weekends and a custom holiday list — with a single Sheets formula.

Updated Jul 2, 2025

Create a live currency-conversion function

Convert amounts inline with a CONVERT-style formula, using a cached live exchange rate.

Updated Jun 27, 2025

Create a fuzzy text-matching function

Match near-duplicate names across two lists with a Levenshtein-based custom function.

Updated Jun 23, 2025

Write a custom function to geocode addresses

Turn a column of addresses into latitude/longitude pairs with a single Sheets formula.

Updated Jun 20, 2025

Dashboards

Auto-refresh charts, KPIs, and live data views.

8 articles

Build a linear-projection forecasting model

Extend a Northwind revenue trend into the next quarter with a simple linear regression.

Updated Aug 30, 2025

Build a subscription churn dashboard

Track active, churned, and reactivated accounts month over month from a Subscriptions sheet.

Updated Aug 27, 2025

Build a cohort-retention analysis tab

Compute month-over-month retention curves from a signups log — built monthly cohorts, automatic.

Updated Aug 23, 2025

Build a budget-vs-actual variance tracker

Compute and colour-code variances between budgeted and actual spend per project category.

Updated Aug 20, 2025

Generate a project burndown chart

Visualise remaining work against an ideal line, refreshed nightly from the Tasks sheet.

Updated Aug 16, 2025

Build a self-updating Gantt chart

Drive a visual timeline from start and end date columns in the Projects sheet.

Updated Aug 13, 2025

Render a heatmap calendar from daily values

Build a GitHub-style activity grid in cells from a column of dated counts.

Updated Aug 9, 2025