I am trying to work on a project to retrieve email attachment ( an Excel sheet) and look up warranty for the devices listed on that downloaded worksheet and enter the validity period into that worksheet again.
I understand that these two are different processes because for the 2nd process I need to select the excel in the first place.
But, how can I select and define a path for the excel while designing the workflow when attached Excel file (the file in which the devices & their serial numbers are listed) is yet to be downloaded from the email ( The first automation task)?
How can I consolidate these two separate processes for automation? Please advice!