Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Integration

To start automating your Razer Pay transactions, first, access Pabbly Connect by visiting pav.com/connect. This platform is essential for integrating various applications seamlessly.

Once on the homepage, you will see options to either sign in or sign up for free. If you are a new user, click on “Sign up free” to receive 300 tasks every month. Existing users can simply sign in to access their dashboard.

2. Creating a Workflow in Pabbly Connect

After signing in, select Pabbly Connect from the list of applications. Here, you will create a new workflow to automate the process of sending payment details from Razer Pay to Google Sheets.

Click on “Create from scratch” or use the AI workflow builder. For this tutorial, let’s use the AI builder. Enter a prompt such as “When a new order comes in from Razer Pay, add it to Google Sheets.” This will help Pabbly Connect set up the workflow correctly.

  • Select the trigger event as “Payment Captured” from Razer Pay.
  • For Google Sheets, choose the action as “Add a New Row”.

Once the workflow is previewed, click on “Approve and Create” to finalize the setup. You will receive a workflow link indicating that the setup is successful.

3. Setting Up the Trigger in Pabbly Connect

The next step involves setting up a trigger in Pabbly Connect. You will receive a webhook URL that connects Razer Pay to Pabbly Connect. Copy this URL for the next steps.

Log into your Razer Pay account and navigate to the developers section. Under this section, find the option for webhooks. Click on “Add New Webhook” and paste the copied URL.

  • Leave the secret field blank.
  • Select “Payment Captured” as the active event.

Click on “Create Webhook” to save the settings. You will see a confirmation message indicating that the webhook has been saved successfully.

4. Testing the Integration with Razer Pay

With the webhook set up, it’s time to test the integration using Pabbly Connect. Go back to your Razer Pay payment page and make a test payment. Ensure your account is in test mode for this process.

Fill in the dummy details like a test user email and a random phone number. Select a payment method such as net banking, and proceed to make a successful test payment.

  • Enter a test user email, e.g., [email protected].
  • Choose a random bank for the transaction.

After completing the payment, check back in Pabbly Connect to see if the webhook response has been received successfully. You should see the order ID and other payment details.

5. Mapping Data to Google Sheets

Now that you have received the payment details, the next step is to map these details into Google Sheets using Pabbly Connect. Click on “Sign in with Google” to connect your Google account.

Once connected, select the spreadsheet and sheet where you want the data to be added. For example, choose “Order Details” and “Sheet1”.

  • Map the fields such as name, email, phone number, and order ID.
  • Use the slash to map data dynamically from the previous step.

After mapping all required fields, click on “Save and Send Test Request”. You should see a successful response indicating that the data has been added to your Google Sheets.

Conclusion

In this tutorial, we explored how to automate Razer Pay payments into Google Sheets using Pabbly Connect. This integration streamlines your payment management and saves valuable time by eliminating manual data entry.

By following these steps, you can set up a seamless workflow that captures payment details and organizes them in a structured format, enhancing your business efficiency.