Watch Step By Step Video Tutorial Below






1. Accessing Pabbly Connect for Integration

To automatically save Razorpay payments to Google Sheets, you must first access Pabbly Connect. Start by opening a new tab and typing pabbly.com/connect in the address bar. This action will direct you to the Pabbly Connect landing page.

If you are a new user, click on the “Sign Up for Free” button to create an account. Existing users should click on the “Sign In” button. Pabbly Connect allows you to automate tasks between different applications, making it the perfect choice for integrating Razorpay with Google Sheets.


2. Creating a Workflow in Pabbly Connect

Once you are logged into Pabbly Connect, navigate to the dashboard and click the “Create Workflow” button on the right-hand side. You can use the “Quick Workflow Builder” for ease of use. Type a name for your workflow, such as “Razorpay to Google Sheets”.

  • Click on “Create Using Quick Workflow Builder”.
  • Enter the name of your workflow.
  • Select Razorpay as the trigger application.
  • Choose the event “Payment Captured”.

After setting up the trigger, click on “Approve and Continue”. This will establish the connection between Razorpay and Pabbly Connect, allowing you to capture payment details automatically.


3. Configuring Razorpay Webhook in Pabbly Connect

Next, you need to configure the Razorpay webhook to connect it with Pabbly Connect. Copy the webhook URL provided by Pabbly Connect. Now, go to your Razorpay account and navigate to “Account and Settings” on the left-hand side.

Click on the “Webhooks” option and then select “Add New Webhook”. Paste the copied webhook URL into the provided field and choose the event “Payment Captured”. This will ensure that every time a payment is captured, the details will be sent to Pabbly Connect.


4. Mapping Payment Details to Google Sheets

After setting up the Razorpay webhook, the next step is to connect Google Sheets to Pabbly Connect. Click on the “Connect” button and select “Add New Connection”. Choose “Sign in with Google” to link your Google account.

  • Select the Google Sheet where you want to save the payment details.
  • Map the fields from Razorpay, such as customer name, email, and order ID.
  • Ensure all required fields are correctly mapped for seamless integration.

Click on “Save and Send Test Request” to verify that the integration is working. If successful, the payment details will appear in your designated Google Sheet, confirming that Pabbly Connect is effectively capturing the data.


5. Testing the Integration Workflow

To confirm that the integration between Razorpay and Google Sheets via Pabbly Connect is functioning correctly, perform a test payment. Navigate to the Razorpay payment page and complete a test transaction.

Once the payment is successful, check your Google Sheet to see if the payment details have been recorded. You should see the customer name, email, and order ID populated in the respective columns of your sheet. This confirms that Pabbly Connect is successfully automating the process of saving Razorpay payments to Google Sheets.


Conclusion

In this tutorial, we explored how to automatically save Razorpay payments to Google Sheets using Pabbly Connect. By setting up a simple workflow, you can streamline your payment tracking process and enhance your business efficiency.