Support & FAQ

Square Checker is a Google Workspace add-on that imports your Square orders into a Google Sheet and keeps it up to date every hour. Sign in with Square, pick your locations, and press play. The free plan imports up to 6,000 rows every 30 days, starting with your recent orders; Pro removes the row limit and imports your full order history.

Open the Google Sheet you want your orders in and choose Extensions → Square Checker → Open, then Sign in with Square. Approve access in the Square tab that opens, then come back to the sidebar, name the connection, choose the locations to include and the tab to write to, and save. Press play on the new connection's card to start importing.

No. You sign in on Square's own page, and Square gives Square Checker read-only access. Square Checker never sees your password and can't change anything in your Square account.

The one you signed in with. If you have signed in with more than one Square account, you choose which one when you add a connection. Each connection uses a single Square account, so to import from another account, add another connection.

Press play on a connection's card. The first import starts straight away, and after that Square Checker checks for new orders about once an hour. Press pause to stop. The card shows when it last synced and how many orders are in your sheet.

No. Imports run in the cloud, whether or not the spreadsheet is open and whether or not your computer is on.

Order ID, Location (Square's location ID), Date, Customer (the customer's name, with their Square customer ID on a second line), Email, Phone, Discount, Tip, Total, Payment, Items, Category (each item's reporting category), SKU, Item totals (what each item brought in after its own discounts), Imported at, Imported by, Type (Sale or Refund), and Refund of. If your items have custom fields your customers fill in, such as a student's name, each question gets its own column too. Category, SKU, Item totals and those answer columns have one line per item, in the same order as Items.

A refund gets its own row, with negative amounts and the order it refunds in Refund of, so totals in the sheet are always net of refunds. An order only appears once it has been paid: open orders with no payment yet, such as an unpaid invoice or a declined card, are added when the payment goes through.

Square Checker finds each column by its header, so you can move columns around and add your own anywhere. If you rename or delete one of its columns, it adds that column back at the end on the next import. Re-importing a tab from scratch clears every row in it, including anything in columns you added.

Click a connection's card to edit it. Hover the card to see three icons: re-import from scratch (clears that tab and imports it again), duplicate, and delete. Deleting a connection keeps the rows it already imported.

The free plan's 6,000 rows for the current 30-day period are used up. Imports pick up again automatically on that date, or you can subscribe to Pro to keep importing now. The allowance is shared by all of your connections.

Every plan imports automatically every hour. The free plan imports up to 6,000 rows in each 30-day period, and it starts with orders from the last 30 days (up to your latest 1,000, and always at least your latest 100). Pro removes the row limit and imports your full order history, however far back your Square account goes. Monthly and annual plans start with a 7-day free trial if you haven't had one before.

In the sidebar, open Settings (the gear icon), choose Manage subscription, then Cancel subscription. You keep Pro until the end of the period you've paid for, or until your trial ends, and you won't be charged again.

Yes: give them the same tab name. Each connection keeps track of its own progress, so point them at different locations or Square accounts. Two connections covering the same location on one tab will import the same orders twice. Re-importing a shared tab from scratch clears it, so every connection on that tab imports again.

Google Apps Script stops any script that runs longer than about 6 minutes. Square Checker saves its progress after every page of orders, so when a run is cut short the next run picks up where it stopped. No orders are lost or written twice.

In your Google account's private per-user storage for Square Checker (Apps Script User Properties). Google encrypts it at rest, and only Square Checker's code running as you can read it. It isn't shared with other add-ons or other users. See the privacy policy for details.

Revoke its access from your Square Dashboard, where Square lists the apps you have connected. Connections using that account will stop importing; to reconnect, delete the connection and add it again. Forgetting an account inside Square Checker removes its saved sign-in from the add-on but does not revoke access at Square.