Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start using Pabbly Connect, navigate to pavi.com/connect in your browser. This is the central platform for creating automations between Razer Pay and Google Sheets.

Once on the Pabbly Connect homepage, you will see options to sign in or sign up. If you are a new user, click on “Sign Up Free” to get 100 free tasks each month. Existing users can simply sign in to access their dashboard.

2. Creating a New Workflow in Pabbly Connect

After logging into Pabbly Connect, you will see various Pabbly apps. Click on “Access Now” for Pabbly Connect to reach the dashboard. Here, you can create a new workflow.

Click on the “Create Workflow” button. You will be prompted to choose between the beta and classic versions. Select the beta version for a modern experience. In the workflow creation dialog, name your workflow, such as “Automatically Save Order Details in Google Sheets.” Choose a folder from the dropdown menu, such as Google Sheets, and click the “Create” button.

  • Click on “Create Workflow” button
  • Select the beta version
  • Name your workflow
  • Choose a folder

With your workflow created, you are now ready to set up the trigger and action steps.

3. Setting Up the Trigger with Razer Pay

The next step involves configuring the trigger in Pabbly Connect. Since you want to capture new orders from Razer Pay, select Razer Pay as your trigger app and choose “Payment Captured” as the event.

Click on “Connect” to generate a webhook URL. This URL will be used to link Razer Pay with Pabbly Connect. Copy the webhook URL and head to your Razer Pay account. In the test mode, navigate to “Developers” and then select “Webhooks”.

  • Select “Developers” from Razer Pay
  • Choose “Webhooks”
  • Click on “Add New Webhook”
  • Paste the copied webhook URL

After setting up the webhook, you need to test it by placing a test order on your Razer Pay payment page. This will ensure that the connection is working correctly with Pabbly Connect.

4. Adding an Action Step to Google Sheets

Once you have successfully set up the trigger, the next step is to add an action in Pabbly Connect. Choose Google Sheets as your action application and select “Add a New Row” as the event.

To build this connection, click on “Add a New Connection” and authenticate your Google account. After granting access, select the spreadsheet where you want to store the order details. For example, choose “Order Details” and select “Sheet1” as the target sheet.

  • Select Google Sheets as the action app
  • Choose “Add a New Row” as the event
  • Authenticate your Google account
  • Select the appropriate spreadsheet and sheet

After setting this up, map the fields from the previous step, such as customer name, email, phone number, and order ID, to ensure the data is captured correctly in Google Sheets.

5. Testing the Automation with Pabbly Connect

Now that you have configured both the trigger and action, it’s time to test the automation in Pabbly Connect. Make a test payment using your Razer Pay payment page. Enter dummy details to simulate a real transaction.

Once the payment is processed, check your Google Sheets. You should see a new row populated with the customer’s details and order ID, confirming that the automation is working as intended. This shows how Pabbly Connect seamlessly integrates Razer Pay with Google Sheets.

  • Make a test payment
  • Verify the details in Google Sheets
  • Ensure all information is captured correctly

This successful test confirms that your automation is set up correctly, allowing you to manage orders efficiently.

Conclusion

In this tutorial, we explored how to automate order management by integrating Razer Pay with Google Sheets using Pabbly Connect. By following these steps, you can efficiently capture order details automatically and streamline your e-commerce workflow.