How to automatic import data from excel file to ServiceNow

[Meera_P]

Hello,

I have an excel spreadsheet file saved in a network drive.  The spreadsheet gets updated by an end user frequently with new records.  We are currently manually importing the data in to ServiceNow.

Is it possible to develop a script to run every 2 hours to import the data from the excel file and create a service requests   

Please let us know.  Thank you so much

[Joe S1]

Hello Meera,

It's certainly possible to automate that import process. The biggest hurdle you're going to need to overcome is how are you going to get the file to ServiceNow? There are a couple options, the file could be emailed in as an attachment and then with the inbound email Flow use the sysAttachmentAPI to process the file. Another way would be to have a process place the file in a share on the MID server and from there you can access it directly and import it. Issue here is determining how often to process the file. Another option is FTP, you can setup a schedule job to use FTP to get the file and process it in the import set.

[Meera_P]

Thank you so much for your suggestions @Joe S1 .

We are able to send an email to ServiceNow with an attachment.  Flow inbound email created a service request.  However, it only created one service request. 

We would like to continue to use the email option.  As long as ServiceNow can read the records in the file and creates  a number of Service Requests based on the number of lines  in the excel file.

I know this is a  challenging project.  Could you or anyone that know how to do it help?

Thank you again.