Skip to main content

google_drive_64_x_64.png Google Drive

New Connector Version in Designer

The Google Drive connectors are now part of the Alteryx One connectors experience. Review the information on this page carefully to ensure you're using the appropriate tools correctly.

The Google Drive connector lets you connect to Google Drive cloud storage in Designer Desktop.

Google Drive is available as a data source in the Input Data and Output Data tools, and as the standalone Google Drive Input and Google Drive Output tools.

Connector Type

Availability

Tools and Data Processing Options

Connector version 3.0 and later.

The latest version is available from the Alteryx Marketplace.

Input Data Tool Icon Input Data Tool—Read Data from Google DriveRead Data from Google Drive

Output Data Tool Icon Output Data Tool—Write Data to Google DriveWrite Data to Google Drive

Standalone Connectors

The latest version is available from the Alteryx Marketplace.

Google Drive Tool Google Drive Input Tool

Google Drive Tool Google Drive Output Tool

Google Drive Connector Details

Google Drive is available in Designer Desktop 2025.1.XX and later as a data source for the Input Data and Output Data tools. To learn more about the file type options, go to Read Data from Google Drive or Write Data to Google Drive.Read Data from Google DriveWrite Data to Google Drive

Google Drive Connector Release Notes

August 28, 2025

Google Drive Connector Version 3.0.0

What's New

To align the user experience between Alteryx One and Designer Desktop, we're releasing a new Google Drive connector for Designer Desktop. This connector enables a DCM connection to Google Drive in the Input Data and Output Data tools.

Known Issues

  • The Google Drive connector supports appending data to Excel sheets only.

  • The Google Drive connector doesn't support reading data with wildcards or from multiple files, folders, or sheets.

  • The Google Drive connector doesn't support partitioning with or without metadata. To use partitioning without metadata, use macros.

  • The Google Drive connector doesn't support selecting a sheet from a dropdown list. You need to type in the sheet name manually.

Authentication Methods

Google Drive supports basic authentication with user's credentials (Sign-in with Google) and advanced custom API app authentication (Sign-in with Google—private).

Sign-in with Google

The basic authentication with email and password is tied to the user's personal Google credentials. You can allow this connection for the SDK.

We don't recommend this type of authentication for scheduling workflows.

Sign-in with Google—private

Advanced authentication leverages the capabilities of custom API applications. For instructions on how to set up the API app, go to our Google Drive API app setup. You can allow this connection for the SDK.

The API apps aren't tied to a specific user, so you can use them more conveniently for scheduling workflows. However, they require one-time authentication when you create a connection in DCM.

Set Up a Connection with DCM

To connect to Google Drive with DCM...DCM - Designer

  1. Drag the Input Data or Output Data tool from the tool palette to the canvas, and select it.

  2. Select Set Up a Connection.

    If you've created a Google Drive connection before, you can select Data Sources > Google Drive > Quick connect , and skip to step 12.

  3. In the Data connections window, select Data Sources.

  4. Find Google Drive and select Quick Connect.

  5. The Connections window opens.

  6. Select + New to create a connection.

  7. Enter a connection name of your choice.

  8. In the Data Source section, Designer automatically selects the Google Drive data source technology.

  9. Enter a data source name of your choice.

  10. In the Credentials section, select your authentication method, and enter the credentials. Refer to the authentication method in the previous section for details.

  11. Select Save. You can also test the connection before saving.

  12. Select Connect. Google Drive may request authentication.

  13. Select the file to read from or write to in the file browser window.

  14. Select the read or write configuration in the Options window.

  15. Select Confirm to create a connection to the file. You can continue building your workflow.

Google Drive Standalone Connectors

Standalone Google Drive Connectors Release Notes

Version

Description

v1.3.5

  • Compatible with Designer 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.

  • Disabled the right-click context menu in Designer for the Google Drive tools to prevent unintended actions.

  • The Google Drive connector defaults Time and DateTime precision to milliseconds to avoid extra trailing zeros, while still supporting nanosecond resolution when required by the workflow.

  • Fixed issue where special characters in a proxy password caused an error during manual proxy server setup.

  • Fixed issue where workflows using the Google Drive tools hung in the “Running” state when published without syncing the DCM connection to Server. (TPM-4985)

  • Fixed issue where Google Drive Output returned an API response error when more than 26 fields were used without records. (TPM-4961)

  • Fixed issue where Google Drive Output removed formatting only from column B. (TPM-4960)

  • Fixed issue where the Google Drive tools wrote slowly to Google Sheets. (TPM-4879)

  • Fixed issue where DCM schema names were interchanged in the body of Google Drive Input and Output. (TPM-4845)

  • Fixed issue where secret values were exposed in JSON when using Developer Tools in Designer. (TPM-4784)

  • Fixed issue where the Google Drive connector didn’t properly accept the selected file path. (TPM-4756)

  • Fixed issue where version 1.3.5 of the Google Drive tools took longer than expected when writing data to Google Sheets. (TPM-4701)

  • Fixed issue where the Google Drive connector wrote null values as “nan” in Excel (XLSX) files. (TPM-4643)

  • Fixed issue where the Google Drive connector changed the GIDs (Google Sheet IDs) of existing sheets when adding a new sheet to the same file. (TPM-4489)

  • Fixed issue where Append and Rename functionality failed for the Google Sheets format in shared drives. (TPM-4484)

  • Fixed issue where Google Drive Input showed an “int too big to convert” error when reading large numeric values. (TPM-4446)

  • Fixed issue where Google Drive Input added a second sheet name unexpectedly. (TPM-4437)

  • Fixed issue where version 1.3.4 of the Google Drive tools failed with a “List index out of range” error. (TPM-4432)

  • Fixed issue where connections with the Google Drive tools were blocked with the message “This app is blocked.” (TPM-3774)

  • Fixed issue where file creation didn’t automatically apply the correct file extension. (TPM-3747)

  • Fixed issue where using special characters in a file name showed a “{” character in the error message. (TPM-3746)

  • Fixed issue where the file breadcrumb display didn’t show the full path when browsing files in Google Drive. (TPM-3628)

Known Issues

  • The Google Drive connector automatically adds a decimal point to numeric values. (TPM-4642)

v1.3.4

  • 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 read data or metadata from CSV and YXDB files containing only the header row. (TPM-4240)

  • Fixed issue where Google Drive Output didn’t create any file if criteria weren’t met. (TPM-4045)

  • Fixed issue where the Google Drive tools couldn’t convert Python integers. (TPM-3832)

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.

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.

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.

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.

Custom Google API Application Setup

To set up a custom API application for this tool, see our guide.

In this section: