Google Sheets Connection

Connect to Google Sheets to use Google Sheets Read, Append, Update, and Clear nodes in your workflows.

Configuration

Field	Description	Required
Client ID	Your Google OAuth 2.0 Client ID	Yes
Client Secret	Your Google OAuth 2.0 Client Secret	Yes
Refresh Token	A long-lived refresh token for offline access	Yes

Setting Up Google OAuth Credentials

To connect to Google Sheets, you need to create OAuth 2.0 credentials in the Google Cloud Console and obtain a refresh token.

Step 1: Create a Google Cloud Project

1. Go to the Google Cloud Console
2. Create a new project (or select an existing one)
3. Navigate to APIs & Services > Library
4. Search for and enable the Google Sheets API
5. Also enable the Google Drive API (used for connection testing)

Step 2: Create OAuth 2.0 Credentials

1. Go to APIs & Services > Credentials
2. Click Create Credentials > OAuth client ID
3. If prompted, configure the OAuth consent screen first:
   • Choose External for testing or Internal for Google Workspace
   • Fill in the required fields (app name, user support email, developer email)
   • Under Test users, add the Google account email you will use to authorize — without this, you will get a 403 "access_denied" error during authorization
4. Select Web application as the application type
5. Add https://developers.google.com/oauthplayground as an authorized redirect URI
6. Copy the Client ID and Client Secret

Step 3: Obtain a Refresh Token

1. Go to the OAuth 2.0 Playground
2. Click the gear icon (settings) in the top right
3. Check Use your own OAuth credentials
4. Enter your Client ID and Client Secret
5. In the left panel, select the following scopes:
   • Google Sheets API v4 → https://www.googleapis.com/auth/spreadsheets
   • Google Drive API v3 → https://www.googleapis.com/auth/drive.readonly (required for connection testing)
6. Click Authorize APIs and sign in with your Google account
7. Click Exchange authorization code for tokens
8. Copy the Refresh Token

Step 4: Create the Connection

1. In the workflow automation platform, go to Connections
2. Click Add Connection
3. Select Google Sheets as the type
4. Enter your Client ID, Client Secret, and Refresh Token
5. Click Test Connection to verify

WARNING

Refresh tokens can expire if the OAuth consent screen is in "Testing" mode and the token has not been used for 7 days. To avoid this, either publish your OAuth app or use a Google Workspace account with the consent screen set to "Internal".

Usage

Once created, this connection becomes available in all Google Sheets nodes:

• Google Sheets Read
• Google Sheets Append
• Google Sheets Update
• Google Sheets Clear