Razorpay Payments to Google Sheets in Seconds (No Manual Work!)

Learn how to automate Razorpay payments to Google Sheets in seconds using Pabbly Connect. Follow this step-by-step tutorial for seamless integration. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To begin integrating Razorpay payments with Google Sheets, first access Pabbly Connect by visiting Pabbly.com/connect. This platform enables seamless automation between different applications without any coding required.

Once on the Pabbly Connect page, you will see options to either sign in or sign up for a free account. If you are new to Pabbly Connect, click on ‘Sign Up Free’ to create your account. Existing users can simply click on ‘Sign In’ to access their dashboard.

2. Creating a New Workflow in Pabbly Connect

After signing into Pabbly Connect, navigate to the dashboard and click on the ‘Create Workflow’ button. You will be prompted to choose between the new beta version or the classic version for your workflow.

• Select ‘New Beta’ for the latest features.
• Name your workflow something like ‘Razorpay Payments to Google Sheets’.
• Choose a folder, such as ‘Pabbly Connect’.

Once your workflow is named and the folder is selected, click on the ‘Create’ button. Your new workflow is now ready for configuration.

3. Setting Up the Trigger for Razorpay Payments

The next step in Pabbly Connect is to set up the trigger. This is crucial for automation. Select Razorpay as your trigger application and choose the event ‘Payment Captured’.

Click on the ‘Connect’ button, and Pabbly Connect will provide a webhook URL. Copy this URL as you will need it to link your Razorpay account with Pabbly Connect. Go to your Razorpay dashboard, click on ‘Developers’ and then select ‘Webhooks’ to add a new webhook.

4. Configuring the Webhook in Razorpay

In the Razorpay Webhook section, click on ‘Add New Webhook’. Paste the copied webhook URL from Pabbly Connect into the designated field. Set the secret key as ‘123’ and select the event as ‘Payment Captured’.

• Ensure the webhook is saved successfully to enable data transmission.
• You will see a status indicating that the webhook is waiting for a response.

To test the webhook, make a test payment through Razorpay. This will trigger the webhook and send data back to Pabbly Connect, confirming that the connection is successful.

5. Storing Payment Data in Google Sheets

With your Razorpay account connected to Pabbly Connect, the final step is to store the payment data in Google Sheets. Select Google Sheets as your next application in the workflow and choose the event ‘Add New Row’.

Click on ‘Connect’ and choose to add a new connection. Sign in with your Google account, granting Pabbly Connect the necessary permissions to access your Google Sheets.

Select the spreadsheet you want to use, such as ‘Razorpay Payments’. Map the fields from Razorpay to your Google Sheets, ensuring data flows correctly.

After mapping the required fields, click on ‘Save and Send Test Request’. Check your Google Sheets to verify that a new row has been added with the payment details.

Conclusion

By following these steps, you can seamlessly integrate Razorpay payments with Google Sheets using Pabbly Connect. This automation saves time and eliminates manual data entry, ensuring that your payment records are always up-to-date.