Datapipe

See your Lemon Squeezy numbers in BigQuery.

Read store orders, amounts, currencies, and current subscription status in one connected workflow.

Lemon SqueezyBigQueryBigQuery

Start free Connect Lemon Squeezy

Updated October 2026

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.

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 SheetsGoogle SheetsA sheet that refreshes every morning.Looker StudioLooker StudioCharts that read the same numbers.BigQueryBigQueryA warehouse table for the same columns.Excel / CSVExcel / CSVA Drive file you can open in Excel.ClaudeClaudeAsk Claude about these numbers in a sentence.ChatGPTChatGPTAsk ChatGPT about these numbers in a sentence.APIAPIRead 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

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 this

Current 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 this

How it works

  1. Create a project and choose Lemon Squeezy in Connections.
  2. Pick where it goes. This one sends the numbers to BigQuery.
  3. Pick where it goes. Choose orders or current subscriptions and a destination.

Sample report

Sample

Order numberCustomer emailStatusCurrencyTotal in centsRefunded amount in centsProduct nameVariant name
860avery@example.compaidUSD1,240$80.00Wool coat1,240
410jordan@example.comrefundedEUR640$125.50Canvas tote640
155sam@example.compaidUSD210$42.00Gift card210

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.

Related sources

ActiveCampaignActiveCampaignAirtableAirtableAttribooAttriboobeehiivbeehiivBigCommerceBigCommerce

Start free