Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Log Sales Data Automatically in Google Sheet (Without Coding)

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start automating your sales tracking, you first need to access Pabbly Connect. Open your browser and go to the Pabbly Connect website. If you are a new user, click on the “Sign Up Free” button to create your account. This will give you 100 free tasks each month, allowing you to explore the platform.

If you already have an account, click on “Sign In”. Once logged in, navigate to the “All Apps” page and select Pabbly Connect. Here, you will find the “Create Workflow” button on the right side of the dashboard.

2. Creating Your Workflow in Pabbly Connect

Upon clicking the “Create Workflow” button in Pabbly Connect, you can choose to create a workflow from scratch or use the AI feature. For this tutorial, select the AI option. Enter a title and use case for your workflow, such as “Capture Razer Pay Payments”.

Describe your workflow to the AI.
Select Razer Pay as your trigger application.
Choose “Payment Captured” as the trigger event.

Once the AI generates the structure of your workflow, click on “Open Workflow” to proceed. You will now set up the integration between Razer Pay and Pabbly Connect.

3. Integrating Razer Pay with Pabbly Connect

In this step, you will integrate Razer Pay as the trigger application in Pabbly Connect. After selecting Razer Pay, click the “Connect” button to receive your webhook URL. This URL will be used to capture payment data.

Next, log into your Razer Pay account. Navigate to “Accounts and Settings” and find the “Webhook” section. Click on the “Add New Webhook” button and paste the webhook URL from Pabbly Connect. Select “Payment Captured” for the active event and click “Create Webhook”.

4. Testing the Integration with a Sample Payment

To test your integration, make a sample purchase on your Razer Pay store. Fill in your personal details and complete the payment. After the transaction, return to Pabbly Connect to check if the webhook response has been captured successfully.

Ensure that the payment details are displayed in the response.
Verify that the transaction data is accurately logged.

If successful, you will see all payment details captured in Pabbly Connect. This confirms that Razer Pay and Pabbly Connect are integrated properly.

5. Adding Google Sheets to Log Transactions

Now that Razer Pay is integrated, the next step is to add Google Sheets as the action application in Pabbly Connect. Click on the “Add Action” button and select Google Sheets. Choose the option to “Add New Row” to log your payment details.

Connect your Google Sheets account by clicking the “Connect” button. If you have an existing connection, select it; otherwise, create a new one. Choose the spreadsheet where you want to log the payment data. Map the fields from Razer Pay to your Google Sheets columns.

Conclusion

This tutorial has guided you through integrating Razer Pay with Google Sheets using Pabbly Connect, enabling automated sales tracking. By following these steps, you can ensure accurate and efficient logging of your transactions, saving time and reducing errors.