How it works

1. Every hour the Salesforce trigger looks for Case records created since the last run, filtered to Priority equal to High. 2. A For Each loop goes through the matching cases one by one. 3. For each case, Google Sheets adds a row with the case number, subject, status, priority and creation time. 4. Connect Salesforce and Google Sheets, pick your spreadsheet and check the column order matches your sheet.