My zap runs great for when I put my info in google sheets it creates a perfect event in google calendar. However, if I go back an make an edit/change to any info in the google sheet, it will create a NEW event in google calendar instead of just updating it. How do I achieve this goal?
Double event being created in Google Calendar instead of being updated
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 4
+6
- Zapier Staff
- 406 replies
-
4 April 2023
Hi
Welcome to the Community! I'm sorry you’re having trouble with your Zap.
If you need to make any of those changes to your Google Sheet, turn your Zap off while you work on the spreadsheet, and then turn it back on again.
Here’s a helpful guide about Google Sheets: https://help.zapier.com/hc/en-us/articles/8495995099533-Common-Problems-with-Google-Sheets-on-Zapier.
Hopefully this helps!
Userlevel 7
+14
- Certified Zapier Expert
- 23933 replies
-
4 April 2023
Hi
Good question.
You should save the GCal Event ID in a column on the GSheet to reference for updates.
Basically, 1 Zap if there is no GCal Event ID to create a new event, and 1 Zap if there is a GCal Event ID to update the event.
If you have a Pro+ plan, then you can use Zaps.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.