Create Facebook ads from rows in a sheet

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, report_fetched

ACT, PAGE_ID, SHEET_ID = "act_1234567890", "1234567890", "your-spreadsheet-id"
G = f"https://graph.facebook.com/v21.0/{ACT}"

@on_trigger
def run(event):
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    rows = values.get(spreadsheetId=SHEET_ID, range="Ads!A2:I").execute().get("values", [])
    ready = [(i + 2, r) for i, r in enumerate(rows) if len(r) >= 9 and r[8] == "Ready"]
    report_fetched(len(ready))
    if not ready:
        return {"summary": "No ready rows"}
    t = {"access_token": credentials.connection("facebook", "work")}
    for n, (name, headline, text, image, link, budget, country, age, _) in ready:
        img = http.post(f"{G}/adimages", data={**t, "url": image}).json()["images"]
        camp = http.post(f"{G}/campaigns", data={**t, "name": name, "objective": "OUTCOME_TRAFFIC", "status": "PAUSED", "special_ad_categories": "[]"}).json()["id"]
        adset = http.post(f"{G}/adsets", data={**t, "name": name, "campaign_id": camp, "daily_budget": int(float(budget) * 100), "billing_event": "IMPRESSIONS",
                          "optimization_goal": "LINK_CLICKS", "status": "PAUSED", "targeting": f'{{"geo_locations":{{"countries":["{country}"]}},"age_min":{age}}}'}).json()["id"]
        story = {"page_id": PAGE_ID, "link_data": {"link": link, "message": text, "name": headline, "image_hash": next(iter(img.values()))["hash"]}}
        creative = http.post(f"{G}/adcreatives", json={**t, "object_story_spec": story}).json()["id"]
        ad = http.post(f"{G}/ads", data={**t, "name": name, "adset_id": adset, "creative": f'{{"creative_id":"{creative}"}}', "status": "PAUSED"}).json()["id"]
        values.update(spreadsheetId=SHEET_ID, range=f"Ads!I{n}:J{n}", valueInputOption="RAW", body={"values": [["Created", ad]]}).execute()
    return {"created": len(ready)}