Recent searches
No recent searches
How to export Zendesk macros into a spreadsheet
Posted Apr 20, 2017
Regarding to this post I decide to make this short tutorial.
1. you need to be logedin as Admin or Agent of your ZD account.
2. open this link XYZ.zendesk.com/api/v2/macros.json?per_page=99 (but change XYZ to your zendesk account name)
2a. If you have more than 100 macros, you should export one more JSON file cause it's up to 100 macros per export. Second file is on this url https://XYZ.zendesk.com/api/v2/macros.json?per_page=99&page=2 (replace XYZ to your ZD name)
3. When json file is loaded, save it on your computer (CTRL+S or CMD+S)
4. Open site: https://json-csv.com/
5. Upload your JSON file
6. Wait a little
7. Click on Download button.
Ta-Da, you have your macros exported in CSV file format.
Hope this helps!
15
71 comments
Eric Nelson
You can do this by using the roles parameter in the url:
https://{subdomain}.
zendesk.com/api/v2/users.json?role[]=agent
.Hope this helps!
1
Steve W
How sad is it that the ability to Export macros had to be developed by an extremely helpful USER and not by Zendesk Dev? Although this way is helpful (Thanks Vlad!), my organization uses close to 900 macros, across multiple departments, this way is extremely cumbersome and way too time consuming, especially since we add and remove macros weekly.
An Export button is ESSENTIAL and takes minimal development time!
Come on Zen Desk, do better!!!
7
Pablo Gonzalez
Hi everyone,
We have a free and open-source app that allows you to export all your Zendesk macros into simple text files. You don't need any scripts or knowledge about the Zendesk API.
You can then make changes to those text files (such as fine and replace) and then bulk import the configuration with a simple command.
This supports macros, triggers, views, fields, and anything in between.
You can check it out here How to export Zendesk macros and bulk import them with Salto’s free app
And here's a video as well on how to do it https://youtu.be/smiolaVsIJU
1
lais
Oh my god! Perfect, thank you so much
0
Ricardo
Is there a way UPLOAD a .json file with macros? (instead of downloading)
0
Peter Hochstrasser
@ricardo:
Using the API, yes.
0
Ricardo
Peter Hochstrasser how exactly I can do that?
0
Noly Maron Unson
Hi Ricardo,
You can utilize the Create Macro endpoint. This way, you can use a JSON format to create your macro.
Hope this helps.
0
Vinicius Henrique da Silva
Thanks
0
Estefania Millan
I struggled with this for a long time, and the API call always required me to get help from engineering. I found this on the Marketplace and was able to get the information I needed: https://www.zendesk.com/marketplace/apps/support/707573/macro-search
It doesn't allow filters, but I processed it in Google Sheets using VLOOKUP vs. the copied list of filtered macros.
0
Estefania Millan
Ticket can be closed, as it's not a support request but rather sharing with the community what worked for me.
0