scratch/test_sheets_tabs.py

import sys, os, anyio, logging
sys.path.insert(0, os.path.abspath('.'))
logging.basicConfig(level=logging.INFO)

def test_tabs():
    from environments.trace_env.tools.sheets_tool import get_sheets_service, get_or_create_ledger
    service = get_sheets_service()
    spreadsheet_id = get_or_create_ledger(service)
    spreadsheet = service.spreadsheets().get(spreadsheetId=spreadsheet_id).execute()
    sheets = spreadsheet.get('sheets', [])
    print(f"Spreadsheet ID: {spreadsheet_id}")
    print(f"Number of sheets found: {len(sheets)}")
    for s in sheets:
        print(s.get('properties', {}).get('title'))

test_tabs()