Very weird! So when you Create a new Google Sheets resource > Connect to Google Sheets > Authorize your current user > do you then see this "Choose an account" screen? This is where you can choose the Google account to connect to