Google Sheets automation

Build an OKR tracker with progress rollups

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

Actualizado 14 ene 2026

Build a recurring-task generator

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

Actualizado 10 ene 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.

Actualizado 7 ene 2026

Auto-rebuild grouped summaries on edit

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

Actualizado 4 ene 2026

Automatización Intermedio Sheets Docs

Build a data-quality scorecard

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

Actualizado 31 dic 2025

Generate a warehouse pick or packing list

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

Actualizado 27 dic 2025

Build a meeting-cost calculator

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

Actualizado 24 dic 2025

Build a weighted raffle and winner picker

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

Actualizado 20 dic 2025

Build a shared-expense splitter

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

Actualizado 17 dic 2025

Automatización Intermedio Sheets Drive

Build a content calendar with status automation

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

Actualizado 13 dic 2025

Auto-import every CSV dropped in a folder

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

Actualizado 10 dic 2025

Auto-flag stale rows that need review

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

Actualizado 6 dic 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.

Actualizado 3 dic 2025

Build a lightweight CRM pipeline board

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

Actualizado 29 nov 2025

Build a tiered commission calculator

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

Actualizado 26 nov 2025

Build a habit tracker with streak counting

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

Actualizado 22 nov 2025

Auto-number invoices and POs without gaps

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

Actualizado 19 nov 2025

Automatización Intermedio Sheets Gmail

Build a capacity-planning resource grid

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

Actualizado 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.

Actualizado 12 nov 2025

Build a multi-currency expense consolidator

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

Actualizado 8 nov 2025

Detect duplicate rows on a composite key

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

Actualizado 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.

Actualizado 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.

Actualizado 29 oct 2025

Ver los 34 en 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.

Actualizado 25 oct 2025

Formatting

Apply conditional styles, freeze structure, and clean data.

5 artículos

Build a dependent dropdown system

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

Actualizado 17 sept 2025

Auto-protect ranges after a deadline

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

Actualizado 13 sept 2025

Auto-sort a sheet whenever data changes

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

Actualizado 10 sept 2025

Detect and highlight data-entry anomalies

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

Actualizado 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.

Actualizado 3 sept 2025

Custom functions

Write JavaScript functions usable from any cell.

13 artículos

Parse messy mixed-format dates

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

Actualizado 2 ago 2025

Scrape a web table into cells with one formula

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

Actualizado 30 jul 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.

Actualizado 26 jul 2025

Build a sentiment-scoring function without AI

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

Actualizado 23 jul 2025

Build a unit-conversion function library

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

Actualizado 19 jul 2025

Create a readability-scoring function

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

Actualizado 16 jul 2025

Generate scannable QR codes in cells

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

Actualizado 12 jul 2025

Add distance and ETA functions with Maps

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

Actualizado 9 jul 2025

Validate IBANs, VAT IDs, and SKUs

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

Actualizado 5 jul 2025

Build a working-day math function

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

Actualizado 2 jul 2025

Create a live currency-conversion function

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

Actualizado 27 jun 2025

Create a fuzzy text-matching function

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

Actualizado 23 jun 2025

Write a custom function to geocode addresses

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

Actualizado 20 jun 2025

Dashboards

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

8 artículos

Build a linear-projection forecasting model

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

Actualizado 30 ago 2025

Build a subscription churn dashboard

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

Actualizado 27 ago 2025

Build a cohort-retention analysis tab

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

Actualizado 23 ago 2025

Build a budget-vs-actual variance tracker

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

Actualizado 20 ago 2025

Generate a project burndown chart

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

Actualizado 16 ago 2025

Build a self-updating Gantt chart

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

Actualizado 13 ago 2025

Render a heatmap calendar from daily values

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

Actualizado 9 ago 2025