The Scenario
You're presenting to your seed investor next Thursday. They want to see your MRR — current, broken down by plan. You run subscriptions through Paystack. Your Excel workbook has a tab called "MRR Analysis" that you set up three months ago and never populated.
You open Paystack to figure out how to export subscription data.
The bad version:
- The Paystack dashboard shows subscriptions in a paginated list: 20 per page, no obvious bulk export. You start clicking through pages and writing down plan names and amounts manually.
- You find an export option eventually. The CSV has a combined "plan" field that includes the plan name and amount in a single string — "Starter Plan (NGN 5,000/month)." Your SUM formula is going to return zero.
- You spend 40 minutes writing helper formulas to parse the plan name and amount out of the string. By the time you have a number, you've introduced three cell references that will break if anyone touches the column order.
The investor meeting is in six days. Your MRR number needs to be accurate and defensible.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your request and pulls your Paystack subscription data through the API, writing each subscription into your MRR Analysis sheet with clean, separate columns — no string parsing, no formula chains, no dashboard pagination.
Fetch all Paystack subscriptions and populate my Excel 'MRR Analysis' sheet with plan code, customer email, amount, interval, and status — then I'll add a pivot table.
What You Get
- Plan Code column: Paystack's internal plan identifier
- Customer Email column: subscriber email address
- Amount column: subscription amount as a numeric value (in smallest currency unit)
- Interval column: monthly, annually, etc.
- Status column: active, cancelled, non-renewing
- One row per subscription — ready for a pivot table by plan or a SUM by status
What If the Data Is Not Quite Ready
You need amounts in naira and only active subscriptions
Fetch all active Paystack subscriptions and populate the 'MRR Analysis' sheet with plan code in A, customer email in B, amount converted from kobo to naira in C, interval in D, and status in E.
You need a plan name column, not just plan code, for the investor presentation
Fetch all active Paystack subscriptions, look up the plan name for each plan code, and populate the 'MRR Analysis' sheet with plan code in A, plan name in B, customer email in C, amount in naira in D, interval in E, and status in F.
You want a summary section showing MRR per plan at the bottom of the sheet
Fetch all active Paystack subscriptions with plan name, email, amount in naira, interval, and status. After writing all rows to the 'MRR Analysis' sheet, add a summary block showing each unique plan name, subscriber count, and total monthly amount — starting 3 rows below the last data row.
Filter to active, convert amounts, add plan names, and build summary in one shot
Fetch all active Paystack subscriptions, convert amounts to naira, look up plan names, write each row to 'MRR Analysis' with plan code in A, plan name in B, email in C, naira amount in D, interval in E, status in F, then add an MRR summary block below the data showing plan name, subscriber count, and total naira MRR per plan.
One prompt, a pivot-ready dataset and a summary block — and you go into the investor meeting with a number you built from source data, not an estimate.
Try It
Open the Excel workbook where you track revenue metrics, then Get the 7-day free trial of SheetXAI and ask it to pull your Paystack subscriptions directly. For related workflows, see how to bulk-create subscription plans, or export the balance ledger for your full cash-flow picture.