Back up a sheet tab every night

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

SHEET_ID = "your-spreadsheet-id"
KEEP = 14

@on_trigger
def run(event):
    try:
        sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
        tabs = sheets.get(spreadsheetId=SHEET_ID, fields="sheets.properties").execute()["sheets"]
        orders = next(t["properties"]["sheetId"] for t in tabs if t["properties"]["title"] == "Orders")
        requests = [{"duplicateSheet": {"sourceSheetId": orders, "newSheetName": f"Orders {date.today()}", "insertSheetIndex": len(tabs)}}]
        backups = sorted((t["properties"] for t in tabs if t["properties"]["title"].startswith("Orders 20")),
                         key=lambda p: p["title"])
        requests += [{"deleteSheet": {"sheetId": p["sheetId"]}} for p in backups[:max(0, len(backups) + 1 - KEEP)]]
        sheets.batchUpdate(spreadsheetId=SHEET_ID, body={"requests": requests}).execute()
    except Exception as e:
        notify.email_me("Orders backup failed", f"{type(e).__name__}: {e}")
        raise
    return {"copied": f"Orders {date.today()}", "removed": len(requests) - 1}