How to Add Razorpay Payment Details in Google Sheets Using Pabbly Connect

Learn how to seamlessly integrate Razorpay with Google Sheets using Pabbly Connect to automate payment details entry effortlessly. 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 add Razorpay payment details in Google Sheets, you first need to access Pabbly Connect. Start by signing in to your Pabbly Connect account. If you are a new user, you can sign up for a free trial, which allows you to explore its features.

Once signed in, you will be directed to the Pabbly Connect dashboard where you can create a new workflow. This platform enables the integration of Razorpay with Google Sheets by automating the data transfer process whenever a payment is made.

2. Creating a New Workflow in Pabbly Connect

To create a new workflow, click on the ‘Create Workflow’ button in the top right corner of the dashboard. You will be prompted to name your workflow. For this integration, name it ‘Razorpay Payment Details in Google Sheets’. using Pabbly Connect

• Select a folder to save your workflow.
• Click on the ‘Create’ button to proceed.

After creating the workflow, you will see the trigger and action setup options. The trigger will be Razorpay, and the action will be Google Sheets. This setup allows you to capture payment details automatically.

3. Setting Up Trigger in Pabbly Connect

In this section, you will configure the trigger event in Pabbly Connect. Select Razorpay as your trigger application and choose the event as ‘Payment Captured’. This event will be triggered whenever a new payment is received.

Upon selecting this, Pabbly Connect will provide you with a webhook URL. Copy this URL as you will need to set it up in your Razorpay account. This URL allows Razorpay to communicate with Pabbly Connect and send payment data.

4. Configuring Razorpay Webhook

Next, go to your Razorpay account and navigate to ‘Account Settings’. Under the settings, select ‘Webhooks’ and click on ‘Add New Webhook’. Here, paste the webhook URL you copied from Pabbly Connect.

• Set the active events as ‘Payment Captured’.
• Click on ‘Create Webhook’ to save your settings.

Now, whenever a payment is captured in Razorpay, it will send the details to Pabbly Connect, which will then process this information to be added to Google Sheets.

5. Mapping Data to Google Sheets

After setting up the webhook, return to your Pabbly Connect dashboard. You will need to test the webhook by making a test payment through Razorpay. Once the payment is made, Pabbly Connect will capture the payment details. using Pabbly Connect

Now, set Google Sheets as the action application. Select the action event as ‘Add Row’. You will need to map the data fields from Razorpay to the corresponding columns in Google Sheets. This includes customer name, email, phone number, order ID, product name, and amount.

After mapping the fields, save the action and send a test request. If everything is configured correctly, you will see the payment details added to your Google Sheets automatically.

Conclusion

By following these steps, you can effectively use Pabbly Connect to automate the process of adding Razorpay payment details into Google Sheets. This integration streamlines your workflow and ensures accurate data entry every time a payment is received.