Updated: 09/24/2023 (Pending approval)
If you host a lot of free virtual or in person events, managing registrations and sending calendar invites can quickly become an administrative nightmare. With some help with a little Apps Script we can automate most of this work. Google Forms have become so ubiquitous that it’s a logical starting point for any registration form. Likewise, Google Form submissions can trigger further automation. Google Calendar makes it easy to share event information with participants including any Google Meet links and resources. It also makes it easy to send a message to all attendees should there be a last minute change.
Given the strengths of these two Google Workspace Apps, I propose they join forces in a Google Workspace Add-on. The main logic behind this is creating a dedicated events calendar, then populating a Google Form with events from that calendar. When an individual selects an event ( or multiple events) during the registration process it will automatically invite them to the calendar event(s).
By default, the add-on scans for events up to 3 months in the future from today’s date.
Here is a video demonstration: