Zendesk Google Sheets Integration Using Pabbly Connect

Learn how to integrate Zendesk with Google Sheets using Pabbly Connect. This detailed tutorial covers every step for seamless data transfer. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start the Zendesk and Google Sheets integration, first access Pabbly Connect. Go to the Pabbly website and hover over the product section to select Connect.

Once on the Pabbly Connect dashboard, you can sign in or create a new account. This process is user-friendly and does not require coding knowledge. After signing in, you will be ready to create your integration workflow.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a workflow to link Zendesk and Google Sheets using Pabbly Connect. Click on the ‘Create New Workflow’ button and name it ‘Zendesk to Google Sheets’.

• Click on ‘Choose App’ and select Zendesk.
• Set the Trigger Event to ‘New Ticket’.
• Copy the Webhook URL generated by Pabbly Connect.

After creating the workflow, you will integrate Zendesk with Pabbly Connect by pasting the copied Webhook URL in the Zendesk settings. This establishes the connection necessary for data transfer.

3. Setting Up Zendesk for Webhook

To complete the integration, log into your Zendesk account. Navigate to the Admin section and select Extensions. Here, you will create an HTTP target for the Webhook.

• Click on ‘Add Target’ and select HTTP Target.
• Name the target ‘New Ticket Webhook’ and paste the Webhook URL.
• Set the method type to POST and content type to JSON.

Once you have configured the target, submit it. This setup allows Zendesk to send ticket data to Pabbly Connect whenever a new ticket is created.

4. Integrating Google Sheets with Pabbly Connect

After establishing the connection with Zendesk, the next step is to integrate Google Sheets. In your workflow on Pabbly Connect, add a new action step and select Google Sheets.

Choose the action event as ‘Add New Row’. Connect to your Google Sheets account and select the appropriate spreadsheet. Map the fields from the Zendesk ticket data to your Google Sheets columns.

After mapping the fields, save the configuration. This will ensure that every new ticket created in Zendesk automatically adds a new row in Google Sheets with all relevant ticket information.

5. Testing the Integration

To ensure the integration works, create a new ticket in Zendesk. Fill in the ticket details and submit it. Check Pabbly Connect to see if it captures the ticket data successfully.

Once the ticket data is captured, verify that the information appears correctly in your Google Sheets. This step confirms that the integration is functioning as intended, allowing seamless data transfer between Zendesk and Google Sheets.

Every time a new ticket is created in Zendesk, a new row will automatically populate in Google Sheets with all ticket details. This automation saves time and improves efficiency.

Conclusion

In this tutorial, we explored how to integrate Zendesk with Google Sheets using Pabbly Connect. This integration automates the process of adding ticket information into spreadsheets, enhancing productivity and data management.

By following these steps, you can set up your own automation and streamline workflows effectively. Pabbly Connect simplifies the process, enabling users to connect different applications without any coding knowledge.