BusyBot
Search all guides

Reference · Credentials

Connect the Google Sheets trigger to BusyBot

Used by 1 BusyBot node.

Type googleSheetsOAuth2 5 fields

Fields

FieldTypeRequiredNotes
Access Token
accessToken		 password Yes Google OAuth2 access token with Sheets and Drive API scopes
Refresh Token
refreshToken		 password Yes Google OAuth2 refresh token for automatic renewal
Client ID
clientId		 string Yes Google OAuth2 client ID from the Google Cloud Console
Client Secret
clientSecret		 password Yes Google OAuth2 client secret from the Google Cloud Console
Token Expiry (Unix timestamp)
expiresAt		 string No Unix timestamp (seconds) when the access token expires. Managed automatically after refresh.

Setting up Google Sheets OAuth2

  1. In Google Sheets OAuth2, create the credential this connection needs — the values listed in the table above. These are issued from your own Google Sheets OAuth2 account, usually under its developer, API or integrations settings.
  2. In BusyBot, open Credentials → Add credential and choose Google Sheets OAuth2.
  3. Paste each value into the matching field and save.
  4. Add the Google Sheets Trigger node to a workflow, select this credential, and run a simple operation to confirm it authenticates.

Security

  • Secret values are encrypted at rest with AES-256-GCM, never written to logs, and readable only by your own account (to edit them).
  • Grant the minimum scopes or permissions the operations you actually use require.
  • Rotate the credential periodically, and immediately if it may have been exposed.
  • Credentials are scoped to your account — a workflow cannot use another account's.

Frequently asked questions

Which BusyBot nodes use Google Sheets credentials?

One node: Google Sheets Trigger. Create the credential once and select it in that node.

What does a Google Sheets credential need?

5 fields: Access Token, Refresh Token, Client ID, Client Secret, Token Expiry (Unix timestamp). Required: Access Token, Refresh Token, Client ID, Client Secret. The values come from your own Google Sheets account.

How are Google Sheets secrets stored?

Secret values are encrypted at rest with AES-256-GCM, never written to logs, and scoped to your account: only you can open the credential again to edit it, and a workflow in another account cannot use it.

Does Google Sheets use OAuth?

Yes. This credential connects through OAuth (fields: Access Token, Refresh Token, Client ID, Client Secret, Token Expiry (Unix timestamp)): you approve access in Google Sheets, and the resulting tokens are stored encrypted like every other credential.

Nodes that use Google Sheets OAuth2

One credential works across every node below — create it once and reuse it.