Skip to main content
All CollectionsTemplatesBasic
Workflow Notification Tracking in Google Sheets - Workflow Template
Workflow Notification Tracking in Google Sheets - Workflow Template

Workflow that will receive notifications of failed workflows and save the details in a Google Sheet. Entries older than 7 days are removed.

Updated over 6 months ago

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

  1. Receive an event on a workflow notification

  2. 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

  3. Add the event data to the spreadsheet

  4. 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

Did this answer your question?