import json
from pathlib import Path
import urllib.request, urllib.parse

TOKEN_PATH = Path.home() / ".config/google-workspace-mcp/profiles/emerson-north/tokens.json"

def get_token():
    tokens = json.loads(TOKEN_PATH.read_text())
    return tokens.get("access_token") or tokens.get("token")

def sheets_get(token, sheet_id, range_):
    url = f"https://sheets.googleapis.com/v4/spreadsheets/{sheet_id}/values/{urllib.parse.quote(range_)}"
    req = urllib.request.Request(url, headers={"Authorization": f"Bearer {token}"})
    with urllib.request.urlopen(req) as r:
        return json.loads(r.read())

token = get_token()
sheet_id = "1aCLZMcvLbacFHrZwuTBlgwezVHoAxFNYpmapqN9AVXY"
data = sheets_get(token, sheet_id, "Client Profile!A:A")
rows = data.get("values", [])

targets = {"booking_link", "members_area_url"}
for i, row in enumerate(rows, 1):
    if row and row[0] in targets:
        print(f"Row {i}: {row[0]}")