Importing into Google Sheets

ยท Test out the query at https://api.bogged.finance and when you are happy, copy the Request URL. It will look something like this:

https://api.bogged.finance/v1/top_exchanges?chain=bsc&api_key=<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