How to Log Payments in Google Sheets from Razorpay Orders Using Pabbly Connect

Learn how to log payments in Google Sheets from Razorpay orders using Pabbly Connect. This step-by-step guide covers all necessary integrations and actions. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Access Pabbly Connect for Integration

To log payments in Google Sheets from Razorpay orders, you need to access Pabbly Connect. Start by visiting Pabbly.com/connect in your web browser. This platform serves as the automation solution connecting your payment gateway with Google Sheets.

Once on the Pabbly Connect homepage, you can either sign in if you are an existing user or sign up for a free account. New users can explore the service with 100 free tasks every month, while existing users can quickly access their dashboards.

2. Creating a Workflow in Pabbly Connect

After signing in, click on the ‘Create Workflow’ button in Pabbly Connect. This action allows you to set up the automation process needed to log payments from Razorpay into Google Sheets. Choose the classic version for a familiar interface. using Pabbly Connect

• Select a name for your workflow, such as ‘Log Payments in Google Sheets from Razorpay Orders’.
• Choose a folder to save your workflow, like ‘Google Sheets’.

Once you have set the name and folder, click on the ‘Create’ button. This initializes your workflow, where you will define triggers and actions necessary for the automation.

3. Setting Up the Trigger with Razorpay

In this step, you will set Razorpay as the trigger application in your Pabbly Connect workflow. Select ‘Razorpay’ as the trigger application and choose ‘Payment Captured’ as the trigger event. This configuration will allow Pabbly Connect to listen for new payment events.

After selecting the trigger, you will be provided with a webhook URL. Copy this URL to set up the webhook in your Razorpay account. Navigate to the Razorpay dashboard, click on the ‘Developers’ section, and select ‘Webhooks’.

• Click on ‘Add a New Webhook’.
• Paste the copied webhook URL and leave the secret field blank.
• Select the event as ‘Payment Captured’ and click ‘Create Webhook’.

Now, your Razorpay account is successfully connected to Pabbly Connect, and it’s ready to send payment data to your workflow.

4. Connecting Google Sheets as the Action Application

With the trigger set, the next step is to connect Google Sheets as the action application in your Pabbly Connect workflow. Select ‘Google Sheets’ and choose the action event as ‘Add a New Row’. This action will enable you to log the payment details received from Razorpay.

To connect Google Sheets, click on ‘Connect’ and then choose to add a new connection. Sign in with your Google account and grant access to Pabbly Connect for managing your spreadsheets.

Select the spreadsheet where you want to log the payments (e.g., ‘Razorpay Orders’). Choose the specific sheet (e.g., ‘Sheet1’).

Now, map the fields from Razorpay to Google Sheets, entering the customer name, email, phone number, and product purchased. This dynamic mapping ensures that every new payment is logged accurately in your Google Sheets.

5. Testing the Automation

To ensure that your automation works, it’s essential to test the entire workflow. Make a test payment through your Razorpay payment page. Use the pre-filled details and select your payment method, such as UPI.

After successfully making the payment, return to Pabbly Connect to check for the webhook response. You should see the payment details captured from Razorpay, confirming that the trigger is working correctly.

Verify that the payment details are logged as a new row in your Google Sheets. Ensure all fields are populated with the correct data from Razorpay.

Once verified, your automation is successfully set up! You can now log payments automatically in Google Sheets from Razorpay orders using Pabbly Connect.

Conclusion

In this tutorial, we explored how to log payments in Google Sheets from Razorpay orders using Pabbly Connect. By setting up triggers and actions, we automated the process of capturing payment details seamlessly. This integration enhances efficiency and accuracy in managing payment records.