How to Log Stripe Payments in Airtable and Send Confirmation Emails Using Gmail with Pabbly Connect

Learn how to log Stripe payments in Airtable and send confirmation emails using Gmail with Pabbly Connect. This step-by-step tutorial covers everything you need to know!

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To log Stripe payments in Airtable and send confirmation emails using Gmail, start by accessing Pabbly Connect. Open a new tab and search for ‘Pabbly.com/connect’. This will take you to the Pabbly Connect landing page where you can automate tasks between multiple applications.

Here, you will find options to sign up for free or sign in if you are an existing user. If you are new, click on ‘Sign Up for Free’ to get 100 free tasks every month. After signing in, you will land on the Pabbly app page, where you can select Pabbly Connect to proceed with your automation.

2. Create Your Workflow in Pabbly Connect

After selecting Pabbly Connect, you will be redirected to the dashboard where you can create and manage your workflows. Click on the ‘Workflow’ button and select ‘Workflow Builder’. Choose the new beta builder for a more modern experience.

Assign a name to your workflow, such as ‘Log Stripe Payment in Airtable and Send Confirmation Email Using Gmail’. Next, select a folder to store your workflow and click on the ‘Create’ button to set up your automation.

• Select the trigger app as Stripe.
• Choose the event as New Charge.
• Connect your trigger setup to start the automation.

With these steps, you have successfully set up your workflow in Pabbly Connect.

3. Connect Stripe with Pabbly Connect

The next step involves connecting your Stripe account to Pabbly Connect. You will receive a webhook URL that needs to be pasted into your Stripe account. Log in to Stripe, navigate to the ‘Developers’ section, and select ‘Webhooks’.

Here, add a new endpoint by pasting the webhook URL you copied from Pabbly Connect. Set the event to ‘Charge Succeeded’ to receive notifications whenever a payment is successfully processed.

• Click on ‘Add Endpoint’ and enter the webhook URL.
• Select the event type ‘Charge Succeeded’.
• Save your changes to connect the webhook.

After saving, your webhook will be connected, and Pabbly Connect will be ready to receive data from Stripe.

4. Add Payment Data to Airtable Using Pabbly Connect

Once your Stripe account is connected, you can now add the payment details to Airtable through Pabbly Connect. Set up an action step by selecting Airtable as your app and choosing the event ‘Create Record’.

Connect your Airtable account and provide the necessary access. You will then need to select the base name where the payment details will be stored. Create a new base in Airtable called ‘Stripe Payments’ and set up fields for name, email, address, and amount.

Map the fields in Airtable to the corresponding data from Stripe. Ensure all necessary details are filled correctly. Click on ‘Save and Send Test Request’ to confirm the data is correctly added.

After confirming, you will see the payment details automatically populated in your Airtable base, demonstrating the power of Pabbly Connect for seamless data integration.

5. Send Confirmation Email Using Gmail through Pabbly Connect

To complete the automation, you will send a confirmation email using Gmail. Add another action step in Pabbly Connect and select Gmail as your app, choosing the event ‘Send Email’.

Connect your Gmail account and set up the email details. Provide a sender name, recipient email (mapped from the previous step), subject, and content. Make sure to personalize the email by including the customer’s name and order details.

Set the sender name as ‘Pabbly’. Map recipient email from the Stripe payment data. Enter a subject line like ‘Payment Received – Thank You for Your Purchase’.

After filling in the details, click on ‘Save and Send Test Request’. Upon success, a confirmation email will be sent to the customer, showcasing the efficiency of Pabbly Connect in automating your workflow.

Conclusion

In this tutorial, we explored how to log Stripe payments in Airtable and send confirmation emails using Gmail with Pabbly Connect. By following these steps, you can automate your payment logging and email confirmation process seamlessly, enhancing your operational efficiency.