Many companies need to prepare and send out reports to stakeholders within the company. Reports can range from customer usage (for sales and marketing purposes) to system uptimes (for monitoring). The purpose of this business case is to grab details and generate Excel reports to send to internal stakeholders.
Commonly, an employee should open an appropriate file, search for the data, and copy-paste the required information to an Excel document. Afterwards, the employee has to open mail service, attach the needed file and send the email to internal stakeholders.
In this example, an RPA bot task will grab all data from five input log files in the .json format, put the data to the online json-to-csv converter, transfer the result to an .csv file, and adjust the file to a proper view with four result columns. After that modification, the file will be saved in the .xslx format and sent to ten persons. You just start it, and a bot will do all the necessary actions by itself. As a result, ten persons will receive a mail with the attached Excel file. One more option allows to apply reusable script components in your own scripts without any modifications.
Example Overview Video
See the video showing how our bot works.
Installation and Getting Started
Install Intelligent Automation Cloud – Express or Business.
Download an example with an Excel template.
Add the example to your WorkFusion Studio as described here.
Copy the metrics in the .json format to any appropriate folder (for example, C:\Examples).
Change the path in the path_to_folder variable.
Change the mail addresses in the mail_list list variable.
Make sure your Outlook account is configured to send emails.