Integrating Razorpay with Google Sheets Using Pabbly Connect

Learn how to integrate Razorpay with Google Sheets using Pabbly Connect. This step-by-step tutorial covers everything you need to know for seamless automation. Develop expertise in application integration and learn how to design streamlined automation workflows using proven, simplified approaches.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Razorpay with Google Sheets, you need to access Pabbly Connect. Open your browser and search for Pabbly Connect to reach the landing page where you can sign in or sign up for free.

If you are a new user, click on ‘Sign Up for Free’ to get 100 tasks free every month. Existing users can simply sign in and access their dashboard. From there, click on ‘Create Workflow’ to begin the integration process.

2. Creating a Workflow in Pabbly Connect

Once you are in Pabbly Connect, you can create a new workflow. Name your workflow something descriptive like ‘Failed Razorpay Payment Details in Google Sheets’ and choose the appropriate folder to save it in. Click on ‘Create’ to proceed.

• Name the workflow: Failed Razorpay Payment Details in Google Sheets
• Select folder: Automations

This opens the workflow window where you can set up the trigger and action for your integration. Remember, Pabbly Connect allows you to connect Razorpay and Google Sheets seamlessly.

3. Setting Up the Trigger with Razorpay

The next step involves setting up the trigger application in Pabbly Connect. Select Razorpay as your trigger app and choose the event ‘Payment Failed’. This will initiate the workflow whenever a payment fails.

After selecting the trigger event, Pabbly Connect will provide you with a webhook URL. Copy this URL as it will be used to connect Razorpay with your workflow. Navigate to your Razorpay account, go to the settings, and add a new webhook using the copied URL.

• Select Razorpay as trigger application
• Choose trigger event: Payment Failed
• Copy webhook URL for Razorpay

Make sure to save the webhook settings in Razorpay to establish the connection with Pabbly Connect.

4. Filtering Payments for Specific Products

In this step, we will filter the payments to ensure that only specific product failures are recorded in Google Sheets. Use the ‘Filter by Pabbly’ option in your workflow. Set the conditions to only capture failed payments for your specific product.

For example, set the filter type to ‘equals’ and specify the amount that corresponds to your product. This ensures that only relevant failed payment details are sent to Google Sheets, making your data management easier.

Use Filter by Pabbly to set conditions Set filter type to ‘equals’ Specify the amount for your product

This filtering process ensures that only relevant data is sent to Google Sheets through Pabbly Connect, enhancing your workflow efficiency.

5. Adding Payment Details to Google Sheets

Now that we have the trigger and filter set up, the next step is to add the payment details to Google Sheets. Select Google Sheets as your action application in Pabbly Connect and choose the action event ‘Add New Row’.

You will need to connect your Google Sheets account to Pabbly Connect. After authorization, select the specific spreadsheet and sheet where you want the data to be added. Map the required fields like name, email, phone, payment method, and reason for failure to ensure accurate data transfer.

Select Google Sheets as action application Choose action event: Add New Row Map fields from Razorpay response to Google Sheets

By mapping these fields, you ensure that every failed payment is logged accurately in Google Sheets, providing you with real-time data management through Pabbly Connect.

Conclusion

In this tutorial, we explored how to integrate Razorpay with Google Sheets using Pabbly Connect. This integration allows for automatic logging of failed payments, improving your data management and follow-up processes. With Pabbly Connect, you can streamline your workflows effortlessly.