Google Drive

Version:

2023.1

Last modified: June 07, 2023

Connection Type	Alteryx Tool. The latest version is available from the Alteryx Community.
Type of Support	Read & Write

Release Notes

Version	Description
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 Issue 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

Link

Google Drive Input Tool

Link

Google Drive Output Tool

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

In Create New Connection, select Sign In Using Internet Browser.
Select Connect.
Enter your credentials and sign in.
Select Continue to allow access.

Connect through Own Google App

In Create New Connection, select Sign In Using Internet Browser and check Connect through own Google App.
Enter Client ID and Tenant ID.
Select Connect.
Enter your credentials and sign in.
Select Continue to allow access.

Custom API Application Setup

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

Go to Google Console.
Select Create Project.
Enter a Project name and other information.
Select ENABLE APIS AND SERVICES from the APIs & Services dashboard.
Search for Google Drive API and select it.
Select ENABLE.
Navigate to Credentials and select CREATE CREDENTIALS, then select OAuth client ID.
Select CONFIGURE CONSENT SCREEN.
Select External and select CREATE.
Enter App name, User support email, and Developer contact information.
Select SAVE AND CONTINUE.
When you finish the setup, select PUBLISH APP and then CONFIRM.
Navigate to Credentials and select CREATE CREDENTIALS, then select OAuth client ID.
In Application type, select Web application.
In Authorized redirect URIs, select ADD URI and enter: http://127.0.0.1/
Select CREATE.
The console displays the Client ID and the Client Secret.