Completed payments
Read each completed payment in the selected dates with amount, total, status, source, receipt number and the order and customer it belongs to.
Square connector · Sales reports & catalog updates
Bring Square payments, orders, catalog items and customers into your reports and AI assistants. Then add or update customer details and rename or describe catalog items from Datapipe, with access your team controls.
Start free See what you can change
Updated November 2026
| Payment date | Amount | Source |
|---|---|---|
| 2026-11-11 | $48.50 | Card |
| 2026-11-12 | $126.00 | Card |
| 2026-11-12 | $19.75 | Cash |
Your Square seller account is the data source, across every location the access token can see. Payments and orders follow the report dates; the catalog and customer list are current.
Read each completed payment in the selected dates with amount, total, status, source, receipt number and the order and customer it belongs to.
See orders by creation date with location, state, total, tax, discounts and customer.
Keep a current list of catalog items with name, description, category, version and whether the item was deleted.
Read the customer directory with name, company, email, phone and when each profile was created or updated.
4 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
Payments processed during the selected dates. Amounts keep payment currency major units. This is not a bank deposit or settlement report.
Orders created during the selected UTC dates. Includes item totals, taxes, discounts and order fulfillment state.
Active and deleted catalog items, not filtered by report dates. Item names, descriptions, categories and version numbers.
Directory of customers in the Square account, not filtered by report dates. Names, company and contact details.
Create a customer profile or update a customer’s contact details. No cards are attached and no payments are taken.
Rename a catalog item or rewrite its description. Variations and prices stay as they are.
Allow the changes your team needs for this data source. Teammates and AI assistants use that access; they cannot grant themselves more.
Allowed changes apply right away unless you require approval. Set approval for risky changes, every change or a specific person. Changes history records who made each update and its result.
Creates one new customer profile in Square. Does not attach cards or take payments. Every change is recorded in the Changes history.
Updates contact details on an existing Square customer profile. Card profiles and past orders are unchanged. Every change is recorded in the Changes history.
Updates the name or description of an existing item in the Square catalog. Variations and prices remain unchanged. Every change is recorded in the Changes history.
| Field | Before | After |
|---|---|---|
| Description | Fresh roasted coffee beans 12oz bag | Ethiopian Yirgacheffe Single Origin Roast · Notes of blueberry and jasmine (12oz) |
32 report fields across 4 datasets.
Search the available fields. Hover or tap a field to see what it means.
No fields match. Try another search or choose All.
Use Datapipe’s MCP access as your Square AI integration. Ask about payments, orders and customers, then make an allowed change and check it in Changes history.
Example
Which location took the most in payments last week, and how did it compare with the week before?
Compare completed payment totals by location for both weeks, with the number of orders behind them.
A Square access token from the seller account you want to report on. Reports cover every location that token can see.
Catalog changes cover item names and descriptions only; prices, variations and stock are not changed.
Create your free account, then choose Square in Data sources.
Paste your Square access token. Add Google Analytics or your email tool if you want marketing context.
Choose a report and destination, or allow customer and catalog changes. Set approvals for the changes you want reviewed first.
Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.
Datapipe reads completed payments and orders for the selected dates, plus your current catalog items and customer directory, across the locations your access token can see.
Yes, when the change is allowed for you in Datapipe. You can create or update customers and change a catalog item’s name or description. Datapipe never takes payments or changes prices. You can require approval before a change applies.
Yes. Reports include every location the access token can see, and orders keep their location ID so you can compare them.
Yes. Add each seller account as its own data source; each one counts as one data source.
Free to start. Paid plans add more data sources and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.
The workspace owner, workspace admins and project managers. Changes start off. They choose which changes are allowed for each data source and who can make them: project operators and managers, selected teammates, and the AI tools those people connect. They can change this at any time.
Yes, if you want. For each data source, approval can cover risky changes only (deleting, sending, publishing, refunds and price changes) or every change. You can also switch it on for one person, such as an intern. Those changes wait on the Changes page until the owner, an admin or a project manager approves them. Nobody but the owner approves their own change.
One for each Square account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.
Start free, add Square and choose how your team reports on sales and updates customers and items.