Google Sheets

Google Sheets is an online table processor which allows you to organize, edit, and analyze different types of information using spreadsheets. For more detailed information, please refer to the official documentation, and for API docs and samples, to the API documentation.

To use the connector, you need your OAuth2 credentials from the Google Cloud console. For a step-by-step guide, please see the dedicated subpage.

API

Description

Google Spreadsheet Write APIs

Google Spreadsheets Write APIs allow you to:

Export report data from a table to a spreadsheet. Create and store a spreadsheet at the specified folder.
Replicate data from table to a spreadsheet.
Replicate data from spreadsheet, CSV or txt hosted at GDrive to a table

How to Connect

There are two ways to connect to Google Sheets: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the Google Sheets button in the list of connectors or type ‘google’ in the search field and select it:

3. Enter the data source name, click Sign in with Google, and follow the instructions:

Usage

The Google Sheets API connector introduces a new virtual schema google_spreadsheets that contains the following stored procedures:

In addition to these public API procedures, there is the google_spreadsheets_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all example views directly by dropping google_spreadsheets_examples.