I am trying to accomplish the following , can you please help me by pointing me to the right functionalities or letting me know if this is doable using Ui Path:
- Access a outlook mailbox
- Retrieve the attachment
- Read the attachment and scrape the data from the attached xls
- Use the scraped data ( clean it / add formulas and transform)
- Compare transformed data to an existing spreadsheet and find a value from a grid
- Store the the value in a spreadsheet
- Email the new spreadsheet back to the sender.