Support & FAQ

Square Checker is a Google Workspace add-on that imports your Square orders into a Google Sheet. Configure a connection once with your Square credentials, turn on Continuous import, and it keeps that sheet current on its own. The free plan covers 6,000 rows a month; Pro removes that limit and imports your full order history.

Open Square Checker from Extensions → Square Checker; the first time, choose Set up and it creates a spreadsheet called Square Checker imports and opens it. In that file, open the sidebar and click + Add Connection. Give it a name, paste your Square Application ID, Access Token, and Location ID, choose a sheet name for its tab and a starting date, then Save.

Sign in to the Square Developer Dashboard (developer.squareup.com), open or create an application, and copy the Application ID and Access token from the Production tab. Your Location ID is on the Locations tab: a 13-character code next to each location's name.

Live imports real orders from your Square account. Sandbox imports from Square's test environment; use it to try things out without touching production data. The two have separate credentials in the Square Developer Dashboard.

It's the earliest order date Square Checker will fetch. Orders before this date are ignored. After the first run, each subsequent import resumes from the most recent order already in the sheet, so this field only matters for the very first import.

Flip on the Continuous import toggle on the connection's card. The first import starts straight away, and after that Square Checker keeps the tab current on its own, about once an hour. The card's status line shows what it has synced through and when the next sync is due.

Order ID, Location, Date, Customer, Discount, Tip, Total, Payment, Items, Imported At, and Imported By. Square Checker matches columns by header name (case-insensitive), so you can reorder them or insert your own columns in between that won't be touched.

Click anywhere on a connection's card to edit it. To delete, hover the card and click the trash icon in the top-right corner. Hovering also reveals a Duplicate icon next to it.

No. Turn on Continuous import once and that is the whole setup. Square Checker imports new orders roughly hourly, in the cloud, and the card tells you what it has synced through. If you ever need to start over, hover the card and click the circular arrow, which clears that tab and re-imports it from scratch.

No. Continuous imports run in the cloud, whether or not the spreadsheet is open and whether or not your browser is running.

Continuous import itself is free, so the sheet stays current either way. Pro raises two limits. The free plan imports up to 6,000 rows a month, and it starts you off with your most recent 1,000 orders rather than your whole history. Pro removes the monthly row limit and backfills everything from before you installed, however far back your Square account goes. Subscribe via the banner at the bottom of the sidebar.

Inside the add-on, click the subscription banner at the bottom of the sidebar and choose Manage. From there you can cancel; your access ends immediately and Continuous import toggles flip off on the next sync.

Each connection writes to its own tab by default (you choose the sheet name when you create it). If you give two connections the same sheet name they share a tab, and Square Checker still skips rows whose Order ID already exists, so you won't get duplicate rows.

Google Apps Script terminates any script that runs longer than ~6 minutes. Square Checker writes orders to the sheet page-by-page as it fetches them, so when a run gets cut short the next run resumes from the most recent order already in the sheet. No work is lost.

In your Google account's private per-user storage (Apps Script User Properties), scoped to Square Checker. It's encrypted at rest by Google and only readable by Square Checker's code running as you. It isn't shared with other add-ons or other users.