Automate Slack Error Alerts and Google Sheets Tracking

Introduction

Catch errors early and keep your team informed—automatically. 🚨 This workflow alerts the right Slack channel, stores error details, and tracks repeats across testing and production.

Trigger Event

A webhook receives an error payload from your app or service (including org, bridge, environment, message, and error details).

Actions

• The flow checks if a matching error record already exists for the same org and bridge.
• If no record exists and the environment is Testing or Production:
  • Testing or specific orgs: Send an alert to the testing Slack channel with a clear, formatted message.
  • Production (excluding specific orgs):
    • Create a new error record (with errorCount = 0)
    • Send a detailed alert to the production Slack channel
    • Save the error details to a Google Sheet for reporting
    • Wait briefly, fetch the stored record, capture the latest errorCount, and call a reporting endpoint
    • Clean up the temporary record to keep storage tidy
• If a matching error record already exists:
  • Increment the errorCount to track repeated occurrences
• A lightweight retry mechanism helps detect excessive retries within a short window and can raise an internal alert if limits are hit.

Benefits

• ✔️ Immediate Slack alerts to the right channel by environment
• ✔️ Centralized error tracking with errorCount for repeat issues
• ✔️ Auto-save key fields to Google Sheets for reporting and audits
• ✔️ Reduced manual triage; faster visibility for engineering and QA
• ✔️ Clear separation of Testing vs. Production to avoid noise and keep focus