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/