How to Add Pabbly Subscription Billing Failed Payment Details in Google Sheets

Learn how to integrate Pabbly Subscription Billing with Google Sheets to automatically capture failed payment details using Pabbly Subscription Billing. Follow this step-by-step tutorial. Take full control of your subscription business with a comprehensive billing system that handles everything from payment processing to dunning management.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Subscription Billing for Payment Integrations

To begin integrating Pabbly Subscription Billing with Google Sheets, first, access your Pabbly Subscription Billing account. If you don’t have an account, you can easily sign up for free. This platform allows you to manage subscriptions effectively and capture payment details.

Once logged in, navigate to the dashboard where you will find various applications. Here, you will select Pabbly Subscription Billing to set up your integration. Make sure to familiarize yourself with the interface as it will guide you through the integration process.

2. Setting Up Pabbly Connect Workflow

Next, you will create a new workflow using Pabbly Connect. Click on the ‘Create Workflow’ button and name your workflow, such as ‘Add Pabbly Subscription Billing Failed Payment Details in Google Sheets’. This will help you identify the workflow later.

• Select the folder to save your workflow.
• Choose ‘Pabbly Subscription Billing’ as the trigger application.
• Set the trigger event to ‘Payment Failure’.

After setting up the trigger, you will need to connect your Pabbly Subscription Billing account to Pabbly Connect using a webhook URL. This URL will facilitate communication between the two platforms, allowing you to capture failed payment details.

3. Configuring Webhook in Pabbly Subscription Billing

To configure the webhook in Pabbly Subscription Billing, go to the ‘Settings’ section and locate ‘Webhook Settings’. Here, you will add a new webhook by clicking on the ‘Add Webhook’ button.

• Name your webhook (e.g., ‘Testing’).
• Select all products and plans for which you want to capture payment failures.
• Paste the copied webhook URL from Pabbly Connect.

After saving the webhook settings, you can test the integration by simulating a payment failure. This will allow Pabbly Connect to receive the response and process the details accordingly.

4. Capturing and Mapping Failed Payment Details

Once the webhook is configured, you can capture the details of the failed payment. Make a test payment on your checkout page, ensuring to select the payment failure option. This will generate a response in Pabbly Connect with all the relevant payment details.

Now, you need to set up the action step in your workflow. Select ‘Google Sheets’ as the action application and choose the event ‘Add New Row’. This will allow you to send the captured data to your Google Sheets.

Connect your Google Sheets account to Pabbly Connect. Select the spreadsheet and sheet where you want to add the data. Map the fields from the payment response to the corresponding columns in Google Sheets.

After mapping all necessary fields, save your settings and test the workflow. This ensures that all failed payment details are automatically added to your Google Sheets.

5. Finalizing the Integration and Testing

With the action step configured, it’s time to finalize your integration between Pabbly Subscription Billing and Google Sheets. Go back to your Google Sheets and verify that the details from the payment failure are correctly populated.

To ensure everything is working correctly, you can perform another test payment failure. This will help confirm that the integration captures all relevant data and adds it to your Google Sheets seamlessly.

Once you have confirmed that the integration is successful, you can utilize this workflow to automatically track failed payments in your Google Sheets. This saves time and ensures you have accurate records of all payment failures.

Conclusion

Integrating Pabbly Subscription Billing with Google Sheets allows you to automatically capture failed payment details, streamlining your payment management process. By following this tutorial, you can efficiently track payment failures and maintain accurate records.