#!/usr/bin/env python3
import json, subprocess, sys

env = {'GOG_KEYRING_PASSWORD': '', 'PATH': '/usr/local/bin:/usr/bin:/bin', 'HOME': '/root'}
# Get columns A-D which should have ID, name, category, status
for col_range in ['A:A', 'B:B', 'C:C', 'D:D']:
    result = subprocess.run(
        ['gog', 'sheets', 'get', '1lPFmhuXnlTchsqE_V5Ntx7k46NFfHSGnldyeL6hH_jQ', f'{col_range}1:{col_range}1000',
         '--account', 'alihajouoc@gmail.com', '--json'],
        capture_output=True, text=True, env=env,
        cwd='/root/.openclaw.pre-migration/workspace'
    )
    data = json.loads(result.stdout)
    values = data.get('values', [])
    print(f'Col {col_range}: {len(values)} rows')
    for i, v in enumerate(values[:20]):
        print(f'  Row {i+1}: {v}')
    print()