Inbound email attached excel to Catalog Request

Arun_Manoj
Mega Sage

Hi,

I requirement is when an inbound email with specific subject , then the attached excel data use to create catalog request for specific item. Need to to create REQ,RITM,SCTASK for the each data.

6 REPLIES 6

KSreeVamsi
Tera Contributor

Hi @Arun_Manoj ,

Will the excel sheet contain the data to make the request or should it be just attached to the request once the email is received?

Hi @KSreeVamsi ,

 

Excel contain corresponding field data.

Hi @Arun_Manoj,

So each row of the excel sheet will be a separate request by itself right?

Amit Verma
Kilo Patron
Kilo Patron

Hi @Arun_Manoj 

 

You can create a flow with trigger as Email Received with particular subject line. Inside the flow, make use of Lookup Email Attachments action to get the attachment and create records. Refer https://www.servicenow.com/community/developer-forum/servicenow-flow-read-email-attachment-file-and-...

https://www.servicenow.com/community/developer-forum/flow-designer-for-inbound-emails-with-multiple-...

 

Thanks and Regards

Amit Verma


Please mark this response as correct and helpful if it assisted you with your question.