An automated event management system that turns a Google Form submission into a public, color-coded calendar entry in under 30 seconds.
The client, a Philadelphia nonprofit serving formerly incarcerated individuals and marginalized communities, needed a streamlined way to post community events to a public calendar. Their manual process was time-consuming, inconsistent, and lacked proper categorization.
Staff were spending roughly 5 minutes per event on manual data entry, formatting, and calendar posting. With dozens of events per month across six categories, this added up to hours of repetitive work -- time better spent on their mission. There was no analytics on event engagement, and the visual presentation of events was inconsistent and hard to scan.
An end-to-end automated event management system with four integrated components -- from submission to public display -- requiring zero manual data entry after the initial form fill.
A streamlined Google Form that staff complete in under 2 minutes.
Google Apps Script triggers on every form submission.
A custom JavaScript widget embedded in the client's Squarespace site.
A spreadsheet-driven import for loading multiple events at once.
A serverless pipeline: a form submission triggers a script that posts to the calendar and feeds the public widget -- no servers to maintain.
The public-facing calendar renders a month grid with color-coded events by category. Visitors click an event to see details and register. Every click is tracked via HubSpot UTM parameters. The live widget runs on the client's Squarespace site at domooregood.org.
View the live calendar on domooregood.org