The Scenario
You are the finance lead at a subscription box company. It is the first Monday of the quarter and your CFO is asking for current MRR. You know roughly how many active PayPal subscriptions you have, but you have never pulled them into a sheet before. You need subscriber email, plan ID, billing amount, start date — and a total MRR figure — before the 10 AM finance standup.
The slow version:
- Open PayPal's subscription management section
- Export subscriptions — realize the export does not include plan name or billing amount clearly
- Download the CSV and open it in Sheets
- Spend 20 minutes removing irrelevant columns and figuring out which field is the billing amount
- Write a SUMIF to group by plan and calculate MRR
- Still rechecking the formula when the standup starts.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that pulls the PayPal subscription data and builds the MRR summary for you in one pass.
Open the SheetXAI sidebar and type:
List all active PayPal subscriptions and write each one to the Active Subs sheet with columns for subscription ID, subscriber email, plan ID, amount, currency, and start date. Then add a summary block below showing total MRR grouped by plan ID.
SheetXAI fetches all active subscriptions from PayPal, writes them into the Active Subs sheet, and calculates MRR by plan in a summary block below the data.
What You Get
A sheet your CFO can look at during the standup:
- Subscription ID — direct PayPal reference
- Subscriber email — for customer-level lookup
- Plan ID — to group by tier
- Amount and currency — the billing amount per subscriber
- Start date — for cohort and churn analysis later
- MRR summary block — total billing per plan, total overall MRR
You walk into the standup with a number, not a spreadsheet still loading. The summary block is at the bottom of the data, not in a separate tool.
If you need churned subscriptions too — for a net revenue retention calculation — add that to the prompt.
What If the Data Is Not Quite Ready
Subscription data is rarely exactly what the finance model needs. SheetXAI handles enrichment and reshaping inline.
When subscriptions are in multiple currencies and MRR needs to be in one
Some subscribers are on EUR plans, some on USD. The CFO wants MRR in USD only.
List all active PayPal subscriptions and write them to the Active Subs sheet with subscription ID, subscriber email, plan ID, amount, currency, and start date. Add a USD Equivalent column converting EUR at 1.09 and GBP at 1.27. Then add a summary block showing total USD MRR by plan and overall.
When you also need to flag subscribers on grandfathered pricing
Some subscribers are on old plans at legacy prices. You want to flag rows where the plan ID starts with "LEGACY_" so finance can see the exposure.
List all active PayPal subscriptions and write them to the Active Subs sheet. Add a Pricing Tier column: write "LEGACY" if the plan ID starts with "LEGACY_", otherwise "CURRENT." Then show MRR split by LEGACY vs CURRENT in the summary block.
When you need to see which plans have been growing month over month
Finance wants to know if subscription counts are rising or falling compared to last month. You have last month's snapshot in the Previous tab.
List all active PayPal subscriptions and write them to the Active Subs tab. Then compare the count and total MRR per plan ID against the Previous tab. Add a Growth column in the summary block showing the change in subscriber count and MRR since last month.
When the CFO also wants a per-subscriber view with estimated LTV
The summary block is fine, but finance wants a full per-subscriber table with a 12-month LTV estimate next to each row.
List all active PayPal subscriptions and write them to the Active Subs sheet with subscription ID, subscriber email, plan ID, amount, currency, and start date. Add an Estimated 12M LTV column calculated as amount × 12 for each subscriber. Then add a summary block showing total MRR and average LTV by plan.
The pattern: the subscription list, the MRR calculation, and any enrichment all happen in one prompt. You do not pull first and calculate second.
Try It
Get the 7-day free trial of SheetXAI and connect your PayPal account, then ask it to pull your active subscriptions and calculate MRR. The PayPal integration is included in every SheetXAI plan. See also how to create PayPal subscription plans from a sheet or the PayPal in Google Sheets overview.