Triage brand crises with OpenAI, Telegram, Slack, and Google Sheets

Quick overview This workflow receives negative brand mentions via webhook, uses OpenAI to classify crisis severity and draft a holding statement, logs incidents to Google Sheets, and notifies approvers and teams via Telegram and Slack with severity-based escalation plus an approval callback to mark incidents approved or rejected.

How it works Receives a POST webhook containing a brand mention, source, sentiment score, and related metadata. Normalizes the incoming payload, generates a unique incident ID, and prepares the fields used for triage and notifications. Uses OpenAI (gpt-4o-mini) to classify the incident severity as low, medium, or high, then uses OpenAI again to draft a short holding statement. Appends the incident details, severity, drafted response, and a Pending status to a Google Sheets incident log. Routes notifications by severity, sending a Telegram message to the approver for all incidents, adding a Slack alert to the PR team for medium/high, and escalating to an executive Slack channel for high. Listens for a Telegram inline-button callback and updates the corresponding Google Sheets row to Approved or Rejected, while sending a confirmation message back to the approver. If any step fails, posts an error alert to a designated Slack channel with execution details.

Setup Add OpenAI API credentials for the severity classification and response drafting steps. Connect Google Sheets OAuth2, create a sheet with the required columns, and replace YOUR_GOOGLE_SHEET_ID in all Google Sheets steps. Connect Telegram Bot credentials and set the approver chat ID (YOUR_TELEGRAM_CHAT_ID) used for approver notifications. Connect Slack OAuth2 and replace the channel IDs for the PR team, executive escalation, and error-alert channels. Copy the production webhook URL from the crisis-signal trigger and configure your brand monitoring tool (or source system) to POST mentions to it.