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, then click Import Now whenever you want fresh orders. On the Pro plan you can also flip on Continuous import to keep fetching automatically.

Open the sidebar from Extensions → Square Checker. On the Connections screen, click + Add Connection. Give it a name, paste your Square Application ID, Access Token, and Location ID, pick a target sheet 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.

Click Import Now on the connection's card. The button shows Importing… while it runs and then briefly flashes N orders imported before fading back. The new orders appear in your target sheet when it finishes. To have imports run continuously without you having to come back, flip on the Continuous import toggle below the Import Now button (Pro feature).

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.

Import Now kicks off a single one-time import. Free for everyone; use it whenever you want fresh orders. Continuous import (Pro) is a toggle that keeps importing in the background, so you don't have to come back and click Import Now. Both run the exact same import; the toggle just keeps it firing on its own.

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

Anyone can click Import Now whenever they want fresh data. Pro lifts the per-click action and keeps imports happening automatically, with no need to keep coming back. 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.

Yes. Square Checker skips rows whose Order ID already exists, so multiple connections (or multiple duplicates) can safely target the same sheet without producing 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.

Stuck-import recovery kicked in after 10 consecutive runs failed to make progress (usually because a single page is too large to fetch within the time budget). Click Reset import state to clear the halt and try again at full page size. If the same connection keeps getting stuck, narrow its date range with the Import From field.

In your spreadsheet's Document Properties, scoped to Square Checker. It's encrypted at rest by Google and only readable by Square Checker code running against this spreadsheet. It isn't shared with other add-ons or other spreadsheets.