Bibliothek / CRM & Vertriebspipeline
CRM & Vertriebspipeline
Kundenabwanderungsrisiko aus PostgreSQL-Daten bewerten und Slack mit Gemini benachrichtigen
Läuft täglich oder auf Abruf, bewertet Kunden anhand von PostgreSQL-Merkmalen, sendet unklare Fälle zur Diagnose an Gemini und postet Warnungen zu Hochrisikofällen in Slack.
Was sie bewirkt
## Customer Relationship Drift Detector ### How it works This workflow runs daily or on demand to identify customer relationship drift from stored customer features. It scores each customer with deterministic rules, sends higher-risk or ambiguous cases through an AI diagnosis path with ticket and communication context, then merges AI and non-AI results into a saved assessment. When an assessment requires action, it posts a high-risk alert to Slack for the CRM team. ### Setup steps - Configure PostgreSQL credentials and verify the customer feature, ticket/communication context, and assessment tables used by the SQL nodes. - Configure the Daily 07:00 Trigger timezone and cadence, and keep the Manual Trigger available for testing or ad hoc runs. - Add Google Gemini credentials for the Drift Diagnosis Agent and confirm the structured output parser schema matches the validation code. - Configure Slack credentials and select the destination channel for high-risk CRM alerts. - Review the rule-scoring thresholds and IF conditions so they match the organization’s definition of relationship drift and required CRM action. ### Customization Adjust drift scoring rules, AI escalation criteria, diagnosis prompt/output fields, assessment table columns, and Slack message content to match your customer health model and CRM process. @youtube
Die Schritte
- Every Day at 7 AM
- Start Manually
- Fetch Customer Features
- Calculate Drift Score
- Check AI Analysis Need
- Retrieve Ticket Context
- Build Evidence Payload
- Drift Analysis Agent
- Gemini AI Model
- Parse Structured Output
- Check Diagnosis Validity
- Combine Analysis Streams
- Create Analysis Record
- Store Assessment Result
Insgesamt 17 Schritte.
Ähnliche Automatisierungen
Datensynchronisierung & ETLPostgreSQL-Tabelle in eine CSV-Datei exportieren4 SchritteDatensynchronisierung & ETLPostgreSQL-Tabelle in eine CSV-Datei exportieren6 SchritteMonitoring, Betrieb & StörungenPostgreSQL-Blockierungssitzungen mit Ollama triagieren und per Telegram-Freigabe15 SchritteKalender & TerminplanungZweiseitige SMS-Terminerinnerungen mit VoxiSMS und PostgreSQL versenden20 Schritte