Welcome to the Gallery. Please feel free to post and comment, and check out our FAQ!

Community Gallery

Post, download, and share all of your favorite tools and workflows — from Alteryx supported to user-built.
Comments
FlorianH
7 - Meteor

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:

 

FlorianH_0-1644256339035.png

 

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!

LisaL
Alteryx
Alteryx

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

maxwarburgh
5 - Atom

Does this support reading and writing from team drives? 

cgoodman3
13 - Pulsar
13 - Pulsar

@LisaL 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.

 

cgoodman3_0-1647425061924.png

 

Hayden_McHan
7 - Meteor

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
5 - Atom

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

3.PNG

Hayden_McHan
7 - Meteor

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!

LisaL
Alteryx
Alteryx

@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
5 - Atom

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
Alteryx
Alteryx

@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
Alteryx
Alteryx

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
Alteryx
Alteryx

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
6 - Meteoroid

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