Log every new Gorgias ticket to a Google Sheets tracker

On a cron schedule every hour, pull the newest Gorgias support tickets and append every new one as a row in a Google Sheets tracking tab, so the team has a running log for reporting and backup.

Fetch tickets with the Gorgias List Tickets operation, filtered to tickets created since the last run (order_by created_datetime:desc and filter on created_datetime against a stored high-watermark of the most recent created date already logged). Gorgias is not a poll provider, which is why this runs on cron plus List Tickets rather than a poll trigger.

Before writing, read the existing ticket ID column from the tracking tab with the Google Sheets Get Values operation and build a set of IDs already present, so tickets are deduped on ticket ID and never appended twice across runs (the created_datetime filter narrows the fetch; the ID set is the source of truth for dedupe).

For each new ticket whose ID is not already in the sheet, map a fixed set of fields into one row in this column order: ticket ID, created date, subject, channel, requester email, status, tags (comma-joined), and assignee. Write the rows into the tracking tab with the Google Sheets Append Values operation, one row per new ticket.

Keep it fully deterministic: a fixed column mapping, one row per ticket, no summarizing or judgement. If there are no new tickets since the last run, do nothing. Build this as a code workflow.