Google Drive Tool

Google Drive Input Tool

Version:
2022.1
Last modified: May 04, 2022

Google Drive Input reads files from Google Drive to Designer. See Google Drive to learn about sign-in options and known limitations.

To maintain full functionality of the Google Drive data connector, note compatibility with Designer.

Connector Version 1.0.0

Designer versions 2021.4 and later.

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

Select a Data Source

OneDrive Input reads individual files or multiple files of the same type. You can select a folder to read all the files of the same type in that folder and its subfolders and you can define the files with wildcards. You can also read files directly from a URL.

  1. Select which files to display in the Files to display dropdown. Options are My Files, Shared with me, and Recent.
  2. Select a folder or a file in the file tree, or search for it by its name. You can also enter the file path in the File Path field.

    TIP

    When you select a file, the file format is detected automatically. If you select a folder, you need to select the file type of the files you want to read in the Options tab. You can define the file path with wildcards. For example “.../*2020.xlsx” for all .xlsx files that end with '2020'.

  3. If you want to process a file of a file type that Google Drive Input doesn’t support or if you want to keep an offline copy of a file, select Download file locally for later processing and choose the location to save the file. The default location is %TEMP%.

Select a File Format

The file format is detected automatically when you select a file. To read multiple files from a folder and its subfolders, you need to manually select the file type in the Options tab.

XLSX
  • Data Range options specify which sheets contain the data. Options are All Sheets, Sheet Names, Sheet Numbers, Named Range, or Import only the list of sheet names.
  • Check the First row contains field names box to set the first row of data as column headers.
  • Use Start data on line to select which line to start the import on.
  • In Number of Rows, enter a number of the lines you want to import. Leave it blank to import all the rows.
  • Select Code Page to determine the encoding of the data.
  • Select the Propagate field immediately to the next tool to propagate all fields to a connected tool without the need to run the workflow.
  • Use Attach Metadata to select the metadata to attach to every row of the input.
CSV
  • Use Max Field Length to set the maximum length of each field, allowing control over string cut off.
  • Use Field Delimiter to select a field delimiter between fields. Options are Comma, Semicolon, Tab, Pipe, Space, or Custom delimiter.
  • Check the First row contains field names box to set the first row of data as column headers.
  • Use Start Data on Line to select which line to start the import on.
  • In Number of Rows, enter a number of the lines you want to import. Leave it blank to import all the rows.
  • Use Quote Character to select a format of the quote. Options are None, Single Quote, Double Quote, or Custom.
  • Select Code Page to determine the encoding of the data.
  • Select the Propagate field immediately to the next tool to propagate all fields to a connected tool without the need to run the workflow.
  • Use Attach Metadata to select the metadata to attach to every row of the input.
YXDB
  • Select the Propagate field immediately to the next tool option to propagate all fields to a connected tool without the need to run the workflow.
  • Use Attach Metadata to select the metadata to attach to every row of the input.
GSHEET
  • Data Range options specify which sheets contain the data. Options are All Sheets, Sheet Names, Sheet Numbers, Named Range, or Import only the list of sheet names.
  • Check the First row contains field names box to set the first row of data as column headers.
  • Use Start Data on Line to select which line to start the import on.
  • In Number of Rows, enter a number of the lines you want to import. Leave it blank to import all the rows.
  • Select Code Page to determine the encoding of the data.
  • Select the Propagate field immediately to the next tool to propagate all fields to a connected tool without the need to run the workflow.
  • Use Attach Metadata to select the metadata to attach to every row of the input.
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.