Google Workspace Properly: Forms, Apps Script, Sharing Logic

⚠️ Version note. Google's menus and Apps Script editor change over time. The workflow — Form → Sheet → automation, plus sane sharing — is stable. Last checked: 25 July 2026.

What you'll have at the end

• A Google Form that collects responses straight into a Sheet
• One small Apps Script automation that acts on a new response
• Sharing set deliberately — the difference between "view", "comment", "edit", and the dangerous "anyone with the link"

Prerequisite

• TL-01 — Spreadsheets From Zero. Responses land in a sheet; you'll want basic formulas.
• A Google account.

The point: collect once, act automatically

Most people use Google tools as separate islands — a form here, a spreadsheet there, emailing links around. Used properly, they're a pipeline: a Form gathers structured data, a Sheet stores and computes on it, Apps Script reacts to it, and sharing controls exactly who can do what. Wiring those together is a genuinely useful, employable skill — and it's not hard.