The Scenario
You are a marketing manager. The quarter just closed. You ran 40 email campaigns and the board report is due Friday. The CMO wants a single table showing every campaign with sent count, open rate, click rate, and unsubscribe rate.
HubSpot's email analytics UI shows one campaign at a time. There is no "export all" view that gives you a clean 40-row table.
The bad version:
- You open the first email campaign in HubSpot and manually copy the four metrics into a sheet
- You move to the second campaign and repeat
- Forty campaigns at three minutes each is two hours of copy-pasting
- Halfway through, you mistype one open rate and do not catch it until the CMO questions the number in the meeting
- You spend thirty minutes after the meeting finding and correcting the error.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI pulls the performance stats for every HubSpot email campaign into your sheet, without you opening a single campaign record.
Open the SheetXAI sidebar and type:
Retrieve aggregated performance statistics for all HubSpot marketing emails created this quarter. For each email, pull email name, send count, open rate, click rate, unsubscribe rate, and send date into this sheet. Sort by send date ascending.
SheetXAI queries HubSpot's marketing email stats API, collects all 40 campaigns, and writes the table into the sheet. Five columns, 40 rows, no copy-pasting.
What You Get
A clean sheet with 40 rows and five metric columns:
- Email name — the campaign identifier
- Send count — total recipients
- Open rate — as a percentage
- Click rate — as a percentage
- Unsubscribe rate — as a percentage
The data comes directly from HubSpot's API, not from reading a screen. There is no transcription error. If the open rate in the sheet does not match what HubSpot shows, you have a HubSpot data discrepancy, not a copy-paste error.
Need to add click-to-open rate as a calculated column? Ask SheetXAI: "Add a column G showing click-to-open rate calculated as click rate divided by open rate." One sentence.
What If the Data Is Not Quite Ready
Quarterly email performance pulls often need extra shaping before they are board-ready.
When you want to break out results by email type
HubSpot has promotional, transactional, and automated email types. The board wants to see each category separately.
Retrieve all HubSpot marketing email stats for this quarter. Group the results by email type. Write each group to its own tab: "Promotional," "Transactional," and "Automated." Include email name, send count, open rate, click rate, and unsubscribe rate on each tab.
When you need to compare this quarter to last quarter
The CMO wants to see whether performance improved or declined.
Retrieve HubSpot marketing email stats for Q1 2026 and Q2 2026. Write Q1 to a tab called "Q1" and Q2 to a tab called "Q2." Then create a summary tab showing average open rate, click rate, and unsubscribe rate for each quarter side by side.
When you want to flag campaigns that underperformed
Any campaign with an open rate below 20% needs a flag for the review meeting.
Retrieve all HubSpot marketing email stats for this quarter. Write all results to this sheet. Add a column F that says "REVIEW" if the open rate is below 20% and "OK" otherwise.
When you need the full reporting table built in one pass
Raw stats, calculated click-to-open rates, quarter-over-quarter comparison, and underperformance flags, all in one shot.
Retrieve HubSpot marketing email stats for this quarter. Pull email name, send count, open rate, click rate, and unsubscribe rate. Add a calculated column for click-to-open rate. Flag any campaign with open rate below 20%. Sort by open rate descending. Write to this sheet.
The pattern: describe the table you need and SheetXAI fetches and shapes it. No manual campaign-by-campaign review.
Try It
Get the 7-day free trial of SheetXAI and open any blank Google Sheet, then ask it to pull your HubSpot email campaign stats. The HubSpot integration is included in every SheetXAI plan. For related workflows, see how to export HubSpot contacts for segmentation reporting or the HubSpot in Google Sheets overview.