Skip to main content
Best answer

How can I correctly format Google Sheets data into different columns in Monday.com?

  • February 26, 2021
  • 6 replies
  • 147 views

Hi! I need help please. How can Imake the output in monday.com board in columns?

 

*dummy data is used

 

 

what action event and set up action should I use?

Best answer by Troy Tessalone

@AizaLiansing 

Please reference this help link: https://support.monday.com/hc/en-us/articles/360014205860-Zapier-JSON-Formatting-Examples

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 26, 2021

Hi @AizaLiansing 

You need to use this section in the Action.

Make sure to check out the blue linked “documentation” below that section.

In Monday, go to Labs (settings), and turn on Developer Mode, to retrieve the internal Monday column IDs to be used on the left side of the Column Values below: https://support.monday.com/hc/en-us/articles/360002138760-What-is-monday-labs-

 


  • Author
  • Beginner
  • February 26, 2021

Hi @Troy Tessalone I had turned on the Developer Mode and filled up the column values. However, I still can’t have the desired output. Please guide me.

 

 

 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • February 26, 2021

  • Author
  • Beginner
  • February 26, 2021

Hi @Troy Tessalone is there a need to do it in coding/scripts?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 26, 2021

@AizaLiansing 

Unfortunately yes specific Monday column types necessitate certain formatting as the Monday integration is not the most user friendly to work with.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • February 26, 2021

@AizaLiansing 

Or you can update an Item’s fields individually with separate Zap actions per column type, but that will use a lot of Tasks

https://zapier.com/apps/monday/integrations#triggers-and-actions