How to Add Cancelled Pabbly Subscription Billing Details in Google Sheets

Learn how to integrate Pabbly Subscription Billing with Google Sheets to automatically add cancelled subscription details using Pabbly Subscription Billing. Learn step-by-step how to configure flexible subscription plans, automate billing cycles, and generate detailed revenue reports without coding knowledge.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Subscription Billing for Integration

To integrate Pabbly Subscription Billing with Google Sheets, first, access your Pabbly Subscription Billing account. This platform allows you to manage subscriptions effectively and automate various tasks. If you are new, sign up for a free account to get started.

Once logged in, navigate to the dashboard. Click on the ‘Create Workflow’ button on the right-hand side. Name your workflow, for example, ‘Add Cancelled Pabbly Subscription Billing Details in Google Sheets’. Save this workflow in the folder labeled ‘Pabbly Subscription Billing’ for better organization.

2. Configuring Trigger and Action in Pabbly Connect

In this step, you will set the trigger and action for your integration. The trigger will be Pabbly Subscription Billing, specifically the event of a subscription being cancelled. Select the trigger event as ‘Subscription Cancelled’ from the dropdown menu.

• Choose ‘Pabbly Subscription Billing’ as your trigger application.
• Set the trigger event to ‘Subscription Cancelled’.
• Proceed to select Google Sheets as the action application.

Now, set the action event to ‘Add New Row’ in Google Sheets. This action will allow the details of the cancelled subscriptions to be recorded automatically. After selecting the trigger and action, a webhook URL will be generated. This URL acts as a bridge to connect Pabbly Subscription Billing with Pabbly Connect.

3. Adding the Webhook in Pabbly Subscription Billing

Next, navigate to your Pabbly Subscription Billing dashboard. Go to the ‘Settings’ section and select ‘Webhook’. Click on the ‘Add Webhook’ button to create a new webhook.

• Name your webhook, for example, ‘Latest Cancelled Subscriptions’.
• Paste the webhook URL generated in Pabbly Connect.
• Enable the ‘Subscription Cancel’ option and click ‘Save’.

After saving, you will see a confirmation message indicating that the webhook has been added successfully. This step ensures that every time a subscription is cancelled, the details will be sent to Pabbly Connect.

4. Testing the Integration with Google Sheets

Now that you have set up the webhook, it’s time to test the integration. Go back to Pabbly Subscription Billing and cancel a subscription to see if the details are captured. Click on the three dots next to the subscription and select ‘Cancel Subscription’.

Provide a cancellation reason when prompted. Confirm the cancellation by clicking ‘Cancel Immediately’.

Once the subscription is cancelled, return to Pabbly Connect. You should see a test response indicating that the cancelled subscription details have been received. This confirms that your integration is working correctly.

5. Adding Cancellation Details to Google Sheets

With the integration tested successfully, it’s time to add the cancellation details to Google Sheets. In Pabbly Connect, establish a connection with Google Sheets by clicking on ‘Connect’. Sign in with your Google account and authorize access. using Pabbly Connect

Now, select the Google Sheet you created for this purpose. Use the mapping feature to insert data from the previous step into the respective fields in your Google Sheet, such as first name, last name, email, phone number, and cancellation reason.

Map the first name from the response. Continue mapping the last name, email, and phone number.

After mapping all fields, click on ‘Save and Send Test Request’. Check your Google Sheet to verify that the cancellation details have been added in a new row. This completes the automation process, allowing you to track cancelled subscriptions efficiently.

Conclusion

In this tutorial, we explored how to integrate Pabbly Subscription Billing with Google Sheets to automatically add cancelled subscription details. This integration streamlines your workflow and ensures accurate record-keeping of cancellations, enhancing your subscription management process.