automation of excel sheet via inbound email action

[chandan2212]

Hi Team,

I have a requirement where, on the 1st of every month, I need to update the owner name in a custom table. The user will send an Excel sheet via email, which I will receive in ServiceNow through an inbound email action. I have already prepared a staging table where the Excel data will be stored, and then it will update the target custom table.

Could anyone provide me with the script that I need to write in the inbound email action to automate this process?

Thanks and Regards,
Chandan

[Viraj Hudlikar]

Hello @chandan2212 

There is article created by @Maik Skoddow and I think it will be helpful for your use case.
Import Excel File from Inbound Email via Flow - ServiceNow Community

If my response has helped you, hit the helpful button, and if your concern is solved, do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

[Shruti · Accepted solution]

Hi,

Check this blog https://www.servicenow.com/community/developer-blog/loading-data-from-an-email-attachment/ba-p/2279...

[Ankur Bawiskar]

@chandan2212 

everything is listed in this blog, check and enhance for your requirement

Auto load Excel spreadsheet using Email Inbound Action 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@chandan2212 

Thank you for marking my response as helpful.

As per new community feature you can mark multiple responses as correct.

💡 If my response helped, please mark it as correct ✅ as well so that this helps future readers find the solution faster! 🙏