Integrate Pabbly Subscription Billing with Google Sheets Using Pabbly Connect

Learn how to integrate Pabbly Connect with Google Sheets using Pabbly Connect to automate payment failure records. Follow our detailed tutorial for step-by-step guidance.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To start integrating Pabbly Connect with Google Sheets, first, access your Pabbly Connect dashboard. If you don’t have an account, sign up for free to get started. Once logged in, you can create a new workflow by clicking the ‘Create Workflow’ button on your dashboard.

Give your workflow a name, such as ‘Pabbly Subscription Billing to Google Sheets’. This name will help you identify the workflow later. After naming, click on the ‘Create’ button to proceed, where you will see options to set up the trigger and action for your automation.

2. Choosing the Trigger Application in Pabbly Connect

In this step, you need to select Pabbly Subscription Billing as your trigger application in Pabbly Connect. From the ‘Choose App’ dropdown, search for and select ‘Pabbly Subscription Billing’. Next, select the trigger event as ‘Payment Failure’. This event will initiate the workflow whenever a payment fails.

• Select ‘Pabbly Subscription Billing’ from the app list.
• Choose ‘Payment Failure’ as the trigger event.
• Copy the provided webhook URL for the next step.

This webhook URL will allow Pabbly Subscription Billing to send payment failure data to Pabbly Connect. Ensure you follow the instructions provided in the interface to complete this setup accurately.

3. Configuring Pabbly Subscription Billing for Webhook

Now, navigate to your Pabbly Subscription Billing dashboard. Here, go to the ‘Settings’ option and find the ‘Webhooks’ tab. Click on it and then select the ‘Add Webhook’ button. In the new window, you will need to enter a name for the webhook, such as ‘To Google Sheets’.

• Enter the webhook name.
• Select the relevant product for which you want to track payment failures.
• Paste the copied webhook URL in the appropriate field.

Make sure to check the box for ‘Payment Failure’ under the events section to capture payment failure details. Click ‘Save’ to finalize the webhook configuration. This will link your Pabbly Subscription Billing account with Pabbly Connect, allowing it to send data whenever a payment fails.

4. Testing the Integration with Pabbly Connect

To ensure everything is set up correctly, you need to test the integration. Go back to your Pabbly Subscription Billing dashboard and simulate a payment failure. Fill in the customer details and select the payment failure option. This will trigger the webhook you just set up.

After initiating the test payment failure, return to Pabbly Connect and check if the details of the payment failure have been captured. You should see the response indicating the event type as ‘Payment Failure’ along with customer details and product information.

5. Adding Payment Failure Data to Google Sheets

The final step is to connect Google Sheets to your workflow in Pabbly Connect. Choose Google Sheets as your action application and select the action event as ‘Add New Row’. Click ‘Connect’ to link your Google Sheets account.

Once connected, select the spreadsheet where you want to store the payment failure data. You will need to map the fields from the response you received from the payment failure. For example, map the customer name, email, phone number, product name, amount, and transaction ID to the corresponding columns in your Google Sheet.

Map customer name to the corresponding column. Map email, phone number, product name, amount, and transaction ID appropriately.

After mapping the fields, click on ‘Save and Send Test Request’ to verify that the data is correctly added to your Google Sheets. If successful, you will see a new row with the payment failure details in your specified sheet.

Conclusion

In this tutorial, we demonstrated how to integrate Pabbly Subscription Billing with Google Sheets using Pabbly Connect. By following these steps, you can automate the process of recording payment failures, enhancing your workflow efficiency and productivity. This integration allows you to manage payment issues effectively without manual intervention.