Planned · on the roadmap

Live spreadsheets for Square

Sheets is coming to Square: your payments, payouts and fees as live tables that formulas, pivot tables and charts read directly, without exports.

Tell me when it's ready What works today
  • Spreadsheet formulas
  • Pivot tables and charts
  • Scheduled e-mail reports
Planned reports

What you will build on Square

Each is one formula on live data. These are examples of the syntax: the column names will follow Square's own fields once the integration ships.

=data.payments.sum(amount, date, A2)
Net sales by day. Gross payments minus refunds and fees, per day and per location.
=data.refunds.count(id)/data.payments.count(id)
Refund rate. Refunds against sales, so a rising rate shows before month end.
=data.payments.sum(fee)/data.payments.sum(amount)
Fees as a share of sales. What processing costs you, by card type or month.
=data.payouts.sum(amount, status, "paid")
Payout reconciliation. Each payout next to the payments it contains, ready to match with the bank.
The data

Tables from Square

Payments · Refunds · Payouts · Fees · Customers · Locations

How it will run

Your data stays in Square

You will sign in with your Square account and give Sheets read access. Sheets runs on our servers in the EU and reads your data through Square's API when a sheet opens or refreshes. We plan to list it in the Square App Marketplace.

Want it?

Vote for Sheets for Square

A thumbs up moves Square up the roadmap. Leave your e-mail address too and we write once, when it ships.

We use your details only to answer you. Privacy policy

Payments: also planned

Stripeplanned
payments, payouts and fees
FAQ

Questions

Is Sheets for Square available?

Not yet. Square is on the Sheets roadmap. Give it a thumbs up and leave your e-mail address on this page: we tell you when it is ready, and the votes decide what we build next.

What will Sheets read from Square?

Your payments, payouts and fees, as tables: Payments, Refunds, Payouts, Fees, Customers, and Locations. Each table becomes a data source that formulas, pivot tables and charts read live.

Will Sheets change anything in Square?

It is planned read-only: Sheets reads your Square data and does not change it.

What works today?

Sheets works today with QuickBooks Online, Xero, Shopify, WooCommerce, BigCommerce, HubSpot, FreshBooks, monday.com, and Asana.

Want Sheets for Square?

Requests decide what we build next. We write once, when it is ready.

Tell me when it's ready

85 tools on the integrations page