Google Sheets automation
Automate data entry, formatting, custom functions, and dashboards in Google Sheets with Apps Script.
Data entry
Validate and import rows from forms, APIs, and uploads.
34 articles
Build an OKR tracker with progress rollups
Aggregate Northwind's key-result progress into objective-level scores automatically.
Mis à jour le 14 janv. 2026
Build a recurring-task generator
Spawn new Northwind task rows on a daily or weekly cadence from a Recurring sheet.
Mis à jour le 10 janv. 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.
Mis à jour le 7 janv. 2026
Auto-rebuild grouped summaries on edit
Refresh pivot-style rollups the instant data changes — no manual recompute.
Mis à jour le 4 janv. 2026
Build a data-quality scorecard
Grade any sheet on completeness, validity, and freshness — surface gaps as a single score.
Mis à jour le 31 déc. 2025
Generate a warehouse pick or packing list
Format Northwind order rows into a print-ready pick list grouped by aisle.
Mis à jour le 27 déc. 2025
Build a meeting-cost calculator
Multiply attendees, salaries, and duration into a dollar figure — make the cost of meetings visible.
Mis à jour le 24 déc. 2025
Build a weighted raffle and winner picker
Draw winners with configurable odds — entries can have weights, e.g. for early-bird bonus.
Mis à jour le 20 déc. 2025
Build a shared-expense splitter
Compute who owes whom from a group expense log — Northwind off-site dinner, settled.
Mis à jour le 17 déc. 2025
Build a content calendar with status automation
Move posts through draft → review → scheduled → published based on date and approval columns.
Mis à jour le 13 déc. 2025
Auto-import every CSV dropped in a folder
Append new vendor CSV exports into a master sheet automatically — drop the file, walk away.
Mis à jour le 10 déc. 2025
Auto-flag stale rows that need review
Highlight records in the Leads sheet that have been untouched for more than 14 days.
Mis à jour le 6 déc. 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.
Mis à jour le 3 déc. 2025
Build a lightweight CRM pipeline board
Track deals through stages with stage-totals rolled up automatically — no CRM subscription required.
Mis à jour le 29 nov. 2025
Build a tiered commission calculator
Apply progressive rates to a Sales column — 5% to £10k, 8% above, 12% above £50k.
Mis à jour le 26 nov. 2025
Build a habit tracker with streak counting
Log daily checkmarks per habit and compute the current streak in a custom column.
Mis à jour le 22 nov. 2025
Auto-number invoices and POs without gaps
Assign sequential, gap-free document numbers as new rows appear in the Invoices sheet.
Mis à jour le 19 nov. 2025
Build a capacity-planning resource grid
Track who's allocated where across weeks — a single matrix view of team load.
Mis à jour le 15 nov. 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.
Mis à jour le 12 nov. 2025
Build a multi-currency expense consolidator
Normalise Northwind's spend from many currencies to GBP using the live FX function.
Mis à jour le 8 nov. 2025
Detect duplicate rows on a composite key
Flag rows in the Invoices sheet that match across (client, invoiceNumber).
Mis à jour le 5 nov. 2025
Build a two-way sync between two spreadsheets
Keep a shared client-facing sheet and a private internal sheet in step — both directions.
Mis à jour le 1 nov. 2025
Build a weighted scoring and ranking model
Score options by criteria, weight each criterion, and auto-rank — for vendor selection or feature prioritisation.
Mis à jour le 29 oct. 2025
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.
Mis à jour le 25 oct. 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.
Mis à jour le 17 sept. 2025
Auto-protect ranges after a deadline
Lock cells in the Submissions sheet once a deadline passes — no more late edits.
Mis à jour le 13 sept. 2025
Auto-sort a sheet whenever data changes
Keep the Projects sheet ordered by due date without anyone manually sorting.
Mis à jour le 10 sept. 2025
Detect and highlight data-entry anomalies
Flag outliers and impossible values on the Expenses sheet the moment a row is added.
Mis à jour le 6 sept. 2025
Auto-format new rows to match the table style
Apply borders, fonts, and data validation to appended rows in the Projects sheet automatically.
Mis à jour le 3 sept. 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.
Mis à jour le 2 août 2025
Scrape a web table into cells with one formula
Pull HTML tables into Sheets as a custom function — no IMPORTHTML quirks.
Mis à jour le 30 juil. 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.
Mis à jour le 26 juil. 2025
Build a sentiment-scoring function without AI
Rate text positive or negative with a tiny built-in lexicon — no API key, no quota.
Mis à jour le 23 juil. 2025
Build a unit-conversion function library
Convert between any units with one custom formula — kg/lb, km/mi, °C/°F, and the rest.
Mis à jour le 19 juil. 2025
Create a readability-scoring function
Rate text columns for reading difficulty with a Flesch reading-ease score in one formula.
Mis à jour le 16 juil. 2025
Generate scannable QR codes in cells
Render a QR code per row from its data — for asset tags, event badges, or product labels.
Mis à jour le 12 juil. 2025
Add distance and ETA functions with Maps
Fill drive times and distances between two cells inline using the Maps service.
Mis à jour le 9 juil. 2025
Validate IBANs, VAT IDs, and SKUs
Check structured identifiers in a cell with a single custom function — no manual lookup.
Mis à jour le 5 juil. 2025
Build a working-day math function
Add or count business days excluding weekends and a custom holiday list — with a single Sheets formula.
Mis à jour le 2 juil. 2025
Create a live currency-conversion function
Convert amounts inline with a CONVERT-style formula, using a cached live exchange rate.
Mis à jour le 27 juin 2025
Create a fuzzy text-matching function
Match near-duplicate names across two lists with a Levenshtein-based custom function.
Mis à jour le 23 juin 2025
Write a custom function to geocode addresses
Turn a column of addresses into latitude/longitude pairs with a single Sheets formula.
Mis à jour le 20 juin 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.
Mis à jour le 30 août 2025
Build a subscription churn dashboard
Track active, churned, and reactivated accounts month over month from a Subscriptions sheet.
Mis à jour le 27 août 2025
Build a cohort-retention analysis tab
Compute month-over-month retention curves from a signups log — built monthly cohorts, automatic.
Mis à jour le 23 août 2025
Build a budget-vs-actual variance tracker
Compute and colour-code variances between budgeted and actual spend per project category.
Mis à jour le 20 août 2025
Generate a project burndown chart
Visualise remaining work against an ideal line, refreshed nightly from the Tasks sheet.
Mis à jour le 16 août 2025
Build a self-updating Gantt chart
Drive a visual timeline from start and end date columns in the Projects sheet.
Mis à jour le 13 août 2025
Render a heatmap calendar from daily values
Build a GitHub-style activity grid in cells from a column of dated counts.
Mis à jour le 9 août 2025
Build a rolling 12-month KPI dashboard
Auto-shift the time window so the Northwind dashboard always shows the last 12 months — never a stale snapshot.
Mis à jour le 6 août 2025