• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Live updates from Google Sheets to monday.com

bak1221

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

Attachments

  • Screenshot 2024-08-28 at 12.52.48 PM.png
    Screenshot 2024-08-28 at 12.52.48 PM.png
    45.6 KB · Views: 24
  • Screenshot 2024-08-28 at 12.52.39 PM.png
    Screenshot 2024-08-28 at 12.52.39 PM.png
    92.4 KB · Views: 22
  • Screenshot 2024-08-28 at 12.52.03 PM.png
    Screenshot 2024-08-28 at 12.52.03 PM.png
    89.3 KB · Views: 22
  • Screenshot 2024-08-28 at 12.53.28 PM.png
    Screenshot 2024-08-28 at 12.53.28 PM.png
    48.3 KB · Views: 21
  • Screenshot 2024-08-28 at 12.53.47 PM.png
    Screenshot 2024-08-28 at 12.53.47 PM.png
    78.1 KB · Views: 24
  • Screenshot 2024-08-28 at 12.54.04 PM.png
    Screenshot 2024-08-28 at 12.54.04 PM.png
    88.6 KB · Views: 23

Himesh

Active member
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.
 
Top