The  google-spreadsheet  translator is used to connect to a Google Spreadsheet. To use the Google Spreadsheet Translator you need to configure and deploy the Google JCA connector - see the Admin Guide.

The query approach expects the data in the worksheet to be in a specific format. Namely:

• Any column that has data is queryable.

• Any non-string column with an empty cell has the value retrieved as null, otherwise it is the empty string.

• If the first row is present and contains string values, then it will be assumed to represent the column labels.

If you are using a dynamic vdb, the metadata for your Google account (worksheets and information about columns in worksheets) are loaded upon translator start up. If you make any changes in data types, it is advisable to restart your vdb.

The translator supports queries against a single sheet. It supports ordering, aggregation, basic predicates, and most of the functions supported by the spreadsheet query language.

There are no google-spreadsheet importer settings, but it does provide metadata for dynamic VDBs.