Zendesk Google Sheets Integration
                     log 
/
Ho to Connect Zendek  
to Google heet
 Kevin 
artle
Octoer 4, 2022
8 min read
Here’ a tep  tep guide on ho to connect Zendek to Google heet ithout
reaking a eat.
Zendek o 몭 er a uite of product that enhance cutomer upport, ale, and cutomer 
communication. The Zendek platform i deigned to enure excellent cutomer  
experience in all compan channel, from upport ticket, to ocial media.
While the platform i rout, cutomer ucce and operation team frequentl  
import Zendek data into Google heet. Thi allo them to uild ummarie,  
report, dahoard, and more ith the 몭 exiilit of preadheet. ut man of  hete
uer mut manuall copa ndp ate Zendek data into heet from CV, anitg  
countle hour.
No ou can directl import Zendek data into Google heet uing the three method 
in thi log. Here’ a full alkthrough for each method.
TL;DR: Coe 몭 cient provide the quicket  
method for connecting Zendek to Google
heet
Coe 몭 cient i the eaiet a to connect Zendek to Google heet. You can link  
Zendek to heet in one click uing Coe 몭 cient’ pre uilt connector. Then ou can
tart pulling Zendek data into our Google preadheet intantl.
Coe 몭 cient allo ou to import real time Zendek data into Google heet. It keep
our imported dataet on heet automaticall updated, meaning ou’re ala
orking ith the latet verion of our data.
Coe 몭 cient’ Zendek connector help u cutomer ucce and operation team 
eliminate manual ork, ave time, and treamline procee. Additionall, Coe 몭 cient 
come ith integration for other popular data ource, alloing ou to conolidate
our data from multiple uine tem in one Google preadheet.
Top 3 Method to Connect Zendek to  
Google heet
There are man a to et up a Zendek to Google heet integration. We’ll focu  
on the top method elo.
1. Coe 몭 cient
tart  intalling the Coe 몭 cient addo n in Google heet.
Open a ne Google heet. Click xtenion on the top menu ar, then Addo n from  
the dropdon lit, then Get addo n on the umenu.
On the Google Workpace Marketplace’ earch ar, tpe “Coe 몭 cient,” and click on the  
highlighted app.
Chooe the Google account ou ant to pair ith Coe 몭 cient. Click Allo to give the  
app acce permiion.
A 몭 er completing the intallation, return to Google heet and launch the Coe 몭 cient 
Addo n from the xtenion menu.
Launch Coe 몭 cient, and ou’ll ee the app a a idear on the right hand ide of ou r 
Google preadheet.
No ou’re read to connect Zendek to Google heet. Click Import from… on the 
Coe 몭 cient app idear.
Find Zendek on the lit of data ource. Click the Connect utton.
Allo Coe 몭 cient to connect to our Zendek account  providing our Account URL .
 Click Authorize.
You can import our Zendek data from cratch, alloing ou to create ne 
import
ith Coe 몭 cient’ intuitive pointa ndc lick UI.
You can alo import data uing a aved Vie, hich let ou uild an import from  
an exiting Vie in Zendek.
Then click the Import utton. Your Zendek data ill auto populate on our Google
heet, like the example elo.
et up autor efreh chedule dail, hourl, or eekl to keep our data freh. No  
Coe 몭 cient ill automaticall refreh our Zendek data in our preadheet.
If ou need to update our preadheet data intantl, click the Refreh utton on the 
 header.
nure our team memer have acce to the latet report, ke metric, and KPI 

etting up automatic lack and email alert.
et up a trigger event to puh crucial data and report at prede 몭 ned time, from our  
cutomer atifaction core to upport ticket in the queue.
You can alo naphot data to get pointi n time copie of our oject 몭 edl ithin 
report at peci 몭 c interval.
The hole proce — from connecting Zendek to Google heet, to pulling Zendek 
data into our preadheet — take le than 60 econd.
2. Google’ Data Connector for Zendek
You can alo connect Zendek to Google heet uing Google’ data connector for  
Zendek. The Google connector allo ou to import Zendek ticket (ith cutom  
querie) or metric into our Google preadheet.
Google’ data connector for Zendek allo ou to:
Pull Zendek metric into Google heet
Lit ticket (including an exiting ticket) from Zendek in Google heet  
Refreh querie in Zendek aed on data that exit in our preadheet
Here’ ho to intall Google’ data connector for Zendek. Open our 
Google
preadheet. Navigate to xtenion>Addo n>Get addo n.
Find Data Connector for Zendek uing the Google Marketplace earch ar. elect the 
 addo n and follo the prompt to intall.
Once intalled, go ack to our Google heet and open the addo n from xtenion on 
the top menu.
Tpe in our Zendek udomain to authorize the connection. Then click 
the Authorize utton.
Over 50K pro uilding report ue Coe 몭 cient to 
automate
uine tem data into their Google heet
Learn More
"What an amazing app! Coe 몭 cient make integrating ome of the mot  
complex tem unelieval imple! et up our integration in el  
than a minute."
Yonatan chvimer
No ou can tart importing data from Zendek to Google heet. elect ou r
 preferred operation from the lited option:
Hoever, Google’ connector ha everal limitation. Unlike Coe 몭 cient, Google’  
Zendek connector cannot nc data eteen Zendek and Google heet. o if 
 uo make change to our Zendek data in Google heet, thoe change ill not e 
re 몭 ected in the Zendek platform.
Google’ Zendek connector onl allo for 몭 ve aic operation, limiting hat ou  
can do ith our data. Alo, it doen’t o 몭 er the automation functionalitie that rou t 
data connector app uch a Coe 몭 cient do.
Google’ Zendek connector ill create a lot of manual, tediou ork, leading to
igni 몭 cant ottleneck in our data anali and reporting.
3. Google App cript
Google App cript allo more technical uer to pull Zendek data into Google
heet ith it uilti n cript ditor.
To launch Google App cript, go to xtenion on the top menu of Google heet.
Click App cript from the dropdon. Thi ill launch the Google App cript 
interface. You can rename our project no, or do it later.
Revie Zendek’ API documentation to identif the data ou can pull into Google
heet. You can ue Zendek tool, uch a Potman collection or an API explorer,  
ot  map out hat data i acceile.
Firt, rite code to create our data’ header preadheet column.
Let’ a ou ant to create a heet containing all the uer from the API, 
featuring  Name and mail column.
You can achieve thi  uing the code 
elo: function updateData() {
cont HADR = [‘Name’, ‘mail’]
cont preadheet = preadheetApp.getActive();  
cont heet = preadheet.getheetName(‘heet1’);
heet.clear();
heet.appendRo(HADR);
}
Click the ave icon on the top menu. Then click 
Run.
Click Revie permiion and follo the prompt. The xecution log ill ho the
tatu of our deploed code.
Go ack to our Google preadheet. It ill ho Name and mail a our ne column 
header.
Next, ou’ll need to rite an authentication code to hit the API “readData.”
Find the ection on authentication ithin the Zendek API documentation. You’ll ant  
to reference Node.j or Javacript (J) documentation ince App cript code i ritten 
 in J.
Write code that perform an OAuth authentication proce or ue a peronal ace  
token. Ue the code elo a a ne function (elo the “updateData” function e 
created).
function readData() {
cont PRONAL_ACC_TOKN = “94e3c3f9 5704 8d2 d44 
02810097879”;  cont API_URL = “http://app.aana.com/api/1.0”;
cont DATA_NDPOINT = “/uer?opt_ 몭 eld=name,email&orkpace=38823”; 
 cont repone = UrlFetchApp.fetch(API_URL + DATA_NDPOINT, {
header: {
“Authorization”: “earer ” + PRONAL_ACC_TOKN
}
});
cont content = JON.pare(repone.getContentText()); 
 conole.log(content);
}
ave and run the “readData” function.
No let’ connect “readData” to “updateData.”
In thi example, e ant to create a ne ro of data for ever reult from “readData”  
uing the function elo:
Run our “updateData” function. Check our Google heet to ee the updated data. If
our function didn’t ork, conider uing conole.log() tatement for deugging.
In term of connecting Zendek to Google heet, technical uer can rite code in  
App cript a a topg ap meaure. ut deugging and maintaining the code i tediou, 
timec onuming, and o 몭 en frutrating.
That’ h non technical and technical uer hould leverage pre uilt data connector  
app, uch a Coe 몭 cient. You don’t have to orr aout an ackend maintenance  
or technical iue — that’ all taken o 몭  our plate. Focu intead on analzing and  
viualizing data in Google heet.
Connect Zendek to Google heet: 
What’  the et Method for Your 
Team
There are a numer of a to connect Zendek to Google heet. Coe 몭 cient and  
Google’ data connector allo ou pull Zendek data into Google heet ithout  
coding. More technical uer alo have the option of uing Google App cript.
ut onl Coe 몭 cient o 몭 er the peed and reliailit that team need to integrate  
Zendek data into their Google heet ork 몭 o. Tr Coe몭c ient for free right no to
tart pulling Zendek data into Google heet intantl.
Related Article
Ho to Import Live Data into Google 
heet
Ho to Connect hopif to Google 
heet
Ho to Connect aleforce to Google 
heet
Wait, there' 
Connect mano re!tem to Google heet in jut 
econd.
Get tarted Free
50,000+ uer on  
Google 
Marketplace
Truted  thouand 
of companie
©2022 Coe 몭
Integration  cient
alefo
rce Hu
pot
Google 
Analtic  Looker
Taleau
More 
Integration  
Product
Overvie
 Pricin
g
Data ecurit  
Cutomer torie
olv 
Je
it 
Cat
or 
Ao
ut
Compan
 Car
eer
log
Privac 
Polic  Term