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 entry or Sheet entry from a GOOGLE: Calendar URL?
+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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.