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