12 Google Apps Script automation examples for your business
From auto-generated invoices to attendance trackers and manager alerts — here are twelve Google Apps Script automations that remove real, daily busywork for small and mid-size businesses.
Why examples matter more than theory
When people say 'I want to automate my business', what they usually mean is 'I have a specific spreadsheet task I do by hand'. Examples make automation concrete. Here are twelve we've built or see constantly — in rough order of how often they save serious hours.
The sheet-based examples
- Auto-generated invoices — create a PDF invoice from your template when a row is added, email it to the customer, and log it. (The classic time-saver.)
- Attendance and leave tracker — employees submit via a Google Form; overtime, balances, and monthly totals calculate themselves.
- Inventory with reorder alerts — stock levels live in Sheets, and the script flags (or messages) anything running low.
- Expense tracker with approval — submissions route to the right approver and file themselves once approved.
- Weekly management report — the script compiles totals from your sheets and emails a summary every Monday morning.
The email and messaging examples
- Gmail auto-triage — label, forward, or reply to emails based on rules (e.g. support tickets vs invoices).
- Auto-send emails from Sheets — send a personalised email to each row in your sheet, one by one.
- WhatsApp notifications from Sheets — trigger a WhatsApp message when a sheet changes, like an order or a stock alert.
- Reminder sequences — automatic reminders for renewals, overdue payments, or document submissions.
The process examples
- Document generator — create contracts, offer letters, or PO documents from a template and fill them with the right data.
- CRM without the subscription — a Sheets-based CRM with Apps Script that tracks leads, stages, and follow-ups.
- Approval workflow — a Google Form submission triggers a chain of approvals and notifications until it's done.
How to pick your first one
Choose the task that costs the most time per week, not the one that sounds most impressive. The invoice generator is a crowd favourite because it's visible, daily, and error-prone by hand. If stock or money is involved, that's usually the highest-ROI target.
Once you know what you want, a good developer is the difference between a script that runs forever and a hack that breaks on Fridays. See what proper Google Apps Script development includes — testing, error alerts, and handover are non-negotiables.