Recent searches


No recent searches

How to export Zendesk macros into a spreadsheet



image avatar

Vlad

The Wise One - 2022Community Moderator

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

71 comments

image avatar

Eric Nelson

Zendesk Developer Advocacy

Hey Φάνης,

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


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


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


Oh my god! Perfect, thank you so much

0


Is there a way UPLOAD a .json file with macros? (instead of downloading)

0


@ricardo:
Using the API, yes.

0


Peter Hochstrasser how exactly I can do that?

0


image avatar

Noly Maron Unson

Zendesk Customer Care

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


Thanks 

0


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


Ticket can be closed, as it's not a support request but rather sharing with the community what worked for me.

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post