Skip to main content

First, thanks for reading! 
 

I have a marketing company that logs appointments on Google Sheets (Name, Number, Date, Time). I partner with 20+ car dealerships, so I have 20+ spreadsheets (1 per location). 
 

My goal is to integrate Calendar with Sheets so when there’s a new appointment on Calendar it’ll trigger a new appointment row on Sheets. 
 

I'm sure this can be done, but I’m still familiarizing myself with this software. 
 

Thank you in advance for any valuable information! 

Hi @AFrederick 

 

Check out the available triggers/actions/searches for each app…

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

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

 

Steps

  1. Trigger: GCal - New Event
  2. Action: GSheets - Add Row

Hey @AFrederick,

Just wanted to check in, were you able to get things working with the info Troy provided?

The suggested steps should be able to get new events from Google Calendar added into the Google Sheet as they are created in the calendar.