Skip to main content

Varicent ELT Help Center

Google Sheets export

Abstract

Connect your Varicent ELT and Google Sheets accounts to export your data to your Google Sheets account. This connection allows Varicent ELT to write data to Google Sheets.

Connect your Varicent ELT and Google Sheets accounts to export your data to your Google Sheets account. This connection allows Varicent ELT to write data to Google Sheets.

Set up the connector to be available for use with the Export tool. You only need to set up the connection once. After the connection is set up, Varicent ELT can write updates and inserts in Google Sheets.

Caution

Google Sheets has a maximum cell limit of 10 million cells. Google API automatically generates 26 A-Z columns when a new sheet is created. For tables with less than 26 columns, the maximum cell limit might be reached before reaching the 10 million cell limit.

Create the connection

Create the connection between Varicent ELT and Google Sheets. Generate a new Google Sheets connection or use an existing one.

Creating a new connection

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the Connection drop-down.

  4. From the connection drop-down, click + New connection.

  5. Create the new Google Sheets connection for the Export tool.

    1. On the Create a connection page, click Google Sheets.

    2. Sign in with Google. If you are already signed in, choose an account.

    3. Follow the on-screen prompts, ensuring that you selected options to grant access required for exporting data to Google Sheets.

    4. Click Continue and you are redirected to Varicent ELT.

      The Google Sheets connector name now appears in the Connection field.

  6. In your pipe on the Export tool configuration page, find the new connection in the Connection drop-down.

  7. Enter the name and spreadsheet name.

    Note

    The name is the whole workbook name. The spreadsheet name is the sheet name within the workbook.

  8. Click Export now.

    The data is now available to use in the Export tool. For more information about the tool, see Export.

Using your existing Google Sheets connection

  1. In Varicent ELT, go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the Connection drop-down.

  4. Search for and select your existing Google Sheets connection.

  5. Enter the name and spreadsheet name.

    Note

    The name is the whole workbook name. The spreadsheet name is the sheet name within the workbook.

  6. Click Export now.

    The data is now available to use in the Export tool. For more information about the tool, see Export.