Connecting to Google Spreadsheets

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.
  3. Note: Make sure you are working with Sisense version 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.

    The following screen appears.
  4. In the User Account field, enter your user account email.
  5. Click Get to obtain your Google 2-Step Verification code, and enter it in the Auth Code field.
  6. Click Connect to Server.
  7. From the Select Database list, select the relevant spreadsheet you want to work with and click OK.
  8. Select the checkbox next to each sheet you want to use.
  9. Once all relevant tables are selected, click Add.