Authorize Google Sheets (OAuth2)
Authorize with OAuth 2.0 (Desktop app) and open a connection. Caches a refresh token so later runs reconnect silently.
Google SheetsGoogleSheetsConnect
What it does
Authorize with OAuth 2.0 (Desktop app) and open a connection. Caches a refresh token so later runs reconnect silently.
Parameters
| Parameter | Type | Required | Default | Description |
|---|---|---|---|---|
| Connection name | variable | Required | sheets | Name of the connection created by Authorize. |
| client_secret.json (optional) | file | Optional | OAuth Desktop-app client file from Google Cloud. Leave blank to use Client ID + Secret below. Example: C:/keys/client_secret.json Supports variables | |
| Client ID (optional) | string | Optional | Used if no client_secret.json is given. Supports variables | |
| Client Secret (optional) | string | Optional | Supports variables | |
| Token cache file (optional) | file | Optional | Where to store/load the OAuth token. Default: %APPDATA%/AutoFlowRPA/gsheets_token_<connection>.json Supports variables |
More Google Sheets commands
Ready to automate your busywork?
Start your free 10-day trial today. No credit card, no commitment.