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:
=IMPORTHTML('https://apirest.atinternet-solutions.com/data/v2/html/getData?&columns={d_time_date,m_visitors,m_page_views,m_visits}&sort={-m_visitors}&space={s:xxxxxx}&period={R:{D:'-1'}}&max-results=20&page-num=1&apikey=xxx','table',1)

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: https://marketplace.atinternet-solutions.com/product/google-sheets/

Have more questions? Submit a request