Automations
Real, project-based tutorials grouped by Google service, integration, and goal.
By Google service
Email & Gmail automation
Automate inbox triage, mail merges, scheduled reports, and attachment handling with Gmail and Google Apps Script.
4 clusters · 55 articles
Google Sheets automation
Automate data entry, formatting, custom functions, and dashboards in Google Sheets with Apps Script.
4 clusters · 60 articles
Google Docs automation
Generate documents from templates, batch-create invoices and contracts, and export Docs to PDF with Apps Script.
2 clusters · 35 articles
Google Slides automation
Generate decks from spreadsheets, batch-export slide content, and personalise presentations with Apps Script.
2 clusters · 30 articles
Google Drive automation
Organise, audit, and back up Google Drive files and folders at scale with Apps Script.
3 clusters · 45 articles
Google Calendar automation
Create events from Sheets, sync calendars, and email weekly meeting summaries with Apps Script.
2 clusters · 35 articles
Google Forms automation
Notify, route, and post-process Google Forms responses automatically with Apps Script.
2 clusters · 30 articles
By integration
AI-powered workflows
Use Claude, Gemini, and other LLMs from Apps Script to classify, summarise, extract, and generate content.
5 clusters · 65 articles
External APIs
Call REST APIs, import third-party data, and send messages from Google Apps Script using UrlFetchApp.
3 clusters · 50 articles
Web apps & deployment
Build webhooks, internal tools, and tiny web services with Apps Script deployed as a web app.
2 clusters · 35 articles
By goal
Reporting & dashboards
Scheduled reports, live KPI dashboards, and recurring data summaries powered by Apps Script.
0 clusters · 147 articles
Notifications & alerts
Email, Slack, Telegram, and SMS notifications triggered by spreadsheets, forms, calendars, and APIs.
0 clusters · 45 articles
File management
Organise, audit, and back up Drive content. Generate, route, and clean up documents at scale.
0 clusters · 84 articles
Approval workflows
Multi-step approvals, sign-offs, and routing flows built on Forms, Sheets, and Gmail.
0 clusters · 99 articles
Content generation
Generate documents, decks, emails, and AI-drafted content in bulk from your existing data.
0 clusters · 174 articles