Live updates from Google Sheets to monday.com

[bak1221]

Hello! I am trying to set up a flow so any updates made in a google sheet are then synced to Monday.com. I was able to successfully set up the trigger for new rows that were added, but can't seem to get the changes done properly.

I set it up as follows:

• Trigger - Google sheets / New or updated spreadsheet row
  • The trigger column I set to the last column in the row because when I was testing it to be the third, it stopped sending any information after column 3 (even though column 3 is generally what I want to be the trigger for both updates and new rows)
• Next step - router / conditionally run
  • Route 1 - Filters / Column G exists -> action: Monday.com / create item
  • Route 2 - Filters / Column C or G exist -> action: Search items by column value / Column C -> update item column value
    • This is really where I'm stuck because it's not updating the necessary items

The first three screenshots are the ones tied to the update flow and the fourth and fifth are the ones that are set up for creating a new item.

Any help would be greatly appreciated!

 

[Himesh]

Hello @bak1221 ,
This video might be helpful

If you still unable to resolve that let me know we'll have a free zoom call. FYI I'm not from pabbly connect team. I'm just an automation freelancer who helps other pabbly connect users.