community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
New Data Science Blog

Check out the latest post: All Models Are Wrong

READ MORE

Welcome to Alteryx Connect

Atom

I am having an issue with getting a specific google file to be input into Alteryx. When I sign into to my account, there are only certain random files being pulled in and none of them are the one I'm looking for. The file is a part of a folder shared with my team, but I have included that folder in "My Drive". Is there a way to fix this?

Alteryx
Alteryx

Hi, @EFred12,

 

What type of file is this? Are you using the Google Sheets Tools found in the Data Sources District?

Atom

It's an excel file in drive. And yes I'm using the google sheets input tool. Do I need to convert it to a google sheet in order for it to pull in?

Alteryx
Alteryx

When I log into the Google Sheets Tool, I can only see actual Google Sheets as well. I have many xlsx files available in My Drive, but the tool only picks up the .gsheet files.

 

This looks to be a limitation of the Google Sheets API, as you would need to use an Excel interpreter to read an XLSX file across the API as well. I'm not saying that there isn't a work-around, but I can't find one with a quick scan.