Technology Stack
RPA
Challenge
The client manually extracted workbook files to Excel from GreenScreen (PE), opened and renamed them accordingly to the content inside and saved to a specific SharePoint location. These files were then read by workbook with Power Queries that manipulate the data accordingly.Â
Solution
The robot built by Blackbook automatically downloads the files generated from PE and extracts / unzips them. The files are opened and renamed according to the content inside so it can be picked up by the Power Query. The robot also archives old data from one week ago and saves the new data to the SharePoint.Â
Outcome
The client reduced the time spent on manually extracting, renaming and saving workbooks in specific SharePoint locations. This allowed the clients employees to get access to the files they needed quicker in SharePoint and allowed them to complete more important tasks.