Google Sheets integration for Explore

image avatar

Justine

Posted Apr 28, 2021

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.

4

3

3 comments

Date
    Newest
      image avatar

      Elijah Stownton

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

      0

      image avatar

      Dave Dyson

      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

      0

      image avatar

      CJ Johnson

      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

      0

      Sign in to leave a comment.

      Didn't find what you're looking for?

      New post