How to Log Failed Razorpay Payments in Google Sheets Using Pabbly Connect

Learn how to log failed Razorpay payments in Google Sheets using Pabbly Connect. This step-by-step tutorial guides you through the integration process. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To log failed Razorpay payments in Google Sheets, we will use Pabbly Connect as the automation solution. Start by opening a new tab in your browser and navigate to Pabbly.com/connect. This will take you to the Pabbly Connect landing page, where you can either sign in or sign up for a free account.

If you are an existing user, click on the ‘Sign In’ button. For new users, you can create an account by clicking on ‘Sign Up for Free’. Pabbly Connect offers a generous number of tasks free each month, allowing you to explore its capabilities. Once logged in, navigate to the Pabbly Connect dashboard to begin setting up your workflow.

2. Creating a Workflow in Pabbly Connect

Now that you have accessed Pabbly Connect, the next step is to create a workflow. Click on the ‘Create Workflow’ button. You will be prompted to select between the new workflow builder and the classic one. Choose the new workflow builder for a modern experience.

• Click on ‘Create Workflow’ to begin.
• Select ‘New Workflow Builder’.
• Name your workflow as ‘Log Failed Razor Payment in Google Sheets’.

After naming your workflow, click on ‘Create’. This opens the workflow window where you will set the trigger and action for your automation. The trigger indicates what event will start the workflow, while the action specifies what will happen as a result.

3. Configuring the Trigger with Razorpay

In the workflow window, click on the ‘Add Trigger’ button. Search for Razorpay and select it as your trigger application. For the trigger event, choose ‘Payment Failed’. This configuration allows Pabbly Connect to detect when a payment fails in Razorpay.

After selecting the trigger event, click on ‘Connect’. You will be provided with a webhook URL. Copy this URL as it will be used to connect Razorpay with Pabbly Connect. Now, go to your Razorpay dashboard, navigate to the ‘Developers’ section, and select ‘Webhooks’.

• Click on ‘Add Webhook’.
• Paste the copied webhook URL into the Webhook URL field.
• Select ‘Payment Failed’ as the active event and click ‘Create Webhook’.

Once the webhook is created, you will see a message indicating that the webhook was saved successfully. This means that Razorpay is now configured to send payment failure notifications to Pabbly Connect.

4. Testing the Setup for Failed Payments

To ensure that everything is set up correctly, you need to perform a test submission. Go back to your payment page and attempt to make a payment that you know will fail. Use the same payment method and enter the necessary details, ensuring that you trigger a failure.

Once the payment fails, return to Pabbly Connect and check if it captures the webhook response. You should see the details of the failed payment, including the name, email, phone number, and the reason for failure. This confirms that Pabbly Connect is successfully receiving data from Razorpay.

Verify that the captured data includes all necessary fields. Ensure that you see the failure reason and payment method.

With this test, you confirm that the integration is working as expected, setting the stage for logging the payment details into Google Sheets.

5. Logging Failed Payments to Google Sheets

Now, it’s time to log the failed payment details into Google Sheets. In your Pabbly Connect workflow, click on ‘Add New Action Step’ and search for Google Sheets. Select it as your action application and choose the event as ‘Add New Row’.

Click on ‘Connect’ to establish a connection with your Google Sheets account. If you have not created a connection before, you will need to sign in with your Google account and grant the necessary permissions to Pabbly Connect.

Select your spreadsheet from the dropdown list. Choose the appropriate sheet where you want to log the data. Map the fields from Razorpay to the columns in Google Sheets.

After mapping the fields, click on ‘Save and Send Test Request’. This step will log the failed payment details into your specified Google Sheets. You will receive a confirmation message indicating that the data has been successfully added.

Conclusion

In this tutorial, we demonstrated how to log failed Razorpay payments in Google Sheets using Pabbly Connect. By following the steps outlined, you can automate the process of capturing payment failures and storing them in a structured format. This integration not only saves time but also ensures that you have a reliable record of failed transactions for further analysis.