How to create a Google Form or Google Sheets entry when there's a new or changed Google Calendar event?

Hi ​@thehost.Greene 

Check out the available triggers/actions for each app:

• GCal
  • https://zapier.com/apps/google-calendar/integrations#triggers-and-actions
  • https://zapier.com/apps/google-calendar/integrations#help
• GSheets
  • https://zapier.com/apps/google-sheets/integrations#triggers-and-actions
  • https://zapier.com/apps/google-sheets/integrations#help

STEPS

1. Trigger: GCal - New or Updated Event
   1. Specify the Calendar 
2. Action: GSheets - Lookup Row
   1. Enable the checkbox to create row if not found
   2. Thus step becomes find/create row
3. Action: Filter
   1. Check if Zap step 2 found an existing row
      1. Help: https://zapier.com/apps/filter/integrations#help
4. Action: GSheets - Update Row
   1. Map the Row/ID from Zap step 2

Hello ​@thehost.Greene 
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

Hey ​@thehost.Greene,

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

Hey there ​@thehost.Greene 👋 How did you get on with the suggestions from Troy, drtanvisachar and Sparsh?

Let us know what worked for you, or whether you’re still having some trouble getting the events into Google Sheets. 🙂