Best answer

Integrating Google Calendar/Spreadsheets

  • 22 March 2021
  • 2 replies
  • 32 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! 

icon

Best answer by Troy Tessalone 22 March 2021, 21:44

View original

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

Userlevel 3
Badge +6

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.

Userlevel 7
Badge +14

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