Skip to content
AirtableSquare

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

Triggers in Airtable with steps in Square
When this happens in AirtableThis runs in SquareHow fastStarter
A record is addedCreate a customerWithin 15 minutesTwo steps on the canvas
A record is addedUpdate a customerWithin 15 minutesTwo steps on the canvas
A record is changedCreate a customerWithin 15 minutesTwo steps on the canvas
A record is changedUpdate a customerWithin 15 minutesTwo steps on the canvas

From Square to Airtable

Triggers in Square with steps in Airtable
When this happens in SquareThis runs in AirtableHow fastStarter
A payment landsCreate a recordWithin 5 minutesInstall the starter
A payment landsFind recordsWithin 5 minutesTwo steps on the canvas
A payment landsUpdate a recordWithin 5 minutesTwo steps on the canvas
A new bookingCreate a recordWithin secondsInstall the starter
A new bookingFind recordsWithin secondsTwo steps on the canvas
A new bookingUpdate a recordWithin secondsTwo steps on the canvas
A new customerCreate a recordWithin secondsInstall the starter
A new customerFind recordsWithin secondsTwo steps on the canvas
A new customerUpdate a recordWithin secondsTwo steps on the canvas

Set up the starter

Create a record in Airtable 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 Airtable, for “Create a record”
  4. 4Fill in Airtable: Base ID (From the base’s URL: airtable.com/appXXXX/…)
  5. 5Fill in Airtable: Table (For example Leads)
  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. 7Match Airtable’s fields to the client’s own: Starts, Status, Customer ID, Customers note
  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 Airtable’s “Create a record” step.

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

The values Create a record in Airtable when a new booking in Square sends
Airtable valueFilled 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

The values Create a record in Airtable when a new customer in Square sends
Airtable valueFilled 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

The values Create a record in Airtable when a payment lands in Square sends
Airtable valueFilled 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.