Log your arrival and departure times automatically

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import datetime, timezone
from googleapiclient.http import MediaInMemoryUpload
from clickruntime import on_event, credentials, state

SHEET_ID, FOLDER_ID = "your-spreadsheet-id", "your-timesheets-folder-id"

@on_event
def handle(event):
    p = event.json or {}
    now = datetime.now(timezone.utc)
    creds = Credentials(credentials.connection("google", "work"))
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Attendance!A:D", valueInputOption="USER_ENTERED",
        body={"values": [[now.strftime("%Y-%m-%d"), now.strftime("%H:%M"), p.get("place", ""), p.get("action", "")]]}).execute()
    if now.day == 1 and state.get("exported") != now.strftime("%Y-%m"):
        drive = build("drive", "v3", credentials=creds, cache_discovery=False)
        pdf = drive.files().export(fileId=SHEET_ID, mimeType="application/pdf").execute()
        drive.files().create(body={"name": f"Attendance {now:%Y-%m} (previous month).pdf", "parents": [FOLDER_ID]},
                             media_body=MediaInMemoryUpload(pdf, "application/pdf")).execute()
        state.set("exported", now.strftime("%Y-%m"))
    return {"logged": p.get("action")}