Skip to main content

gray icon with file graphic inside Google Sheets Output Tool

Warning

The Google Sheets tools are deprecated. Install the Google Drive tools which provide updated features.

The Google Sheets Output tool publishes data from an Alteryx workflow to a Google Sheets spreadsheet.

Important

This tool is not automatically installed with Alteryx Designer. To use this tool, download it from the Alteryx Community.

Due to improved security of your instance when accessing the database and loading data into the workflow, we recommend to use Google Sheets Output tool v3.0.0.

Configure the Tool

To authenticate...

  1. Select Connectors, located in the Configuration panel.

  2. Enter your credentials to sign in to your Google account.

    1. Accept the consent forms to allow Alteryx to read (through the Input tool) your Google Sheets’ files.

    2. If you select the checkbox Optional 0Auth2 Overrides, you will need to enter your Client ID and Client Secret andprovide the same override credentials for the Connection Token.

    3. Enter the Connection Token, or, in combination with the OAuth Override option if you would like to share the same Connection Token with another Google Sheets Output tool.

      Note

      To not exceed the limit of 50 Refresh Tokens per user or application, you can share Connection Tokens among Google Sheets tools. To obtain a Connection Token for the first time, sign in with your Google account and copy the token. This Connection Token can be reused in other Google Sheets tools.

Write Options

We recommend using the Google Sheets plugin with the latest Designer release.

Create New Spreadsheet

  1. Create a new spreadsheet with a specified name and sheet name. Select Done.

  2. If you want to change options, select Change Write Option.

Add a Sheet to an Existing Spreadsheet

  1. Under Select a Spreadsheet, select Add Sheet to Existing Spreadsheet. Select Next.

  2. Under Enter Name,enter the name of the new sheet. It will not overwrite an existing sheet. If a sheet with the same name already exists, an error will display.

Append to Existing Sheet

  1. Under Select a Spreadsheet,choose the name of the existing spreadsheet. Select Next.

  2. Under Select a Sheet, select the sheet that you want to append your data. Select Done.

Overwrite Spreadsheet (Remove)

  1. Under Select a Spreadsheet,choose the name of the existing spreadsheet that you wish to delete. Select Next.

  2. Under Enter Name,enter the name of the sheet that you wish to create. Select Done.

Overwrite Sheet (Drop)

  1. Under Select a Spreadsheet,choose the name of the existing spreadsheet. Select Next.

  2. Under Select a Sheet,select the existing sheet that you want to overwrite. Select Done.

Other Considerations

Google Sheets might replace specific characters within a spreadsheet (for example, a tab will become a space).

In this section: