Create Requests from excel sheet sent through email
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2025 11:20 AM
Hello,
A excel sheet is sent through email which contains 100+ rows. I have a requirement where in I need to create request -> RITM -> task for each row of the sheet.
I have create requests through cart functionality but not sure how to automate it for excel sheet.
Any guidance would be really helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-21-2025 11:28 AM - edited 08-21-2025 11:31 AM
This can be achieved -
Excel file into ServiceNow (Data Source + Import Set).
Process the Import Set rows with a Transform Map + Script.
In that script, use Cart API / Request API to create REQ → RITM → TASK for each row.
Go through this link to get more idea about ServiceCatalogAPI.
Link - https://www.servicenow.com/docs/bundle/zurich-api-reference/page/integrate/inbound-rest/concept/c_Se...
PS :Start the development from scratch and go through the steps on your own once. While doing this, if you have any doubts, feel free to ask in the community.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-02-2025 10:08 AM
Hello @Shashank_Jain
Thank you the response. I have a query, when I create a Transform Map what should I map as target table. I do not want to create any custom table.
As of now I have created a import set table and loading data in it and through 'On Before' script, creating requests through Cart API. What should I map in target table, currently I have mapped the source 'import set table' in target table as well but I think that will not be best practice.
Do you have any idea what should be the target table?
Regards