Add lines in Excel from monday.com after batch action

Hi there,

I’m completely new to Make and I try to make an excel file out of changes made in monday.com.
Here is how my scenario looks like:

It works quite fine when I do my changes one at a time.
In monday.com, you can select more than one item and make the same change on all the selected items in one shot. This is a batch action.
When I run my scenario and do a batch action, then it works well in the beginning, but Excel gets only 4 lines updates out of 10 changes in monday.com.
It looks like when I add more than one line within the same second, Excel add only the first one…
I would like to make 10 changes in a batch action in monday.com and get 10 lines added in Excel as a result.
Would anybody have an idea on how to solve that ?

Thank you in advance for your help

Franck

Hi @Franck_de_Luca and welcome to the Make Community!

Are you calling Make 10 times from Monday? Or are you calling Make once with 10 commands to execute?

If it’s #1 (which is what I suspect) you can change your scenario’s settings to make it sequential:

You can access this in the settings:

image

If you’re sending 10 commands at once (I don’t think that’s what you are doing since I don’t see an aggregator in your scenario), consider adding a delay with a sleep module

With a random delay. In this example, I’m adding a ranndom 10-second delay:

L

1 Like

Hello @L_Duperval,

You are right, Make is called 10 times in this scenario, one time for each pulse in monday.
I implemented your suggestion and it works perfectly.
Thank a lot for your help.
Have a good day
Franck

1 Like