Skip to main content
For using the integration, see Google Sheets.

​
Enable Google SSO

To authenticate Google users, first you need to enable Google SSO on your server. If you still want to keep users to login via email/password or another SSO provider, set AUTH_GOOGLE_ENABLED=false. This hides Google as a login option while still allowing the Google Sheets integration to work. Lightdash requests the necessary OAuth scopes -drive.file and spreadsheets (optional) when users connect to Google Sheets.

​
Create an API key for Google file picker

We use Google Drive picker API to allow you to select your spreadsheet files on Syncs To create a Google Drive picker API you need to add a new API key in APIs and services in Google Cloud. Your Google project must have the following API’s enabled:
  • Google Picker API
  • Google Sheets API
Save the API key in a new environment variable GOOGLE_DRIVE_API_KEY

​
Allow access from Google’s infrastructure

The Google Sheets add-on sends its sign-in and query requests from Google’s Apps Script infrastructure, not from users’ browsers, so your instance needs to be reachable from outside your network, not only from your users. See Sign in with your Lightdash account for details.