Connecting stripe to airtable

Hello

I am working to find a way to connect stripe to Airtable. The use case for this is to show when a customer’s account is paid, past due, or cancelled.

  1. We have a people base in airtable that is each individual user in our system. Name, company name, emails, etc
  2. In stripe we have subscriptions that are paid and automated there. All payments are through this system.
  3. Some stripe subscriptions are an ap or accounting email but pay for 10 users in our people base.

I have tried zapier but it does not have the ability to connect the two in the way that is needed.

I am thinking I need to connect the unique stripe customer Id to the user in airtable. Not sure if this is best done through the stripe meta data. Then I would need a script to connect this meta data to the users in the airtable base.

I use Make to connect my Stripe to Airtable. I have one scenario that I run from a button in Airtable that passes the email from my “user” table to Make. Make then searches for matching customers based on that email: if a match exists it passes the customer ID back to airtable, if not it creates a customer in Stripe and then passes the new customer ID back to Airtable.

I also set up on the Stripe side to fire an Airtable webhook when certain events happen, in your case that might be “subscription is paid”.

1 Like

Make should work as Kamille_Parks mentioned, but if you don’t want to use Make because you’re already familiar with Zapier. You could create a new table for the Zap to send payment records to, and then work within Airtable’s automations to connect to your user tables. So set up the customer id field on your user table and then anytime a payment gets pushed to the payment table, you can run an automation to match them. I do something similar with a Base.

1 Like