Best answer

How to replicate Google Sheets data in Monday.com board?

  • 24 February 2021
  • 3 replies
  • 25 views

Hi!

I need help please. I should replicate the google sheet data into a Monday.com board and have to be able to update it as well.

Please see screenshots attached.

  1. Reference Google Sheet (Dummy Data provided)

 

  1. Zapier

 

  1.  
  2.  

 

icon

Best answer by Troy Tessalone 24 February 2021, 23:23

View original

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

Userlevel 7
Badge +13

Hi @AizaLiansing 

Check this help article: https://zapier.com/help/doc/common-problems-with-monday-on-zapier

Check your app connections here: https://zapier.com/app/connections

 

FYI: You might want to add spaces or some delimiter between these fields otherwise it will result in a blob of text.

 

Hi @Troy Tessalone,

How should the delimiter be used in the Formatter? I tried to use the [:space:]`, `[:tab:]`and `[:newline:]` (both in Google Sheet and Monday.com, but still the output comes in one line.

(Dummy Data is being used)

 

 

 

Thanks,

@AizaLiansing 

 

 

Userlevel 7
Badge +13

@AizaLiansing 

No need to use the Formatter.

Not sure if you can have line breaks in the Monday Item Name.

Just add a single space between the dynamic data points, or whatever character you want to use.

e.g. [FIRST NAME] [LAST NAME]