Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I have a monday.com dashboard that is created from a google sheet. When I update the status column on Monday.com I want the relevant item to be updated backinto google sheets. I am having an issue on the Zap creation steps as it is always asking for a set field or row to update and I need it to update any row I update in Monday.com

 

Hi @ShelD1 

Good question.

Check out this help article about findings/updating rows in GSheets: https://zapier.com/help/doc/finding-and-updating-rows-in-google-sheets

Try these Zaps steps

  1. Trigger: Monday - Specific Column Value Changed
  2. Action: GSheets - Lookup Row
  3. Action: GSheets - Update Row
    1. Map the Row ID from Step 2

Hi there, 

 

Thanks for the feedback, I changed the steps as suggested, it now finds the correct rows to update yet does not push the data from Monday.com into the google sheet? the updated row stays blank.

Zap Steps

I am still getting the data out from the Zap run to not include the actual updates from Monday.com and update the google sheet. 

@ShelD1

You’ll need to make sure to map the desired data points from Monday.

If these desired Monday Item data points are not available in step 1, then add a new step for Monday Get Column Values to get the values for the Item returned in Step 1.

 

 

Thanks for the assistance, I got it working. Changed the Project status ID to read from Monday and it worked. 

 

Terms & Conditions