<svg viewBox='0 0 48 48' xmlns='http://www.w3.org/2000/svg' role='img' aria-label='Stripe glyph'><rect x='4' y='11' width='40' height='26' rx='5' fill='none' stroke='currentColor' stroke-width='3'/><path d='M4 20h40' fill='none' stroke='currentColor' stroke-width='3'/><rect x='11' y='27' width='13' height='4' rx='2' fill='currentColor'/></svg>
<svg viewBox='0 0 48 48' xmlns='http://www.w3.org/2000/svg' role='img' aria-label='Airtable glyph'><rect x='5' y='9' width='38' height='30' rx='4' fill='none' stroke='currentColor' stroke-width='3'/><path d='M5 20h38M19 20v19M31 20v19' fill='none' stroke='currentColor' stroke-width='3'/><rect x='19' y='20' width='12' height='9' fill='currentColor'/></svg>
Add every Stripe charge to an Airtable revenue base
Each successful payment becomes a row with the customer, the decimal amount, the currency and the invoice ID, ready to total at the end of the month.
Trigger: Payment succeeded
Action: Create a record
About 8 minutes to set up
How this flow works
Syncline watches Stripe for Payment succeeded. When that happens it runs Create a record in Airtable with the fields you mapped.
- Connect Stripe with read scopes and pick the payment succeeded event.
- Connect the base and choose the table that holds revenue rows.
- Map the amount onto a numeric field and set the invoice ID as the match key.
- Push a test charge through, check the row and the arithmetic, then connect live.
Field mapping
| From Stripe | To Airtable | Note |
|---|---|---|
| Customer email | Name | The address is the primary field, so a base can be grouped by customer without a lookup table. |
| Amount | Amount | Minor units are converted before the write, so a 4900 charge stores 49.00 with your precision setting respected. |
| Status | Status | Succeeded, pending and refunded map onto select options, which keeps a monthly total honest. |
| Invoice ID | Record ID | The flow looks for a row already holding this invoice reference and updates it, which stops a retried event doubling the month. |
Why teams run it
- Revenue reporting without exporting a Stripe CSV
- Rows can carry your own notes and cost columns
- Retried events update a row instead of adding one
Who uses it
A small business owner who models margins in Airtable and cannot do it from the Stripe dashboard.
About the two apps
<svg viewBox='0 0 48 48' xmlns='http://www.w3.org/2000/svg' role='img' aria-label='Stripe glyph'><rect x='4' y='11' width='40' height='26' rx='5' fill='none' stroke='currentColor' stroke-width='3'/><path d='M4 20h40' fill='none' stroke='currentColor' stroke-width='3'/><rect x='11' y='27' width='13' height='4' rx='2' fill='currentColor'/></svg>
Stripe
Stripe knows the moment money arrives, fails or goes back out. Syncline turns each of those events into something your team can see and act on within a couple of minutes.
<svg viewBox='0 0 48 48' xmlns='http://www.w3.org/2000/svg' role='img' aria-label='Airtable glyph'><rect x='5' y='9' width='38' height='30' rx='4' fill='none' stroke='currentColor' stroke-width='3'/><path d='M5 20h38M19 20v19M31 20v19' fill='none' stroke='currentColor' stroke-width='3'/><rect x='19' y='20' width='12' height='9' fill='currentColor'/></svg>
Airtable
Airtable is where teams build the tracker no off-the-shelf tool provides. Syncline keeps that base fed from your other apps and sends its rows onward when something changes.
Questions
Will a refund correct the row?
Add a second flow on the refund trigger pointed at the same match key. It updates the existing row rather than adding a negative one, unless you prefer both.
How far back can I load history?
New charges flow automatically. For the past, export from Stripe once and import it into the base, then let the flow keep it going from that day.
Related combinations
Connect Stripe and Airtable
Set it up once and let it run. The free plan covers 100 tasks a month.
Start free