Creating a Google Sheets connection
Connecting to Google Sheets
To create a Google Sheets connection:
Go to the connections page.
Click Create connection.
Select the Google Sheets connector.
Specify the connection parameters:
- Connection name. Specify a name for the connection. You can set any name.
- Link. Specify a link to the desired sheet in Google Sheets. To do this, in the Google Sheets access settings, select Anyone with the link and copy the link to the desired sheet from the browser's address bar.
Click Create. The connection appears in the list.
When loading data from Google Sheets, a cache with a lifetime of up to 5 minutes is used, so there might be delays when updating data in DataLens.