Skip to content

Google Sheets Integration

Jump to bottom
ewyct edited this page Mar 6, 2026 · 1 revision

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.

Lastest Wiki

Getting Started

Core Features

Integrations

Deployment & CI

Administration

Reference

Clone this wiki locally