Workflow templateSend Stripe invoices from Airtable orders
Creates, finalizes and sends a Stripe invoice for every Airtable order you mark Invoice, then writes the payment link back to the row so nothing is invoiced twice.
Workflow illustration
01Trigger
ScheduleEvery 15 minutes, read Status Invoice rows in the Airtable base and table ids from setup (Email, Description, Amount (major units), Currency, Invoice Link).
02St
StripeGet or make the Stripe customer by email.
03St
StripeReuse the Stripe invoice whose metadata holds the record id, else create one due in 30 days carrying that id, for the Description, Amount and Currency.
04
Custom stepFinalize it if a draft; send it unless Invoice Link is filled.
05
Custom stepPut the hosted link in Invoice Link; set Status Invoiced.
06
OutputFinish
How it runs
This is the brief Whenever builds from. Change any of it in plain words before you publish.
When
Every 15 minutes, read Status Invoice rows in the Airtable base and table ids from setup (Email, Description, Amount (major units), Currency, Invoice Link).
Then
- Get or make the Stripe customer by email.
- Reuse the Stripe invoice whose metadata holds the record id, else create one due in 30 days carrying that id, for the Description, Amount and Currency.
- Finalize it if a draft; send it unless Invoice Link is filled.
- Put the hosted link in Invoice Link; set Status Invoiced.
Agents should build your automations, not be them
Describe your first workflow in plain words. AI building is free within weekly usage limits; you pay when it runs.
Airtable
Stripe