Menu

Google Sheets Integration

Viktor Fási

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.


Related

Wiki: AI Configuration
Wiki: Environment Variables
Wiki: Home
Wiki: Settings Reference
Wiki: _Sidebar

MongoDB Logo MongoDB