Google Sheets integration for Explore | The place for Zendesk users to come together and share
Skip to main content
Feedback submitted

Google Sheets integration for Explore

Related products:Analytics
  • April 28, 2021
  • 3 replies
  • 1 view
J

I have multiple data sources where I track analytics for my team. One way I am looking to pull in data is into Google Sheets. Having a Google Sheets integration for Explore data would be great so that I can make sure everything is where I need it.

    3 replies

    CJ95
    • CJ95
    • April 22, 2022

    There's a Google Sheets Connector for Zendesk, made by Google, that does something sort of like this in theory. Unfortunately, it's completely broken for me, and doesn't appear to be actively developed anymore. It could be the sheer amount of data in my account though, or restrictions on my Sheets, maybe you'll have some luck with it. 
    https://workspace.google.com/marketplace/app/zendesk_connector/30725559692

    Dave12
    • Dave12Employee
    • Employee
    • April 23, 2022
    It's possible to use a Google Apps Script to pull data from the Zendesk API into Google Sheets. I wouldn't call it trivial and it can take a while to run if you're pulling a lot of data, but it's definitely possible. Here's the tutorial I used to learn how to do it (it uses a different API, so you'd have to adapt that to pull the Zendesk data you want): API Tutorial For Beginners With Google Sheets & Apps Script
     
    A probably easier way might be to use a third-party connector such as Automate.io
    Elijah13
    • Elijah13
    • August 23, 2023

    You can use Skyvia Data Integration to connect Zendesk and Google Sheets. it is a no-code freemium platform.

    Terms & ConditionsCookie settingsAccessibility statement