The ElastiCube Manager enables easy and quick access to tables contained within Google Spreadsheets.

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

To connect to Google Spreadsheets:

  1. Click the Add Data icon in the top menu of the ElastiCube Manager.
  2. Under the Web Services category, select Google Spreadsheets.
    Note: Make sure you are working with Sisense version 5.7.6.71 or above. If you are working with a previous version and cannot connect to Google Spreadsheets, click here to upgrade your Sisense version and learn how to refresh your data.

Add Google spreadsheets

The following screen appears.

spreadsheet connect

  1. In the User Account field, enter your user account email.
  2. Click Get to obtain your Google 2-Step Verification code, and enter it in the Auth Code field.
  3. Click Connect to Server.
  4. From the Select Database drop-down list, select the relevant spreadsheet you want to work with and click OK.
  5. Select the checkbox next to each sheet you want to use.

Add Google spreadsheets_2

  1. Once all relevant tables are selected, click Add.