How to retrieve data from Excel email attachment and store it in ServiceNow Flow designer.

NaveenMalla
Tera Contributor

Hi,

 

I will be receiving a report from a 3rd party application as an email attachment. I have to fetch the data of 1st column from that excel. Paste that data in other excel sheet and have to upload the sheet while filling a catalog form in SNOW ONS.

My question is "How to retrieve data from Excel email attachment and store it in ServiceNow Flow designer and then use that data to paste the same data in other excel sheet?"

 

Thank you.

2 REPLIES 2

ShubhamGarg
Kilo Sage

Hello @NaveenMalla ,

 

These resources should help you -

 

Import Excel File from Inbound Email via Flow 

 

Read email attachment file and update the ServiceNow table 

 

Let me know if it works.

 

Regards,

Shubham

NaveenMalla
Tera Contributor

Thank you for the response. I tried the steps mentioned in the first link. I am stuck while testing the same. 

NaveenMalla_0-1723467010374.png