Emails each person who signs up in a sheet a confirmation with a calendar invite for your event attached.
Uses
Gmail
Google Sheets
Confirm event signups with a calendar invite
Google SheetsWhen a row is added to the Event signups tab. Save it as signup.When a row is added to the Event signups tab. Save it as signup.
Event nameSet eventName to blank.Event startSet eventStart to blank.Event locationSet eventPlace to blank.
Make the calendar inviteCreate Calendar invite (.ics) Save it as invite.
Events: title: eventName; start: eventStart; location: eventPlace
File name: eventNameEmail the confirmationSend an email to signup.fields.Email. Save it as confirmed.
Subject: You're signed up for eventNameHi signup.fields.Name,
You're signed up for eventName at eventPlace. The calendar invite is attached.Gmail