Hi, we always have issues with the Google Sheet Reader using Web Connection due to company extra 2-step authentication and a security key to "authorize" a browser to sign in.

So there is a Google Drive Desktop App, after you installed on a PC, you can map the google drive as a network drive (eg, K:) and you can see the Google Drive content in Windows File Explorer, is there anyway that FME reader can read the google sheet BY browsing the file directory instead of using Web Connection. thanks!