The Scenario
You're the performance engineer for a mid-size SaaS company. You monitor 25 pages across three different websites in GTmetrix — the main marketing site, the app subdomain, and a help center. Every Monday, your manager expects a performance snapshot in the shared ops workbook: every page, its current grade, its current performance score.
Last week someone on the team manually copied the data over. They missed four pages. The manager noticed at the team sync.
The bad version:
- Open GTmetrix, go to the Monitored Pages view, click the first page, copy the grade and score, switch to the workbook, paste.
- Go back. Click the next page. Twenty-four more times.
- Add column headers. Check for missing rows. Realize the order doesn't match last week's snapshot, re-sort manually.
This is a 35-minute task that happens every Monday, produces something that could have been automated, and has a meaningful failure rate because it involves a human copying 50 numbers by hand on a tight schedule.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls the GTmetrix API, retrieves every monitored page you have access to along with its latest test result, and writes the data into your workbook — all from one prompt.
Pull all my GTmetrix monitored pages and their latest performance scores into the "Site Health" sheet. Write the page URL in column A, the page name in column B, the latest GTmetrix Grade in column C, and the latest performance score in column D. Sort by performance score ascending so the worst performers are at the top.
What You Get
- Column A: Full URL of each monitored page.
- Column B: Page name as set in GTmetrix.
- Column C: Most recent GTmetrix letter grade.
- Column D: Most recent performance score (0–100).
- Sorted lowest score first so degraded pages surface immediately.
What If the Data Is Not Quite Ready
You only want pages from a specific website, not all three
Pull all my GTmetrix monitored pages where the URL contains "app.example.com" and write the page URL in column A, latest grade in column B, and latest performance score in column C into the "App Pages" sheet.
You want to flag pages where the grade dropped from last week
Pull all my GTmetrix monitored pages into the "Site Health" sheet with URL in column A, grade in column B, and score in column C. Then compare column B against the "Last Week" column E — flag any row in column F where the grade is lower than last week's grade.
Page names in GTmetrix don't match your internal naming convention — use a lookup
Pull all my GTmetrix monitored pages into the "Raw" sheet with GTmetrix page name in column A and latest grade in column B. Then in column C, look up each page name against the "Page Map" sheet (column A = GTmetrix name, column B = internal name) and write the internal name.
Full Monday-ready snapshot: pull, compare, highlight regressions, summarize by site
Pull all my GTmetrix monitored pages and latest scores into the "Site Health" sheet with URL in column A, page name in column B, grade in column C, and score in column D. Group by domain (the first subdomain of each URL) in column E. Flag any page in column F where the score is below 60. Add a summary row at the bottom of each group showing the average score for that domain.
One prompt builds the whole thing — groupings, flags, and summary rows included.
Try It
Get the 7-day free trial of SheetXAI and open your ops workbook, then ask it to pull all your GTmetrix monitored pages and write their latest grades and scores into your columns. For related workflows, see Retest All GTmetrix Monitored Pages From an Excel workbook After a Deploy or the GTmetrix + Excel overview.