Tutorials

Step-by-step Google Workspace automations. Every workflow is free to follow. Templates and bundles available if you want the shortcut.

Invoice Tracker
How to Create an Automatic Invoice Tracker in Google Sheets
Build an automatic invoice tracker in Google Sheets with overdue detection, dashboard summaries, and email reminders. Step-by-step guide with copy-paste code.
14 min read
Sheets → PDF
How to Automatically Generate PDFs from Google Sheets
Step-by-step guide to generating formatted PDF documents from Google Sheets row data using Apps Script. Copy-paste code included.
12 min read
Form → Doc/PDF
How to Automatically Create Documents from Google Form Responses
Auto-generate formatted documents from Google Form submissions using Apps Script. Turn every form response into a PDF, intake summary, or client brief.
14 min read
Recurring Reports
How to Automate Recurring Reports in Google Sheets
Set up automated weekly, daily, or monthly reports from Google Sheets data. Script reads metrics and emails a formatted summary on a schedule.
13 min read
Lead Tracking
Google Sheets Lead Tracker Template (+ How to Automate Follow-Up)
Free Google Sheets lead tracker template with status tracking, owner assignment, and automated follow-up emails. Download and start using it in 5 minutes.
12 min read
Email Automation
How to Automatically Send Emails from Google Sheets
Send emails automatically when a Google Sheet changes. Trigger on cell edits, new rows, checkbox clicks, or a schedule. Copy-paste Apps Script included.
13 min read
Forms + Email
How to Send Email Notifications from Google Forms
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.
11 min read
Email Automation
How to Send Reminder Emails from Google Sheets Based on a Date
Automatically send email reminders from Google Sheets when a date is approaching or past due. Works for invoices, renewals, follow-ups, and deadlines.
9 min read
Invoice Template
Free Google Sheets Invoice Template (+ How to Add Reminders and PDF Export)
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.
8 min read
Lead Tracking
Free Google Sheets Lead Tracker Template (+ Statuses, Follow-Up, and Owner Columns)
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.
6 min read