This guide shows you how to connect Airtable to Stripe and import customer data directly into your base using the free Data Fetcher extension. You'll learn to set up the Stripe Airtable integration, import customer information, and configure automatic data syncing.
The same method works for importing Stripe subscriptions, invoices, and payment data into Airtable. By connecting these platforms, you can track key metrics like monthly recurring revenue (MRR) and manage customer relationships within Airtable's flexible database structure.
Install Data Fetcher
1. Add Data Fetcher to your base from the Airtable marketplace. This is a free extension that lets you import data from Stripe as well as other apps like Google Sheets, OpenAI and Facebook Ads without needing to write code.
2. After you have added Data Fetcher to your base, create a free Data Fetcher account. Enter a password and click Sign up for free. Alternatively, can also sign up with your Google account.
Connect Airtable to Stripe
Once you've created your Data Fetcher account, you'll see the home screen.
1. Click Create your first request to begin setting up your Stripe integration.
2. On the create request screen, select Stripe from the Application dropdown to access the Stripe Airtable integration options.
3. Under Authorization, click + New Stripe Connection to link your Stripe account. This opens a new browser tab where you'll authorize the connection.
4. Select the Stripe account containing the data you want to import into Airtable, then click Connect. This grants Data Fetcher read-only access to your Stripe data.
4. Return to the Data Fetcher tab. For Endpoint, select List all customers to import your customers from Stripe into Airtable.
5. Name your request "Import Stripe Customers" to identify it easily later, then click Save & Continue.
Configure Import Settings
Before importing your Stripe customers, you can filter the data to meet your specific needs.
Email filtering: Enter a specific email address in the Email input field to import only customers with that email domain or address. Leave this blank to import all customers.
Date filtering: Use the Created dropdown to limit imports to customers created within a specific timeframe. Options include the last 30 days, 90 days, or custom date ranges.
Click Save & Run (or Run) in the bottom right corner to begin importing your Stripe customer data into Airtable.
Map Stripe Data Fields to Airtable
After Data Fetcher connects to your Stripe account, the Response Field Mapping modal opens. This screen determines how Stripe customer fields transfer into your Airtable table. You can choose which fields to import and whether they create new columns or use existing ones.
By default, Data Fetcher selects all available fields from Stripe. Since customer records contain many fields you may not need, we'll customize the selection to focus on essential information.
1. Click Deselect All to clear the current selection and start fresh.
2. Select only the fields you need by checking the boxes next to these specific fields:
- Id → Map to New field and name it "Id"
- Name → Map to Existing field and select "Name"
- Email → Map to New field and name it "Email"
- Created → Map to New field and name it "Created"
Step 3: For the Created field, keep the field type as "Number" since Stripe uses Unix timestamps for date values. You can convert this to a readable date format later using an Airtable formula.
Step 4: Click Save & Run to complete the field mapping and import your customer data.
Data Fetcher will create the new fields in your Airtable table and populate them with your Stripe customer information. Since Stripe limits responses to 100 customers per request, Data Fetcher may need multiple runs to import your complete customer database.
Configure Record Syncing
To keep your Airtable records synchronized with changes in Stripe, you need to specify a unique identifier field.
1. Click Advanced settings to access the sync configuration options.
2. Under "Update Based on Field(s)", select Id. This ensures Data Fetcher can match existing Airtable records with their corresponding Stripe customers, even if you reorder or move records within your table.
3. Click Save to apply the sync settings.
Convert Unix Timestamps to Readable Dates
Stripe stores dates as Unix timestamps (numeric values representing seconds since January 1, 1970). To display these as readable dates in Airtable:
1. Create a new formula field in your table.
2. Use this formula to convert the Created field: DATEADD('1/1/1970',Created,'seconds')
3. Name the field "Created Date" and set the formatting to display dates in your preferred format.
Set Up Automatic Stripe Airtable Integration
Currently, you must manually click Run to import new or updated customer data from Stripe. Data Fetcher's scheduling feature enables automatic imports at regular intervals, keeping your Airtable Stripe integration synchronized without manual intervention.
The scheduling feature requires a paid Data Fetcher plan. Here's how to upgrade and configure automatic syncing for your Airtable Stripe integration:
Upgrade Your Account
1. In your Data Fetcher request, scroll down to the Schedule section and click Upgrade.
2. A new browser tab opens with Data Fetcher's pricing plans. Select the plan that matches your needs and complete the payment process.
Configure Automatic Scheduling
1. Click + Authorize in the Schedule section to grant Data Fetcher permission to run scheduled imports for your Stripe Airtable integration.
2. In the authorization window, select + Add all resources. This prevents authorization issues when you create new bases or workspaces in the future.
3. Click Grant access to complete the authorization.
4. Back in Data Fetcher, you'll see Schedule this request is now enabled. Choose your preferred sync frequency from the dropdown menu to connect Airtable to Stripe automatically. Options include:
- Every 15 minutes (for high-frequency updates)
- Every hour (recommended for most businesses)
- Daily (for less active Stripe accounts)
- Weekly or monthly (for periodic reviews)
5. Click Save to activate the automatic schedule.
Your Stripe customer data will now import automatically according to your chosen schedule. Data Fetcher will check for new customers, updated information, and changes in your Stripe account, then sync these updates to your Airtable base automatically.
Conclusion: Connected Airtable to Stripe Successfully
You've successfully set up the Airtable Stripe integration and configured automatic data synchronization. Your Stripe customer data now flows directly into Airtable, where you can analyze trends, manage relationships, and build custom workflows around your payment information.
The automatic syncing ensures your customer database stays current without manual maintenance, letting you focus on growing your business rather than managing data transfers.
Common Use Cases for Stripe Airtable Integration
This integration works particularly well for:
- Customer support tracking payment history with support tickets to resolve billing issues faster.
- Sales teams converting new customers into upsell opportunities using payment data and follow-up schedules.
- Financial reporting combining Stripe revenue with other business metrics in custom dashboards.
- Marketing campaigns segmenting customers by subscription type or payment amount for targeted outreach.
- Subscription management tracking renewal dates, failed payments, and customer communication in one location.
Advanced Integration Options
For more complex setups, consider importing Stripe subscriptions, invoices, or payment data using the same Data Fetcher approach. You can also link records between different Airtable tables to create comprehensive customer profiles that connect payments to specific products or services.
