ThoughtSpot Google Sheets add-ons

There are two ThoughtSpot add-ons for Google Sheets aimed at different audiences. This article describes how each works, and how you can use them together.

ThoughtSpot Analytics for Google Sheets™

ThoughtSpot Analytics for Google Sheets is a free add-on that lets you use the power of ThoughtSpot to search, and create charts and visualizations from your spreadsheet data.

Display of an analytics chart in ThoughtSpot Analytics for Google Sheets

Details

  • No ThoughtSpot license required

  • No data modeling required

  • Query your data with search

  • Drill anywhere

  • Easy internal navigation

  • Pin to Slack, Google Sheets and Google Slides

First-time setup

  1. Download ThoughtSpot for Google Sheets.

  2. In Google Sheets, open a sheet with data organized in columns and rows.

  3. Select Extensions > ThoughtSpot > Launch.

    A message appears indicating the add-on needs permission to run.

  4. Click Continue and authenticate using your Google account.

    A message appears indicating ThoughtSpot wants access to your Google account.

  5. Click Allow.

  6. Select Extensions > ThoughtSpot > Launch again.

    The ThoughtSpot search bar and data panel appear.

  7. Analyze your data using the ThoughtSpot search bar, or by clicking items in the data panel.

Inline Getting started

ThoughtSpot Connected Sheets™

ThoughtSpot Connected Sheets is an add-on that allows you to connect to a ThoughtSpot instance, pull data directly into a Google Sheet from trusted data sources connected to that instance (like Snowflake, Google BigQuery™, DataBricks, and others), and use the tools in Google Sheets™ for ad-hoc analysis.

A google spreadhseet displaying ThoughtSpot add-in in the right sidebar

Details

  • Requires a ThoughtSpot license and an email linked to a ThoughtSpot user ID

  • Requires the Can download data privilege in ThoughtSpot to use this add-on, and to export ThoughtSpot data into your Google Sheet

  • You can sign up for a ThoughtSpot free trial to use this add-on

  • Embeds insight into Google Sheets

  • Allows you to push the ThoughtSpot data model to Sheets for exploration

  • Only compatible with ThoughtSpot Cloud

First-time setup

  1. Download ThoughtSpot Connected Sheets.

  2. Select Extensions > ThoughtSpot Connected Sheets > Get data from ThoughtSpot.

    The ThoughtSpot Search bar and data panel appear.

  3. Enter the URL of your ThoughtSpot instance, or click the free trial link if you do not have an instance.

    If you chose the free trial option, you’ll come back to this page after you sign up and enter your free trial instance.

  4. Click Continue.

  5. Sign in to your ThoughtSpot instance using your ThoughtSpot username and password or SSO.

  6. Analyze your data using the ThoughtSpot search bar, or by clicking items in the data panel.

    Use with ThoughtSpot Analytics for Google Sheets

    Once your data is in Sheets, you can use our free companion add-on, ThoughtSpot Analytics for Google Sheets, to easily create charts, visualizations, get AI-insights, and share with others using Google Slides™, Slack, and more.