The Scenario
You are a deliverability consultant. A client audit is due Friday. The client wants to know where their opens and clicks are concentrated geographically and whether their Engagement Quality Score has been trending up or down over the last two months. All into a single Excel workbook, formatted for charts.
SendGrid has both data sets. There is no "export to Excel" button for either one.
The slow version:
- Call the SendGrid geo stats endpoint manually
- Copy the JSON, paste it somewhere, format it as a table
- Do the same for the EQS endpoint, 60 separate calls if the API returns one day at a time
- Merge both into the workbook with the right column structure
- Half of Thursday spent on data wrangling for a report that should take 20 minutes.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls both SendGrid endpoints and writes the data into the right tabs in one operation.
Open the SheetXAI sidebar and type:
Pull SendGrid geo stats for the last 30 days and write each country, state, open count, and click count as a separate row in the GeoStats tab, with headers in row 1. Then pull my Engagement Quality Score for each day of the last 60 days and write the date and score into columns A and B of the EQS tab, sorted by date ascending.
SheetXAI calls both endpoints, handles pagination, and fills both tabs. The workbook is ready for the client before you start your analysis.
What You Get
Two populated tabs ready for charting:
- GeoStats tab — one row per country/state combination, with open and click counts
- EQS tab — 60 rows of daily Engagement Quality Score data, sorted by date
The EQS trend is the most actionable part. A score climbing from 60 to 85 over 60 days means the client's list hygiene work is paying off. A score dropping from 80 to 55 means something changed and the client needs to know what before the next campaign.
What If the Data Is Not Quite Ready
When you want only the top 10 countries by open count
Pull SendGrid geo stats for the last 30 days. Aggregate by country (not state). Sort by open count descending and write only the top 10 countries into the GeoStats tab.
When you want the EQS trend with a 7-day rolling average
Pull my SendGrid Engagement Quality Score for each day of the last 60 days. Write the date and raw score into columns A and B of the EQS tab. Calculate a 7-day rolling average and write it in column C.
When you want to compare geo performance to the prior period
Pull SendGrid geo stats for the last 30 days and for the 30 days prior to that. Write both periods into the GeoStats tab with the same column structure. In column I, calculate the percentage change in open count between the two periods.
When you need the full client audit package in one prompt
Pull SendGrid geo stats for the last 30 days and write them to the GeoStats tab. Pull 60 days of Engagement Quality Score and write date and score into the EQS tab with a 7-day rolling average in column C. Aggregate geo stats by country and write the top 10 countries by open count into a Summary tab. Then write a paragraph in the Summary tab interpreting the deliverability trend: is the EQS improving or declining, which countries drive the most engagement, and what should the client watch next quarter.
The pattern: all the data plus the interpretation in one prompt. The Friday deadline is not a problem.
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook, then ask it to pull your SendGrid geo stats and Engagement Quality Score history. The SendGrid integration is included in every SheetXAI plan. For related workflows, see how to pull SendGrid campaign stats into Excel or the SendGrid in Excel overview.