Skip to main content
Best answer

Integrating Google Calendar/Spreadsheets

  • March 22, 2021
  • 2 replies
  • 54 views

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! 

Best answer by Troy Tessalone

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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • March 22, 2021

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

william
Forum|alt.badge.img+6
  • Zapier Staff
  • May 27, 2021

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.