Skip to main content

Google Drive

Connection Type

Alteryx Tool. The latest version is available from the Alteryx Marketplace.

Type of Support

Read & Write

Version

Description

v1.3.3

  • Compatible with Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.

  • Compatible with AMP engine only.

  • DCM is required for running this connector in Alteryx Server.

  • Fixed issue where Google Drive Input couldn't maintain the user’s settings. (TPM-3873)

  • Fixed issue where Google Drive Input couldn't properly read files with blank rows. (TPM-3872)

  • Fixed issue where Google Drive Input couldn't properly read a CSV file if the \0 character was set as no delimiter and the data contained the \ character. (TPM-3860)

  • Fixed issue where Google Drive Output lost the formatting and data type when writing dates. (TPM-3859)

  • Fixed issue where the Google Drive tools' interface didn't update the file path, file name and other values when the file was updated. (TDCE-542)

  • Fixed issue where Google Drive Input returns the "invalid extension" error. (TDCE-541)

  • Fixed issue where Google Drive Input couldn't properly read CSV files which contained special characters. (TDCE-535)

  • Fixed issue where Google Drive Input couldn't properly read XLSX files whose sheet name ended with a space. (TDCE-532)

  • Fixed issue where Google Drive Output couldn't properly append data or overwrite sheets in existing XLSX files. (TDCE-483)

v1.3.2

  • Compatible with Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.

  • Compatible with AMP engine only.

  • DCM is required for running this connector in Alteryx Server.

  • Google Drive Output now uses Google Sheets API to create GSHEET files. (TPM-2984)

  • Fixed issue where Google Drive Output didn’t properly append DateTime data. (TPM-3738)

  • Fixed issue where Google Drive Output didn’t create CSV files. (TPM-3737)

  • Fixed issue where Google Drive Input returned an error when reading XLSX files with both text and number values in one column. (TPM-3708)

  • Fixed issue where Google Drive Output ignored the entered sheet name. (TPM-3626, TPM-3368)

  • Fixed issue where Google Drive Output changed Google Sheet ID. (TPM-3434)

  • Fixed issue where Google Drive Input couldn’t properly read Null values. (TPM-2972)

  • Fixed issue where multiple Google Drive Output tools configured to overwrite data in different sheets changed the settings and overwrote the same sheet. (TPM-2059)

  • Fixed issue where the Google Drive tools returned an error that the file doesn’t exist. (TFLN-1908)

  • Fixed connectivity and authentication issues of Google Drive Input to folders with too many characters. (TDCE-451)

  • Fixed issue where Google Drive Input didn’t retain user’s settings if the user switched to another tab. (TDCE-450)

Known Issues

  • Google Drive Input reads Boolean data as Strings in YXDB files. (TPM-3756)

  • Google Drive Input incorrectly reads double quotes. (TPM-3707)

  • Google Drive Output returns an error when writing files with special characters in the file name. (TPM-3746)

  • The Google Drive tools don’t display the full file path. (TPM-3628)

  • Google Drive Output writes Null values in Boolean columns as False values. (TPM-3053)

v1.3.1

  • Compatible with Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.

  • Compatible with AMP engine only.

  • DCM is required for running this connector in Alteryx Server.

  • For Google Drive Input, added an option to include subfolders when utilizing the wildcard search, downloading files locally, or when user opts to Process file as.

  • Fixed issue where the list of files in Shared Drive was refreshed back to root when user scrolled down the list. (TFLN-1759)

  • Fixed issue where the wildcard search didn’t work on shared files. (TFLN-1373)

  • Fixed issue where manually editing file path in a Shared Drive deleted connector configuration. (TFLN-1861)

  • Fixed issue where Google Drive Output didn't append records to new sheets. (TDCE-252)

v1.3.0

  • Compatible with Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later.

  • Compatible with AMP engine only.

  • DCM is required for running this connector in Alteryx Server.

  • Removed usage of .shiv folder.

  • Added option to limit wildcard usage and “Download file locally” option to only the currently selected folder.

  • Fixed issue where tool failed to connect when PAC was downloaded as plaintext or JSON. (TPM-2927)

  • Fixed issue where list of file refreshed and redirected back to the root Shared Drive location when scrolling down the list. (TFLN-1759)

  • Fixed issue where Google Drive Input replaced “NA” values with Nulls. (TPM-2576)

  • Fixed issue where Google Drive Output removed formatting, filtering, and grouping of embedded objects when user opted to Overwrite Sheet in GSHEET. (TPM-2926)

  • Fixed issue where Google Drive Output was changing Google Sheet IDs when appending or overwriting the same Google Sheet. (TPM-2789)

  • Fixed issue where Designer stopped responding when user replaced an Input Data tool with a Google Drive Input tool. (TPM-3059)

v1.1.2

  • Compatible with Alteryx Designer and Server 2021.4.2 Patch 4, 2022.1 Patch 2 and later.

  • Requires AMP engine.

  • When locally downloading an XLSX file, the tool now returns a list of Sheet Names.

  • Google Drive Output now preserves formatting when using the Append or Overwrite Sheet action.

  • Fixed issue where Google Drive Output changed the date fields to 70 years in the future. (TPM-1905)

  • Fixed issue where Google Drive Output didn’t keep configuration for Sheet name. (TFLN-1223)

Known Issues

  • Alteryx Server requires the AllowAll value of the SDK Access Mode settings.

  • When multiple Google Drive Output tools are configured to overwrite different sheets in the same GSHEET file, they incorrectly overwrite the same sheet instead. (TPM-2059)

  • Wildcard search is currently not working for shared files. (TPM-1840)

v1.1.1

  • Compatible with Alteryx Designer and Server 2021.4.2 Patch 4, 2022.1 Patch 2 and later.

  • Added option to overwrite a single sheet in Google Sheets.

Known Issue

  • Alteryx Server requires the AllowAll value of the SDK Access Mode settings.

v1.1.0

  • Compatible with Alteryx Designer and Server 2021.4.2 Patch 4, 2022.1 Patch 2 and later.

  • Requires AMP engine.

  • Added support for DCM.

    • DCM is required for running this connector on Alteryx Server.

  • Added support for Google Shared Drives.

  • Changed the behavior of sheet and file name field to be excluded from the written data. Added option to keep the sheet and file name field.

  • SSL/TLS validation is now performed against Windows Certificate Store.

  • FIPS capable.

Known Issues

  • Alteryx Server requires the AllowAll value of the SDK Access Mode settings.

  • Can’t overwrite single sheet in Google Sheets. (Coming soon.)

v1.0.0

  • Compatible with Alteryx Designer version 2021.4 and later.

  • Initial release.

  • Built-in multitenant Google App with an option to use custom Google App (incl. single-tenant app).

  • Supports reading and writing XLSX, CSV, and YXDB file formats.

  • Proxy support.

Alteryx Tools Used to Connect

Data Connection Manager

The Google Drive tools version 1.1.0 and later support Data Connection Manager for an easier and a safer storage of your credentials. Create a connection to Google Drive and easily reuse the stored credentials in workflows that include the Google Drive tools. Alteryx Server requires stored credentials to successfully run the published workflows.

Enable AMP Engine

Make sure you have the AMP engine enabled for the workflows which contain the Google Drive tools version 1.1.0 and later.

Sign In to Google Drive

You can sign in via an internet browser or you can connect via a personal Google App. Go to Custom API Application Setup for more information how to create an app or see Create and set up your app for details.

Sign In via Internet Browser

  1. In Create New Connection, select Sign In Using Internet Browser.

  2. Select Connect.

  3. Enter your credentials and sign in.

  4. Select Continue to allow access.

Connect through Own Google App

  1. In Create New Connection, select Sign In Using Internet Browser and check Connect through own Google App.

  2. Enter Client ID and Tenant ID.

  3. Select Connect.

  4. Enter your credentials and sign in.

  5. Select Continue to allow access.

Custom Google API Application Setup

To set up a custom API application for this tool, see our guide.Set Up Google API Application