Send AI-generated stale lead nudges from Notion CRM to Telegram with OpenAI

Description

Meet your new automated Sales Manager. This workflow acts as a relentless but helpful AI Sales Coach that lives inside your n8n.

It wakes up every morning, scans your Notion CRM for deals that have been neglected, and uses OpenAI to send personalized, context-aware "nudges" directly to the specific sales agent responsible via Telegram.

💡 Why use this?
Stop Generic Spam:* Unlike dumb bots that blast the whole channel, this workflow maps Notion Users to Telegram Handles to tag the *exact person responsible (e.g., "@alex, wake up!").
Context-Aware AI:** The AI reads the deal details. It gets "greedy" for high-value deals and "sarcastic" for long silences.
Zero Management:** It runs on autopilot, ensuring no lead slips through the cracks.

⚙️ How it works
Data Sync: Fetches your "Agents" database (Notion User ↔ Telegram ID) and "Active Deals".
Logic Core: Calculates exactly how many days a lead has been untouched.
Smart Routing: Matches the Assigned Manager in Notion to their Telegram ID.
AI Generation: Generates a punchy message based on the deal's value and stage.
Delivery: Sends the notification to Telegram with a direct link to the Notion deal.

🛠 Setup Steps
Get the Notion System
This workflow requires a specific database structure to map Agents and Deals.
👉 Click here to duplicate the Notion Template

Connect Databases
In the "Get Agents" node, select your duplicated Agents Configuration database.
In the "Get Active Leads" node, select your duplicated Active Deals database.

Configure Settings
Open the 📝 CONFIGURATION node to set:
DAYS_INACTIVE_LIMIT: How many days of silence before alerting? (default: 7).
COACH_PERSONA: Customize the AI's personality (e.g., "Tough Boss" or "Friendly Helper").
TELEGRAM_CHAT_ID: A fallback chat for unassigned leads.

Connect Accounts
Add your credentials for Notion, OpenAI, and Telegram.