Integrating Failed Razorpay Payments to Google Sheets Using Pabbly Connect

Learn how to automatically add failed Razorpay payments to Google Sheets using Pabbly Connect in this step-by-step tutorial. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Introduction to Pabbly Connect for Razorpay and Google Sheets Integration

In this tutorial, we will explore how to use Pabbly Connect to automatically add failed Razorpay payments to Google Sheets. This integration allows you to streamline your payment processing and keep track of failed transactions easily.

With Pabbly Connect, you can automate the process without needing any coding skills. This means anyone can set it up quickly and efficiently, making it an ideal solution for businesses of all sizes.

2. Setting Up Pabbly Connect for Razorpay Integration

To begin, access Pabbly Connect by visiting their website and signing in. Once logged in, create a new workflow by clicking on the ‘Create Workflow’ button. Name your workflow something like ‘Razorpay to Google Sheets’ to keep it organized.

After naming your workflow, you will see two windows: the trigger window and the action window. The trigger window is where you will set up Razorpay as the trigger application and select the event as ‘Payment Failed’. This signifies that whenever a payment fails, it will trigger the action to add details to Google Sheets.

3. Connecting Razorpay to Pabbly Connect

Next, you need to connect Razorpay to Pabbly Connect. In the Razorpay settings, navigate to the webhooks section and add a new webhook. Copy the webhook URL provided by Pabbly Connect and paste it into Razorpay’s webhook URL field. Make sure to select the active event as ‘Payment Failed’ before saving the webhook.

• Go to Razorpay dashboard and click on Settings.
• Select Webhooks and add a new webhook.
• Paste the webhook URL from Pabbly Connect.
• Set the event as Payment Failed.

Once the webhook is created, Pabbly Connect will wait for a response from Razorpay. You can then test this by making a failed payment, which will send the details to Pabbly Connect.

4. Trimming the Amount and Sending Data to Google Sheets

After receiving the payment failure details in Pabbly Connect, the next step is to trim the amount to ensure it reflects accurately in Google Sheets. You will need to add an API by Pabbly in the action window to perform this task.

Set the endpoint URL for the API and map the amount data received from Razorpay. After trimming the amount, you can proceed to the next action, which is to send the details to Google Sheets. Here, you will add Google Sheets as your action app and select the action event as ‘Add New Row’.

5. Finalizing the Integration with Google Sheets

To finalize the connection between Pabbly Connect and Google Sheets, you will need to authorize Pabbly Connect to access your Google Sheets account. Click on the ‘Connect with Google Sheets’ button and choose the appropriate Google account.

Once connected, select the specific Google Sheet you want to use for recording failed payments. You will map the fields in the Google Sheet to the corresponding data received from Razorpay. After mapping all necessary fields, click on ‘Save and Send Test Request’ to ensure the integration works correctly.

Upon successful testing, you will see the details of the failed payment reflected in your Google Sheet, confirming that the integration was successful.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automatically add failed Razorpay payments to Google Sheets. This integration simplifies tracking payment failures and enhances your operational efficiency.

By following the steps outlined, you can easily set up this automation and ensure that your payment records are always up to date. Using Pabbly Connect, you can integrate various applications and streamline your business processes effectively.