Automate Stripe Customers to Airtable with Pabbly Connect

Learn how to automatically add new Stripe customers to Airtable using Pabbly Connect. Follow this detailed tutorial for seamless integration. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To begin the integration process, first access Pabbly Connect by navigating to Pabbly.com/connect. This platform serves as the central hub for automating workflows between Stripe and Airtable.

If you are a new user, click on the ‘Sign Up’ button to create an account, which takes less than two minutes. Existing users can simply log in. Upon signing up, you will receive 100 free tasks to explore the capabilities of Pabbly Connect.

2. Create a New Workflow in Pabbly Connect

After logging into Pabbly Connect, click on the ‘Create Workflow’ button on the dashboard. This action will prompt you to name your workflow, such as ‘Stripe to Airtable Integration,’ to reflect its purpose.

Once the workflow is created, you will be directed to a new window where you can set up the trigger and action for your integration. The trigger application will be Stripe, and you will select the event ‘New Customer’ to initiate the workflow.

• Click on the ‘Create Workflow’ button.
• Name your workflow appropriately.
• Select Stripe as the trigger application.
• Choose ‘New Customer’ as the trigger event.

After setting up the trigger, you will receive a webhook URL. This URL acts as a bridge connecting Stripe with Pabbly Connect. Copy this URL for the next steps.

3. Set Up Stripe Webhook in Your Account

Now, log into your Stripe account and navigate to the ‘Developers’ section. From there, select ‘Webhooks’ on the left sidebar and click on ‘Add Endpoint’ on the right side.

Paste the webhook URL you copied from Pabbly Connect into the endpoint URL field. Optionally, you can add a description. For the events, select the ‘Customer Created’ event to ensure that every new customer added in Stripe triggers the workflow.

• Navigate to ‘Developers’ in Stripe.
• Select ‘Webhooks’ and click ‘Add Endpoint.’
• Paste the webhook URL from Pabbly Connect.
• Select ‘Customer Created’ as the event.

After adding the endpoint, you will see that your webhook has been successfully created. This setup allows Stripe to communicate with Pabbly Connect whenever a new customer is added.

4. Test the Integration with a New Customer

With the webhook set up, return to Pabbly Connect and perform a test submission. Go back to Stripe and add a new customer by filling in the necessary details like name, email, and billing information.

Once you click on ‘Add Customer,’ this action should trigger the webhook, and you will see the customer data reflected in Pabbly Connect. This data includes the customer ID and email address, confirming that the integration is functioning correctly.

Add a new customer in Stripe. Fill in all required customer details. Click ‘Add Customer’ to trigger the webhook.

After testing, you should see the API response in Pabbly Connect, indicating that the customer information has been successfully received.

5. Store Customer Data in Airtable

Next, you will configure Airtable as the action application in Pabbly Connect. Select Airtable and the action event ‘Create Record’ to store the customer data.

To connect Airtable, you need to log into your Airtable account and retrieve your API key. Paste this key into Pabbly Connect to establish the connection. You will then need to map the fields from Stripe to Airtable, ensuring that each customer detail is accurately recorded.

Select Airtable as the action application. Choose ‘Create Record’ as the action event. Log into Airtable and copy your API key. Map Stripe fields to Airtable fields appropriately.

After mapping, click ‘Save and Send Test Request’ to verify that the customer data is correctly added to your Airtable base. Once confirmed, your integration is complete, successfully automating the addition of new Stripe customers into Airtable.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of adding new Stripe customers to Airtable. By following these detailed steps, you can streamline your workflow and enhance productivity.