Best answer

Use a zap to update existing events in google calendar

  • 28 October 2020
  • 7 replies
  • 949 views

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.

icon

Best answer by andywingrave 3 March 2021, 01:49

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.

7 replies

Userlevel 7
Badge +14

2 Zaps

  1. Trigger: GSheet - New/Updated Row
  2. Action: GCal - Create Detailed Event
  3. Action: GSheets - Update Row (log the GCal Event ID)
  1. Trigger: GSheets - New/Updated Row
  2. Action: GCal - Update Event (use the GCal Event ID)
Userlevel 1

Hi Troy, 

 

What do you then add as ‘Row’ information in 3rd action of the 1st App?

Userlevel 7
Badge +14

The Row ID of the Trigger Step.

Userlevel 1

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!!?

Userlevel 1

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.

Userlevel 1

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?

Userlevel 7
Badge +9

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

  1. Trigger: GSheets - New/Updated Row
  2. Action: GCal - Update Event (use the GCal Event ID)