import json
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build

with open('/root/.hermes/google_token.json') as f:
    token_data = json.load(f)

creds = Credentials.from_authorized_user_info(token_data)
service = build('sheets', 'v4', credentials=creds)
spreadsheet_id = '1yNVqn5LcgARSwvpIJdWbg8lCELwki6Rl0bxNrJ5RKUA'

# Read current rows
res = service.spreadsheets().values().get(
    spreadsheetId=spreadsheet_id, range="Sheet1!A1:I30"
).execute()
rows = res.get('values', [])

for r in rows:
    if len(r) > 2 and 'Xô Zòn Zã' in r[2]:
        r[7] = "Chỉ gồm 5 Miếng Gà Rán nguyên bản (không kèm khoai tây chiên hay nước ngọt)"
        r[8] = "5 Miếng Gà Rán: 31,800 VND/miếng (Định giá theo gói 159k)"

service.spreadsheets().values().update(
    spreadsheetId=spreadsheet_id, range="Sheet1!A1:I30",
    valueInputOption="USER_ENTERED", body={'values': rows}
).execute()

print("Updated sheet notes successfully!")