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/