Skip to content
Advertisement

Parsing JSON into Google spreadsheet (Apps Script)

I have a download in JSON format that I get through the API. Example:

JavaScript

An example of what should happen: enter image description here

The ratio of the JSON list of employees with columns in the table:

JavaScript

How can I convert JSON to a Google spreadsheet for 300+ rows? At the moment I only have a request to the API. The response is JSON. What are my next steps?

JavaScript

Advertisement

Answer

Try this:

JavaScript

Let me know if it works.

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement