Google Sheets Integration

Google Sheets Integration

Use spreadsheet data as test data sources for data-driven testing.

---

Features

• Per-team OAuth connection
• Automatic token refresh
• Multi-tab spreadsheet support
• Custom header row selection
• Fixed data ranges
• Caching for performance

---

Setup

1. Configure Google OAuth credentials (see [Environment Variables])
2. Go to Settings > Google Sheets
3. Click "Connect Google Account"
4. Authorize access to Google Drive/Sheets

---

Using Spreadsheet Data

1. Select spreadsheets from your connected Google account
2. Configure data sources with aliases (e.g., "users", "products")
3. Reference data in test code via the cached headers and rows

Data Source Configuration

Option	Description
Alias	Short name to reference in tests (e.g., "users")
Spreadsheet	Which Google Sheet to use
Tab	Which tab within the spreadsheet
Header row	Which row contains column headers
Data range	Optional fixed range (e.g., A1:D50)

---

Environment Variables

GOOGLE_CLIENT_ID=your-client-id
GOOGLE_CLIENT_SECRET=your-client-secret
GOOGLE_SHEETS_REDIRECT_URI=http://your-url/api/auth/callback/google-sheets

Note: Google Sheets OAuth uses a separate redirect URI from Google login OAuth.