Skip to main content
Question

Excel to monday - Sync multiple items

  • December 9, 2020
  • 4 replies
  • 207 views

Hi! 

 

I have made a zap which succesfully sync data between a excelark and monday.com on one specific Item line. Althought I have 180 Itemlines in that board and I would like to make one zap that automatically updates a specific column for ALL items when changed in the excel ark. 

 

As far as I can see this is not possible - but maybe someone else have done it and knows a shortcut? I would like to avoid creating 180 individual zaps for each item line in monday.com :-) 

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

Did you try this action? Monday - Update Item Multiple Column Values

In Monday.labs, turn on Developer Mode

 


Hi Troy. Yes - I tried. But that is only for multiple columns - and not Item-lines. Unfortunately that doesn’t solve my problem :( 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31400 replies
  • December 10, 2020

Ok, sorry I misunderstood what you were asking.

Have you tried using Batch Actions in the Monday UI? https://support.monday.com/hc/en-us/articles/115005335049-Batch-Actions

Depending on how frequently the data in Excel is being updated it might be over engineering a solution trying to automate this when it can be done manually.

 

[ADVANCED] Otherwise, you’d likely have to use the Monday API: https://monday.com/developers/v2

With the API you could GET all the desired line items in Monday then TBD on the API endpoints either bulk update or iterate thru the line items to update the desired column value.

This would involve the Code app or Webhooks app.

 


Liz_Roberts
Forum|alt.badge.img+8
  • Zapier Staff
  • 1366 replies
  • March 4, 2021

@sabrinadevett - were you able to get this Zap squared away using Troy’s suggestion? Let us know!