How to Add Failed Stripe Payment Details in Google Sheets Using Pabbly Connect

Learn how to integrate Stripe with Google Sheets to capture failed payment details using Pabbly Connect. Step-by-step tutorial included. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Creating a Payment Link in Stripe

To start capturing failed payment details using Pabbly Connect, you first need to create a payment link in Stripe. Begin by logging into your Stripe account and clicking on the ‘More’ option to create a payment link.

Once you are in the payment link section, add a new product. For example, name it ‘Pabbly Connect’ and set the price as $1 for a one-time product. After entering the required details, click on the ‘Create Link’ button to generate your payment link.

2. Setting Up the Webhook in Stripe

After creating the payment link, the next step is to set up a webhook in Stripe to send failed payment notifications to Pabbly Connect. Navigate to the Developer section in your Stripe dashboard and click on ‘Webhooks’.

In the webhook settings, click on ‘Add Endpoint’. Here, you will paste the webhook URL provided by Pabbly Connect. Set the event type to ‘payment_failed’ to ensure you receive notifications whenever a payment fails. Click on the ‘Add Endpoint’ button to save your settings.

3. Configuring Pabbly Connect to Receive Data

Now, it’s time to configure Pabbly Connect to receive the failed payment data from Stripe. Create a new workflow in Pabbly Connect and name it ‘Stripe Failed Payment to Google Sheets’. Select Stripe as the application and choose the trigger event as ‘Payment Failed’.

• Select the webhook URL generated by Pabbly Connect.
• Copy this URL into your Stripe webhook settings.
• Save your configuration and wait for an event.

When a payment fails, Pabbly Connect will receive the data, including payment intent and customer details, which you can then send to Google Sheets.

4. Testing the Failed Payment Integration

To test the integration, you need to simulate a failed payment. Use the test card number provided by Stripe that results in a declined charge. Fill out the payment form using this card and submit it.

After submitting the payment, Pabbly Connect will wait for the webhook event to arrive. Once the event is received, you will see all the payment details, including the failure reason, in the Pabbly Connect workflow.

5. Sending Data to Google Sheets

With the failed payment data captured, the next step is to send this information to Google Sheets. Create a new Google Sheet and set up the columns for customer name, email, amount, and failure code.

In Pabbly Connect, select Google Sheets as the application and choose the action event as ‘Add New Row’. Connect your Google Sheets account and map the data fields from the Stripe payment failure event to the corresponding columns in your Google Sheet.

• Map the customer name and email from the Stripe data.
• Set the amount and failure code appropriately.
• Click on ‘Save and Send Test Request’ to verify the integration.

Once completed, your Google Sheet will automatically update with new failed payment entries every time a payment fails in Stripe.

Conclusion

Integrating Stripe with Google Sheets using Pabbly Connect allows you to efficiently capture and manage failed payment details. By following the steps outlined in this tutorial, you can automate the process of recording these critical payment events into your Google Sheets.