Hello my friends, how are you?
I would like help in a situation I’m facing.
I’m ahead of opening rotating inventories in all units.
The process consist of two steps.
1- Open the inventory in each store
2- Create count list.
In the first step of opening the inventories, I assembled the data in a spreadsheet and it executes based on this information.
The second part I have a second worksheet with the items that will be inserted in the count list
I could create a huge spreadsheet and create a huge flow to put all these items in one automation. But I know there is a simpler and easier way, but I don’t know what to do.
The idea would be the following, the automation will open the inventory and in the store that it opens, it will get the information in the second worksheet inserting the items in the counting list, when it finishes placing the items, it moves to the next unit and does the process until all are finished.
How can I do it?
I can create a video to illustrate the process if you want