The Scenario
The monthly marketing report is due Thursday. Your CMO wants the last 20 EmailOctopus campaigns in a slide deck — campaign name, send date, open rate, click rate, and total recipients. You've pulled this report manually every month for the last seven months: log into EmailOctopus, go to Campaigns, screenshot or copy each row, paste into a Google Sheet, calculate open rate from open count and recipient count because EmailOctopus doesn't give you a percentage directly, format the dates, fix the column headers. It takes about 45 minutes.
The bad version:
- Open EmailOctopus, navigate to the Campaigns list, click into each campaign to get the stats (the list view doesn't show click count), copy each number, tab back to the sheet, paste
- Realize you have 23 campaigns visible and aren't sure which 20 to include — oldest? most recent? best performing? — check with your manager, come back
- After building the table, notice two campaign names have special characters that broke the sorting in your sheet
Thursday is tomorrow.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It can query your EmailOctopus account and write campaign performance data directly into your sheet — in the format your report already expects.
Fetch all recent EmailOctopus campaigns and write each campaign's name, status, created date, open count, and click count into my Google Sheet
What You Get
- One row per campaign written to the sheet, starting at row 2
- Campaign name, status, created date, open count, click count in columns A through E
- Headers auto-written in row 1
- A total row or count in the sidebar summary so you know how many campaigns were returned
What If the Data Is Not Quite Ready
You need open rate and click rate as percentages, not raw counts
Fetch the last 20 EmailOctopus campaigns and write campaign name (column A), send date (column B), total recipients (column C), open count (column D), and click count (column E) to my Google Sheet. In column F, calculate open rate as open count divided by total recipients, formatted as a percentage.
Only certain campaign statuses should be included
Pull all EmailOctopus campaigns that have status 'sent' and write campaign name, send date, recipients, opens, and clicks to my Google Sheet. Skip any campaigns in draft or scheduled status.
The report compares this month to last month side by side
Fetch EmailOctopus campaigns from the last 30 days and write them to the 'This Month' tab — name in column A, send date in column B, opens in column C, clicks in column D. Then fetch campaigns from the 30 days before that and write them to the 'Last Month' tab in the same column layout.
Pull the stats, calculate performance, flag underperforming campaigns, and sort — all in one prompt
Fetch all sent EmailOctopus campaigns and write campaign name (A), send date (B), recipients (C), open count (D), click count (E) to my Google Sheet. In column F, calculate open rate as opens/recipients. In column G, write 'below average' if the open rate is less than 20%, otherwise leave blank. Sort the rows by send date descending.
The pattern is to ask for the data pull and the analysis logic together — you get a ready-to-present table, not raw numbers you still have to shape.
Try It
Get the 7-day free trial of SheetXAI and open your monthly report sheet, then ask it to pull the latest EmailOctopus campaign stats directly into it. You can also read how to export subscribers to a sheet or check the full EmailOctopus integration overview.