How to Connect Stripe to Airtable (2026)

How to connect Stripe to Airtable, step by step

1. 1

   Create an Airtable table with fields: Charge ID (single line), Customer Email (email), Amount (currency), Status (single select), Paid At (date), Product (single line).

2. 2

   In your automation platform, add a Stripe trigger and choose the payment_intent.succeeded event (not charge.created — that fires before the money settles).

3. 3

   Connect Stripe using a restricted API key with read access to Charges and Customers only. Never paste your live secret key.

4. 4

   Add an Airtable 'Create Record' action and map amount_received divided by 100 into Amount — Stripe returns cents, Airtable expects units.

5. 5

   Map the customer email from charges.data[0].billing_details.email, with the customer object email as fallback.

6. 6

   Run one test with a Stripe test-mode payment, confirm the row, then switch the connection to live keys.

7. 7

   Add a second path for payment_intent.payment_failed writing to the same table with Status = Failed, so churn shows up in the same view.

Common mistakes to avoid

• Stripe amounts are in the smallest currency unit — divide by 100 before writing to Airtable.
• Refunds do not update the original row; add a separate charge.refunded path that finds and updates the record.
• Airtable's API rate limit is 5 requests/second per base — batch high-volume stores instead of firing one call per event.

Other tools that can do this

Frequently asked questions