Confirm event signups with a calendar invite

People who sign up for an event often forget it. When a row is added to your Event signups tab, a calendar invite file for your event is made and emailed to that person with a short confirmation, so they can add it to their own calendar in one click.

You give it the event's name, start time and location once when you set the workflow up. Your tab needs columns named Name and Email.

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: eventName

Email 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