Import JSON from any URL directly into your Google Sheets.
ImportJSON.gs adds an
=ImportJSON() function to your spreadsheet, allowing quick and easy JSON importing. To use go to
Script Editor and add the
ImportJSON.gs file. Now in your spreadsheet you can access the
ImportJSON() function. Use it like this:
Here are all the functions available:
|ImportJSON||For use by end users to import a JSON feed from a URL|
|ImportJSONFromSheet||For use by end users to import JSON from one of the Sheets|
|ImportJSONViaPost||For use by end users to import a JSON feed from a URL using POST parameters|
|ImportJSONBasicAuth||For use by end users to import a JSON feed from a URL with HTTP Basic Auth|
|ImportJSONAdvanced||For use by script developers to easily extend the functionality of this library|
ImportJSON.gs for more info on how to use these in detail.
This code base used to be hosted at http://blog.fastfedora.com/projects/import-json and contained a lot of useful information. It has been archived at https://rawgit.com/bradjasper/ImportJSON/master/archive/blog.fastfedora.com/projects/import-json.html
Some of this if possible internally with Google App Scripts External APIs, like UrlFetch: https://developers.google.com/apps-script/guides/services/external
These require a Google account and an explicit permission, but in some cases may be a good fit.