Razorpay Google Sheets Integration Using Pabbly Connect

Learn how to integrate Razorpay with Google Sheets using Pabbly Connect. This step-by-step tutorial covers all necessary actions and configurations for seamless automation. This comprehensive guide reveals exactly how to connect your applications and automate repetitive tasks — accessible for professionals of all technical backgrounds.

Watch Step By Step Video Tutorial Below

1. Introduction to Pabbly Connect and Application Overview

In this tutorial, we will use Pabbly Connect to integrate Razorpay with Google Sheets. Razorpay is a payment gateway, while Google Sheets is an online spreadsheet tool. This integration allows you to automatically add payment details from Razorpay to your Google Sheets whenever a new payment is made.

Since Razorpay and Google Sheets do not have a built-in integration, Pabbly Connect will facilitate the data transfer. You do not need any coding skills to set this up, making it accessible for everyone.

2. Setting Up Pabbly Connect for Razorpay Integration

To get started with the integration, first access Pabbly Connect by visiting the Pabbly website. Sign in or create a free account if you haven’t already. Once logged in, navigate to the dashboard to create a new workflow.

• Go to the ‘Workflows’ section and click on ‘Create New Workflow’.
• Name your workflow as ‘Razorpay to Google Sheets’.
• Select Razorpay as the trigger application.

After selecting Razorpay, choose the trigger event as ‘Payment Captured’. This means that the workflow will initiate whenever a new payment is captured in Razorpay. Copy the provided webhook URL, as you will need to paste it into Razorpay’s settings.

3. Configuring Razorpay Webhook for Pabbly Connect

Now, go to your Razorpay account and navigate to the settings to add a new webhook. Paste the webhook URL copied from Pabbly Connect into the designated field. Make sure to select the ‘Payment Captured’ event from the list of active events.

Once you have saved the webhook, return to Pabbly Connect and capture the webhook response. This response will contain the details of the payment made in Razorpay. To test this, make a sample payment using the Razorpay payment page.

• Enter the payment details such as email and amount.
• Complete the payment process.
• Check back in Pabbly Connect to see if the response has been captured.

After the payment is successfully processed, Pabbly Connect should show the payment details captured from Razorpay. Ensure that the amount is correctly displayed as it may sometimes show in a different format.

4. Trimming Amount Data for Google Sheets

In case the amount captured from Razorpay appears in an incorrect format (like 15000 instead of 150), you need to add an action step in Pabbly Connect to trim the amount. This involves using an API to adjust the format of the amount.

Add a new action step and choose the API option. You will need to paste a specific endpoint URL that allows you to trim the amount. Set the parameters to map the incorrect amount captured earlier. The endpoint URL will be provided in the tutorial description for easy access.

Paste the endpoint URL in the designated field. Map the incorrect amount to the parameter. Save and send a test request to confirm successful trimming.

Once the API responds successfully, you will see the amount formatted correctly. Save this action step to proceed with the integration.

5. Adding Payment Data to Google Sheets

The final step involves integrating Google Sheets with Pabbly Connect. Start by adding another action step and select Google Sheets as the application. Choose the action event as ‘Add New Row’ to ensure that every payment captured in Razorpay results in a new entry in your Google Sheets.

Before connecting, open a blank Google Sheet and create headers for the data you want to capture, such as email, amount, payment type, and phone number. After setting up your Google Sheet, return to Pabbly Connect and authenticate your Google account.

Select the correct Google Sheet and worksheet. Map the captured data from Razorpay to the respective fields in Google Sheets. Save and send a test request to verify the integration.

After successfully sending the test request, check your Google Sheet to confirm that the payment details have been added correctly. This completes the integration process, allowing seamless data transfer from Razorpay to Google Sheets through Pabbly Connect.

Conclusion

In this tutorial, we showcased how to integrate Razorpay with Google Sheets using Pabbly Connect. You can now automatically log payment details into your Google Sheets whenever a new payment occurs in Razorpay. This integration enhances your workflow efficiency without requiring any coding skills.