Invite new sheet registrants to your calendar event

from googleapiclient.discovery import build
from google.oauth2.credentials import Credentials
from clickruntime import on_trigger, credentials, report_fetched

SHEET_ID, EVENT_ID = "your-spreadsheet-id", "your-event-id"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    values = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values()
    rows = values.get(spreadsheetId=SHEET_ID, range="Registrations!A2:C").execute().get("values", [])
    new = [(i + 2, r[1]) for i, r in enumerate(rows) if len(r) > 1 and (len(r) < 3 or r[2] != "invited")]
    report_fetched(len(new))
    if not new:
        return {"summary": "No new registrations"}
    cal = build("calendar", "v3", credentials=creds, cache_discovery=False).events()
    ev = cal.get(calendarId="primary", eventId=EVENT_ID).execute()
    guests = ev.get("attendees", []) + [{"email": email} for _, email in new]
    cal.patch(calendarId="primary", eventId=EVENT_ID, body={"attendees": guests}, sendUpdates="all").execute()
    for row, _ in new:
        values.update(spreadsheetId=SHEET_ID, range=f"Registrations!C{row}", valueInputOption="RAW", body={"values": [["invited"]]}).execute()
    return {"invited": len(new)}