Track your X post performance weekly

from datetime import datetime, timedelta, timezone
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai, notify

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    x = {"Authorization": "Bearer " + credentials.connection("x", "main")}
    me = http.get("https://api.x.com/2/users/me", headers=x).json()["data"]["id"]
    since = (datetime.now(timezone.utc) - timedelta(days=7)).strftime("%Y-%m-%dT%H:%M:%SZ")
    posts = http.get(f"https://api.x.com/2/users/{me}/tweets", headers=x, params={
        "start_time": since, "max_results": 100, "tweet.fields": "public_metrics,created_at"}).json().get("data", [])
    rows = [[p["created_at"][:10], p["text"][:120], p["public_metrics"].get("impression_count", 0), p["public_metrics"]["like_count"],
             p["public_metrics"]["reply_count"], p["public_metrics"]["retweet_count"]] for p in posts]
    if not rows:
        return {"posts": 0}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Stats!A:F", valueInputOption="RAW", body={"values": rows}).execute()
    try:
        summary = ai.generate("date | text | views | likes | replies | reposts\n" + "\n".join(" | ".join(map(str, r)) for r in rows),
                              system="In 4 bullet points, say which posts did best and what they had in common.", max_output_tokens=300).text
    except (ai.AINotIncluded, ai.AILimitReached):
        summary = "Top post: " + max(rows, key=lambda r: r[3])[1]
    notify.email_me(f"Your week on X: {len(rows)} posts", summary)
    return {"posts": len(rows)}