I am subscribed to a Google calendar URL and would like to be notified either via Google sheets or Google forms of any new calendar events or changes to calendar. First, How would I go about setting up this zap to pull event data from google calendar? Then How would I go about pushing that data to google sheets or google forms (that pushes data to google sheets)?
Question
How to create a Google Form or Google Sheets entry when there's a new or changed Google Calendar event?
+14- Zapier Orchestrator & Solution Partner
Hi
Check out the available triggers/actions for each app:
- GCal
- GSheets
STEPS
- Trigger: GCal - New or Updated Event
- Specify the Calendar
- Action: GSheets - Lookup Row
- Enable the checkbox to create row if not found
- Thus step becomes find/create row
- Action: Filter
- Check if Zap step 2 found an existing row
- Action: GSheets - Update Row
- Map the Row/ID from Zap step 2
+3Hello
You can use Zapier’s Google Calendar trigger "New Event" or "Event Updated" to pull events from your calendar. Then use Google Sheets action "Create Spreadsheet Row" to push the event data into a sheet. Directly pushing to Google Forms isn’t supported, but you can use Webhooks or push to the form’s connected sheet instead.
Dr. Tanvi Sachar
Monday Certified Partner, Monday Wizard
+6- Zapier Solution Partner
Hey
What do you mean by subscribed to the Google Calendar URL? For the zap to work, you need the necessary permissions to view, add or manage events on the calendar you want to access.
Then you can just use New or Updated Event trigger from Google Calendar in Zapier.
Pushing to google forms will not work and you will have to Create Spreadsheet row action to push that data to Google sheets. Hope it helps!
PS: If you need more active help, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.