Skip to main content

Varicent ELT Help Center

Google Sheets

Abstract

Connect your Varicent ELT and Google Sheets accounts to import your data.

Connect your Varicent ELT and Google Sheets accounts to import your data.

Important

You may encounter an access token error if you have too many connections open or a stale connection. Create a new connection to try again.

Importing data

  1. In Varicent ELT, go to the Data tab.

  2. Click Import data.

  3. In the Third party sources section, click Google Sheets.

  4. Click New connection.

    A Select Google Sheets connection modal appears, notifying you of which options to select to ensure that your data is visible.

  5. Click Sign in with Google.

  6. Follow the on screen prompts to sign in to your Google account, ensuring that you selected the required options.

    A message appears when the connection is successful.

  7. On the Select data page, choose the file from the Directory dropdown field.

  8. Click Next.

  9. On the Choose data sets page, select which data sets that you want to include.

  10. Click Import data.

    The data is available on the My Data page.

Error handling

The following errors may appear during the import process:

Error

Description

Import failed with the following error: message.

Import failed with an error.