Skip to main content

Google Sheets OAuth Setup Guide

This guide explains how to connect your Google Account to Reeva for Google Sheets tools using OAuth with your own Google Cloud credentials.

Why Use This Method?​

Google Sheets OAuth provides API access to your spreadsheets, allowing you to:

  • Create spreadsheets programmatically
  • Read and write cell values
  • Manage sheets/tabs, formatting, and ranges
  • (Optional) Use Google Drive features like placing new spreadsheets into specific folders

Since Reeva hasn't completed Google's OAuth verification process yet, you'll use your own Google Cloud project credentials.

Prerequisites​

  • A Google Account
  • A Google Cloud project (free tier is sufficient)
  • OAuth credentials (Client ID + Client Secret)

Good to know: The same Google OAuth account can be used across Gmail, Google Calendar, and Google Sheets tools.

Step-by-Step Setup​

1. Create a Google Cloud Project​

(If you already have a project from Gmail/Calendar setup, you can use the same one.)

  1. Go to Google Cloud Console
  2. Click "Select a project" → "New Project"
  3. Enter a project name (e.g., "Reeva Google Integration")
  4. Click "Create"

2. Enable Google Sheets API ⚠️ REQUIRED​

Sheets tools will not work unless the Google Sheets API is enabled.

  1. In your project, go to "APIs & Services" → "Library"
  2. Search for "Google Sheets API"
  3. Click on "Google Sheets API" in the results
  4. Click the "Enable" button

If you want tools to place new spreadsheets into a specific Drive folder, you must enable the Drive API:

  1. Go to "APIs & Services" → "Library"
  2. Search for "Google Drive API"
  3. Click on "Google Drive API" in the results
  4. Click the "Enable" button

(Skip this if you already did it for another Google integration.)

  1. Go to "APIs & Services" → "OAuth consent screen"
  2. Choose "External" (unless you have a Google Workspace account)
  3. Fill in the required fields:
    • App name: "Reeva" (or your preferred name)
    • User support email: Your email
    • Developer contact: Your email
  4. Click "Save and Continue"
  5. On the "Scopes" page, click "Save and Continue" (Reeva requests scopes during connection)
  6. On "Test users", add your own Google account email
  7. Click "Save and Continue"

5. Create OAuth Credentials​

(If you already have OAuth credentials from Gmail/Calendar setup, you can reuse them!)

  1. Go to "APIs & Services" → "Credentials"
  2. Click "Create Credentials" → "OAuth 2.0 Client ID"
  3. Choose "Web application"
  4. Name it "Reeva Web Client"
  5. Under "Authorized redirect URIs", add: 
    https://app.reeva.dev/oauth/callback
    (Or http://localhost:5173/oauth/callback for local development)
  6. Click "Create"
  7. Save your Client ID and Client Secret

6. Connect in Reeva​

  1. Go to Reeva → Accounts → "Connect Platform"
  2. Select "Google Account (OAuth)"
  3. Enter your Client ID and Client Secret
  4. Give your account a name (e.g., "My Google Account")
  5. Click "Create Account"
  6. You'll be redirected to Google
  7. Important: You'll see a warning "This app isn't verified"
    • This is expected since you're using your own credentials
    • Click "Advanced" → "Go to [your app name] (unsafe)"
    • Review permissions and click "Continue"
  8. Click "Allow"
  9. You'll be redirected back to Reeva
  10. ✅ Your Google Account is now connected!

What This Account Can Do​

Once connected, this single Google Account works with:

Google Sheets Tools​

  • Create spreadsheets
  • (More Sheets tools coming soon)

Gmail Tools​

  • Send emails, read/search, drafts

Google Calendar Tools​

  • List calendars, create/update/delete events

Troubleshooting​

"Google Sheets API has not been enabled" Error​

If you see an error indicating the Sheets API isn't enabled:

  1. Go to https://console.cloud.google.com/apis/library/sheets.googleapis.com
  2. Select your project
  3. Click "Enable"
  4. Wait 10–30 seconds
  5. Try again

"Google Drive API has not been enabled" Error​

This usually happens when using a feature that touches Drive (like placing a spreadsheet into a folder):

  1. Go to https://console.cloud.google.com/apis/library/drive.googleapis.com
  2. Select your project
  3. Click "Enable"
  4. Wait 10–30 seconds
  5. Try again

Account Works for Gmail/Calendar but Not Sheets​

This can mean your Google OAuth account was connected before Sheets/Drive scopes were added.

Fix: Disconnect your Google OAuth account in Reeva and reconnect it so you can grant the new permissions.

Security Notes​

  • Your OAuth credentials (Client ID and Secret) are stored encrypted in Reeva
  • Reeva never sees your Google password
  • You can revoke access anytime at https://myaccount.google.com/permissions
  • Access tokens are automatically refreshed as needed

Additional Resources​