The GoogleSheets data integration polls a Google Sheet for stats data on an interval. Setup fields below are configured per Show in the PV4 Portal (Show → Data Integrations); field descriptions are transcribed from the Portal setup screen. Required fields are marked.
Fields
|
Field |
Required |
Type |
Default |
Description |
|---|---|---|---|---|
|
Stats Enabled |
|
Boolean |
None |
Is the stats provider enabled for the Orchestrator. |
|
Credentials |
Required |
String |
None |
Stringified JSON credentials. |
|
Scope |
Required |
String |
None |
What scope the credentials have access to. |
|
Sheet ID |
Required |
String |
None |
The ID of the Google Sheet. Can be found in the URL when viewing the sheet. |
|
Sheet Ranges |
Required |
String |
None |
Comma-delimited string of ranges to access, e.g. |
|
Poll time (ms) |
|
Number |
None |
How long between polls of the Google Sheet. |