Crystal Docs
English
English
  • Welcome
  • Fundamentals
    • Crystal
    • Crystal Topics
  • Crystal Advisor
    • Access to Crystal
      • Signup
      • Login
      • Discover the Advisor
        • Notifications
        • Account
    • Talk to Your Data
      • Conversation
        • Request Topics
          • Entity-Based Conversation
          • Context Memory
          • Autocomplete
        • Request a Data Analysis
        • Disambiguation
    • Explore Your Data
      • Suggestions
      • Topics Overview
      • Filter Topics
      • Ask Topics
      • Past Questions
      • Change Chart
    • Analyze Your Data
      • Automated Insights
      • Insight Analysis
      • Alerts
        • Anomaly Detection
        • Threshold Monitoring
        • Topic Scheduling
      • Forecasting (Beta)
    • Report and Discuss Your Data
      • Export Topic
      • Share Topic
      • Data Storytelling
    • Customize Your Experience
      • Choose Language
      • Choose Theme
    • Crystal on Mobile
      • Siri & Shortcuts
    • Crystal on Microsoft Teams
      • Download Crystal on Teams
  • Crystal Console
    • Configure Crystal
      • Discover the Console
      • Choose Project Settings
      • Prepare Your Data
    • Create Topics
      • Topic Creation: Overview
      • Topic Creation: Connect
        • Supported Data Sources
        • Supported Data Fields
        • Manage Data Sources
        • Tutorials for Specific Data Sources
          • Connect Google Sheets
          • Connect Google BigQuery
          • Build a Web Connector
      • Topic Creation: Configure
        • Objectives and Visualizations
        • Data Binning
        • Configure Custom Entities
        • Configure Key Values
        • Modify Data Table
      • Topic Creation: Filter
      • Topic Creation: Train
      • Topic Creation: Topic Details
      • Topic Creation: Set Permissions
      • Topic Creation: Review and Publish
      • Specifc Visualizations Guides
        • Build a List Table
        • Build a Single Line Chart
        • Build a Multi-Line Chart
        • Build a Ranking Table
      • Topic Creation: Custom Topic Titles
      • Topic Statuses
      • Data Preview
      • Manage Your Entities
    • Manage Users
      • Discover the Users Area
      • Invite Users to Crystal
        • Invite Users Manually
        • Invite Users via Identity Providers
          • Enable the Microsoft Identity Provider
          • Enable the Google Identity Provider
      • Create and Manage Groups
      • Manage Permissions
  • Limitations
    • Limitations on Crystal Advisor
    • Limitations on Crystal Console
  • Support
    • Support on Crystal Advisor
    • Support on Crystal Console
  • Release Notes
    • 2024
      • Crystal Web
        • Crystal Web v2.59
        • Crystal Web v2.58
        • Crystal Web v2.57
        • Crystal Web v2.56
      • Crystal Mobile
        • Crystal Mobile v3.1.7
        • Crystal Mobile v3.1.6
        • Crystal Mobile v3.1.5
        • Crystal Mobile v3.1.4
        • Crystal Mobile v3.1.3
        • Crystal Mobile v3.1.2
        • Crystal Mobile v3.1.1
        • Crystal Mobile v3.1.0
        • Crystal Mobile v3.0.39
        • Crystal Mobile v3.0.38
    • Archive
      • 2023
        • Version 2.55
        • Version 2.54
        • Version 2.53
        • Version 2.52
        • Version 2.51
        • Version 2.50
        • Version 2.49
        • Version 2.48
        • Version 2.47
        • Version 2.46
        • Version 2.45
        • Version 2.44
        • Version 2.42
        • Version 2.41
        • Version 2.40
        • Version 2.39
        • Version 2.38
      • 2022
        • Version 2.37
        • Version 2.35
        • Versions 2.29-2.30
        • Versions 2.27-2.28
        • Version 2.26
        • Versions 2.24-2.25
        • Version 2.23
        • Version 2.22
        • Version 2.21
        • Version 2.20
        • Version 2.19
        • Version 2.18
        • Version 2.17
      • 2021
        • Version 2.15
        • Version 2.14
        • Version 2.13
        • Version 2.12
        • Version 2.11
        • Version 2.10
        • Version 2.9
        • Version 2.8
        • Version 2.7
        • Version 2.6
        • Version 2.5
        • Version 2.4
        • Version 2.3
        • Version 2.2
        • Version 2.1
Powered by GitBook
On this page
  • Google API configuration
  • Create service account
  • Data source configuration on crystal Self-Service console
  • Google Sheets Oauth Authentication

Was this helpful?

  1. Crystal Console
  2. Create Topics
  3. Topic Creation: Connect
  4. Tutorials for Specific Data Sources

Connect Google Sheets

This page is currently under review. Stay tuned!

PreviousTutorials for Specific Data SourcesNextConnect Google BigQuery

Last updated 1 year ago

Was this helpful?

You can now connect Google Sheets spreadsheets as data source in your crystal project using Google user’s account.

In order to configure Google Sheets as a datasource, you will need to enable the Google Drive and Google Sheets APIs and to create a Service Account on GCP console. All the required configurations steps are explained in details in the following sections of this article.

Let’s get started!

Google API configuration

Sign in the Google Cloud platform and go to the . Select the related GCP Project and then on the left sidebar menu of the GCP Console select APIs and Services and then Library.

In the opened menu search for Google Sheets and select the Google Sheets API.

Click on Enable button to activate the Google Sheets API for the current project.

Once you activated the Google Sheets API, be back to the search, look for the Google Drive and select the Google Drive API.

Click on Enable button to activate the Google Drive API for the current project.

Now, when the required APIs are enabled, it is needed to create a service account and connect it. Let’s see how you can do it on the GCP Console.

Create service account

From the top menu, select Create Credentials and then choose option Service Account.

In the opened form fill in the Service account name, then click on Create and continue and continue the setup skipping all the optional steps.

Now find the Service Account you just created in the list of service accounts and open its link.

Then go to the Keys tab.

Click on Add Key and then select Create new key.

In the opened menu select the JSON format and then click Create. This will automatically download the JSON service account file needed for the following setup with crystal.

Data source configuration on crystal Self-Service console

Once the previous steps on Google Cloud Platform are performed, it is time to connect Google Sheets to your crystal project. To do so, open Self-service console and click on Data Source Management.

Click on Connect new data source at the bottom of the screen and in the opened section choose Google Sheets.

In order to fill in the fields in the opened menu, you will need the service account file downloaded previously. Open the JSON file and put the information inside of the form, then click Test and connect.

After the datasource has been successfully connected, you will need to manually share your spreadsheets with the service account's email.

To do so, open every Google Sheet you would like to connect to crystal project, click on Share and enter the client email which you can find in the JSON file.

“Viewer” permissions are enough grant for allowing crystal to access the spreadsheets

Once it is done, the spreadsheets you shared with client email will be showed up in the collection of tables in the first step of topic creation.

Google Sheets Oauth Authentication

You can connect your Google Sheets by simply signing-in with your Google account.

To do that, select Google Sheets in the Add new data source menu:

A new window will prompt with two options: Manual Authentication or Oauth Authentication. Select the second one, then click on Next:

Sign-up with your Google account to connect your Google Sheets. A new window will prompt-up, allowing you to select both Date (dd/MM/yyy) and Locale (local time zone format).

You can also set your Data source name. Therefore, click on Test and connect to proceed:


Login into the and be sure to select the correct project. From the sidebar menu, select APIs and services and then select Credentials.

GCP Console
GCP console