Course track
Google Workspace Automation and Apps Script
A practical path through Google-native automation: Apps Script, Sheets, Gmail, Forms, Calendar, approval flows, triggers, quotas, and the difference between lightweight Google Workspace scripting and broader external orchestration platforms.
Lessons13
Live now13
Draft queue0
This track page is intentionally kept out of the index until more of the public lessons are live. That keeps the curriculum navigable for humans without asking search engines to rank thin track pages before the lesson bodies exist.
Track lessons
Live lessons link out directly. Draft lessons are already scaffolded in the repo so the track can be written in order without changing slugs or metadata later.
- Lesson 1LiveGoogle Apps Script Explained for Workflow Automation
- Lesson 2LiveApps Script vs Zapier vs Make
- Lesson 3LiveHow to Write Your First Apps Script Automation
- Lesson 4LiveSimple Triggers vs Installable Triggers in Apps Script
- Lesson 5LiveHow to Automate Google Sheets with Apps Script
- Lesson 6LiveHow to Automate Gmail with Apps Script
- Lesson 7LiveHow to Automate Google Forms and Form Responses
- Lesson 8LiveHow to Automate Google Calendar and Reminders
- Lesson 9LiveWebhooks and UrlFetchApp in Apps Script
- Lesson 10LiveHow to Build Approval Workflows in Google Workspace
- Lesson 11LiveApps Script Quotas and Execution Limits Explained
- Lesson 12LiveHow to Debug Apps Script Errors
- Lesson 13LiveBest Google Workspace Automation Ideas for Small Teams
Tools that fit this track
Free, privacy-first utilities in your browser — no uploads required for most workflows.
- Excel SuiteComplement Google Sheets workflows with browser-based joins, pivots, and ad hoc spreadsheet analysis.
- CSV Tools SuiteSplit, merge, validate, and profile CSV files that move into or out of Google Workspace workflows.
- Universal ConverterBridge JSON, CSV, XML, and spreadsheet formats while testing Apps Script and Workspace handoffs.
- URL Builder & EncoderAssemble clean URLs with query strings, encoded params, and UTM blocks for workflow steps and callbacks.
Browse other course tracks
- Workflow Automation FoundationsStart here if you are still defining the model. This track covers what workflow automation actually is, how integrations fit into it, when automation is worth doing, how to map a workflow cleanly, and which use cases create leverage instead of chaos.
- APIs, Webhooks, and Integration BasicsThe technical core of modern automations: APIs, webhooks, authentication, retries, quotas, schemas, and error handling. This track is where non-technical operators stop feeling blocked and technical builders stop shipping brittle workflows.
- Zapier WorkflowsA practical track for teams standardizing on Zapier. Learn how Zaps are structured, how to use built-in tools like Formatter, Filters, Paths, and Webhooks, what task usage really means, and where Zapier is strong or weak compared with other platforms.