Google Sheets

Connect Sola and Google Sheets to get security insights

Overview

The Google Sheets integration allows you to bring any spreadsheet data into Sola in real time.

Connect any Google Sheet to Sola and query your data directly, from user access records and asset inventories to compliance trackers, security context and investigation, and more.

Google Sheet names are currently supported in English only. Support for additional languages is not yet available. Data in your sheets can be in any language.

Your data can only be retrieved, never modified.

Once connected, your data is securely stored, and access is restricted to retrieving configurations and metadata only. Authentication methods ensure secure delegation of permissions while maintaining data integrity.

Set up Google Sheets data source integration with Sola

Go to Integrations > Data Sources > click New data source > select Google Sheets.

The Sola wizard will take you through the steps.

Set up Google Sheets ->

Connect Google Sheets to Sola

To connect Google Sheets, you'll need a Google account with access to the spreadsheet you want to connect.

Google OAuth

This method uses Google OAuth to securely grant Sola read-only access to your Google Drive.

About Google Drive permissions Sola uses read-only access and never edits, creates, or deletes anything in your Google Drive. When connecting, Google's consent screen shows edit, create, and delete access. This is the drive.file scope, the least privileged scope Google makes available for this integration.

Permissions are granted from the file picker in the Sola wizard. Sola can only access the specific file you select. Files you do not pick are never accessible, even if they are in the same folder or Drive.