Update row in GG sheet when there has changes from GG calendar

I try to make a update if any changes from GG calendar, but it seem doesn’t work atm


image

Hello! Welcome to the Make Community!

Apparently, you are trying to map the EventID of the Calendar item to a RowID of Google Sheets; which will not work, because IDs are different between the 2 products.

Assuming that you have a column “EventID” in your spreadsheet, you first need to make a Search Rows in Google Sheet, and filter with the “Column:EventID=Even ID (from Calendar)”.

When doing so, you will use the filters in each route. In the top one (where you do Add A Row), your filter should be “Total number of bundles - numeric EQUAL TO - 0”, and the lower one should be a Fallback.

Let me know if I wasn’t clear

Benjamin

Hi @Dung_Ha

You can search for the row with that event id and then get the row number to update the row:


Best regards,

Msquare Automation
Gold Partner of Make
@Msquare_Automation