Google Drive Input Tool -- Invalid Extension Error

Question

Hi there,

We're trying to read in several gsheets through the google drive input tools. We're able to successfully connect and navigate to the files we want to read in. However, once we run the workflow, some of the tools work as expected while others give an "Invalid Extension Error" and the configuration window will say that there's no such file or directory -- which we know to be incorrect since we selected the file through the tool. When we run the workflow again, some of the tools that previously errored will work as expected while others will error. We're on 2024.2 of Alteryx Designer Desktop and the latest version of the google drive tools.

Has anyone experienced this error and have any solutions?

apathetichell · Answer

Here's the issue --- the google drive tool is unarguably one of --- and in my opinion --- the single worst Alteryx tool. My hunch is that you are seeing this because the file types you are trying to read in are not of the four types of files which Alteryx is set up to read in. Is this a google drive limitation? nope. Did they implement gsheet logic well? nope.

My recommendation would be ---> go to GCP --- get your own oauth clientid/client secret. Ask claude how to oauth to Google drive in Python. Build your own client. ignore the Alteryx version.

jrgo · Answer

Hi @dmpope

If you run just one of those tools that's erroring in its own workflow, does it continue to error?

Did you review all the options in the "Configure File" tab to make sure that there isn't anything that wasn't auto set?

Lastly, did you copy/paste the file path into the tool or did you select it from a list? I ask because in your second screenshot, the "Select File" section is showing empty. In the tools help doc, it does have a "Caution" that suggests a configuration may not set if you don't actually click or press the enter button.