Load Excel data into a table when email sent

[Lucky1]

Hello all,

When an email is sent to service-now with an Excel attachment, I want to upload the excel data into a custom table.

Can someone tell me the steps to do it and help in achieving it?

Thank you.

Regards,

Lucky

[Ankur Bawiskar]

@Lucky1 

check these links and those should help you

Auto load Excel spreadsheet using Email Inbound Action 

Import Excel File from Inbound Email via Flow 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Lucky1]

Hi ANkur,

Thanks for your reply.

Please note below points:

I already have a Data Source created for my requirement and also there is a scheduled job.

So, every time when I receive the excel, I am manually attaching that excel to the Data source and then running the transform to upload the excel data to custom table

Later, manually clicking on the Execute Now button of the Scheduled job.

So, Can you tell me now if an email is received to snow, can the custom table will be automatically gets loaded with the data from the Excel sheet?

Regards,

Lucky

[Ankur Bawiskar]

@Lucky1 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.