Automatically send Google Calendar event invite from RSVP Google Form

Automatically send a Google Calendar event invite when someone registers/RSVPs using a Google Form.

Setup

Video walkthrough here

1. Create a new Google Calendar event for your regional group meeting with all the details you'd like.
   • Ensure that the title of your event is unique in your Google Calendar. One suggestion is to add the year and month to the end of the event to make it easy to identify, like "CITE Regional Group Meeting 2024.09".
2. Copy or create a Google RSVP Form (our template is here if you'd like to use it).
   • If you are not using our template, ensure that there is a field titled "Email Address" or that you are collecting email addresses through the form's built-in feature.
3. In the Google Form, click Responses -> Link to Sheets and create a new spreadsheet.
4. In the linked spreadsheet, click Extensions -> Apps Script.
5. Copy/paste all the code from the Code.gs file into the Code.gs file that pops up, and modify the variables to match your form and Google Calendar event:
   • FORM_ID - copy/paste the ID of the Google Form from the URL bar
   • EVENT_TITLE - copy/paste the title of your Google Calendar event here
6. In the Google Apps Script window, click Project Settings, and tick the box to Show "appsscript.json" manifest file in editor
7. Click on Editor, and copy/paste the code from the appsscript.json into the appsscript.json file.
8. Click on Code.gs, then ensure the setup function is selected, then click run and allow any permissions that are requested.
9. At this point, everything should be set up, but I would recommend running a test to ensure it works expected.

Original Walkthrough and code here