Consuming JSON Web Data Using Google Sheets

[Dave Johnson]

Note: This article has been superseded with Fetching, Filtering, and Sorting JSON APIs in Google Sheets: The Missing Functions which provides a set of Google Sheets functions with additional capabilities.

I’ve said it before, and I’ll say it again. JSON has become the lingua franca for exchanging data on the web, and we (as developers) need to know how to process JSON data received from RESTful web services so we can be positioned for the present and for the future.