Skip to main content
Question

Google Calendar to Google Sheets

  • October 20, 2020
  • 7 replies
  • 116 views

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.

Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+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


  • Author
  • Beginner
  • 3 replies
  • October 20, 2020

Thanks Troy

 

 


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

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


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.


AndrewJDavison_Luhhu
Forum|alt.badge.img+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.


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.


AndrewJDavison_Luhhu
Forum|alt.badge.img+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?