Automate two-session workshop invitations
At a glance
A workshop organizer used Claude to build a form-and-calendar workflow for monthly onboarding cohorts. This workflow is listed under Events, Automation, Administration.
- Agents / tools
- Claude, Google Forms, Google Sheets, Google Apps Script, Google Calendar, Zoom
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Set up a Google Form with a choice of monthly cohorts, a linked response spreadsheet, and consistently named Google Calendar events for the two Zoom sessions. The author gave Claude a description of the process in a Project with supporting documents. 2) Ask Claude to create an Apps Script connected to the response sheet: it checks for new registrants every 30 minutes, finds the selected cohort's calendar events and adds each person to both. It also sends a confirmation and emails the organizer on failures. 3) Maintain the form's cohort choices and calendar events monthly, adjust the script when needed, and handle any error alerts manually.
How it went
The author reported moving from daily manual checks to monthly maintenance and giving attendees a clearer registration process.
Worth knowing
The running automation is Google Apps Script; Claude helped create it but does not run each registration. The author still occasionally adjusts the script and updates the form.