Start free
Read & reportControlled changes

See your Square numbers in Databricks SQL.

Connect Square POS and online sales, catalog items and customer profiles with catalog and customer edits from Datapipe.

  • Payments, orders and customers in a sheet that refreshes itself
  • Revenue by month without exporting from Square
  • Tidy customer records from Datapipe, with every change recorded
SquareDatabricks SQLDatabricks SQL

Start free Connect Square

Updated November 2026

Square reportSample data
DateGross amountStatus
Oct 29$145.00COMPLETED
Oct 28$125.50Pending
Oct 29$42.00Refunded
Refreshes on your schedule in Databricks SQL

Who uses Datapipe with Square

Founders

See payments and orders every morning without logging in.

Finance leads

Reconcile payments in the spreadsheet you already use.

Store managers

Compare order totals and discounts across locations each week.

What you can do with Square

Read and report

Read completed payments, orders, customer profiles and catalog items across all authorized Square locations.

  • Completed payments
  • Orders by creation date
  • Store catalog items
  • Customer directory

Explore metrics and dimensions

Controlled changes

  • Create a customer
  • Update customer contact details
  • Update catalog item name or description

Changes stay off until you allow them. Allowed changes apply to Square right away, and history keeps the values before and after.

See what you can change

Full read details

Amounts retain the location currency and timestamps remain explicit UTC.

Examples for your team

Read & report

Review daily sales and payment tenders

Compare daily payment totals across store locations.

  1. Scheduled refresh
  2. Latest Square data
  3. Updated report

Limit: Keep card tender amounts, fees and processing timestamps visible in your spreadsheet or dashboard.

Controlled change

Clarify a product catalog description before launch

A teammate sets a clearer description or corrected name for a catalog item, and Square updates the catalog.

  1. Allowed
  2. Applied
  3. Recorded

Limit: History keeps the old copy.

Fix things in Square without opening it

Spot it, fix it

See the problem in your report, then make the fix in Datapipe instead of opening Square, finding the record and retyping it.

More people can help

Teammates and AI tools you allow can make changes without getting edit access to Square.

You decide what can change

Changes stay off until you allow them. Every change is recorded with who made it and the values before and after.

Jobs you can stop doing by hand in Square

Create a customer

  • Enroll corporate catering client into customer directory

    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.

  • Add wholesale commercial partner profile for direct invoicing

    TodayOpen Square directory, manually create new buyer profile with contact and company info.

    With DatapipeCreate the wholesale buyer profile from your wholesale pipeline report.

Exactly what this can change

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.

Update customer contact details

  • Update customer loyalty contact details after in-store verification

    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.

  • Add corporate billing tax ID to customer directory profile

    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.

Exactly what this can change

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.

Update catalog item name or description

  • Update seasonal retail item descriptions across POS terminals

    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.

  • Standardize product naming across multiple retail locations

    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.

Exactly what this can change

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.

Recorded changeExample

SquareCreate a customerCatalog item · Single Origin Roast (#itm_9941) · made by Alex Chen

FieldBeforeAfter
DescriptionFresh roasted coffee beans 12oz bagEthiopian Yirgacheffe Single Origin Roast · Notes of blueberry and jasmine (12oz)

Applied to SquareRecorded in Changes history

You control who can change what

  1. A change is allowed for this data source
  2. A teammate or AI tool makes it
  3. It applies right away, or waits for approval if you set that
  4. Recorded with the values before and after

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 rules and limits

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.

Before you connect

What you need

An API key or token from your Square account.

Read and write

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.

Limits and exclusions

Anything your connected account cannot see in Square.

Full details and limits

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.

Reports you can build

4 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

What each dataset reports
  • Completed payments

    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 by creation date

    Orders created during the selected UTC dates. Includes order totals, taxes, discounts and order state.

  • Store catalog items

    Current catalog items, not filtered by report dates. Item names, descriptions, reporting categories and version numbers.

  • Customer directory

    Directory of customers in the Square account, not filtered by report dates. Names, company and contact details.

Metrics and dimensions

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.

Send Square data anywhere

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.

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.

Better than exporting by hand

Start from a goal

How it works

  1. Create a project and choose Square in Data sources.

  2. Pick where it goes. This one sends the numbers to Databricks SQL.

  3. Pick where it goes. Choose payments, orders, catalog, or customers and a destination.

Sample report

Square reportSample data
DatePayment IDGross amountStatusTenderOrder IDTotal moneyState
Oct 29sq-pay-901$145.00COMPLETEDCARD10241,2401,240
Oct 281025$125.50Pending6401025640640
Oct 291031$42.00Refunded2101031210210

Sample numbers, so you can see the shape. Your report uses your accounts.

Works well with Square

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.

Questions

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.

Try Square with sample data first

Build the report first, then add Square when you are ready.

Start free Add data source