The Scenario
Your monitoring platform flagged 60 issues during a weekend maintenance window. By Monday morning someone has already collected them into an Excel workbook — short descriptions in column A, urgency ratings in column B, caller IDs in column C — and dropped it in the shared drive with a note: "These all need to be in ServiceNow by standup."
The bad version:
- Open ServiceNow, navigate to Incident, click New, fill in the short description, set the urgency, type the caller's name, submit, wait for the incident number to appear, copy it back into the workbook.
- Repeat 59 more times across the next two hours.
- Discover at row 34 that two urgency values use different formatting than ServiceNow expects and have to go back through those rows manually.
Creating 60 incidents by hand is a task that exists only because the process was never automated. You were not hired to operate a form 60 times in sequence. The incident numbers need to be in that workbook before standup, and there are other fires already burning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your column layout, understands the data, and talks to ServiceNow on your behalf — no form-clicking, no CSV gymnastics.
Create a ServiceNow incident for each row in this workbook using the short description in column A, urgency in column B, and caller name in column C, then write the returned incident number into column D
What You Get
- A new ServiceNow incident record per row, submitted via the Table API
- Column D filled with the assigned incident number for each row
- Rows that fail validation flagged with an error message in column D instead of a number
- The full batch runs in a single operation — no row-by-row loop on your end
What If the Data Is Not Quite Ready
The urgency values use free-form text instead of ServiceNow codes
ServiceNow expects urgency as 1, 2, or 3. Your workbook has "High," "Medium," and "Low."
Before creating incidents, convert the urgency text in column B to ServiceNow numeric codes — High to 1, Medium to 2, Low to 3 — then create a ServiceNow incident for each row using the description in column A, converted urgency, and caller name in column C, and write the incident number into column D
The caller names are not matching any ServiceNow user records
Some callers are listed by first name only, or with a department suffix.
For each row, look up the caller in ServiceNow using the name in column C and write the matching sys_id into column E, then create an incident using the description in column A, urgency in column B, and the resolved caller sys_id in column E, and write the incident number into column D
The descriptions need to be prefixed with an environment tag before submission
All incidents from this outage should have "[PROD]" prepended to the short description.
For each row in this workbook, prefix the description in column A with [PROD] and create a ServiceNow incident with the modified description, the urgency in column B, and the caller in column C, writing the returned incident number into column D
Full kill chain: normalize, validate callers, flag duplicates, then create
Check if any descriptions in column A already match open incidents in ServiceNow and mark those rows "DUPLICATE" in column E, then for the remaining rows convert urgency text in column B to numeric codes, look up caller sys_ids by name in column C, and create ServiceNow incidents for each valid row, writing the incident number into column D and any errors into column F
The pattern: instead of cleaning the data first, then creating records, then checking for duplicates in a separate pass, you ask for everything at once.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of reported issues ready to become ServiceNow incidents, then ask it to run the full batch. You can link to the export-open-incidents spoke to see the flip side, or return to the ServiceNow hub for other workflows.