Log HappyFox ticket activity to Google Sheets hourly

Every hour, on a cron schedule, sync recently changed HappyFox tickets into a Google Sheet so support activity is always available for reporting and BI. This is a deterministic list, map, and append sync, not an agent.

Use the HappyFox List Tickets operation to fetch tickets, sorted by last update (most recently updated first) and filtered to the window since the previous run, meaning tickets created or updated in the past hour. HappyFox returns a page_info object and accepts size (max 50) and page parameters, so request the maximum page size and advance page from 1 up to page_info.page_count to collect every ticket in the window. All HappyFox timestamps are UTC, so compare against a UTC one-hour cutoff.

For each ticket, map its key fields into a single row: ticket number (the ticket id and display id), subject, status, priority, category, assigned agent, requester name, requester email, created timestamp, and last-updated timestamp. Status, priority, category, and assignee come back as numeric IDs in HappyFox, so include the human-readable names alongside them wherever the list payload provides them, and fall back to the ID if a name is missing.

Append the mapped rows to the tracking spreadsheet using the Google Sheets Append Values operation, writing after the last row of the existing data so the sheet becomes a running activity log. Keep one row per ticket update rather than upserting existing rows, which preserves a full history that downstream dashboards and pivot tables can build on. If the sheet is empty on the first run, write a header row first.

Append rows in ascending last-updated order so the log reads chronologically, and if no tickets changed in the past hour, leave the sheet unchanged.