utils.py

import os
from pprint import pprint

from googleapiclient.discovery import build
from google.oauth2.credentials import Credentials
from google.auth.transport.requests import Request

from google_auth_oauthlib.flow import InstalledAppFlow

SCOPES = ["https://www.googleapis.com/auth/spreadsheets"]
SPREADSHEET_ID = "1DwihAqU_0W-z4bn5LQRb3IKuw9DMaXEH-RQG-J2QeXg"
SOURCE_SHEET_NAME = "Language requests"


def load_and_refresh_credentials(filename="token.json", scopes=None):
    creds = None
    if os.path.exists(filename):
        creds = Credentials.from_authorized_user_file(filename, scopes=scopes)

    if creds and creds.expired and creds.refresh_token:
        creds.refresh(Request())
        # Save the refreshed token
        with open(filename, "w") as token:
            token.write(creds.to_json())

    return creds


def update_token():
    flow = InstalledAppFlow.from_client_secrets_file(
        'client_secret.json', SCOPES)
    creds = flow.run_local_server(port=0)

    with open('token.json', 'w') as token_file:
        token_file.write(creds.to_json())

    print("✅ token.json created successfully!")