Set this property to initiate the process to obtain or refresh the OAuth access token when you connect.

Syntax

Connect-GoogleSheets -InitiateOAuth string

Possible Values

Data Type

cstr

Default Value

"OFF"

Remarks

The following options are available:

1. OFF: Indicates that the OAuth flow will be handled entirely by the user. An OAuthAccessToken will be required to authenticate.
2. GETANDREFRESH: Indicates that the entire OAuth Flow will be handled by the cmdlet. If no token currently exists, it will be obtained by prompting the user via the browser. If a token exists, it will be refreshed when applicable.
3. REFRESH: Indicates that the cmdlet will only handle refreshing the OAuthAccessToken. The user will never be prompted by the cmdlet to authenticate via the browser. The user must handle obtaining the OAuthAccessToken and OAuthRefreshToken initially.