Connecting to Google Sheets
Note: This topic describes how to import data using the online Sisense Web Application. To import data through the desktop ElastiCube Manager, click here.
Sisense enables easy and quick access to databases, tables, and views contained in Google Sheets databases.
Note: If you are connecting to a Google service remotely, and the address of Sisense is something other than localhost, Google requires that you connect using the OAuth 2.0 protocol. See Google Authentication for more information. If you are on a Linux deployment, see Google Authentication in Linux.
Note: To work with Google Sheets, you must have a professional Google account, since Google’s API is only available to business accounts.
Note: For the list of connectors available on Linux, click here.
To import data from your Google Sheets:
- In the Data page, open an ElastiCube model or create a new ElastiCube model.
- In the Model Editor, click . The Add Data dialog box is displayed.
- Click Google Sheets. The Google Sheets Connect area is displayed.
- Click Google and enter your Google Sheets credentials.
- Once you have logged in, click Next. The Add Data area is displayed with a list of available spreadsheets for your account.
- Select the relevant spreadsheet and click Done. A list of tabs included the sheet are displayed.
- Select the relevant tabs within the sheet and click Done. All the selected tables are added to your schema.
- Enter the following details:
Culture: Select the culture for your spreadsheet. This defines settings such as the format of the date and time or delimiter (decimal or comma). To change the default culture, see here.
First Row Contains Field Names: Select to specify table column names based on the header in the first row of the spreadsheet.
Ignore rows that start with: Specify rows to ignore that start with a specific symbol, value or letter.
Static Range: This enables you to select a specific range of data in the sheet. Data needs to be in a table structure, starting at the top-left cell of the range, with field names as the first row.
Enter two cells, each with a leading $ sign and a colon as a delimiter. Press Enter to preview the selection. For example, for a static range between cells A1 and E10, type in $A1:$E10.
- Click Done. The relevant data is added to your model's schema.
When building an ElastiCube with this connector, you might receive an "out of memory" error. To add more memory, see Troubleshooting Out-of-Memory Issues.
- Table field headers (column titles) must be strings for full backwards compatibility.
- The connector does not support Team Drive. If you need to use Team Drive, you can download a certified driver (included in your license with Sisense) from here.