Google Drive Input Tool cannot pull any data

[JHope]

I had a workflow running using the Google Sheets Tool (an old version), but was forced to upgrade the tool. After installing the latest Good Drive Input tool, I was able to select the file, and tab, but upon running the flow, it will simply stalls, and never finds any data. I've left it run for up to an hour... no success (the flow used to take 30-45s).  Is the most recent version stable?

[apathetichell]

there's a whole slew of reasons why this can happen. 1) --- what happens when you go through oauth? the most common reason this would happen is that you did not grant enough access to the gdrive tool via oauth (note to anyone at Alteryx with power --- swapping from a gsheets standalone to a gdrive total tool makes no sense from a security perspective.) --- 2) are you using a standalone gcp client you create --- or Alteryx's --- I'd recommend getting your own GCP oauth client for this tool if you have any kind of GCP/goolge workspace presence.

I'd start by adding this tool to a blank workflow and going through oauth again. See how it works. If you still can't find anything--- and you are sure you are allowing the expanded gcp scopes --- maybe talk to your security team.?

[JHope]

Thank you for the suggestions - I will be trying them when I have some free time.

I had to design a workaround... discovered GSheets has a handy ?export switch that can be used to download the file simply by typing a hyperlink. I spun up a script to drop the file to local drive, then picked it up into my workflow.