How it works

1. Every hour the Zendesk trigger checks for tickets created or updated since the last run. 2. A For Each loop goes through the tickets one by one. 3. For each ticket, Google Sheets adds a row with the ticket id, subject, status, priority and creation time. Use a filter or lookup in the sheet if you only want first-time tickets. 4. Connect Zendesk and Google Sheets, pick your spreadsheet and check the column order matches your sheet.