Skip to main content

[en] Google Drive

[en] Connection Type

[en] Alteryx Tool. The latest version is available from the Alteryx Community.

[en] Type of Support

[en] Read & Write

[en] Release Notes

[en] Version

[en] Description

[en] v1.2.1

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

  • [en] Requires AMP engine.

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

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

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

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

[en] Known Issues

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

  • [en] 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)

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

[en] v1.1.1

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

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

[en] Known Issue

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

[en] v1.1.0

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

  • [en] Requires AMP engine.

  • [en] Added support for DCM.

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

  • [en] Added support for Google Shared Drives.

  • [en] 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.

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

  • [en] FIPS capable.

[en] Known Issues

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

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

[en] v1.0.0

  • [en] Compatible with Alteryx Designer version 2021.4 and later.

  • [en] Initial release.

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

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

  • [en] Proxy support.

[en] Alteryx Tools Used to Connect

[en] Google Drive Input Tool

Google Drive Tool

[en] Link

[en] Google Drive Output Tool

Google Drive Tool

[en] Link

[en] Data Connection Manager

[en] 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.

[en] Enable AMP Engine

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

[en] Sign In to Google Drive

[en] 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.

[en] Sign In via Internet Browser

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

  2. [en] Select Connect.

  3. [en] Enter your credentials and sign in.

  4. [en] Select Continue to allow access.

[en] Connect through Own Google App

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

  2. [en] Enter Client ID and Tenant ID.

  3. [en] Select Connect.

  4. [en] Enter your credentials and sign in.

  5. [en] Select Continue to allow access.

[en] Custom API Application Setup

[en] For more information on how to build and manage an application with Microsoft Azure cloud services, refer to the Google documentation.

  1. [en] Go to Google Console.

  2. [en] Select Create Project.

  3. [en] Enter a Project name and other information.

  4. [en] Select ENABLE APIS AND SERVICES from the APIs & Services dashboard.

  5. [en] Search for Google Drive API and select it.

  6. [en] Select ENABLE.

  7. [en] Navigate to Credentials and select CREATE CREDENTIALS, then select OAuth client ID.

  8. [en] Select CONFIGURE CONSENT SCREEN.

  9. [en] Select External and select CREATE.

  10. [en] Enter App name, User support email, and Developer contact information.

  11. [en] Select SAVE AND CONTINUE.

  12. [en] When you finish the setup, select PUBLISH APP and then CONFIRM.

  13. [en] Navigate to Credentials and select CREATE CREDENTIALS, then select OAuth client ID.

  14. [en] In Application type, select Web application.

  15. [en] In Authorized redirect URIs, select ADD URI and enter: http://127.0.0.1/

  16. [en] Select CREATE.

  17. [en] The console displays the Client ID and the Client Secret.

: