I set up a zap to create detailed calendar events from a google sheet. What I am hoping to figure out is how to set it up so that when a row on a google sheet is changed or updated, that the event is also updated.
Best answer
Use a zap to update existing events in google calendar
Best answer by andywingrave
Hey all, just wanted to summarise this thread for future community members:
As Troy mentioned, you can achieve this with 2 separate zaps.
In the first zap, we want to create a zap when a row is updated
- Trigger: GSheet - New/Updated Row
- Action: GCal - Create Detailed Event
- Then using the row ID from the trigger step, we want to create an action:
- Action: GSheets - Update Row (log the GCal Event ID)
Then for the second zap we want to trigger when a row is updated
- Trigger: GSheets - New/Updated Row
- Action: GCal - Update Event (use the GCal Event ID)
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Orchestrator & Solution Partner
2 Zaps
- Trigger: GSheet - New/Updated Row
- Action: GCal - Create Detailed Event
- Action: GSheets - Update Row (log the GCal Event ID)
- Trigger: GSheets - New/Updated Row
- Action: GCal - Update Event (use the GCal Event ID)
- Beginner
Hi thanks i’ve got it working just about! It’s creating a row ID in spreadsheet and updating changes to rows. However, it’s creating new events and leaving the old ones in the calendar. Any thoughts on how I can clean this up!!?
- Beginner
i’ve tested a few more rows and it seems to be working now, not sure why it wasn’t cleaning out the old events immediately.. but i’ll take it.
- Beginner
Hi there guys
I have this working now, the thing is it it’s using all of my tasks up when I run it.
I think the G Cal event ID is continually creating a new version of itself. Is there any way I can stop this happening or get zaps to ignore this column?
+9- Zapier Solution Partner
- Answer
Hey all, just wanted to summarise this thread for future community members:
As Troy mentioned, you can achieve this with 2 separate zaps.
In the first zap, we want to create a zap when a row is updated
- Trigger: GSheet - New/Updated Row
- Action: GCal - Create Detailed Event
- Then using the row ID from the trigger step, we want to create an action:
- Action: GSheets - Update Row (log the GCal Event ID)
Then for the second zap we want to trigger when a row is updated
- Trigger: GSheets - New/Updated Row
- Action: GCal - Update Event (use the GCal Event ID)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.