Connection parameters

The following table describes the Google Sheets connection parameters you can use in the connect() module method.

Parameter	Description
`SpreadsheetId`	The spreadsheet ID. Use the getspreadsheet() method to obtain the spreadsheet ID.
`RefreshToken`	The refresh token. Follow the instructions in Using the module to obtain a refresh token.
Proxy parameters
`ProxyHostName`	The hostname or IP address of the proxy server
`ProxyPort`	The proxy port
`ProxyUserName`	The username for proxy authentication
`ProxyPassword`	The password for proxy authentication
Other parameters
`HeaderAsColumnName`	Specifies whether to use the first row of a spreadsheet to identify the column names. By default, the standard A-Z column names are used. The possible values are `True` and `False`. The default value is `False`.
`MaxCellLength`	The maximum number of characters in a cell. The default value is `4000` characters.
`PoolId`	The ID of a connection pool that will be used for a particular connection
`DisablePooling`	Disables connection pooling for a particular connection. The possible values are `True` and `False`. The default value is `False`.