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
| When this happens in Google Sheets | This runs in Square | How fast | Starter |
|---|---|---|---|
| A row is added | Create a customer | Within 15 minutes | Two steps on the canvas |
| A row is added | Update a customer | Within 15 minutes | Two steps on the canvas |
| A row is changed | Create a customer | Within 15 minutes | Two steps on the canvas |
| A row is changed | Update a customer | Within 15 minutes | Two steps on the canvas |
From Square to Google Sheets
| When this happens in Square | This runs in Google Sheets | How fast | Starter |
|---|---|---|---|
| A payment lands | Add a row | Within 5 minutes | Install the starter |
| A payment lands | Update a row | Within 5 minutes | Two steps on the canvas |
| A new booking | Add a row | Within seconds | Install the starter |
| A new booking | Update a row | Within seconds | Two steps on the canvas |
| A new customer | Add a row | Within seconds | Install the starter |
| A new customer | Update a row | Within seconds | Two steps on the canvas |
Set up the starter
Add a row in Google Sheets when a new booking in Square
- 1Install the starter into the client from Templates → Library. It lands switched off.
- 2Connect the client’s Square, for “A new booking”
- 3Connect the client’s Google Sheets, for “Add a row”
- 4Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>
/edit) - 5Fill in Google Sheets: Sheet (tab) (For example Sheet1)
- 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.
- 7Check the order of Google Sheets’s values, column by column against the client’s columns
- 8Switch it on. Within seconds: Square tells us as it happens.

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
| Google Sheets value | Filled 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
| Google Sheets value | Filled 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
| Google Sheets value | Filled 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.