find and import google sheets

[BecclesBen]

Hi

I have hundreds of google sheets and excel files in my google drive and I want to import a sheet called 'SUMMARY' into Alteryx so I can collate the data - is it even possible?!

Thanks

[Raj]

Yes, it's possible to import data from Google Sheets into Alteryx. Alteryx provides an Google Sheets Input tool that can be used to import data from a Google Sheet directly into Alteryx for further processing. You can select the 'SUMMARY' sheet from the list of available sheets in your Google Drive account and import it into Alteryx.

[BecclesBen]

That's great - thank you!

Actually, the google sheets input has been deprecated - which is fine actually, as my files all appear to be XLSX anyway - so I installed the google drive tool.

The files are in subdirectories - sometimes multiple directories down - is there a way to do a search??

[BecclesBen]

ok - I've progressed - my version of Alteryx needed to be updated (I was hitting errors).

Having tried lots of ways to try to find my files I am now hitting the following error:

Any ideas on how to fix?

I appear to be able to import a single file with a specific sheet name just fine, but not multiple using a wildcard and a specific sheet name - any ideas?