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:
|
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.