Google Sheets Output Tool

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.

Login Methods

User Login: Use this method for ad-hoc workflows. Sign in using Google Account credentials. This option requires re-entering credentials every 60 minutes or any time a new workflow is opened.
Developer Login: Use this method for scheduled workflows. Sign in using Google API credentials. This option requires obtaining a Client ID, Client Secret, and Refresh Token and does not require re-entering credentials to run a workflow.

Select and configure a write option, and then run your workflow to write data to a Google Sheet spreadsheet stored on Google Drive.

Create New Spreadsheet: Creates a new spreadsheet with a specified name and sheet name.

Google Drive supports multiple files with the same name.

Add Sheet to Existing Spreadsheet: Creates a new sheet within an existing spreadsheet. It will not overwrite an existing sheet – if a sheet with the same name already exists, an error will display.
Append to Existing Sheet: Appends all data to an existing sheet. Output will consist of previous data and new data.
Overwrite Spreadsheet (Remove): Deletes the existing file and creates a new one containing the specified sheet name.
Overwrite Sheet (Drop): Deletes the specified sheet and then writes the data into a new sheet with the same name.

Google Sheets may replace specific characters within a sheet (e.g., a tab will become a space).