Source Providers
Google Sheet Source
Content Source based on Google Sheet.
The Google Sheet Source feeds data from a Google Sheet spreadsheet. Based on the multi-instance source workflow it allows connecting to multiple accounts with different configurations.
Settings
The source settings determines the content structure, every time the instance is saved the structure will be regenerated.
| 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. |
The following settings are common to all source instances.
| Setting | Default | Description |
|---|---|---|
| Name | Google Sheet | The name that will identify this source instance. |
| Default Cache Time | 3600 | 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. |
Content Structure
Be cautious, changing certain settings of an instance might affect it content structure and break existing content mappings.
Authentication
Authentication is based on the OAuth protocol driven by the Google OAuth Driver.
Content Queries
For every source instance the following content queries will be made available as Dynamic Content option.
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. |