Creating a Google Sheets connection

To create a Google Sheets connection:

1. Open the connection creation page.

2. Under Files and services, select the Google Sheets connection.

3. Add files depending on access permissions:

   Public spreadsheet

   Spreadsheet with restricted access

   1. Click + Add file and specify the link to the file. To do this, in the Google Sheets access settings, select Anyone with the link and copy the link to the sheet you need from your browser's address bar. If you copy the link from the Google Sheets sharing window, it will lead to the first sheet of the spreadsheet.
   2. Click Add. If your file contains multiple sheets, specify the ones you want to upload in the Add sheets window. You cannot select empty sheets. Enable the Sheets option to select all available sheets. Each sheet is uploaded to a separate table. Click Add.
   3. Information about this file and the data to upload will appear at the center of the screen.

   1. At the top of the screen, click Log in with Google.
   2. Select the account to go to the DataLens application.
   3. Allow DataLens to access your Google account. Click Continue.
   4. Click + Add file and specify the link to the file.
   5. Click Add. If your file contains multiple sheets, specify the ones you want to upload in the Add sheets window. You cannot select empty sheets. Enable the Sheets option to select all available sheets. Each sheet is uploaded to a separate table. Click Add.
   6. Information about this file and the data to upload will appear at the center of the screen.

   To sign out of your Google account, click . Click Sign out. The sheets from the files with restricted access will no longer be displayed.

   Note

   • To properly identify the data types, select Format → Numbers in the Google Sheets menu and set the column cell format.
   • If a filter is enabled in your Google Sheets table, only data matching the filter criteria will be displayed in connections and datasets based on it.

4. Set the Show column headers option to Yes or No.

5. Optionally, enable automatic updates for spreadsheet data. To do this, in the top-right corner, select Update automatically. Spreadsheet data will be updated every 30 minutes or less often. To update your data manually, click Update data.

6. Click Create connection.

7. Select the workbook to save your connection to or create a new one. If using legacy folder navigation, select a folder to save the connection to. Click Create.

8. Enter a name for the connection and click Create.

You can add, rename, and delete files in the connection.

Additional settingsAdditional settings

You can limit data export from charts based on this connection. To do this, click at the top right and uncheck Allow data export. With this option disabled, for charts based on the respective connection, the export data option will not be available in their menu. However, you will still be able to copy chart data and take screenshots.

LimitationsLimitations

When creating a connection to Google Sheets, consider the following limitations:

• The maximum number of Google Sheets per connection is 10. When creating a connection, all sheets will be loaded, but you can only select ten of them to work with at the same time.

• Maximum size per sheet: 200 MB.

  Note

  Technically, you cannot check the size of an individual sheet in the connection. If the limit is exceeded, you will get a message saying the data could not be loaded.

• Maximum number of columns per sheet: 300.

• Minimum number of rows per spreadsheet: 2. In a spreadsheet with one row, you cannot identify column types as you cannot tell a header from a data row.

FAQFAQ

See how to replace a legacy Google Sheets connection with a new one.