Connect Airtable and Square
Start a client’s workflow in Airtable and act in Square, or the other way round, on the client’s own accounts.
Each app by itself: Airtable integration and Square integration, with how to connect it, its scopes and its limits.
What the pair is used for
- Each new Square appointment writes a row with its start time, status, customer ID and the customer’s note, giving a salon or clinic an appointments table to plan staff from.
- People added to the Square directory at the till, online or by booking land in Airtable with first name, last name, email and phone.
- Payments completed at the default location can build a takings table, one row per payment with its amount, total, currency and status.
- Rows a team adds to a members or clients table can go the other way into Square’s “Create a customer”, so the person is in the directory at the till.
Every way Airtable 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 Airtable to Square
| When this happens in Airtable | This runs in Square | How fast | Starter |
|---|---|---|---|
| A record is added | Create a customer | Within 15 minutes | Two steps on the canvas |
| A record is added | Update a customer | Within 15 minutes | Two steps on the canvas |
| A record is changed | Create a customer | Within 15 minutes | Two steps on the canvas |
| A record is changed | Update a customer | Within 15 minutes | Two steps on the canvas |
From Square to Airtable
| When this happens in Square | This runs in Airtable | How fast | Starter |
|---|---|---|---|
| A payment lands | Create a record | Within 5 minutes | Install the starter |
| A payment lands | Find records | Within 5 minutes | Two steps on the canvas |
| A payment lands | Update a record | Within 5 minutes | Two steps on the canvas |
| A new booking | Create a record | Within seconds | Install the starter |
| A new booking | Find records | Within seconds | Two steps on the canvas |
| A new booking | Update a record | Within seconds | Two steps on the canvas |
| A new customer | Create a record | Within seconds | Install the starter |
| A new customer | Find records | Within seconds | Two steps on the canvas |
| A new customer | Update a record | Within seconds | Two steps on the canvas |
Set up the starter
Create a record in Airtable 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 Airtable, for “Create a record”
- 4Fill in Airtable: Base ID (From the base’s URL: airtable.com/appXXXX/…)
- 5Fill in Airtable: Table (For example Leads)
- 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.
- 7Match Airtable’s fields to the client’s own: Starts, Status, Customer ID, Customers note
- 8Switch it on. Within seconds: Square tells us as it happens.

What it produces
The Airtable step as it runs for an example client, Lakeview Consulting, when Emma Collins asks for a consultation: each value the starter fills in.
- Base ID
- appXXXXXXXXXXXXXX
- Fields
- {"Customer ID":"{{ trigger.payload.customer_id }}","Customers note":"{{ trigger.payload.customer_note }}","Starts":"{{ trigger.payload.start_at }}","Status":"{{ trigger.payload.status }}"}
- Table
- Leads
Setup notes for this pair
- The booking row holds Square’s customer ID and no name, since the booking event has none. Add a step that looks the customer up by ID before the Airtable step if the table should show who is coming.
- Column names must match the mapping exactly, including “Customers note” without an apostrophe. Amounts land in cents in “Amount in cents” and “Total in cents”; an Airtable formula field can divide them by 100.
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.
Create a record for new bookings
Create a record in Airtable when a new booking in Square
| Airtable value | Filled from |
|---|---|
| Base ID | [Airtable: Base ID] |
| Fields | {"Customer ID":"[the customer id, from Square]","Customers note":"[the customer note, from Square]","Starts":"[the start at, from Square]","Status":"[the status, from Square]"} |
| Table | [Airtable: Table] |
Create a record for new customers
Create a record in Airtable when a new customer in Square
| Airtable value | Filled from |
|---|---|
| Base ID | [Airtable: Base ID] |
| Fields | {"Email":"[the customer’s email address, from Square]","First name":"[the customer’s first name, from Square]","Last name":"[the customer’s name, from Square]","Phone":"[the customer’s phone number, from Square]"} |
| Table | [Airtable: Table] |
Create a record for payments
Create a record in Airtable when a payment lands in Square
| Airtable value | Filled from |
|---|---|
| Base ID | [Airtable: Base ID] |
| Fields | {"Amount in cents":"[the customer’s amount, from Square]","Currency":"[the customer’s currency, from Square]","Status":"[the customer’s status, from Square]","Total in cents":"[the customer’s amount, from Square]"} |
| Table | [Airtable: Table] |
Airtable 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.