Know when a competitor changes their pricing

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

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    rows = sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Competitors!A2:B").execute().get("values", [])
    pages = state.get("pages") or {}
    changed = 0
    for i, row in enumerate(rows, start=2):
        name, url = (row + ["", ""])[:2]
        text = BeautifulSoup(http.get(url).text, "html.parser").get_text(" ", strip=True)[:20000]
        digest = hashlib.sha256(text.encode()).hexdigest()
        old = pages.get(url)
        if old and old["hash"] != digest:
            added = [w for w in set(text.split(". ")) - set(old["text"].split(". "))][:5]
            notify.slack(f"🔄 {name} changed {url}\n" + "\n".join(f"+ {s[:200]}" for s in added), channel="#competitors")
            sheets.spreadsheets().values().update(spreadsheetId=SHEET_ID, range=f"Competitors!C{i}",
                                                  valueInputOption="RAW", body={"values": [[date.today().isoformat()]]}).execute()
            changed += 1
        pages[url] = {"hash": digest, "text": text[:5000]}
    state.set("pages", pages)
    return {"checked": len(rows), "changed": changed}