Google Drive Tools

[#1]

Google Drive Help Page

Google Drive Input allows you to read files and lists from Google Drive and Google Drive Output allows you to write files to Google Drive. The supported file formats are XLSX, CSV, YXDB, and Google Sheets.

Current version

Google Drive Tool v1.2.1 (June 7, 2023)

• 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)

Previous versions

Google Drive Tool v1.1.1 (January 3, 2023)

• 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.

Google Drive Tool v1.1.0 (December 13, 2022)

• 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 in 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.)

Google Drive Tool v1.0.1 (August 16, 2022)

• Compatible with Alteryx Designer version 2021.4 and later.

• Fixed issue with unverified app which prevented users from logging in.

• Fixed issue with appending to a single sheet. Now, other sheets in document are not affected anymore.

• Added new option to Overwrite (sheet). Now, users can overwrite a single sheet in a document. 

Google Drive Tool v1.0.0 (February 2, 2021)

• 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.

This tool uses a .yxi file format. A .yxi file is a package that includes an Alteryx Tool and all of its dependencies zipped into a single file. When this file is imported into Alteryx, the tool is added to the tool palette in the category specified by the tool.

When sharing a workflow that uses a .yxi tool, the tool is not included and must be installed by the recipient.

[FlorianH]

Hi :)

I successfully installed the Google Drive Tool in my Alteryx, but when I want to connect to a Google Drive via "Sign in Using Web Browser" or "Get Files from URL" this error message appears in the browser:

It says: Google did not verify this app. The app wants to access confidental data in your Google-account. Only use this app when the developer has verified it with Google.

What can I do to solve this issue?

Thanks a lot in advance!

[lepome]

@FlorianH 
Continue on anyway...the underlined word at the bottom left will allow you to proceed.

[maxwarburgh]

Does this support reading and writing from team drives? 

[cgoodman3]

@lepome having a non-Google verified app available on gallery is probably not the best user experience. Also from a corporate customer perspective it would be a big red flag for users, so saying "continue on anyway..." isn't best approach from an information security perspective.

[Hayden_McHan]

Does anyone know how to input a CSV file that does not have delimiters? I have a file that is generated as CSV but everything is in its own cell. I can't upload the file but it looks like a normal excel just as a CSV. Whenever I input the CSV I get 0 records.

[ak2018]

I used the version 1.1.1 and am able to see Shared Drives including Team drives. However, the challenge is that the tool seems glitchy in that it take a long while at times to refresh. I have to kill the Desktop from Task Manager and then save the recovered workflow. 

Additionally, sometimes while trying to drill down subfolders, the tool just reverts back to the root folders/Shared drives. It is very frustrating and annoying. 

Cannot use a functional ID to connect. You can either use your own login or a Client ID/Secret to connect. Haven't yet tested on the server, so cannot comment on that, the reason being that the server instance of the workflow uses a different userID that may or may not have access to the same shared/team drives as the individual running on the desktop. Need a "connect as" option or DCM to run on the server.

[AISHS]

Hi

I was working on workflow where output needs to be saved in Google drive, which is working as expected in Alteryx desktop but the same Workflow is throwing below error in server as "Failed to authenticate". Any help on this is truly Appreciated.