The Connected Sheets docs say that there’s a max row limit of 100k rows, but when connecting a Look to a GSheet it’s still not downloading more than 5k rows. The user definitely has download_without_limit permission so I’m not sure what’s going on. I’m not seeing any other config parameters to change on either the Looker or GSheets side either.
The 5,000-row limit persists because “Connect to Look” inherits the saved Look’s browser limit, whereas the 100,000-row capacity is exclusive to “Connect to Explore” (Pivot Tables). To fix this, connect directly to the Explore instead of a saved Look, and ensure you aren’t using Table Calculations, which disable the streaming required for large datasets.