Sheet names do not appear when connecting to my google sheets. I tried using sheet numbers but if someone adds a sheet then the numbers change so isn't sustainable. Anyone else with this issue?
I think it depends on the type of login you use, as described in this article
https://community.alteryx.com/t5/Alteryx-Knowledge-Base/The-How-to-Guide-to-Google-Sheets/ta-p/20354
Might this be a solution for you?