The Scenario
Every Monday morning your founder asks the same question in the company Slack: "How are we tracking vs last month?"
You have Payhere's dashboard open on one screen. It shows the current 30-day totals. It shows the prior 30-day totals. It does not calculate the percentage change. It does not show you a formatted table you can paste into Slack or the weekly report doc. So every Monday you squint at two sets of numbers, do the math in your head, type it into a Google Sheet, format it, and share the link.
The bad version:
- Open Payhere, read current 30-day revenue, prior 30-day revenue, new subscriber count, payment count — write them down
- Open the sheet, paste in the numbers, write formulas for percentage change in three separate cells
- Realize last week's numbers are still in the sheet from the previous Monday and you've overwritten them, losing the historical trend
The report takes 15 minutes to produce. It looks like it took 2.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It talks to Payhere's stats endpoint and writes a formatted comparison directly into your sheet — math included.
Fetch Payhere's current 30-day payment stats and write them into this sheet with current period values in column B, prior period values in column C, and a calculated percentage change in column D — include rows for total revenue, new subscribers, and total payment count
What You Get
- Current 30-day totals and prior 30-day totals written side by side in your sheet
- Percentage change calculated automatically in column D for each metric
- Data written as numeric values so you can apply your own formatting and charting on top
- The whole table in under a minute — no copying from the dashboard, no mental arithmetic
What If the Data Is Not Quite Ready
You want the stats appended as a new row each week, not overwritten
Fetch Payhere's current 30-day stats and append a new row to the bottom of this sheet with today's date in column A, current revenue in column B, prior revenue in column C, new subscribers in column D, and payment count in column E
You need the delta as an absolute number, not just a percentage
Pull Payhere's 30-day payment stats and write a summary table with current value, prior value, absolute change, and percentage change for revenue, subscriber count, and payment count — one metric per row
The stats need to go into a presentation-ready summary block
Fetch Payhere's 30-day stats and write a one-page summary into the Dashboard tab with current period totals in bold cells B2 through B4, prior period values in C2 through C4, and percentage change formatted with a + or − sign in D2 through D4
Weekly briefing doc plus trend analysis in one command
Get Payhere's current 30-day stats, write the comparison table into the Weekly tab with today's date, and in the Trends tab append one row to the running historical table so we can track month-over-month patterns over time
The pattern: pull the live data and update the historical record in the same command so the trend table stays current without a separate step.
Try It
Get the 7-day free trial of SheetXAI and open your weekly reporting sheet, then ask it to pull and populate this week's Payhere stats comparison. See also: exporting your full payment history when you need the transaction-level detail behind the headline numbers. Full Payhere overview: How to Connect Payhere to Google Sheets.