The managers very often receive information in the form of XLS or CSV files. They merge and process the data in order to create reports or forecasts.
This process can be easily automated. A software robot can receive the emails and process the data instead of the manager.
The work of the managing director is made easier and optimized.
The concerns are: “Hm, what about my password? Is it safe?”
The problem is solved very elegantly by creating an additional e-mail box.
For example rpa@mycompany.de
The manager can then simply forward the files to the software robot.
The usual suspect:
- Panda for processing the data
- The libraries imapclient, email, smtplib
- docker
- Linux and Cron
The implementation:
- The software robot can be conveniently packed in a Docker container and sent to the customer as a Christmas present A cron job can start the container at short intervals.
- The container checks the dedicated emails
- It receives the e-mails, processes the data, packs them in XLS or CSV files and sends them back
The advantages here are that the software robot works in an encapsulated manner, with almost no attack in the customer’s IT infrastructure.