Tutorials

Build an automatic invoice tracker in Google Sheets with overdue detection, dashboard summaries, and email reminders. Step-by-step guide with copy-paste code.

Step-by-step guide to generating formatted PDF documents from Google Sheets row data using Apps Script. Copy-paste code included.

Auto-generate formatted documents from Google Form submissions using Apps Script. Turn every form response into a PDF, intake summary, or client brief.

Set up automated weekly, daily, or monthly reports from Google Sheets data. Script reads metrics and emails a formatted summary on a schedule.

Three ways to combine data from multiple Google Sheets tabs or files — IMPORTRANGE, VSTACK, and Apps Script — with the tradeoffs of each.

Add dropdown lists to Google Sheets cells using data validation. Three methods covered — typed list, range-based list, and dependent dropdowns.

Create dependent dropdowns in Google Sheets where the options in one dropdown change based on what's selected in another. Uses the INDIRECT function — no code needed.

Build a custom data entry form directly inside Google Sheets using a sidebar created with Apps Script. No Google Forms, no external tools.

Conditional formatting changes cell color based on rules you define. Here's how to set it up, write custom formulas, and avoid the most common mistakes.

Build a project tracker in Google Sheets that shows task status, progress by owner, and overdue items at a glance — with a free downloadable template.

IMPORTRANGE pulls live data from another Google Sheet into yours automatically. Here's the exact syntax, how to fix common errors, and when to use it.

Free Google Sheets lead tracker template with status tracking, owner assignment, and automated follow-up emails. Download and start using it in 5 minutes.

Zapier and Make both automate Google Sheets workflows, but they work differently and cost differently. Here's which one fits your situation.

Send emails automatically when a Google Sheet changes. Trigger on cell edits, new rows, checkbox clicks, or a schedule. Copy-paste Apps Script included.

Google Sheets can replace a CRM for small teams — if you know what to build. Here's when it works, when it doesn't, and how to get started.

Apps Script is Google's built-in tool for automating Google Sheets — no installation, no coding background needed. Here's how to write and run your first script.

Build an expense tracker in Google Sheets that categorizes spending, calculates monthly totals automatically, and emails you a weekly summary.

Lock cells or entire sheets in Google Sheets to prevent accidental edits. Covers protected ranges, editor permissions, and the difference between warning and full lock.

The QUERY function lets you filter, sort, and summarize Google Sheets data using SQL-like syntax. Here's how to write queries, with examples for common use cases.

VLOOKUP finds a value in one column and returns a related value from another column. Here's how to write it, what the arguments mean, and how to fix the most common errors.

Connect Google Sheets to other apps using Zapier — send rows to a CRM, post to Slack, or add records when a form is submitted. Step-by-step with no code needed.

The Google Sheets keyboard shortcuts worth memorizing — navigation, formatting, formula entry, and sheet management. Covers both Windows and Mac.

Set up email notifications from Google Forms: confirmations to respondents, alerts to your team, and custom emails based on answers. Default setup plus Apps Script upgrade.

Google Sheets can act as a lightweight database for many real-world use cases. Here's where it works, where it breaks down, and what to use instead when it does.

Google Sheets can send automatic email reminders using Apps Script. Here's what's possible, what requires a script, and where to start.

Automatically send email reminders from Google Sheets when a date is approaching or past due. Works for invoices, renewals, follow-ups, and deadlines.

Build a personal or business budget tracker in Google Sheets that shows planned vs actual spending, variance by category, and alerts when you're over budget.

Use Apps Script to automatically move a row from one Google Sheets tab to another when a status changes — like moving completed tasks to a Done tab.

COUNTIF counts cells that meet a single condition. COUNTIFS handles multiple conditions. Here's the syntax, examples, and fixes for the most common mistakes.

Automatically color entire rows in Google Sheets when a cell meets a condition. No code — just conditional formatting with a custom formula.

Download a free Google Sheets invoice template with payment tracking, automatic reminders, and PDF export. No sign-up required. Copy to your Drive and start invoicing.

Download a free Google Sheets lead tracker with status dropdowns, owner assignment, follow-up dates, and a dashboard. Copy it to your Drive in one click.

Send automated Slack messages from Google Sheets using Apps Script and a Slack webhook. No add-ons, no paid tools — just a short script and a free webhook URL.