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. Step-by-step tutorial included. Explore how to create custom checkout pages, manage multiple pricing tiers, and automate subscription renewals without any development expertise.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Subscription Billing for Integration

To start, access Pabbly Subscription Billing by visiting the official website. If you don’t have an account, you can sign up for free, which allows you to perform numerous tasks each month.

Once signed in, locate the dashboard where you can see various applications. For this integration, we will use Pabbly Subscription Billing alongside Pabbly Connect to automate the process of capturing failed payment details into Google Sheets.

2. Creating a Workflow in Pabbly Connect

Next, we will create a workflow in Pabbly Connect. Click on the ‘Create Workflow’ button and name your workflow, such as ‘Add Pabbly Subscription Billing Failed Payment Details in Google Sheets’. Choose the folder where you want to save this workflow.

• Click on the ‘Create’ button to proceed.
• You will see two boxes: Trigger and Action.
• Set the Trigger application to Pabbly Subscription Billing.

After setting the trigger, select the event type as ‘Payment Failure’. This will be the event that initiates the workflow whenever a payment fails in Pabbly Subscription Billing.

3. Connecting Pabbly Subscription Billing to Pabbly Connect

Now, you need to connect Pabbly Subscription Billing with Pabbly Connect. Copy the webhook URL generated in Pabbly Connect and head over to your Pabbly Subscription Billing settings.

In the settings, locate the Webhook settings and click on ‘Add Webhook’. Fill in the required details such as the webhook name and select the product and plan. Paste the copied webhook URL and select the payment failure option before saving.

• Click on the ‘Save’ button to finalize the webhook setup.
• Go back to Pabbly Connect and click on ‘Recapture Webhook Response’.
• Perform a test payment failure to capture the response.

Once the test payment failure is processed, you will receive a response in Pabbly Connect, confirming that the integration is successful.

4. Setting Up Google Sheets Integration

Next, we will set up the action application, which is Google Sheets. Select Google Sheets as the action application and choose the action event as ‘Add New Row’. This action will allow us to send the failed payment details directly into our Google Sheets.

Connect your Google Sheets account to Pabbly Connect by clicking on ‘Add New Connection’. Sign in with your Google account to grant access.

Select the spreadsheet named ‘PSB Failed Payments’. Choose ‘Sheet1’ for the specific sheet to use. Map the columns with details from the payment failure response.

Make sure to map each detail correctly such as first name, last name, email, amount, plan, state, country, phone, and product name. Once mapped, click on ‘Save and Test’ to verify the integration.

5. Testing and Verifying the Integration

To ensure everything is working correctly, perform another test payment failure. Go to your checkout page and fill in the dummy payment details, ensuring to select the payment failure option.

After submitting the payment, return to your Google Sheets to check if the new failed payment details are recorded. You should see the details like first name, last name, email, and other relevant information populated in the designated columns.

Verify that all details match the failed payment response from Pabbly Subscription Billing. If everything is correct, your integration is successful!

This integration allows you to automatically capture failed payment details from Pabbly Subscription Billing into Google Sheets, streamlining your data management.

Conclusion

By following this guide, you can effectively use Pabbly Subscription Billing to capture failed payment details in Google Sheets through Pabbly Connect. This automation enhances your workflow and saves time by keeping your records updated automatically.