gray icon with file graphic inside

Google Sheets Output Tool

Version:
Current
Last modified: March 27, 2020

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

Gallery Tool

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

Configure the Tool

To authenticate...

  1. Select Connect, 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 and provide 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. 

      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).

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.