I have a scenario like this
- We get an automated email from external with an email attachment.
- We open the attachment and read the data (it has 5 columns and 2-3 rows of data)
- i have done the above and the workflow seems to check the email and look for attachment
The next steps are taking the information from the columns and inputting in a different system
- My question is how do i read the excel data with the columns and store it
- Next is how do i go ahead in opening the third party system and inputting the received data
Can someone please let me know as I am doing a POC just to showcase we dont need any human to do on a daily basis.
The third and 4th steps I m not sure how to proceed