You can now connect to Google Sheets using OAuth. Just log in with your Google account to connect—there’s no need to issue a service account or configure sharing settings.
Once connected, you can use any spreadsheet your account has access to for building dashboards and analyzing data. The connection is read-only, so your original spreadsheets stay safe from unintended changes.
See other update here.