• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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: 68
  • Screenshot 2024-08-28 at 12.52.39 PM.png
    Screenshot 2024-08-28 at 12.52.39 PM.png
    92.4 KB · Views: 64
  • Screenshot 2024-08-28 at 12.52.03 PM.png
    Screenshot 2024-08-28 at 12.52.03 PM.png
    89.3 KB · Views: 66
  • Screenshot 2024-08-28 at 12.53.28 PM.png
    Screenshot 2024-08-28 at 12.53.28 PM.png
    48.3 KB · Views: 62
  • Screenshot 2024-08-28 at 12.53.47 PM.png
    Screenshot 2024-08-28 at 12.53.47 PM.png
    78.1 KB · Views: 63
  • Screenshot 2024-08-28 at 12.54.04 PM.png
    Screenshot 2024-08-28 at 12.54.04 PM.png
    88.6 KB · Views: 63

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