Workflow templateCollect RSVPs and email a daily headcount
Records attendance and dietary needs from your RSVP form and emails the host a daily headcount digest.
Workflow illustration
01Trigger
ScheduleEvery 15 minutes, fetch new RSVPs from the Typeform form id you choose in setup.
02Go
Google SheetsRecord each person's attendance and dietary needs in the Google Sheets spreadsheet id you choose in setup, skipping responses already in the list.
03
Custom stepEvery day at 06:00 PM UTC, count the yes and no answers in that sheet.
04Gm
GmailEmail the host a digest of the day's RSVPs with Gmail.
05
OutputFinish
How it runs
This is the brief Whenever builds from. Change any of it in plain words before you publish.
When
Every 15 minutes, fetch new RSVPs from the Typeform form id you choose in setup.
Then
- Record each person's attendance and dietary needs in the Google Sheets spreadsheet id you choose in setup, skipping responses already in the list.
- Every day at 06:00 PM UTC, count the yes and no answers in that sheet.
- Email the host a digest of the day's RSVPs with Gmail.