The "Workflow Notification Tracking in Google Sheets" template streamlines application security operations by automatically logging failed workflow notifications into a Google Sheet. This workflow ensures efficient tracking and management of incidents by creating a new spreadsheet if necessary, appending event data, and maintaining data hygiene by removing entries older than seven days. It enhances visibility and accountability in security operations, facilitating timely responses and informed decision-making.
Trigger
Webhook
Use Cases
Application Security Operations
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