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

New Bug? Create a Record in 30 Seconds (Fast Method)

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Integration

To begin integrating Zoho Desk with Google Sheets, first access Pabbly Connect. This platform serves as the central hub for automating your workflows. Start by creating a new workflow in Pabbly Connect.

Once logged in, navigate to the “Create Workflow” option. Name your workflow for easy identification. This initial setup is crucial for capturing the ticket data from Zoho Desk and sending it to Google Sheets.

2. Configuring Zoho Desk with Pabbly Connect

Next, configure Zoho Desk in Pabbly Connect. You need to set up a webhook to automatically capture new ticket data. Go to the “Webhook” option and select “Add Connection” to connect to Zoho Desk.

Log in to your Zoho Desk account.
Copy your account domain from the URL.
Paste it into the Pabbly Connect webhook setup.

After saving, grant necessary permissions for Pabbly Connect to access your Zoho Desk data. This ensures that the integration is secure and reliable.

3. Creating a Ticket in Zoho Desk

Now, create a new ticket in Zoho Desk to test the integration. Input the ticket details such as subject, description, and priority. This step is essential for verifying that Pabbly Connect captures the ticket information correctly.

For example, enter the subject as “Customer Unable to Upgrade Plan” and set the priority to “High”. Once you submit the ticket, check Pabbly Connect for the captured data.

Ensure the ticket ID is recorded.
Verify that all details match the input from Zoho Desk.

This confirmation step is vital to ensure that your integration is functioning as intended.

4. Filtering Data in Pabbly Connect

After capturing the ticket data, the next step in Pabbly Connect is to filter the data. This ensures that only relevant ticket events are processed. In the workflow, add a filter step to check the event type.

Set the filter criteria to only allow events where the type equals “New Ticket Created”. This way, only new tickets will trigger the next steps in your workflow.

With this filter in place, any other events such as adding a contact will be ignored. This specificity helps keep your data organized and relevant.

5. Adding Google Sheets Integration

The final step is to integrate Google Sheets to log the ticket information. In Pabbly Connect, add a new action step and select Google Sheets as the application.

Choose the option to “Add New Row” in your Google Sheets. Connect your Google account and select the spreadsheet where you want to log the data. Ensure you map the ticket details correctly to the appropriate columns in your sheet.

Map the ticket ID to the corresponding column.
Include fields for subject, description, and priority.

Once set up, save your workflow and run a test to ensure that ticket details are logged correctly in Google Sheets.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to integrate Zoho Desk with Google Sheets. This integration streamlines ticket management and automates data logging efficiently. With Pabbly Connect, managing your workflows becomes effortless and effective.