# scripts/test_load_sheet.py

from data_sources.sheets_loader import load_scenarios_from_sheet

sheet_url = "https://docs.google.com/spreadsheets/d/1yMrHdGsQTyOPVkfeMCio0VILYl57L2S0QXqKGu4Skno/edit?usp=sharing"

scenarios = load_scenarios_from_sheet(sheet_url)

print(f"Loaded {len(scenarios)} scenario(s).")

for s in scenarios:
    print(s.model_dump_json(indent=2))