Copy a table from a web page into a sheet every morning

import csv, io
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, notify

URL = "https://listings.example.com/today"
SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    soup = BeautifulSoup(http.get(URL).text, "lxml")
    table = soup.find("table")
    if table is None:
        raise RuntimeError("No table found on the page")
    rows = [[date.today().isoformat()] + [c.get_text(strip=True) for c in tr.find_all("td")]
            for tr in table.find_all("tr") if tr.find_all("td")]
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Listings!A:Z",
                                          valueInputOption="USER_ENTERED", body={"values": rows}).execute()
    buf = io.StringIO()
    csv.writer(buf).writerows(rows)
    notify.email_me(f"Listings for {date.today()}: {len(rows)} rows", buf.getvalue())
    return {"rows": len(rows)}