The Scenario
It is Thursday afternoon. The engineering manager needs a schema check audit log on her desk before the Friday morning standup — specifically, a breakdown of how many checks passed versus failed this month, with the raw rows available for anyone who wants to dig deeper.
You are the backend team lead. You have been in and out of Grafbase all week watching checks run against the main-api graph. You know the data is there. Getting it into the workbook the manager uses for her weekly engineering digest is another matter entirely.
The bad version:
- Navigate to the schema checks view in the Grafbase dashboard, set the date filter to this month, and start reading through the list
- Open an Excel workbook, create headers manually, then type each check's ID, status, commit SHA, and approval state into a new row — one at a time, down the worksheet
- Scroll back through the dashboard to make sure you did not miss checks that loaded above the visible window, then try to verify your pass/fail tally matches the count shown in the UI
You are doing this while also fielding questions about two open PRs and a deployment that is running behind schedule. The audit log can wait, but it cannot wait past 9 AM tomorrow.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the workbook and connects to Grafbase on your behalf — no query writing, no pagination, no CSV reformatting. Ask it directly.
Fetch the last 100 schema checks for Grafbase graph main-api and write each check's ID, status, git commit, and approval state into Sheet1 as rows
What You Get
- Each schema check written as a row in Sheet1
- Columns: check ID, status (passed/failed/pending), git commit SHA, approval state
- Rows appear in the order Grafbase returns them — most recent first
- If a field is null for a given check (e.g., no approval recorded), the cell is left empty rather than written with a placeholder that would break downstream formulas
What If the Data Is Not Quite Ready
The worksheet has check IDs from last month mixed in and you need only this month's rows
Delete all rows in Sheet1 where the check date in column E is before May 1 2026, then re-fetch the current month's schema checks from Grafbase graph main-api and append them
The status values come back as uppercase strings but your Sheet2 formula expects lowercase
Fetch the last 100 schema checks for Grafbase graph main-api, convert the status field to lowercase, and write the results into Sheet1
You need to join the check history against a second worksheet that maps commit SHAs to PR numbers
For each row in Sheet1, look up the git commit in column C against the CommitSHA column in Sheet2 and write the matching PR number into column F — leave blank if no match is found
You need the raw rows, the monthly summary, and a pass-rate calculation all in one go
Fetch the last 100 schema checks for Grafbase graph main-api and write each check's ID, status, commit SHA, and approval state into Sheet1 as rows, then count how many checks passed versus failed this month and write a two-row summary table in Sheet2 with the counts and pass rate as a percentage
One prompt gets the audit log, the summary table, and the percentage — without a second round of work. That is the pattern: ask for the cleanup and the deliverable in a single shot.
Try It
Open the Excel workbook your team uses for engineering digests, then Get the 7-day free trial of SheetXAI and ask it to pull this month's Grafbase schema check history directly into the workbook. Also worth reading: Audit All Subgraph Schemas Across a Grafbase Federated Graph and the Grafbase overview for Excel.