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 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 3 years ago

Was this helpful?