This workflow template assists businesses in tracking notifications for failed workflows by automatically saving event details into a Google Sheet. On each notification received, the workflow checks if the spreadsheet ID and sheet ID are stored; if not, it creates them and stores the data globally. Subsequent notifications are added to the determined spreadsheet, with expired events older than seven days being removed upon the first execution of the day. This ensures operational transparency and assists with timely error resolution.
Trigger
Webhook
Use Cases
null
Workflow Breakdown
Receive an event on a workflow notification
Check if the workflow has saved the Spreadsheet ID and Sheet ID, if not, create a new Spreadsheet and Sheet and save to the Global Variable
Add the event data to the spreadsheet
On the first execution of the day, check if expired events exist, if so remove them
Vendors
Utils, Google Sheets, Torq
Workflow Output
Details from failed workflows in a Google Sheet