Founders
See payments and orders every morning without logging in.
Connect Square POS and online sales, catalog items and customer profiles with catalog and customer edits from Datapipe.
Updated November 2026
| Date | Gross amount | Status |
|---|---|---|
| Oct 29 | $145.00 | COMPLETED |
| Oct 28 | $125.50 | Pending |
| Oct 29 | $42.00 | Refunded |
See payments and orders every morning without logging in.
Reconcile payments in the spreadsheet you already use.
Compare order totals and discounts across locations each week.
Read completed payments, orders, customer profiles and catalog items across all authorized Square locations.
Changes stay off until you allow them. Allowed changes apply to Square right away, and history keeps the values before and after.
Amounts retain the location currency and timestamps remain explicit UTC.
Compare daily payment totals across store locations.
Limit: Keep card tender amounts, fees and processing timestamps visible in your spreadsheet or dashboard.
A teammate sets a clearer description or corrected name for a catalog item, and Square updates the catalog.
Limit: History keeps the old copy.
See the problem in your report, then make the fix in Datapipe instead of opening Square, finding the record and retyping it.
Teammates and AI tools you allow can make changes without getting edit access to Square.
Changes stay off until you allow them. Every change is recorded with who made it and the values before and after.
TodayLog into Square POS or Dashboard, click Create Customer, fill out contact details, and save.
With DatapipeConvert verified corporate catering intake into a registered Square customer record from Datapipe.
TodayOpen Square directory, manually create new buyer profile with contact and company info.
With DatapipeCreate the wholesale buyer profile from your wholesale pipeline report.
Creates one new customer profile in Square. Does not attach cards or take payments. Every change is recorded in the Changes history.
Supported fields: First name, Last name, Email address.
TodayOpen Customer Directory in Square, search customer profile, update phone number or email, and save.
With DatapipeSpot unlinked customer profiles in daily sales reports and add the verified phone number and email.
TodaySearch customer in Square Dashboard, open profile details, edit corporate notes or custom fields.
With DatapipeAdd business client details from recent catering and event invoices. History records who added them.
Updates contact details on an existing Square customer profile. Card profiles and past orders are unchanged. Every change is recorded in the Changes history.
Supported fields: First name, Last name, Email address, Phone number.
TodayLog in to Square Dashboard, open Items catalog, search item SKU, rewrite the description, and publish to all store registers.
With DatapipeAudit thin product descriptions in your catalog report and write fuller copy with flavor notes and sizing from Datapipe.
TodayOpen item library in Square POS backend, click into each variation, and retype product title.
With DatapipeIdentify inconsistent SKU naming across store locations and apply standard titles from Datapipe.
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.
Supported fields: Item name, Description.
| Field | Before | After |
|---|---|---|
| Description | Fresh roasted coffee beans 12oz bag | Ethiopian Yirgacheffe Single Origin Roast · Notes of blueberry and jasmine (12oz) |
Source changes are managed on the Changes page in Datapipe. Approval is optional: set it for risky changes, for every change, or for one person. AI tools such as ChatGPT can never widen their own access. Who can turn this on?
Provider permissions still apply, and automations in Square may react to changes.
Only fields supported by an allowed action can be changed; for some actions the owner, an admin or a project manager also picks the individual writable fields.
An API key or token from your Square account.
Read access for reports. The 3 change actions need edit access in Square and stay off until the owner, an admin or a project manager allows them.
Anything your connected account cannot see in Square.
Completed payments, itemized orders, catalog objects and customer profiles across all authorized locations for your selected dates.
Reporting reads payments and orders. Optional customer creation, contact updates and catalog item edits are off until allowed for this data source, and every change is recorded in history. Payment processing, refunds and stored cards are not modified.
4 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
Completed payments taken during the selected UTC dates at every location the access token can see. Amounts keep payment currency major units. This is not a bank deposit or settlement report.
Orders created during the selected UTC dates. Includes order totals, taxes, discounts and order state.
Current catalog items, not filtered by report dates. Item names, descriptions, reporting categories and version numbers.
Directory of customers in the Square account, not filtered by report dates. Names, company and contact details.
32 report fields across 4 datasets.
Hover or tap a field to see what it means. Custom fields from your own account appear after you connect.
No fields match. Try another search or choose All.
Claude or ChatGPT can read the same numbers. You ask in a normal sentence, and the answer stays with your report.
AI tools can also make allowed Square changes. They can never widen their own access.
Which store locations in Square had the highest order totals last week, and how did discounts compare?
Your busiest location took $18,240 across 612 orders with $940 in discounts, about 30% ahead of the next location.
Completed payments taken during the selected UTC dates at every location the access token can see.
Use this template →Orders created during the selected UTC dates.
Use this template →Current catalog items, not filtered by report dates.
Use this template →Directory of customers in the Square account, not filtered by report dates.
Use this template →Create a project and choose Square in Data sources.
Pick where it goes. This one sends the numbers to Snowflake.
Pick where it goes. Choose payments, orders, catalog, or customers and a destination.
| Date | Payment ID | Gross amount | Status | Tender | Order ID | Total money | State |
|---|---|---|---|---|---|---|---|
| Oct 29 | sq-pay-901 | $145.00 | COMPLETED | CARD | 1024 | 1,240 | 1,240 |
| Oct 28 | 1025 | $125.50 | Pending | 640 | 1025 | 640 | 640 |
| Oct 29 | 1031 | $42.00 | Refunded | 210 | 1031 | 210 | 210 |
Sample numbers, so you can see the shape. Your report uses your accounts.
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.
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.
No. Name a project, add a data source, then choose a report and destination.
OAuth means you sign in with the service and grant access, without pasting an API key. Datapipe works with multiple partners to provide that sign-in. Some partners already provide it. Some integrations are API-only at present, so you paste a key or token. OAuth is coming soon for some. Some partners do not provide OAuth at all. The setup steps on each integration page say how that source connects. Signing in is only how the connection is made. It is not permission to change records. Where a source supports changes, those writes stay off until the workspace owner turns specific actions on and approves each one. We do not promise OAuth on every source, and we do not share dates.
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.
No. Teammates make allowed changes in Datapipe, and Datapipe applies them through the connected Square account. Nobody else gets a Square login from this.
Yes, if that change is allowed for them. They work through Datapipe the same way a teammate does, within the same allowed changes and fields, and every change is recorded in the Changes history. AI tools can switch changes off, but they can never widen their own access. Asking for more waits for a person.
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.
Datapipe sends each change once and records the result in the Changes history. If it cannot confirm that Square received it, the request is marked Uncertain and is never retried automatically, so you can check Square first.
Yes. Datapipe reads the reports on this page and can make 3 kinds of change: create a customer; update customer contact details; update catalog item name or description. Each one stays off until the owner, an admin or a project manager allows it for this data source. Allowed changes apply right away and are recorded in the Changes history. Provider permissions still apply.
This page lists 32 report fields across 4 datasets. You pick the columns when you build the report.
Completed payments, itemized orders, catalog objects and customer profiles across all authorized locations for your selected dates. Account permissions and the records available from the provider determine which rows can be read.
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.
Yes. The same numbers can go to a sheet, a chart, a warehouse, or an assistant.
Build the report first, then add Square when you are ready.