The Scenario
You started tracking Paystack subscription metrics in a spreadsheet six months ago. You created a tab called "MRR" and told yourself you'd update it monthly. You haven't touched it since February.
Now your investor wants a current MRR figure ahead of the quarterly call next Thursday, and you realize you have no idea how many active subscribers you have, what plans they're on, or what the real number is.
The bad version:
- You log into Paystack, navigate to Subscriptions, and start scrolling. The dashboard shows you a paginated list — 20 rows at a time — with no bulk export option that surfaces plan amounts clearly.
- You export what you can, open the CSV, and find that the "amount" field is a combined string rather than a standalone number, so your SUM formula returns zero.
- You spend 40 minutes building a helper column to parse the amount out of the string, and by the time you have a number you're not confident it's actually showing active subscriptions only versus cancelled ones that haven't lapsed yet.
The investor call is in six days. You need the number to be right, not just plausible.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your request and pulls your Paystack subscription data through the API, writing each subscription into your sheet with clean, separate columns — no CSV parsing, no string-splitting formulas.
List all active Paystack subscriptions and write each one to the 'Active Subscriptions' sheet with columns for subscription code, plan name, customer email, amount, and next payment date.
What You Get
- Column A: subscription code
- Column B: plan name as configured in Paystack
- Column C: subscriber email address
- Column D: subscription amount (numeric, in smallest currency unit)
- Column E: next payment date
- Active subscriptions only — cancelled and expired records excluded
- Ready to SUM column D for total MRR, or pivot by plan name for breakdown
What If the Data Is Not Quite Ready
You need the amount in naira, not kobo
List all active Paystack subscriptions and write each one to the 'Active Subscriptions' sheet with subscription code in A, plan name in B, customer email in C, amount converted from kobo to naira in D, and next payment date in E.
You need to group by plan and sum MRR per plan
List all active Paystack subscriptions, write each one to the 'Active Subscriptions' sheet with the standard columns, then create a summary section starting at row 2 of the 'MRR Summary' sheet showing each unique plan name, subscriber count, and total monthly amount in naira.
You want to flag subscribers whose next payment date has already passed
List all active Paystack subscriptions, write them to the 'Active Subscriptions' sheet with the standard columns, then mark 'PAYMENT OVERDUE' in column F for any row where next payment date is before today.
Pull, convert, summarize, and flag in one shot
List all active Paystack subscriptions, convert amounts from kobo to naira, write each row to 'Active Subscriptions' with the standard columns, mark 'PAYMENT OVERDUE' in column F where next payment date has passed, then build an MRR summary on the 'MRR Summary' sheet showing plan name, subscriber count, and total naira MRR per plan.
Running the full chain in one prompt means you go into the investor call with a number you can actually defend.
Try It
Open the Google Sheet where you track subscription or revenue metrics, then Get the 7-day free trial of SheetXAI and ask it to pull your active Paystack subscriptions directly. For related workflows, see how to bulk-create subscription plans, or how to export the full balance ledger for cash-flow analysis.