---
title: "Parsing JSON in Google Sheets with Zendesk and Google Script"
author: "Sourabh Choraria"
date: 2020-02-06T00:50:27+00:00
canonical_url: https://pulse.appsscript.info/p/2020/02/parsing-json-in-google-sheets-with-zendesk-and-google-script/
markdown_url: https://pulse.appsscript.info/p/2020/02/parsing-json-in-google-sheets-with-zendesk-and-google-script.md
categories:
  - "Sheets"
  - "Solutions"
tags:
  - "@LanceCo"
  - "lanceconzett"
  - "Medium"
featured_image: https://pulse.appsscript.info/files/2020/02/1frUYc8q85xa5j4QbRGg0wQ.png
description: "For the most part, using ImportJSON works well—it’s a low effort way of pulling data from any API’s GET endpoint and storing that data in a sheet for further parsing and filtering. But, there was..."
---

# Parsing JSON in Google Sheets with Zendesk and Google Script

![Parsing JSON in Google Sheets with Zendesk and Google Script](https://pulse.appsscript.info/files/2020/02/1frUYc8q85xa5j4QbRGg0wQ.png)

[![](https://pulse.appsscript.info/files/2020/02/1frUYc8q85xa5j4QbRGg0wQ.png)](https://medium.com/@lanceconzett/parsing-json-in-google-sheets-with-zendesk-and-google-script-dfd82a37edb4)

> For the most part, using ImportJSON works well—it’s a low effort way of pulling data from any API’s GET endpoint and storing that data in a sheet for further parsing and filtering. But, there was a flaw: Zendesk’s API calls are paginated and limited to 100 results per page. That meant that we needed to add a new ImportJSON() formula every 100 rows to get all of our data.

This follow-up guide goes the extra step—not to feed a big JSON file into ImportJSON, but to write a script that does everything, including pagination. And, as an added bonus, is easier on your API rate limit.

Source: *[Parsing JSON in Google Sheets with Zendesk and Google Script*](https://medium.com/@lanceconzett/parsing-json-in-google-sheets-with-zendesk-and-google-script-dfd82a37edb4)

---

*Published by [Sourabh Choraria](https://pulse.appsscript.info/p/author/scriptgs/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/02/parsing-json-in-google-sheets-with-zendesk-and-google-script/](https://pulse.appsscript.info/p/2020/02/parsing-json-in-google-sheets-with-zendesk-and-google-script/)*