Authorize Google Sheets (OAuth2)
Authorize with OAuth 2.0 (Desktop app) and open a connection. Caches a refresh token so later runs reconnect silently.
Overview
Authorize Google Sheets (OAuth2) is a no-code automation step in the Google Sheets category of AutoFlowRPA. It performs its action in a single step when the workflow reaches it. You can configure 5 parameter(s) to control exactly how it behaves. It is one of 369 commands you can drag into a workflow in the visual builder — no scripting required.
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 |
How to use Authorize Google Sheets (OAuth2)
- 1
Open AutoFlowRPA and drag the Authorize Google Sheets (OAuth2) command from the Google Sheets group onto the canvas.
- 2
Set its parameters in the side panel — Authorize Google Sheets (OAuth2) has 5 configurable field(s).
- 3
Connect it into your workflow and press Run. Everything executes locally on your machine.
Frequently asked questions
What does the Authorize Google Sheets (OAuth2) command do?
Authorize with OAuth 2.0 (Desktop app) and open a connection. Caches a refresh token so later runs reconnect silently.
Which group does the Authorize Google Sheets (OAuth2) command belong to?
Authorize Google Sheets (OAuth2) is part of the Google Sheets group. AutoFlowRPA ships with 369+ ready-made commands you can combine without code.
Does the Authorize Google Sheets (OAuth2) command take any parameters?
Yes — Authorize Google Sheets (OAuth2) has 5 configurable field(s), all editable in the visual node editor.
More Google Sheets commands
Ready to automate your busywork?
Start your free 30-day trial today. No credit card, no commitment.