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.

If you are trying to connect to Google Sheets from a remote Sisense server or an address other than localhost, you must configure Google Sheets to work with the Google OAuth protocol. For more information, see Google Authentication.

Note: To work with Google Sheets, you must have a professional Google account, since Google’s API is only available to business accounts.

To import data from your Google Sheets:

  1. In the Data page, open an ElastiCube model or create a new ElastiCube model.
  2. In the Model Editor, click . The Add Data dialog box is displayed.
  3. Click Google Sheets. The Google Sheets Connect area is displayed.
  4. Click Google and enter your Google Sheets credentials.
  5. Once you have logged in, click Next. The Add Data area is displayed with a list of available spreadsheets for your account.
  6. Select the relevant spreadsheet and click Done. A list of tabs included the sheet are displayed.
  7. Select the relevant tabs within the sheet and click Done. All the selected tables are added to your schema.
  8. 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).
    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: Enter two cells, each with a leading $ sign and a colon as a delimiter. Hit Enter to preview the selection. Selecting the Static Range option 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.
    For a static range between cells A1 and E10, type in $A1:$E10.
  9. Click Done. The relevant data is added to your model's schema.