Google Sheets Exporter (gsheets)

Exports accuracy metrics to a Google Sheet. Dynamically creates/extends header columns based on observed metrics and appends one row per job.

• Purpose: Centralized spreadsheet for tracking results across runs

• Requirements: gspread installed and a Google service account with access

Usage

Export evaluation results to a Google Sheets spreadsheet for easy sharing and analysis.

CLI

Export results from a specific evaluation run to Google Sheets:

# Export results using default spreadsheet name
nv-eval export 8abcd123 --dest gsheets

# Export with custom spreadsheet name and service account
nv-eval export 8abcd123 --dest gsheets \
  --config '{"spreadsheet_name": "My Evaluation Results", "service_account_file": "/path/to/service-account.json"}'

Python

Export results programmatically with custom configuration:

from nemo_evaluator_launcher.api.functional import export_results

# Basic export to Google Sheets
export_results(
    invocation_ids=["8abcd123"], 
    dest="gsheets", 
    config={
        "spreadsheet_name": "NeMo Evaluator Launcher Results"
    }
)

# Export with service account and filtered metrics
export_results(
    invocation_ids=["8abcd123", "9def4567"], 
    dest="gsheets", 
    config={
        "spreadsheet_name": "Model Comparison Results",
        "service_account_file": "/path/to/service-account.json",
        "log_metrics": ["accuracy", "f1_score"]
    }
)

Key Configuration

Parameter	Type	Description	Default/Notes
service_account_file	str, optional	Path to service account JSON	Uses default credentials if omitted
spreadsheet_name	str, optional	Target spreadsheet name	Default: “NeMo Evaluator Launcher Results”
log_metrics	list[str], optional	Filter metrics to log	All metrics if omitted