A production-ready pattern for capturing form submissions and writing them to Google Sheets with server-side validation, duplicate checks, and conditional email notifications. Includes Drive attachment handling, reCAPTCHA verification, and an admin sheet for toggling features without code edits.
A minimal web app using Google identity. Roles (viewer, editor, admin) are stored in a “Users” sheet and enforced server-side. Demonstrates templated HTML service, cached lookups, and fine-grained permissions for menu/actions—great starter for internal tools.
Time-driven triggers fetch data (APIs/Sheets), normalize it, and refresh a dashboard tab with charts and sparklines. Includes backfill script, audit log, and failure alerts. Ideal for automated morning reports.
Parse incoming emails (e.g., invoices/leads) by label, extract fields via regex, and append rows into a structured Sheet. De-duplicates via message IDs and supports reply-to automations (e.g., “Thanks, recorded—Ticket #1234”).
Convert Google Calendar events into a weekly timesheet in Sheets with project codes, billable flags, and rounding rules. Includes summary pivot, export to CSV, and Slack/email approvals.
