Track news on your topics in Airtable and Slack

from clickruntime import on_trigger, credentials, http, notify

BASE, TABLE, TOPIC = "appXXXXXXXX", "News", "electric vans"

@on_trigger
def run(event):
    at = {"Authorization": f"Bearer {credentials.secret('AIRTABLE_API_KEY')}"}
    url = f"https://api.airtable.com/v0/{BASE}/{TABLE}"
    articles = http.get("https://newsapi.org/v2/everything", params={"q": TOPIC, "sortBy": "publishedAt",
                        "apiKey": credentials.secret("NEWS_API_KEY")}).json().get("articles", [])[:20]
    added = []
    for a in articles:
        found = http.get(url, headers=at, params={"filterByFormula": f"{{URL}}='{a['url']}'"}).json()["records"]
        if found:
            continue
        http.post(url, headers=at, json={"fields": {"Title": a["title"], "URL": a["url"],
                  "Source": a["source"]["name"], "Topic": TOPIC}})
        added.append(f"• <{a['url']}|{a['title']}>")
    if added:
        notify.slack(f"New on {TOPIC}:\n" + "\n".join(added), channel="#news")
    return {"added": len(added)}