The Scenario
Six months ago you built a new checkout flow for your e-commerce site. You've been running GTmetrix monitors on it ever since. Now leadership wants a before-and-after chart — performance scores and Core Web Vitals plotted across the entire monitoring period, with the redesign launch date marked.
You open GTmetrix, click into your monitored page, and see 180 individual test results listed in the report history. You can scroll through them. You can click each one. You cannot, apparently, download all 180 in one go in a format that matches your existing workbook.
The bad version:
- Click the first report. Copy the date, performance score, LCP, and TBT into your workbook manually.
- Click the back button. Click the second report. Repeat.
- Somewhere around report 40, realize you copied the wrong column for TBT and have to go back and redo 40 rows.
Leadership's ask was "can you pull together the performance data from the last six months." They did not mean for this to be an all-day project. It's pulling numbers out of a tool — it should not require a hundred manual clicks.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It connects to GTmetrix, retrieves the full report history for a monitored page, and writes every result into your workbook in the column layout you specify.
Pull all historical GTmetrix reports for my monitored page ID pg_abc123 and fill the "Performance History" sheet with date in column A, performance score in column B, LCP in column C, and TBT in column D. Sort by date ascending.
What You Get
- Column A: Test date and time for each historical report, formatted as YYYY-MM-DD HH:MM.
- Column B: Performance score (0–100) for that test.
- Column C: Largest Contentful Paint in milliseconds.
- Column D: Total Blocking Time in milliseconds.
- Rows in chronological order, oldest first.
What If the Data Is Not Quite Ready
You want only the tests from after the redesign launch date
Pull all historical GTmetrix reports for page ID pg_abc123 where the test date is on or after 2025-11-01 and fill the "Post-Launch" sheet with date in column A, performance score in column B, and LCP in column C.
You have two monitored pages and want them side by side for comparison
Pull all historical GTmetrix reports for page IDs pg_abc123 and pg_xyz789. Write date in column A, then performance score for pg_abc123 in column B and performance score for pg_xyz789 in column C, aligned by test date so the same date appears on the same row.
You want to flag any test where the performance score dropped more than 10 points from the previous test
Pull all historical GTmetrix reports for page ID pg_abc123, fill columns A through D with date, performance score, LCP, and TBT, and add a column E that flags "Drop" on any row where the performance score fell more than 10 points compared to the row above.
Full analysis pipeline: pull history, flag regressions, and summarize by month
Pull all historical GTmetrix reports for page ID pg_abc123 into the "Raw" sheet with date in column A, performance score in column B, LCP in column C, and TBT in column D. Then in the "Monthly Summary" sheet, calculate the average performance score and average LCP for each calendar month and flag any month where the average performance score was below 70.
One prompt, one run — raw data and summary table both populated.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with your GTmetrix page ID, then ask it to pull the full report history and write it into your performance columns. For related workflows, see Bulk Run GTmetrix Speed Tests Into an Excel workbook or the GTmetrix + Excel overview.