Turn new items from your sources into WordPress drafts

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

SHEET_ID = "your-spreadsheet-id"
WP = "https://blog.example.com/wp-json/wp/v2"

def wp(method, path, **kw):
    r = http.request(method, f"{WP}/{path}", auth=(credentials.secret("WP_USER"), credentials.secret("WP_APP_PASSWORD")), **kw)
    r.raise_for_status()
    return r.json()

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    feeds = [r[0] for r in sheets.values().get(spreadsheetId=SHEET_ID, range="Sources!A2:A").execute().get("values", []) if r]
    seen = set(state.get("seen") or [])
    new = [e for f in feeds for e in feedparser.parse(http.get(f).content).entries[:10] if e.link not in seen][:8]
    rows = []
    for e in new:
        body = ai.generate(f"Source: {e.title}\n{e.get('summary', '')[:2500]}\n\nWrite an original 500-word blog draft in HTML for travellers, in our voice, ending with a credit linking {e.link}.", max_output_tokens=1200).text
        post = wp("POST", "posts", json={"title": e.title, "content": body, "status": "draft"})
        rows.append([date.today().isoformat(), e.title, e.link, post["id"]])
        seen.add(e.link)
    if rows:
        sheets.values().append(spreadsheetId=SHEET_ID, range="Drafts!A:D", valueInputOption="RAW", body={"values": rows}).execute()
        notify.email_me(f"{len(rows)} new blog drafts", "\n".join(r[1] for r in rows))
    state.set("seen", list(seen)[-1000:])
    return {"drafts": len(rows)}