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.

[Kunture90]

I have the same issue. Does anyone knows how to resolve it? I tried to allow to less secured apps connect to gdrive, but still have this issue

[Hayden_McHan]

I have a workflow where I need to output 7 tabs to a singular excel file using the drive output tool. The File and Tab are both fields within the data however I cannot get the tool to output all of the tabs to 1 file. It does FileName, FileName (1), FileName (2), etc. I tried unioning the data into 1 set and letting the tool split it into the tabs, which worked for getting the 7 tabs in 1 file but then each tab has a bunch of blank columns bc each tab is different.

Anyone know how to output 7 tabs to a single file in a better way? I would post the workflow but creds for drive wouldn't save and the input is a DWH query. Thanks in advance!

[lepome]

@Hayden_McHan 

I don't know how the Google Drive thing would affect it, but when you create the fileName/tabs info you can create the item as Path\Filename|||Sheetx, so you can define where everything goes with a standard Output Data tool.  Perhaps you could put that into a batch macro and then create an output of that macro that in turn uploads the whole thing to Google Drive?  (Strictly a conceptual suggestion.  I haven't tested.)

[markspivey]

Can someone from Alteryx confirm whether this connector is configured to handle access to Shared Drives (https://developers.google.com/drive/api/guides/enable-shareddrives)?

Per the documentation, the API call should be sending these query parameters as true:

• includeItemsFromAllDrives — Whether shared drive items should be included in results. If not present or set to false, then shared drive items are not returned.

• supportsAllDrives — Whether the requesting application supports both My Drives and shared drives. If false, then shared drive items are not included in the response.

Currently, we cannot see any shared drive files, although we believe the permission structure should allow us to do so, therefore our question is regarding the implementation of the connector from Alteryx.

[JoshML]

@markspiveyThe current version (1.0.1) doesn't support connectivity to Shared/Team Drives. This functionality is currently slated to be included within the upcoming version of the tool. You can subscribe to this article/page to automatically be notified when a new version is published.

[VojtechT]

A new Beta version of Google Drive 1.1.0 tools is now available. The main changes are DCM support and Shared Drives support. 

[VojtechT]

Hi @Hayden_McHan , that is possible by setting the Sheet name By Field, where you select the field that contains the desired Sheet name. In the same way you can also create multiple xlsx files at once. 

[MB25]

great connector! Is there a way to use a refresh token in order to use this connector on a server?

[Logan_Coffey]

Is there any way to have it maintain the file formatting in the output? Even outputting to a different tab, erases the format in the other tabs. 

[InsperaBI]

Same issue as Logan_C - Overwriting a single sheet erases all formatting and formulas on all other sheets in the same file. 

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

[kc20]

hello all,

I'm getting following error when using Google Drive Input or Output Tool:

Google Drive Input Internal error: Failed to read port assignment

[phackely]

Hi, I created a workflow that uploads 4 out of 5 data sets successfully but 1 data set continually stalls out.

Problem:
The GDrive Tool stalls out (~ 1-2+ hrs), but does not error out, when attempting to output my workflow's largest data set, containing a little over 100k lines.

Question:
1. Is there a row/cell limit to the data sets that can be uploaded using GDrive Tool?
2. Any recommendations using GDrive to upload 100k+ lines?

Linking to previously posted: community topic

[Alan_Yang]

Is there a way to extract the comments and the data associated with the comments from google drive (ex comment in a cell from a google sheet, time stamps, responses ect) 

[maxime-obius]

Hi

I also have the Google Drive Input Internal error: Failed to read port assignment error message.
How can we resolve?

[markspivey]

Thanks for finally updating the Connector to resolve some of the bugs with the Shared Drive functionality.

It seems like if GSHEET is selected as a File Format for a Google Sheets file, there is a 'broken' dropdown whereby no field is available to specify sheet(s) names. But if we compare it to the XLSX format, there is a text input box to define Sheets Selection.

https://streamable.com/pfva3l 

[rafaelloucao]

The current version keeps losing data on Wildcard match when reading from files.

Also, everytime i click in input data, it loses all the information.

If i update something in a google drive folder, the input does not recognize this new file.

[huonggiang295]

Hi will this tool allow schedule refresh on Gallery ?

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