The Scenario
You are a marketing analyst. The VP of Marketing asked a question in Slack at 8:45 AM on Monday: "Are we growing or shrinking? I want to see new subscribers versus unsubscribers for every day of the last 6 months."
The data is in ActiveTrail's contact growth stats. You have never pulled it. You need to get it into a Google Sheet, create a chart, and reply in Slack before the 10 AM all-hands.
The slow version:
- You search ActiveTrail's help docs to find where the growth stats live
- You find a "Statistics" section — it shows a graph in the UI but no export button
- You try the API docs — the endpoint exists but the date range parameter is not obvious
- You build a test API call in Postman, get the data, and realize it is returned as a nested JSON object
- You write a script to flatten it, paste it into a sheet, build a chart
- It is 10:05 AM. The all-hands started. You are still in the Postman tab.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls ActiveTrail contact growth statistics and writes them directly into the sheet — no API docs, no JSON parsing.
Open the SheetXAI sidebar and type:
Pull ActiveTrail contact growth stats for the last 6 months and write the date, new subscribers count, and unsubscribers count to this sheet — one row per day. Then create a line chart on this sheet showing new subscribers and unsubscribers over time.
SheetXAI calls ActiveTrail's statistics API, fetches the daily growth data, writes it into the sheet, and creates the chart. You have the answer to the VP's question before the all-hands ends.
What You Get
A daily subscriber growth dataset with a chart:
- One row per day — date, new subscribers, unsubscribers
- Six months of data — the full date range you asked for
- Line chart — new subscribers versus unsubscribers over time, built directly in the sheet
The chart is real data, not a screenshot. The VP can open the sheet and filter it, zoom in on a specific month, or ask for a different view.
Want a net change column — new subscribers minus unsubscribers per day? Add it to the prompt. SheetXAI writes the formula or calculates the column inline.
What If the Data Is Not Quite Ready
Growth data at a daily granularity can have blank days or noisy patterns. SheetXAI handles them in the same prompt.
When daily granularity is too noisy for the chart
Day-level data has spikes from campaign sends that distort the trend. The VP wants weekly averages.
Pull ActiveTrail contact growth stats for the last 6 months. Group by week and write one row per week showing total new subscribers, total unsubscribers, and net change. Add a line chart showing weekly net subscriber change over the 6-month period.
When you want to add a net change column and a cumulative total
The VP also wants to see absolute list size over time, not just daily flows.
Pull ActiveTrail daily contact growth stats for the last 6 months — date, new subscribers, unsubscribers. Add a Net Change column (new minus unsubscribers) and a Cumulative Net column that running-totals the net change from day 1. Create a line chart showing cumulative net growth over the period.
When you want to compare growth in two different time windows
The VP wants this quarter versus last quarter side by side to see if growth is accelerating.
Pull ActiveTrail daily contact growth stats for Q2 and Q3 of this year. Write Q2 data to the Q2 tab and Q3 data to the Q3 tab, each with date, new subscribers, unsubscribers, and net change. On the Comparison tab, write monthly totals for each quarter side by side, then create a bar chart comparing monthly net subscriber growth between the two quarters.
When you want the full picture — growth data, analysis, and a Slack-ready summary in one prompt
You need to reply in Slack with a number and a trend, not just share a link.
Pull ActiveTrail daily contact growth stats for the last 6 months. Write date, new subscribers, unsubscribers, and net change to this sheet. Calculate the total new subscribers and total unsubscribers for the full 6-month period. Identify the month with the highest net growth and the month with the biggest net loss. Write a 3-sentence summary of the findings in cell A1 above the data table that I can paste into Slack.
The pattern: instead of digging through API docs and building a chart from scratch, you describe the deliverable and SheetXAI builds it. The Slack reply is ready before the all-hands ends.
Try It
Get the 7-day free trial of SheetXAI and open any sheet, then ask it to pull your ActiveTrail subscriber growth statistics. The ActiveTrail integration is included in every SheetXAI plan. For related workflows, see how to pull campaign performance into a sheet or the ActiveTrail in Google Sheets overview.