Can I import REST API data into Google Sheets?

The =IMPORTHTML function can be used to do this.

You will need to:

  • Get a REST API URL from Data Query in HTML format
  • Create a GUID in the API Accounts interface
  • Add the previously created URL
  • Get the GUID (API key)

Here is an example of this function being used:

where "xxxxxx" is the level 1 site ID.

We also have a script available on the Marketplace that allows you to import the API in a Google Sheet:

Have more questions? Submit a request