Google Sheets Source Provider

The Google Sheets Source feeds data from Google Sheets supporting Records query.

Settings

Setting	Description	Default
Name	The name that will identify this source instance.
Default Cache Time	The default duration in seconds before the cache is renewed, set to 0 to disable caching. This setting can be overriden in each query configuration.	3600

Setting	Default	Description	Required
Account		The Google Account which to authenticate with.	✓
Spreadsheet		The spreadsheet which to retrieve the data from.	✓
Sheet	Default	The spreadsheet sheet which data to create the source with.
Start Column	A	The starting column to restrict the sheet data with.
End Column	Z	The ending column to restrict the sheet data with.

Records Query

Fetches records from the spreadsheet and resolves to a dynamically generated list of record type based on the sheet schema.

Setting	Default	Description
Start	1	The offset applied to the query.
Quantity	20	The limit applied to the query.
Cache	3600	The duration in seconds before the cache is invalidated and the query re-executed.