How to export Zendesk macros into a spreadsheet

This works beautifully! It also helps if you want to find a specific word occurring in more than one Macro that needs to be changed. I recently had to change voice and tone for a specific term throughout our 500+ macro library and this saved me so much time.

Hi, thanks for the tip how to export macros, it's very useful.

Is there a way to export the JSON file back to Zendesk with some changes? I want to add descriptions to macros and it would be very convenient if I could do it this way. 

Hi Jed - Yes, that API call should still work. However, I clicked through to your account and it looks like you have a different subdomain listed there from the one you indicated in your comment above. 

Is this link, http://xyz.zendesk.com/api/v2/macros.json?per_page=99, still functional? I tried it but it does not work. I'm getting the error message below.

  "error": {
    "title": "No help desk at jedbonillaephan.zendesk.com",
    "message": "There is no help desk configured at this address. This means that the address is available and that you can claim it at http://www.zendesk.com/signup"

Hello Juan,

You can try using sideload instead (if your plan is Enterprise)

/api/v2/macros.json?include=usage_30d&sort_order=asc

Or the standard usage for macros:

/api/v2/macros.json?sort_by=usage_30d&sort_order=asc

You can change asc to desc.

Hope this helps!

Hi There, 

What is the best way to export by usage in the last 30 days; 

I tried

https://(MyCompany).zendesk.com/api/v2/macros.json?per_page=99&sort_by=usage=30d


but was unable to do so

Hey Pradeep, I just checked and they seem to work. Please note you should remove XYZ from the links and put there your ZD subdomain. Sure, you need to be logged in as admin in your ZD. 

These links are not working. I changed the Domain name

XYZ.zendesk.com/api/v2/macros.json?per_page=99 

https://XYZ.zendesk.com/api/v2/macros.json?per_page=99&page=2 

Hey Matthew, the key is that number of macros per an API call/request is limited to max 99 macros. 

So, if you have eg 250 macros, you will have to do the call 3x.
How to do that? Just replacing the last part of the URL "page=2". So you should call it with: page=1, page=2, page=3. Let me know if anything still isn't clear. Best.