The Scenario
You are a newsletter analyst. Your client is presenting to investors in three weeks. They want a 6-month subscriber growth chart built in Google Sheets showing daily net new subscribers from their Kit account — a clean date-indexed table that feeds a line chart.
You have never pulled Kit growth stats before. You do know the data is in Kit's API somewhere.
The bad version of getting this data:
- You search Kit's help docs for "export subscriber growth by date"
- You find there is no built-in date-range export for daily growth in the UI
- You look at the API docs, find the stats endpoint, realize you need to authenticate and paginate
- You consider building a script, estimate two hours
- You call the client and tell them the chart will be ready "next week."
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI calls Kit's growth stats API and writes the date-indexed table directly into the sheet, so you never have to touch the API yourself.
Open the SheetXAI sidebar and type:
Fetch Kit subscriber growth stats for the past 180 days and write one row per day into this sheet. Include date in column A, total subscriber count in column B, new subscribers that day in column C, and unsubscribes that day in column D. Sort by date ascending.
SheetXAI calls Kit's growth endpoint, pulls the 180-day window, and writes the date-indexed table into the sheet sorted by date. Your client has a chart-ready data set before the meeting.
What You Get
A 180-row growth table, one row per day, ready to feed a line chart:
- Date — one per day in column A
- Total subscriber count — the running count as of that date in column B
- New subscribers — net adds that day in column C
- Unsubscribes — churn signal that day in column D
The total subscriber count column is what the line chart uses. New subscribers and unsubscribes give you the underlying story behind the trend line — a spike in unsubscribes on a specific date tells you which broadcast caused it.
Add a chart using column A as the x-axis and column B as the y-axis. Done.
What If the Data Is Not Quite Ready
Growth data across a 180-day window sometimes has gaps or needs reshaping for a specific presentation context. SheetXAI handles it inline.
When you need weekly averages instead of daily rows
The investor chart needs weekly granularity, not daily, to avoid the noise.
Fetch Kit subscriber growth stats for the past 180 days. Aggregate the data to weekly totals — one row per week showing the week starting date in column A, total new subscribers that week in column B, total unsubscribes in column C, and net growth (new minus unsubscribes) in column D. Write the result into the sheet sorted by week ascending.
When you need to align the growth window with a specific date range
The client wants January 1 through June 30, 2026 — not a rolling 180-day window.
Fetch Kit subscriber growth stats from January 1, 2026 to June 30, 2026. Write one row per day with date in column A, total subscribers in column B, new subscribers in column C, and unsubscribes in column D. Sort by date ascending.
When you want to annotate the chart with campaign send dates
You want to see subscriber spikes against the backdrop of broadcast dates.
Fetch Kit growth stats for the past 180 days and write the daily table — date, total, new, unsubscribes — into the Data tab. Then fetch all Kit broadcasts sent in the same 180-day window and write their send dates and names into the Campaigns tab. In the Data tab, add a column E that writes the broadcast name for any date that matches a send date, and leave it blank otherwise.
When you need the full investor-ready analysis: data, chart config, and narrative in one pass
The investor deck needs a table, chart instructions, and a one-paragraph growth narrative.
Fetch Kit growth stats for the past 180 days. Write the daily table into the Data tab. In the Summary tab, write: (1) total subscriber count at start and end of the period, (2) net growth over the 180 days, (3) the single day with the highest new subscriber count and what the count was, (4) the single day with the highest unsubscribes and what the count was, and (5) a two-sentence narrative suitable for an investor update describing the growth trend.
The pattern: pull the data, shape it for the audience, and write the narrative in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet, then ask SheetXAI to pull your Kit subscriber growth stats into it. The Kit integration is included in every SheetXAI plan. For the broadcast performance side, see how to pull Kit broadcast stats into a sheet or the Kit in Google Sheets overview.