Google Sheets OAuth — 5-Minute Setup
Get your credentials to connect Sheety with Google Sheets
1. Project & API
Create a new project (or select existing)
Navigate to APIs & Services → Library
Find Google Sheets API → Enable
Don't enable Drive API (not needed)
2. OAuth Consent Screen
Go to APIs & Services → OAuth consent screen
Choose user type:
Internal (RECOMMENDED if you have Google Workspace)
No verification needed, access limited to company users, no 7-day refresh
External (for personal Gmail accounts)
Add test users, tokens expire every ~7 days in testing mode
Add these scopes only:
https://www.googleapis.com/auth/spreadsheetsopenidemailFill app name and support email, then save
3. Create OAuth Client
Go to APIs & Services → Credentials
Create credentials → OAuth client ID → Web application
Add authorized redirect URI:
https://go.sheety.app/auth/google/callbackOptional for development:
http://localhost:3000/auth/google/callbackLeave JavaScript origins empty
Create and note your Client ID and Client Secret
4. Configure in Sheety
Open Sheety app → Settings → Google OAuth
Enter your Client ID and Client Secret
Save configuration
Common Issues & Solutions
access_denied
You're in Testing mode but not added to Test Users list. Add your email.
SERVICE_DISABLED
Google Sheets API not enabled. Go back and enable it.
redirect_uri_mismatch
Redirect URI doesn't match exactly. Check http/https, port, and trailing slash.
Why Google Workspace (Internal) is Better
Security: Access limited to company users only
Stability: No 7-day token refresh requirement
Management: Centrally managed within organization