Google Drive Output Tool
Google Drive Output Tool
Google Drive Output writes files from Designer to Google Drive. See Google Drive to learn about sign-in options and known limitations.
Important
This tool is not automatically installed with Designer. To use this tool, download it from the Alteryx Marketplace.
To maintain full functionality of the Google Drive data connector, please note compatibility with Designer.
Alteryx Designer and Server 2021.4.2 Patch 4, 2022.1 Patch 2 and later.
Designer version 2021.4 and later.
Select a File
Select which files to display in the Files to display dropdown. Options are My Files, Shared with me, and Recent.
Select the file in the file tree or search for it by name. You can enter the file path in the File Path field.
Use Existing File Action in the Options tab to select how you want to handle an existing file.
Rename: The Rename option renames the file (it appends a unique number to the end of the filename).
Overwrite: The Overwrite option deletes the existing file and writes the new file contents.
Overwrite Sheet: The Overwrite Sheet option rewrites the selected sheets and makes no changes to other sheets.
Append: The Append option adds new data to the existing file.
Abort: When Abort is selected, the file doesn't upload if there is another file with the same name.
Warning
If you select the Overwrite or Append options in Existing File Action, the updated sheet becomes the first sheet in the file. This can impact tools using the order numbers of sheets.
Add a Folder
Go to the folder where you want to add a folder.
Select Add Folder.
Select By Name and enter the name of the new folder. Designer adds the folder without the need to run the workflow.
Select By Field to add multiple folders based on a specified field from the data.
Enter the name of the new files in the File Name field.
Google Drive Output excludes the field from the written data. You can keep it by selecting Keep Field in Output.
The File Name field requires the file name including the file type extension.
Run the workflow to add the folders.
Add a File
Go to the folder where you want to add a file.
Select Add File.
Select By Name and enter the name of the new file. The File Name field requires the file name and the file type extension.
Select By Field to add multiple files based on a specified field from the data.
Run the workflow to add the file.
Select a File Format
Data Range options specify the names of the sheets to create. Options are By Sheet Name and By Field.
Google Drive Output excludes the field from the written data. You can keep it by selecting Keep Field in Output.
If you select the By Field option, multiple sheets will be created and named based on the value selected in Select Field.
Enter the cell in Start in cell to specify the start of data output.
Select Write headers to include headers in the output data.
Select Code Page to determine the encoding of the data.
Use Max Field Length to set the maximum length of each field. This lets you control string cut-off.
Use Field Delimiter to select a field delimiter between fields. Options are Comma, Semicolon, Tab, Pipe, Space, or Custom delimiter.
Select Write headers to include headers in the output data.
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.
Data Range options specify the names of the sheets to create. Options are By Sheet Name and By Field.
Google Drive Output excludes the field from the written data. You can keep it by selecting Keep Field in Output.
If you select the By Field option, multiple sheets are created and named based on the value selected in Select Field.
Enter the cell in Start in cell to specify the start of data output.
Select Write headers to include headers in the output data.
Select Code Page to determine the encoding of the data.
No options.