Google Sheets

This is the implementation of the Google Sheets data handler for MindsDB.

Google Sheets is a spreadsheet program included as a part of the free, web-based Google Docs Editors suite offered by Google.

​

Prerequisites

Before proceeding, ensure the following prerequisites are met:

1. Install MindsDB locally via Docker or Docker Desktop.
2. To connect Google Sheets to MindsDB, install the required dependencies following this instruction.
3. Install or ensure access to Google Sheets.

​

Implementation

This handler is implemented using duckdb, a library that allows SQL queries to be executed on pandas DataFrames.

In essence, when querying a particular sheet, the entire sheet is first pulled into a pandas DataFrame using the Google Visualization API. Once this is done, SQL queries can be run on the DataFrame using duckdb.

The required arguments to establish a connection are as follows:

• spreadsheet_id is the unique ID of the Google Sheet.
• sheet_name is the name of the sheet within the Google Sheet.

​

Usage

In order to make use of this handler and connect to a Google Sheet in MindsDB, the following syntax can be used:

CREATE DATABASE sheets_datasource
WITH
    engine = 'sheets',
    parameters = {
      "spreadsheet_id": "12wgS-1KJ9ymUM-6VYzQ0nJYGitONxay7cMKLnEE2_d0",
      "sheet_name": "iris"
    };

You can use this established connection to query your table as follows:

SELECT *
FROM sheets_datasource.example_tbl;

The name of the table will be the name of the relevant sheet, provided as an input to the sheet_name parameter.