Skip to main content

I want to create Zap using monday.com and Google sheet  when any item created in monday.com new item should create in Google sheet . if monday.com particular item column changes it should get updated in spreadsheet 

Hi there @Renson!

 

From your description, I think you’ll want to either use a “New Update in Board” trigger, or potentially set up two Zaps:

  • One with a New Item in Board trigger, followed by a Create Spreadsheet Row in Google Sheets action;
  • One with a Specific Column Value Changed in Board trigger, followed by a Lookup Spreadsheet Row in Google Sheets (to find the row associated with the monday.com item that was updated), and then an Update Spreadsheet Row in Google Sheets to perform the relevant update.

Here’s our monday.com page where you can take a look at all the available actions and triggers:

https://zapier.com/apps/monday/integrations

 

Hope this helps!


Welcome to the community, Renson! Was Sebastian able to answer your question, or is there anything else you’d like help with to get started on Zapier?


Hi ​@Renson 

Try these Zap steps…

 

Zap 1

  • Trigger: Monday - New Item in Board
  • Action: GSheets - Create Row

 

Zap 2

  • Trigger: Monday - Specific Column Value Changed in Board
  • Action: GSheets - Lookup Row
  • Action: Filter
    • From Zap step 2, check if found = true
  • Action: GSheets - Update Row
    • Map the Row/ID from Zap step 2

 

 


Reply