I’m creating a Google Form called “Calendar Request” so our employees can request events to be added to our organization’s main Google Calendar.
My plan is to add an “Approved?” column in the form response Google Sheet with checkbox data validation; checking the box (i.e. altering that column) would trigger a Zap that pulls information from the form response sheet to create a detailed calendar event in our main calendar.
I’d like the Zapier action to “Create Detailed Event in Google Calendar” to include resources such as rooms and vehicles that have already been set up within our Google Workspace. Resources don’t have unique email addresses, but they do each have their own calendar. They are typically added to events from within Google Calendar like attendees.
The only field I see on the Zapier action that might work to request resources is “Attendees” - but since Resources don’t have unique email addresses, I am not sure if field mapping will be sufficient. Please help!