Google Sheets Input Tool

The Google Sheets Input tool downloads data from a Google Sheets spreadsheet directly into your Alteryx workflow.

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

Login Methods

Configuration Properties

Select a spreadsheet and sheet name from which to import data, and then run your workflow to download the sheet data.

First row contains field names: When this box is checked, Alteryx sets the first row of input as field header information. If you leave this option unchecked, Alteryx assigns field names based on their order (e.g., 0, 1, 2).

Limitations

The Developer Login authentication method uses the Google Spreadsheets API and may time out when trying to download large files. If you encounter this issue:

  1. Break one large sheet into two or more smaller sheets.
  2. Use a Google Sheets Input tool for each sheet and combine the results with the Union tool.