F3Go30

Google Apps Script automation for managing monthly Go30 fitness challenge trackers in Google Sheets.

About

• Short: Automates copying and initializing a monthly Go30 tracker spreadsheet and its signup form, wiring triggers, URL shortening, and logging for non-technical operators.
• Topics: apps-script, google-sheets, automation, fitness, go30, beads, gdpr-conscious

---

Getting Started

Prerequisites

• Google account that owns the Go30 tracker spreadsheet
• Go30 Template spreadsheet created and accessible (the bound script is deployed on this template)
• clasp installed: npm install -g @google/clasp
• .clasprc.json configured by running clasp login from the script/ folder. (clasp will create this file automatically.)
• TINYURL_ACCESS_TOKEN Script Property configured (see OPERATIONS.md)

Deploy

cd script
clasp push

Open the spreadsheet with the owner account — the F3 Go30 custom menu should appear.

See OPERATIONS.md for full configuration and failure mode reference.

---

Documentation

Document	Purpose
CONTEXT.md	Purpose, capabilities, use cases, glossary
DESIGN.md	Architecture, modules, data model, runtime risks
OPERATIONS.md	Configuration, deployment, failure modes
ADRs	Architecture decision records
Sheet reference	Per-sheet descriptions, column layout, formulas, and operational notes

Project Management

• Recommended: use the Beads issue tracker for backlog and task management. Beads is optional but recommended for AI-assisted workflows and issue tracking that lives with the repository. See the included .beads/README.md for usage and local installation instructions, or learn more at https://github.com/steveyegge/beads.
• The repository includes a local Beads database (.beads/) so you can run bd commands locally without an external service. Using Beads is an optional prerequisite for following the project's documented bead-based workflows.