# 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](https://gist.github.com/paulgambill/cacd19da95a1421d3164) 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:

![](https://2904693074-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-Mjz3PBq89DT2OWUHzd5%2Fuploads%2FTIN08a7v5cHEsPbWlYSm%2Fimage.png?alt=media\&token=e3bb0397-b1b9-47f3-8493-798b61d7bf0e)