The Scenario
You're the ops manager for a small e-commerce business that accepts Bitcoin. Last Tuesday, your accountant sent a message: "I need a list of all outstanding and completed payment requests from BTCPay so I can reconcile them against accounts receivable."
You know the data is in BTCPay. You've seen it in the dashboard. But getting it out — structured, with status flags, in a format your accountant can actually work with in Google Sheets — is a different problem entirely.
The bad version:
- You log into BTCPay, navigate to payment requests, and start reading through the list in the dashboard.
- You copy titles, amounts, and statuses by hand into a new sheet, one row at a time.
- Halfway through, you realize you forgot to include creation dates — so you go back and add a column, then re-enter the dates for the rows you already entered.
Seventy payment requests is not a number that bends to manual extraction. Your accountant needed this yesterday. The time you're spending on data entry is time that isn't going toward any of the three other things on your list for the week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to your BTCPay Server instance and pulls the records you need directly into the sheet — no dashboard scraping, no CSV wrestling. Open the sidebar and tell it what you want.
Pull all BTCPay Server payment requests from my store into this Google Sheet — include title, amount, currency, status, and creation date in columns A through E, and flag any requests with a status of "pending" in column F
What You Get
- Every payment request from your BTCPay store written into the sheet, one row per request.
- Columns populated: title (A), amount (B), currency (C), status (D), creation date (E).
- Pending requests flagged in column F with the word "FOLLOW UP" so your accountant can filter immediately.
- The full list in one pull — not paged or truncated.
What If the Data Is Not Quite Ready
You only want requests from the last 90 days
Your store has two years of payment history and you don't need all of it for this reconciliation.
Pull BTCPay Server payment requests created in the last 90 days into my sheet — include title, amount, currency, status, and creation date — skip anything older than 90 days from today
You need to match requests against your internal invoice IDs
Your AR ledger uses internal invoice IDs stored in the payment request memos. You want those pulled through too.
Export all BTCPay payment requests into my sheet and include the memo field in column G — I need to cross-reference memo values against column A of my "AR Ledger" tab where column A holds internal invoice IDs, and mark any matches in column H
You're pulling from multiple stores
You manage two BTCPay stores for two sub-brands and need all requests in one sheet.
Pull payment requests from both BTCPay store IDs 'store-001' and 'store-002' into my sheet — add a "Store" column to indicate the source, and include title, amount, currency, and status
Full reconciliation pipeline in one pass
Pull all BTCPay payment requests created this calendar year into my sheet with title, amount, currency, status, memo, and creation date — flag pending ones in a "Status Flag" column, mark any whose memo doesn't match a value in my "AR Ledger" tab column A as "Unmatched," and sort the results by creation date descending
Asking for the pull, the flag logic, and the cross-reference in a single prompt means you get a clean sheet instead of a sheet that needs three more passes.
Try It
Get the 7-day free trial of SheetXAI and open a Google Sheet where you'd normally build your BTCPay reconciliation report, then ask SheetXAI to pull in the payment requests and flag what needs attention. You can also see how to bulk-create payment requests from invoice rows or return to the BTCPay Server hub overview.