When I receive the Outlook mail, I want to move the table in the mail contents to the Google spreadsheet and create an automation that processes functions within the spreadsheet and sends the result back to my mail.
There’s no part in UiPath that sends mail contents to the option available through Outlook, is it impossible?
It is possible to extract the table from an Outlook email and move it to a Google Spreadsheet using UiPath.
You can use UiPath activities “Get Outlook Mail Messages”
Use “Data Scraping” to extract the table from the email
Use “Google GSuite” activities to create a new spreadsheet
insert the table data into it.
Once data is added to spreadsheet, you can use UiPath activities such as “Read Range” and “Write Range” to perform data processing functions and write the result back to the same or a different sheet in the spreadsheet.
Finally, you can use the “Send SMTP Mail Message” activity to send the result back to your email. You can customize the body of the email using HTML tags to format the data as a table or any other desired format.
Note that the process may require some custom coding or activities depending on the specific format of the email table and the data processing functions required.