Best answer

Transfer all data from Monday board to Google Sheets

  • 26 August 2021
  • 7 replies
  • 341 views

How can I transfer all my data in Monday board to google sheet? Example I have 15 columns from my Monday board, I want that 15 columns to be transfer to my google sheet and all the data in each columms  

icon

Best answer by Remdon 26 August 2021, 21:49

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.

7 replies

Userlevel 7
Badge +14

Hi @Remdon 

Zaps work when turned ON for new data going forward on a per record basis.

If you are trying to transfer existing Monday Board Items, then you’re better doing that manually via an export/import.

Hello sir, thanks for answering. I already exported all the data from my Monday board to my google sheet, but what action and triggers do I need when I add a new item on my Monday board and the same time  added on my google sheet? 

Userlevel 7
Badge +14

Hi @Remdon 

Check out the available triggers/actions for each app: https://zapier.com/apps/monday/integrations/google-sheets

 

Steps

  1. Trigger: Monday - New Item in Board
  2. Action: Monday - Get Column Values
  3. Action: GSheets - Create Row

I have 25 columns on my Monday board, and all the 25 columns is detected on my google sheet action but the Monday tags shows only 9  

Userlevel 7
Badge +14

@Remdon 

Make sure your Zaps steps are like this

Steps

  1. Trigger: Monday - New Item in Board
  2. Action: Monday - Get Column Values (map the Item [Pulse] ID from Step 1)
  3. Action: GSheets - Create Row

Do I need to fill up this sir? Still only 9 tags are shows in Monday. When I leave it as blank, Zapier says the test successful but when I create new item on my Monday board, nothing happens on my google sheet 

hi sir, the trigger new item is now working on my google sheets, how about when a new update on my Monday board sir, what trigger and action do I need? Do I follow the same steps?