Importing into Google Sheets

ยท Test out the query at and when you are happy, copy the Request URL. It will look something like this:<your api key>

ยท Create a new Google Sheet

ยท Select Extensions --> Apps Script

ยท Delete the existing content of the script

ยท Copy the code from this script on Github into the script editor

ยท File --> Save

ยท In cell A1, type the following and press enter:

=ImportJSON("<your request url>", "/data", "noInherit")

ยท You should see the query data returned as rows:

Last updated