Effortlessly create Stripe payment links from your Airtable data, with support for line items and quantities using our Stripe Checkout tool.
To set up Stripe payment links, please follow this guide.
The products you reference must first be processed with the tool.
Missing stripe api key?
Add an Stripe Checkout Project
Products IDs
The Airtable field which contains record IDs of the products.
Products Qty
The Airtable field which contains the quantities of the products. This must be equal with the number of products set in the Products ID field.
Customer Email
The Airtable field which contains email of the customer. The email is added to the payment link for pre-filling the email field on checkout.
Once you are done setting up, you can publish changes and check api response.
If there is nothing wrong with your configuration, you should be able to see a URL similar to the screenshot below:
You can select the url and open it to see the result.
Using the Airtable to Stripe Checkout Project in Airtable Automation
Tables
In this example, we are using Orders and Payments for the automating the process of creating Stripe payment links.
The Orders table is the table used to trigger the Airtable automation. We will set up the trigger to check which records have empty values for payments.
Payments table is used to store the Payment links generated by the Automation. The payments table is linked to the Payments field in the Orders table. The URL will appear in the Orders table via Lookup.
Add the Automation Trigger
In this example, we use the table Orders to trigger the Automation by checking if there are Payments assigned to an order and if an order has a customer.
Condition: “When record matches conditions”
Make sure to refrence ‘Orders’ table, condition → if there is no ‘Payment’ link, this way we will only generate payment URLs for items that do not yet have stripe links.
Fetch the payment link
Click the Add Advanced Logic or Action and choose Run a Script.
The script is inside stripe checkout editor
Copy script to airtable, add recordid variable and test the script
Set the configuration to Payments table. Set the Order field to an Airtable Record ID—this will link to the Orders table. Set the URL to the result of the “Run Script” action so that the Automation will save the Stipe payment link to the URL.
Don’t forget to publish your automation.