Skip to main content
Question

How do I create and update a Google Sheet with new items from monday.com using Zap?

  • November 14, 2024
  • 3 replies
  • 25 views

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 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Sebastian M
Forum|alt.badge.img
  • Zapier Staff
  • 29 replies
  • November 14, 2024

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!


tomzap
Forum|alt.badge.img+1
  • Beginner
  • 39 replies
  • November 14, 2024

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?


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30916 replies
  • November 14, 2024

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