Google Sheets

Discover more about the Google Sheets connector and how to use it on the Digibee Integration Platform.

The content of this documentation is under revision and may change. We appreciate your understanding as we work to improve it.

Google Sheets manages spreadsheets in Google Sheets.

Parameters

Take a look at the configuration parameters for the connector. Parameters supported by Double Braces expressions are marked with (DB).

General tab

Parameter	Description	Default value	Data type
Dynamic Account	When active, the connector will use the account dynamically. Otherwise, it will use the account statically.	False	Boolean
Account Name (DB)	The name of the dynamic account used by the connector. This account must have been previously configured in a Store Account connector in the pipeline for this process to take effect. It is only available if the Dynamic Account parameter is active.	N/A	String
Account	The account used by the connector. It is only available if the Dynamic Account parameter is inactive.	N/A	Account
Api Name	The operation to perform.	N/A	String
Method Name	The sub-operation to use for the selected operation.	N/A	String
Fail On Error	If the option is activated, the pipeline's execution with an error will be interrupted. Otherwise, the pipeline execution proceeds, but the result will show a false value for the "success" property.	False	Boolean

Optional tab

Parameter	Description	Default value	Data type
Application Name (DB)	Google Sheets application name. Example would be digibee-google-sheets/1.0	N/A	String
Client Id (DB)	Client ID of the sheets application.	N/A	String
Delegate (DB)	Delegate for wide-domain service account.	N/A	String
In Body (DB)	Sets the name of a parameter to be passed in the exchange In Body.	N/A	String
Scopes (DB)	Sheets scopes.	N/A	JSON

Documentation tab

Parameter	Description	Default value	Data type
Documentation	Section for documenting any necessary information about the connector configuration and business rules.	N/A	String