IMPORTJSON: A simple Google Sheets function to parse JSON data in a flash

Get the add-on here:

- Retrieve JSONs from any URLs, Google Drive documents and cUrl requests
- Filter the JSON object with a simple query language (like parent/child/0)
- Automatically pivot the array elements into columns
- Load thousands of JSONs in one spreadsheet
- it caches the results to avoid repeated requests to an API

[leomdem]

This is really helpful to me. Thank you!

[potatoman]

Hey how do you have your json online like that, I am struggling to import

[brytonmassie]

Do you have a app for google sheets that auto exports new entries as .json files to a github repo?

[mairhart]

This add-on does not pivot arrays into columns as the documentation claims. It strings the array items along in a single row with headers.

[THEDMITRIYctf]

Hello thanks for the man. maybe you can tell me how to implement a script update once an hour ? or by timer ? I'm already crying...

[brytonmassie]

Can this be used to auto import .json files submitted via google form?