Question

Google Calendar to Google Sheets

  • 20 October 2020
  • 7 replies
  • 107 views

Userlevel 1

I’m new to zapier and I love it, in concept.  I was able to get it to do one important function which is to update a google shees with a new event added to google calendar. I love seeing new events auto populate into my spreadsheet.

However, I’m going in circles trying to get it to do some other things I’m hoping it will help me with.

I need it also to update a google sheet row when an event in google calendar is changed

and I need it to delete a google sheet row when an event is cancelled.

I have a feeling I’m doing something wrong in the row field but I’ve tried every option and It’s still not working.  

If anyone could help with their Zapertise I would be very grateful.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Userlevel 7
Badge +10

Hi @ThePuliceDept - have you been touch with support yet. They run 24/7 and will definitely help guide you through this. You can open a ticket here: https://zapier.com/app/contact-us

In terms of trying to get help here. Can you show us screenshots of how the various steps of your zap are setup?

Userlevel 1

Thanks. I tried that but again the zap failed to find the row and make the change. It just added a new row again. I love the idea of zaps but the lack of customer service makes it hard to advocate its use company wide.

Userlevel 7
Badge +10

@ThePuliceDept 

You might want to consider a zap that triggers when the event is created and adds the Gcal event ID to the Google Sheet - giving you a search key you can use to record changes.

Userlevel 1

Thanks for checking in. I have it working mostly, though not consistently. The biggest challenge is with calendar changes. Zapier can’t find the correct row to make the change so I have to manually go in and make the changes.

Userlevel 7
Badge +10

Hi @ThePuliceDept 
Just checking in to see if you still need help with this? 

Userlevel 1

Thanks Troy

 

 

Userlevel 7
Badge +14

Please provide screenshots of your Zap step configurations.

Action: GSheets - Lookup Row

Triggers/Actions/Searches available for the apps:

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

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