google sheets URL read in to alteryx

[bb213]

How do I read in Google Sheets data directly from a URL? The sheets are not password protected.  Thanks. 

[joshuaburkhow]

You would still need to access them from an API I believe, because authentication to a google user still needs to happen 😉 

There is a google sheets tool in the gallery here: https://gallery.alteryx.com/#!app/Google-Sheets-Tools/5952d212a18e9e0e48a0cafe 

Hope this helps! If it does please mark as solved so others can benefit 🙂 

[bb213]

I need to authenticate as a google user to access a public google docs url?