Sync data from ThoughtSpot to Google Sheets

Use ThoughtSpot Sync to connect ThoughtSpot to your Google account and deliver CSV tables directly to Google Sheets.

Sync to Google Sheets from an answer

To create a sync to Google Sheets from an answer, follow these steps:

  1. Select the desired answer from the Answers tab or the ThoughtSpot homepage. You must have Can manage sync permissions and view access to an answer to create a sync.

  2. In the upper-right corner of the answer, select the more options menu icon icon more 10px. From the drop-down menu, select Sync to Google Sheets.

    You cannot create a sync from an unsaved answer. If the Sync to Google Sheets option appears grayed-out in the menu, first save the answer before trying again.
  3. If this is the first sync you have created for Google Sheets, a pop-up authorization window appears. To give ThoughtSpot permission to send data to your Google Sheets account, click Sign in with Google, select your account, and click Allow.

    ts sync permission sheets

  4. Within ThoughtSpot, fill in the following parameters:

    • Edit the Pipeline name if needed. By default, this field populates with PL-[Answer Name].

    • If you have more than one Google destination set up, then the Destination field appears, and you must select a Google destination from the drop-down available. However, if no destinations have been set up before or if you have only one Google destination, the Destination field does not appear.

    • Select File name from the drop-down menu.

    • Select Sheet name from the drop-down menu.

    • Enter the Cell number in A1 format.

      ts sync sheets param

  5. By default, “Sync and save” is selected. Click Save to send your data to Google Sheets. Your data immediately appears in the Sheet you specified.

Sync to Google Sheets from a Custom SQL View

To sync to Google Sheets from a custom SQL view, follow these steps:

  1. Navigate to your SQL view by clicking the Data tab and searching from the Data Workspace home page. Select the SQL view name.

  2. In the top right corner, click the more options menu icon icon more 10px and select Sync to Sheets.

  3. If this is the first sync you have created for the selected app, an authorization page appears. To give ThoughtSpot permission to send data to your Google Sheets account, click Sign in with Google, select your account, and click Allow.

  4. Fill in the following parameters:

    • Edit the Pipeline name if needed. By default, this field populates with PL-[Answer Name].

    • If you have more than one Google destination set up, then the Destination field appears, and you must select a Google destination from the drop-down available. However, if no destinations have been set up before or if you have only one Google destination, the Destination field does not appear.

    • Select File name from the drop-down menu.

    • Select Sheet name from the drop-down menu.

    • Enter the Cell number in A1 format.

  5. By default, “Sync and save” is selected. Click Save to send your data to Google Sheets. Your data immediately appears in the Sheet you specified.

Sync to Google Sheets from the Data Workspace

To create a sync to Google Sheets from the Data Workspace, follow these steps:

  1. Click the Data tab.

  2. On the left menu bar, select Sync.

  3. Under the Pipelines tab, select Create new pipeline. Note that if you do not already have a destination created to the intended destination app, you first need to create one in the Destinations tab.

  4. Fill in the following parameters:

    • Edit the Pipeline name if needed. By default, this field populates with PL-[Answer Name].

    • All destinations available appear in the Destination drop-down.

    • Select your Source data. Here, you choose an answer or a custom SQL view to send through sync.

    • Select File name from the drop-down menu.

    • Select Sheet name from the drop-down menu.

    • Enter the Cell number in A1 format.

  5. By default, Sync and save is selected. Click Save to send your data to Google Sheets. Your data immediately appears in the Sheet you specified.

Manage pipelines

While you can also manage a pipeline from the Pipelines tab in the Data Workspace, accessing the Manage pipelines option from an answer or view displays all pipelines local to that specific data object. To manage a pipeline from an answer or view, follow these steps:

  1. Click the more options menu icon icon more 10px and select Manage pipelines.

  2. Scroll to the name of your pipeline from the list that appears. Next to the pipeline name, select the more options icon icon more 10px. From the list that appears, select:

    • Edit to edit the pipeline’s properties. For a pipeline to Google Sheets, you can edit the pipeline name, destination, file name, sheet name, or cell number.

    • Delete to permanently delete the pipeline.

    • Sync now to sync your answer or view to the designated destination.

    • View run history to see the pipeline’s Activity log in the Data Workspace.

      ts sync manage pipelines