06 Automation & backend · internal system, no public URL
Festival & restaurant group · internal capture systems
A whole forms ecosystem on Google Workspace, deployed from the terminal — submission to database to notification, with no license fees.
AThe problem
A festival and a two-location restaurant group were collecting vendor applications, volunteer signups, artist and staff details, sponsorship commitments, job applications and customer reviews by hand — and paying a per-seat form vendor for the privilege.
BWhat we built
A complete Google Apps Script forms ecosystem, deployed from the terminal with clasp rather than pasted into a browser tab. Each form auto-connects to a Google Sheet acting as its database, and a trigger sends a formatted HTML notification email on every response.
CSignature pieces
The parts worth looking at.
- 01
Surgical updates in production
A live form can be changed without changing its public URL, without changing its ID, and without deleting responses already collected. The link printed on a flyer keeps working.
- 02
Bilingual by script, not by hand
Scripts rebuild a form in the other language and reassign its email triggers — so the Spanish version is a command, not a week of re-typing.
- 03
Idempotent by design
Every script can be re-run safely: no duplicate forms, no duplicate data, no orphaned triggers. It also finds existing forms in Drive by name instead of hard-coded IDs.
- 04
Validation and payment sections
Email format checks, required checkboxes and rating scales, plus payment sections handling Zelle, check, card with surcharge, and proof-of-payment over WhatsApp.
DDelivered
- Festival: three vendor forms by category ($100 / $250 / $550) with permit rules, refrigeration and electricity options and a payment section
- Festival: volunteer, artist/staff and attendee registration forms
- Festival: sponsorship at three tiers — Gold $1,500, Diamond $5,000, Elite $10,000
- Restaurant group: employment application and B2B customer registration
- Restaurant group: per-location review forms for Austin and Round Rock on a 1–5 scale
EOutcome
Fully automated capture — response to database to notification, with no human in the loop — at no license cost, replacing Typeform and Jotform. The scripts are reusable across future events and maintainable by whoever comes next.
FStack
- Google Apps Script
- Google Forms
- Google Sheets
- Gmail
- clasp (CLI)
- Triggers
- Google Workspace APIs
- Bilingual localization
- Idempotent scripts
GStill to supply
- [TODO-DUEÑO] Anonymized screenshots of a form and a notification email, if you want visuals here.