The Scenario
Third-party auditors want monthly KPI summaries for the past 12 months. The IT director has been building these by logging into the ServiceNow Analytics Hub, screenshotting scorecards, and typing numbers into an Excel workbook. Three scorecard panels. Twelve months. Twenty-four indicators. She did this manually last month. She will not do it again.
The bad version:
- Log into ServiceNow, navigate to Analytics Hub, open each scorecard panel.
- Read the indicator name, current score, and target off the screen.
- Type each value into the workbook, switching back and forth between browser tabs.
- Discover the values changed overnight because ServiceNow recalculates on a schedule, so the numbers you entered this morning are already stale.
The scorecard data is live in ServiceNow. Transcribing it by hand — and then having it be wrong by the time it is reviewed — is a process that should not exist.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It connects to the ServiceNow Performance Analytics API, pulls the scorecard indicators, and writes the values directly into the workbook — current scores, not last week's screenshots.
Get all performance analytics scorecards from ServiceNow and write each indicator name, current score, and target value into columns A, B, and C
What You Get
- One row per active scorecard indicator in ServiceNow Analytics Hub
- Columns A, B, and C populated with indicator name, current score, and target value
- The data reflects ServiceNow's most recent calculation run
- The pull can be repeated any time to refresh the numbers without re-entering anything
What If the Data Is Not Quite Ready
You need the trend direction alongside the score for the executive report
The report template has a column for whether each KPI is improving, flat, or declining.
Pull all performance analytics scorecard indicators from ServiceNow and write the indicator name, current score, target value, and trend direction into columns A through D, using "Up," "Flat," or "Down" in column D
The scorecards cover multiple domains and you only need the ITSM indicators
The Analytics Hub has scorecards for ITSM, HR, and Facilities. You want ITSM only.
Get all ServiceNow Analytics Hub scorecard indicators in the ITSM domain and write the indicator name, current score, target, and domain into columns A through D
You need a timestamp in column E to show when the data was pulled
The audit process requires the report to show the data extraction date.
Pull all performance analytics scorecard indicators from ServiceNow, write indicator name, score, target, and trend into columns A through D, and add today's date as the extraction timestamp in column E for each row
Full kill chain: pull ITSM scorecards, flag off-target indicators, add trend, sort by priority
Get all ITSM performance analytics scorecard indicators from ServiceNow, calculate the percentage gap between current score and target for each, flag indicators more than 10% below target as "AT RISK" in column F, sort by gap percentage descending, and write indicator name, score, target, trend, domain, and risk flag into columns A through F
The monthly KPI report builds itself.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook your IT director uses for executive reporting, then ask it to pull the current Analytics Hub scorecard data straight from ServiceNow. For working with incident or change data, return to the ServiceNow hub.