Quick overview
This workflow reads new RSS items, checks Google Drive to avoid duplicate angles, uses OpenAI to analyze and score the signal, and then routes an approval request via Gmail before logging outcomes to Google Drive and notifying a Telegram channel.
How it works
- Reads an incoming business signal from an RSS feed endpoint.
- Normalizes the RSS payload, creates a fingerprint, and searches Google Drive to see if the same fingerprint was already recorded.
- If the item is not already actioned, sends the signal text to OpenAI to generate a factual, structured business analysis.
- Applies deterministic scoring rules to assign a tier and filter out items that are not policy-safe.
- Compiles a decision digest and sends an approval request email via Gmail using a send-and-wait approval flow.
- If approved, writes an approved record to Google Drive, posts the tier and summary to Telegram, then writes a completion audit record to Google Drive.
- Sends a Gmail escalation email for manual review after the audit is written.
Setup
- Add credentials for Google Drive OAuth2, OpenAI API, Gmail OAuth2, and the Telegram bot API.
- Set the RSS trigger path value (YOUR_TRIGGER_PATH) to the feed endpoint you want to read.
- Replace YOUR_APPROVER_EMAIL with the approver mailbox and set YOUR_CHANNEL_OR_RECIPIENT to the target Telegram chat or channel.
- Review and adjust the OpenAI prompt and the deterministic scoring thresholds to match your content and policy requirements.