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.