Analytics Suite 2
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/
Piano Analytics
To import data into Googles Sheets with the v3 API, you will need to use plugins such as Mixed Analytics or Supermetrics.
Mixed Analytics:
Link: https://mixedanalytics.com/api-connector/
Steps:
1/ Generate an API Key from your User Profile
2/ Build your template in Data Query
3/ Retrieve the API request URL (GET)
4/ Import the API Connector addon in Google Sheets
5/ Create a new request using the API URL
Headers:
| Key | Value |
| Content-Type | application/json |
| x-api-key | accesskey_secretkey |
6/ Choose the “grid” display style
7/ Save and play the query
Quick start guide: https://mixedanalytics.com/knowledge-base/api-connector-quick-start/
The connector can also work with POST requests.
Supermetrics:
Link: https://supermetrics.com/product/google-sheets
Steps:
1/ Generate an API Key from your User Profile
2/ Build your template in Data Query
3/ Retrieve the API request URL (GET)
4/ Import the Supermetrics addon in Google Sheets
5/ In the addon pannel, choose data source “Custom JSON/CSV”
6/ Copy the API URL in the field “Type URL”
http headers : X-API-Key: accesskey_securekey
7/ Choose the “grid” display style
8/ Save and play the query
Quick start guide: https://supermetrics.com/docs/product-google-sheets-getting-started/