Skip to main content

[en] gray icon with file graphic inside Google Sheets Output Tool

警告

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

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

重要

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

[en] 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.

[en] Configure the Tool

[en] To authenticate...

  1. [en] Select Connectors, located in the Configuration panel.

  2. [en] Enter your credentials to sign in to your Google account.

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

    2. [en] 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. [en] 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.

      注意

      [en] 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.

[en] Write Options

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

[en] Create New Spreadsheet

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

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

[en] Add a Sheet to an Existing Spreadsheet

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

  2. [en] 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.

[en] Append to Existing Sheet

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

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

[en] Overwrite Spreadsheet (Remove)

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

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

[en] Overwrite Sheet (Drop)

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

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

[en] Other Considerations

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

: