The Scenario
You are a deliverability consultant. A client audit is due Friday. The client uses SendGrid for all outbound email and wants to understand 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.
That means pulling 30 days of geo stats — opens and clicks by country and state — plus 60 days of daily Engagement Quality Score readings. All into a single Google Sheet, formatted for charts.
SendGrid has both data sets. They are in different endpoints. There is no "export to sheet" button for either one.
The slow version:
- Call the SendGrid geo stats endpoint manually, copy the JSON response, paste it somewhere, format it as a table
- Do the same for the EQS endpoint, 60 separate date calls if the API returns one day at a time
- Manually merge both into the sheet with the right column structure
- Spend half of Thursday on data wrangling for a report that should take 20 minutes to build.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that calls both SendGrid endpoints and writes the data into the right places 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 on the geo stats, and fills both tabs. The sheet is ready to hand to the client.
What You Get
Two populated tabs ready for charting:
- GeoStats tab — one row per country/state combination, with open count and click count columns. Sort it however you want for the client presentation.
- EQS tab — 60 rows of daily Engagement Quality Score data, sorted by date so a trend line is trivial to add
The EQS trend is the most useful part of the audit. A score that climbed from 60 to 85 over 60 days means the client's recent list hygiene work is paying off. A score that dropped from 80 to 55 means something changed and the client needs to know what.
Both charts are live in the sheet before you start your analysis.
What If the Data Is Not Quite Ready
Client deliverability audits often need more than raw numbers.
When you want to isolate the top 10 countries by open count
The geo stats have 80 countries and the chart needs to be readable.
Pull SendGrid geo stats for the last 30 days. Aggregate open count and click count by country (not by 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
A daily score has noise. The client wants to see the smoothed trend.
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. Then calculate a 7-day rolling average for each day (where enough data exists) and write it in column C.
When you want to compare geo performance to the prior period
Last 30 days versus the 30 days before that.
Pull SendGrid geo stats for the last 30 days and for the 30 days prior to that. Write both periods into the GeoStats tab: columns A through D for the recent period (country, state, opens, clicks), columns E through H for the prior period. 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
Stats, EQS trend, geographic breakdown, and a written interpretation.
Pull SendGrid geo stats for the last 30 days and write country, state, open count, and click count into 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 sheet, 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 a sheet or the SendGrid in Google Sheets overview.