Copy Square sales into Google Sheets automatically

Short answer: Use a free Google Apps Script that copies your Square payments, card and cash, into a Google Sheet every hour, ready for totals and bookkeeping. It runs in your own Google account; nothing is sent to us. Setup takes 3 steps: Add your key; Paste the script; Run it.

How to set it up

1. Add your key. In the Apps Script editor, open Project Settings and add the Script property SQUARE_TOKEN. In the Square Developer Dashboard, create an app, open Credentials and copy the Production access token. Keys stay in the script, never in the sheet.
2. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a Square menu appears.
3. Run it. Choose Square, then Copy new sales. The Sales tab fills in with the date, payment ID, amount, currency, status, how it was paid, any note and the receipt link, for the last 90 days. Choose Copy new sales every hour to keep it up to date.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• Each payment is added once, matched on its payment ID.
• Only payments are copied, not the items in each sale.
• The access token can read your Square account, so keep it to yourself.

Questions

What does this script do?

It is a free Google Apps Script that copies your Square payments, card and cash, into a Google Sheet every hour, ready for totals and bookkeeping.

How do I set it up?

In 3 steps: 1. Add your key; 2. Paste the script; 3. Run it. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want it wired into QuickBooks, your CRM or your payment system? Send us a short brief.