Skip to content
Google SheetsSquare

Connect Google Sheets and Square

Start a client’s workflow in Google Sheets and act in Square, or the other way round, on the client’s own accounts.

Each app by itself: Google Sheets integration and Square integration, with how to connect it, its scopes and its limits.

What the pair is used for

  • A physio clinic taking appointments in Square can log each new booking to a sheet within seconds, with the start time, status, customer ID and both the customer’s and the seller’s notes.
  • Customers added to the Square directory, at the till, online or through a booking, become rows of first name, last name, email, phone and how they were added.
  • Completed payments give the owner a takings log, one row per payment with the amount, currency, total, status, how it was paid and the customer ID.

Every way Google Sheets and Square join

A workflow starts from a trigger in one app and runs a step in the other, on the client’s accounts. Where the library has a starter for it, it installs that pairing into a client switched off; any other pairing is two steps on the canvas.

From Google Sheets to Square

Triggers in Google Sheets with steps in Square
When this happens in Google SheetsThis runs in SquareHow fastStarter
A row is addedCreate a customerWithin 15 minutesTwo steps on the canvas
A row is addedUpdate a customerWithin 15 minutesTwo steps on the canvas
A row is changedCreate a customerWithin 15 minutesTwo steps on the canvas
A row is changedUpdate a customerWithin 15 minutesTwo steps on the canvas

From Square to Google Sheets

Triggers in Square with steps in Google Sheets
When this happens in SquareThis runs in Google SheetsHow fastStarter
A payment landsAdd a rowWithin 5 minutesInstall the starter
A payment landsUpdate a rowWithin 5 minutesTwo steps on the canvas
A new bookingAdd a rowWithin secondsInstall the starter
A new bookingUpdate a rowWithin secondsTwo steps on the canvas
A new customerAdd a rowWithin secondsInstall the starter
A new customerUpdate a rowWithin secondsTwo steps on the canvas

Set up the starter

Add a row in Google Sheets when a new booking in Square

  1. 1Install the starter into the client from Templates → Library. It lands switched off.
  2. 2Connect the client’s Square, for “A new booking”
  3. 3Connect the client’s Google Sheets, for “Add a row”
  4. 4Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>/edit)
  5. 5Fill in Google Sheets: Sheet (tab) (For example Sheet1)
  6. 6Confirm with the client: The client is on Square Appointments Plus or Premium. On the free Appointments plan, bookings made in Square’s own dashboard or booking site send no event: only bookings made through the API do.
  7. 7Check the order of Google Sheets’s values, column by column against the client’s columns
  8. 8Switch it on. Within seconds: Square tells us as it happens.
The installed workflow on the canvas: Square’s “A new booking” trigger leading to Google Sheets’s “Add a row” step.

What it produces

The Google Sheets step as it runs for an example client, Lakeview Consulting, when Emma Collins asks for a consultation: each value the starter fills in.

Sheet
Lakeview leads
Spreadsheet ID
Lakeview leads
Values
2026-10-21T09:05:00Z · new · 1042 · Kitchen tap leaking under the sink · Kitchen tap leaking under the sink · 1042

Setup notes for this pair

  • Bookings name the customer by ID alone. To put a name in the sheet, add a step that finds the customer by that ID before “Add a row”.
  • Payments are checked every 5 minutes and only at the account’s default location, while bookings and new customers arrive within seconds. Amounts are in cents.

Field mapping, starter by starter

Each value a starter’s step is given, and where it comes from. Words in brackets are filled in when it runs; change any of it after installing.

Add a row for new bookings

Add a row in Google Sheets when a new booking in Square

The values Add a row in Google Sheets when a new booking in Square sends
Google Sheets valueFilled from
Sheet[Google Sheets: Sheet (tab)]
Spreadsheet ID[Google Sheets: Spreadsheet ID]
Values[the start at, from Square] [the status, from Square] [the customer id, from Square] [the customer note, from Square] [the seller note, from Square] [the location id, from Square]

Add a row for new customers

Add a row in Google Sheets when a new customer in Square

The values Add a row in Google Sheets when a new customer in Square sends
Google Sheets valueFilled from
Sheet[Google Sheets: Sheet (tab)]
Spreadsheet ID[Google Sheets: Spreadsheet ID]
Values[the customer’s first name, from Square] [the customer’s name, from Square] [the customer’s email address, from Square] [the customer’s phone number, from Square] [the customer’s creation source, from Square]

Add a row for payments

Add a row in Google Sheets when a payment lands in Square

The values Add a row in Google Sheets when a payment lands in Square sends
Google Sheets valueFilled from
Sheet[Google Sheets: Sheet (tab)]
Spreadsheet ID[Google Sheets: Spreadsheet ID]
Values[the customer’s amount, from Square] [the customer’s currency, from Square] [the customer’s amount, from Square] [the customer’s status, from Square] [the customer’s source type, from Square] [the customer’s customer id, from Square]

Google Sheets and Square and their logos are trademarks of their owners, used here only to say what Thrum works with; no endorsement is implied.

Thrum is cooking.

Get early access and you’ll be among the first in. Early members get a launch perk.