Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start the integration process, you first need to access Pabbly Connect. This powerful integration platform allows you to connect various applications seamlessly. Simply visit the Pabbly website and sign in to your account.

Once logged in, you will be directed to the Pabbly apps page. Here, click on the option for Pabbly Connect to access the dashboard and begin creating your workflow.

2. Creating a Workflow in Pabbly Connect

In this step, you will create a new workflow to automate the process of sending payment details from Razer Pay to Google Sheets using Pabbly Connect. Click on the “Create Workflow” button and assign a name to your workflow, such as “Add E-commerce Payment Details to Google Sheets Automatically”.

  • Click on the plus icon to create a new folder if needed.
  • Select the folder for this workflow, e.g., “Razer Pay Automations”.
  • Once your workflow is named and folder selected, click “Create”.

After creating the workflow, you will be prompted to set up your trigger application. In this case, select Razer Pay as your trigger application and configure it to activate the workflow whenever a new payment is captured.

3. Configuring the Trigger Application

Now that you have selected Razer Pay as your trigger application, you need to specify the trigger event. Choose “Payment Captured” as the event that will initiate the workflow in Pabbly Connect. This means that every successful payment will automatically trigger the workflow.

Next, you will need to connect Razer Pay with Pabbly Connect by using a webhook URL provided in your workflow. This URL acts as a bridge to connect the two applications. Follow these steps to set up the webhook in Razer Pay:

  • Go to Razer Pay settings and navigate to the webhooks section.
  • Add a new webhook by entering the provided URL and selecting the event “Payment Captured”.
  • Save the webhook settings to establish the connection.

Once the webhook is set up, return to your Pabbly Connect workflow to test the connection by making a test payment through Razer Pay.

4. Adding Google Sheets as the Action Application

After successfully capturing the payment details, the next step is to add Google Sheets as the action application in your Pabbly Connect workflow. Select “Google Sheets” as the action application and choose the event “Add New Row”.

Connect your Google Sheets account by clicking on “Sign in with Google”. Choose the account you wish to connect and grant the necessary permissions. After the connection is established, select the specific spreadsheet where you want the payment details to be stored.

  • Map the fields from Razer Pay to the corresponding columns in your Google Sheets.
  • Ensure that fields like Name, Email, Phone, and Product Price are accurately mapped.
  • Save the action settings to finalize the integration.

This setup ensures that every new payment captured will automatically add a new row in your Google Sheets with all relevant details.

5. Testing and Verifying the Integration

With the workflow fully configured, it’s time to test the integration. Make a test payment through Razer Pay to see if the payment details are successfully captured and logged in your Google Sheets via Pabbly Connect.

After processing the test payment, check your Google Sheets to verify that the payment details have been added correctly. You should see fields such as Name, Email, Phone, and Product Price populated with the test data you entered during the payment process.

If everything appears correctly, your integration is successful! You can now automate the process of logging payment details from Razer Pay to Google Sheets without any manual intervention.

Conclusion

In this tutorial, we’ve demonstrated how to integrate Razer Pay with Google Sheets using Pabbly Connect. This powerful automation saves time and ensures accurate record-keeping for your e-commerce payments. By following these steps, you can streamline your payment processes effectively.