You are here:

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

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.

Configure the tool

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:

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