Bot 4: InFlow Stock Adjust
Scenario
You received an email that requests to update the quantity of some items in stock. The email has excel attachments that contains info about these items.
The bot will be triggered, read the emails with Outlook and download the excel attachments to a folder.
The bot read data from the excel files in that folder and enter data to the InFlow app.
Benefits
Better stock adjust process for inventory management.
Improve team productivity by reducing time spent on manual data entry on InFlow.
How it works
The excel file template is as follow

NOTE: In the video, we run the bot manually from Auteros Agent. But you can schedule to run it by interval or at a specific time in day.
Techniques used
Email automation.
Excel automation.
Desktop app automation.
How to use
Download the bot package (.aupkg) here.
Open Auteros Studio. if you don't have Auteros Studio installed, you can get it here.
Open the Explorer tab, from the root Auteros Node, right click and then click Import Workflow Package, then point to the InFlow_StockAdjust.aupkg file.
Open the workflow StockAdjust_Main, change the value of the variable folderPath to the folder that you want to save the excel attachments.