Bogged Finance
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:
Copy link