Datapipe
Review orders for your dates
Read orders created during the dates you choose. Keep totals, tax, discounts, and refunded amounts with each order's currency.
See your Lemon Squeezy numbers in Claude.
Read store orders, amounts, currencies, and current subscription status in one connected workflow.
ClaudeStart free Connect Lemon Squeezy
Updated October 2026
Review current subscriptions
Read current subscription status, product, and variant details. Keep renewal and trial dates alongside customer identifiers.
Refresh store reporting
Send the selected store's rows to a spreadsheet or download them. Identify test-mode records before combining results.
Ask AI about your data
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
Metrics and dimensions
5 metrics and 15 ways to split them.
Browse the documented fields below. In the app, choose your project connection to load its field list. Availability depends on API permissions, report type, and compatible field combinations. Property-specific custom fields appear after connecting.
Send Lemon Squeezy data anywhere
Google SheetsA sheet that refreshes every morning.
Looker StudioCharts that read the same numbers.
BigQueryA warehouse table for the same columns.
Excel / CSVA Drive file you can open in Excel.ClaudeAsk Claude about these numbers in a sentence.
ChatGPTAsk ChatGPT about these numbers in a sentence.
APIRead the same rows from your own tool.Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.Better than exporting by hand
- You can keep a row per day instead of one lump sum.
- Orders and sales stay in the report, ready each morning.
- People and the way you reach them can be their own rows.
- Products can be listed with the price and the status.
Start from a goal
Orders by creation date
Orders created during the selected UTC dates for the selected store. Amounts are integer cents in the order currency. Refund amounts describe each order's current state.
Use thisCurrent subscriptions
Current subscriptions for the selected store, independent of the selected report dates. Status, product, variant, renewal, and trial dates are current inventory rather than historical recurring revenue.
Use thisHow it works
- Create a project and choose Lemon Squeezy in Connections.
- Pick where it goes. This one sends the numbers to Claude.
- Pick where it goes. Choose orders or current subscriptions and a destination.
Sample report
Sample
| Order number | Customer email | Status | Currency | Total in cents | Refunded amount in cents | Product name | Variant name |
|---|---|---|---|---|---|---|---|
| 860 | avery@example.com | paid | USD | 1,240 | $80.00 | Wool coat | 1,240 |
| 410 | jordan@example.com | refunded | EUR | 640 | $125.50 | Canvas tote | 640 |
| 155 | sam@example.com | paid | USD | 210 | $42.00 | Gift card | 210 |
Sample numbers, so you can see the shape. Your report uses your accounts.
Orders use the selected UTC creation dates; subscriptions are current inventory, independent of the selected report dates. Amounts are integer cents in the order currency. One connection selects one store, and test-mode records are identified. Current refunded amounts are not a refund-event history or a settlement reconciliation.
Questions
Free to start. Paid plans add more connections and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 connections.
No. Name a project, add a connection, then choose a report and destination.
This integration is read-only. It reads store orders and subscriptions without changing subscriptions, creating checkouts, or issuing refunds. Use a dedicated credential; it can have broader provider permissions outside this connector.
This page lists 5 metrics and 15 ways to split them. You pick the columns when you build the report.
Orders use the selected UTC creation dates; subscriptions are current inventory, independent of the selected report dates. Amounts are integer cents in the order currency. One connection selects one store, and test-mode records are identified. Current refunded amounts are not a refund-event history or a settlement reconciliation. Account permissions and the records available from the provider determine which rows can be read.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
ActiveCampaign
Airtable
Attriboo
beehiiv
BigCommerce