The Scenario
Every Monday morning, the IT operations analyst sends the same weekly ops summary to the department heads: incident count by priority and assignment group, average resolution time by category, change request volume by type. The data lives in ServiceNow. The summary lives in a Google Sheet. The analyst builds it by exporting a list, pivoting it in a second tab, copying the pivot output into the summary tab, and formatting it. Every Monday. Forty minutes that exist only because nobody ever asked ServiceNow for the aggregates directly.
The bad version:
- Export open incidents from ServiceNow, open the CSV, build a pivot table in a new tab.
- Export closed incidents for the resolution time calculation, pivot that separately.
- Export change requests, pivot that too.
- Copy the pivot summaries into the ops report template, reformat the column headers to match the template style.
The aggregates ServiceNow already has. You are building a process to re-derive them in a spreadsheet every week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It queries ServiceNow's aggregate API directly, gets the grouped counts and averages server-side, and writes the summary rows into your sheet — no CSV, no pivot table.
Query ServiceNow for the count of open incidents grouped by priority and assignment group and write the results into this sheet with one row per group
What You Get
- One row per priority-and-assignment-group combination in ServiceNow
- Incident count per group written into the summary tab
- Results reflect the live ServiceNow state at the time of the query
- No intermediary CSV or pivot table required
What If the Data Is Not Quite Ready
You need the average resolution time alongside the count
The ops report has two columns per group: volume and mean time to resolve.
Query ServiceNow for the count and average resolution time of incidents closed in the last 7 days, grouped by category, and write the category, count, and average resolution time in hours into columns A, B, and C
You want to compare this week's volume to last week's in the same pull
The department heads always ask for the week-over-week delta.
Get the count of incidents created in ServiceNow in the last 7 days grouped by priority, and the count from the 7 days before that in the same grouping, then write priority, this week's count, last week's count, and the delta into columns A through D
You also need change request volume by type for the same period
The ops summary has two sections: incidents and changes.
Query ServiceNow for the count of change requests created in the last 7 days grouped by type (normal, standard, emergency), and separately the count of open incidents grouped by priority, then write the incident summary starting at row 2 and the change summary starting at row 10 with a label row for each section
Full kill chain: pull incident aggregates, change aggregates, calculate deltas, and format for the report
Get incident counts and average resolution times grouped by category from ServiceNow for the last 7 and 14 days, calculate week-over-week deltas, get change request counts grouped by type for the same periods, write incident data into rows 2 through 15 and change data into rows 18 through 25, add section headers, and flag any category where incident count increased by more than 20% week over week with "SPIKE" in column E
The Monday morning ops summary is done before the coffee finishes brewing.
Try It
Get the 7-day free trial of SheetXAI and open your weekly ops summary Google Sheet, then ask it to pull the ServiceNow aggregates directly instead of building a pivot table from an export. For pulling raw incident records, see the export-open-incidents spoke or return to the ServiceNow hub.