Google Sheets Output Tool
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...
Select Connectors, located in the Configuration panel.
Enter your credentials to sign in to your Google account.
Accept the consent forms to allow Alteryx to read (through the Input tool) your Google Sheets’ files.
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.
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 a new spreadsheet with a specified name and sheet name. Select Done.
If you want to change options, select Change Write Option.
Under Select a Spreadsheet, select Add Sheet to Existing Spreadsheet. Select Next.
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.
Under Select a Spreadsheet,choose the name of the existing spreadsheet. Select Next.
Under Select a Sheet, select the sheet that you want to append your data. Select Done.
Under Select a Spreadsheet,choose the name of the existing spreadsheet that you wish to delete. Select Next.
Under Enter Name,enter the name of the sheet that you wish to create. Select Done.
Under Select a Spreadsheet,choose the name of the existing spreadsheet. Select Next.
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).