Inbound email attached excel to Catalog Request

[armanoj]

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.

[KSreeVamsi]

Hi @armanoj ,

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?

[armanoj]

Hi @KSreeVamsi ,

Excel contain corresponding field data.

[KSreeVamsi]

Hi @armanoj,

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

[vermaamit16]

Hi @armanoj 

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