Log new SEO issues to a sheet and create Asana tasks to fix them

from datetime import date
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, state

DOMAIN = "example.com"
SHEET_ID = "your-spreadsheet-id"
PROJECT_ID = "your-asana-project-id"

@on_trigger
def run(event):
    auth = (credentials.secret("DATAFORSEO_LOGIN"), credentials.secret("DATAFORSEO_PASSWORD"))
    res = http.post("https://api.dataforseo.com/v3/backlinks/backlinks/live", auth=auth,
                    json=[{"target": DOMAIN, "filters": ["is_broken", "=", True], "limit": 500}]).json()
    items = (res["tasks"][0]["result"] or [{}])[0].get("items") or []
    seen = set(state.get("seen") or [])
    new = [i for i in items if f"{i['url_from']}|{i['url_to']}" not in seen]
    if not new:
        return {"new": 0}
    rows = [[date.today().isoformat(), i["url_from"], i["url_to"]] for i in new]
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Broken links!A:C", valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    for i in new:
        http.post("https://app.asana.com/api/1.0/tasks", headers={"Authorization": f"Bearer {credentials.secret('ASANA_TOKEN')}"},
                  json={"data": {"name": f"Fix broken backlink to {i['url_to']}", "notes": f"Linked from {i['url_from']}", "projects": [PROJECT_ID]}})
        seen.add(f"{i['url_from']}|{i['url_to']}")
    state.set("seen", sorted(seen))
    return {"new": len(new)}