Start free

Square connector · Sales reports & catalog updates

Read & reportRead & write

See your Square sales by day and location.

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.

  • Review completed payments and orders by date and location
  • Keep your catalog and customer list in a sheet that refreshes
  • Update customers and item names from ChatGPT or Claude
SquareSheetsSheetsData StudioData StudioChatGPTChatGPTClaudeClaude

Start free See what you can change

Updated November 2026

Square reportSample data
Payment dateAmountSource
2026-11-11$48.50Card
2026-11-12$126.00Card
2026-11-12$19.75Cash
Refreshes on your schedule in Google Sheets

Square reporting for payments, orders, catalog and customers

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.

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.

Orders

See orders by creation date with location, state, total, tax, discounts and customer.

Catalog items

Keep a current list of catalog items with name, description, category, version and whether the item was deleted.

Customers

Read the customer directory with name, company, email, phone and when each profile was created or updated.

Report datasets and details

Reports you can build

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

  • Completed payments
  • Orders by creation date
  • Store catalog items
  • Customer directory
What each dataset reports
  • Completed payments

    Payments processed during the selected dates. 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 item totals, taxes, discounts and order fulfillment state.

  • Store catalog items

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

  • Customer directory

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

Go from a sales report to a Square update

Keep customers current

Create a customer profile or update a customer’s contact details. No cards are attached and no payments are taken.

Tidy the catalog

Rename a catalog item or rewrite its description. Variations and prices stay as they are.

You choose who can change what

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.

See every supported change
  • Create a customer
    What this changes

    Creates one new customer profile in Square. Does not attach cards or take payments. Every change is recorded in the Changes history.

  • Update customer contact details
    What this changes

    Updates contact details on an existing Square customer profile. Card profiles and past orders are unchanged. Every change is recorded in the Changes history.

  • Update catalog item name or description
    What this changes

    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.

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

Metrics and dimensions

32 report fields across 4 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send Square data anywhere

Connect Square to ChatGPT or Claude for sales questions and updates

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.

Start with Square

What you need

A Square access token from the seller account you want to report on. Reports cover every location that token can see.

What to know

Catalog changes cover item names and descriptions only; prices, variations and stock are not changed.

How it works

  1. Create your free account, then choose Square in Data sources.

  2. Paste your Square access token. Add Google Analytics or your email tool if you want marketing context.

  3. Choose a report and destination, or allow customer and catalog changes. Set approvals for the changes you want reviewed first.

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

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.

Turn your sales review into the next update.

Start free, add Square and choose how your team reports on sales and updates customers and items.

Start free See setup requirements