Skip to main content
Question

How to sync Monday.com to Google Sheets and then keep them in sync

  • December 24, 2022
  • 4 replies
  • 150 views

I have a CRM board in Monday.com which has contact details for my suppliers. I would like to create a Zapp that pushes the data of this CRM to a Google Sheets file. After the initial push, I want it to always be in sync so if any new items are created in the CRM or existing ones updated, Google Sheets updates to reflect this.

How can I do this? I saw the options below but not sure which accomplishes first A) the initial push of all the data (given that the Google Sheet is empty now) and then B) the continual update + sync.

 

 

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.

4 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30923 replies
  • December 26, 2022

Hi @bz181d 

Good question.

Zapier is not mean for 2-way sync between apps: https://help.zapier.com/hc/en-us/articles/8495908569613-Does-Zapier-support-two-way-syncing-


  • Author
  • 1 reply
  • December 26, 2022

I am purely after a one way sync - so dumping Monday.com data to Google Sheets in the manner described above.


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30923 replies
  • December 27, 2022

@bz181d 

FYI: Zaps work while turned ON for new data going forward.

Generally a concept of logic that includes find, else create + update is used to keep data in “sync”.

Try one of these Zap triggers for Monday.

 

 


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • December 29, 2022

Hey there, @bz181d! I wanted to pop in and see if you were able to get this up and running? Or at least the second part of your question pertaining to setting up your zap. 🙂 Here’s some tips on how to setup your Google Sheets to work best with Zapier.

Regarding the bulk transfer of the old contacts, as Troy mentioned zaps only work with new incoming data after the zap has been turned on.

Since Monday.com isn’t supported for Transfer (typically what we would recommend in these scenarios to import the existing data to Google Sheets) here’s a workaround we’ve recommended in the past that may be helpful:
 

Either way keep us posted how this is coming along! 🤗