Skip to content
Airtable

Connect Airtable and Stripe

Start a client’s workflow in Airtable and act in Stripe, or the other way round, on the client’s own accounts.

Each app by itself: Airtable integration and Stripe integration, with how to connect it, its scopes and its limits.

What the pair is used for

  • Each Checkout or payment link can add a row to an Airtable payments ledger with the payer’s name, email, phone and the amount, and each paid invoice adds one with the amount paid and its currency.
  • Declined invoice payments can fill a table to chase from, carrying the amount due and the customer’s name, email and phone.
  • From the base, a row entering a view such as Ready to invoice can run Stripe’s “Send an invoice” for the invoice ID it holds, or “Make a payment link” for one price, the link then going out in a message step.

Every way Airtable and Stripe 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 Stripe

Triggers in Airtable with steps in Stripe
When this happens in AirtableThis runs in StripeHow fastStarter
A record is addedCreate a customerWithin 15 minutesTwo steps on the canvas
A record is addedMake a payment linkWithin 15 minutesTwo steps on the canvas
A record is addedSend an invoiceWithin 15 minutesTwo steps on the canvas
A record is changedCreate a customerWithin 15 minutesTwo steps on the canvas
A record is changedMake a payment linkWithin 15 minutesTwo steps on the canvas
A record is changedSend an invoiceWithin 15 minutesTwo steps on the canvas

From Stripe to Airtable

Triggers in Stripe with steps in Airtable
When this happens in StripeThis runs in AirtableHow fastStarter
A customer pays (checkout or payment link)Create a recordWithin secondsInstall the starter
A customer pays (checkout or payment link)Find recordsWithin secondsTwo steps on the canvas
A customer pays (checkout or payment link)Update a recordWithin secondsTwo steps on the canvas
An invoice is paidCreate a recordWithin secondsInstall the starter
An invoice is paidFind recordsWithin secondsTwo steps on the canvas
An invoice is paidUpdate a recordWithin secondsTwo steps on the canvas
A payment failsCreate a recordWithin secondsInstall the starter
A payment failsFind recordsWithin secondsTwo steps on the canvas
A payment failsUpdate a recordWithin secondsTwo steps on the canvas

Set up the starter

Create a record in Airtable when a customer pays (checkout or payment link) in Stripe

  1. 1Install the starter into the client from Templates → Library. It lands switched off.
  2. 2Connect the client’s Stripe, for “A customer pays (checkout or payment link)”
  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. 6Match Airtable’s fields to the client’s own: Their email, Their name, Their phone, Amount in cents
  7. 7Switch it on. Within seconds: Stripe tells us as it happens.
The installed workflow on the canvas: Stripe’s “A customer pays (checkout or payment link)” 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
{"Amount in cents":"{{ trigger.payload.amount_total }}","Their email":"{{ trigger.payload.customer_details.email }}","Their name":"{{ trigger.payload.customer_details.name }}","Their phone":"{{ trigger.payload.customer_details.phone }}"}
Table
Leads

Setup notes for this pair

  • Each starter writes its own set of columns. Checkout rows have no currency column, invoice rows have “Amount paid in cents” and “Currency”, and failed payments write “Amount due in cents”. Create them with those names or rename them in the step.
  • Smart Retries can fire “A payment fails” again for the same invoice, adding a second row. Airtable’s “Find records” can check for one first.
  • Stripe refuses to send a draft invoice or one already paid, so point the invoice step at finalized invoices.

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 checkout payments

Create a record in Airtable when a customer pays (checkout or payment link) in Stripe

The values Create a record in Airtable when a customer pays (checkout or payment link) in Stripe sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Amount in cents":"[the customer’s amount total, from Stripe]","Their email":"[the customer’s email, from Stripe]","Their name":"[the customer’s name, from Stripe]","Their phone":"[the customer’s phone, from Stripe]"}
Table[Airtable: Table]

Create a record for paid invoices

Create a record in Airtable when an invoice is paid in Stripe

The values Create a record in Airtable when an invoice is paid in Stripe sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Amount paid in cents":"[the customer’s amount paid, from Stripe]","Currency":"[the customer’s currency, from Stripe]","Their email":"[the customer’s customer email, from Stripe]","Their name":"[the customer’s name, from Stripe]"}
Table[Airtable: Table]

Create a record for failed payments

Create a record in Airtable when a payment fails in Stripe

The values Create a record in Airtable when a payment fails in Stripe sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Amount due in cents":"[the customer’s amount due, from Stripe]","Their email":"[the customer’s customer email, from Stripe]","Their name":"[the customer’s name, from Stripe]","Their phone":"[the customer’s customer phone, from Stripe]"}
Table[Airtable: Table]

Airtable and Stripe 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.