Zum Inhalt springen
NEUMarktplatz und trig8n Agent: Verkaufen Sie, was Sie bauen, und erhalten Sie Pläne und Änderungen, die getestet sind, bevor Sie sie sehen. Neuigkeiten ansehen

Bibliothek / Finanzen, Rechnungen & Buchhaltung

Finanzen, Rechnungen & Buchhaltung

Umsatzverluste erkennen und Gemini-Zahlungserinnerungs-E-Mails über Gmail und Slack senden

Prüft Rechnungen und Zahlungen in Google Sheets zeitgesteuert auf Umsatzverluste, erstellt Zahlungserinnerungen mit Gemini und versendet sie per Gmail oder postet eine Slack-Warnung.

Was sie bewirkt

## Revenue Leakage Detector & AI Recovery Pipeline ### How it works This scheduled workflow audits spreadsheet data for revenue leakage by comparing invoices, delivered work, payments, and prior follow-ups. It detects recovery opportunities, logs tasks, then uses an AI agent to draft recovery dispatch content. Depending on eligibility, it sends a client email or posts an internal Slack alert, and finishes by creating an audit summary. ### Setup steps - Configure the Schedule Trigger cadence for how often the revenue audit should run. - Set the Config node values, including spreadsheetId, timezone, gracePeriodDays, and draftThresholdDays. - Connect Google Sheets credentials and ensure the spreadsheet has the expected invoice, work delivered, payment, follow-up, and recovery-task sheets/columns. - Connect Google Gemini credentials for the AI Recovery Agent and verify the selected model is available. - Connect Gmail credentials for client email dispatch and Slack credentials/channel settings for internal alerts. ### Customization Adjust the leakage detection code, limit size, grace-period thresholds, AI prompt construction, and the email/slack eligibility rules to match your billing policy and recovery workflow. @youtube

Die Schritte

  1. Set Configuration Parameters
  2. Read Invoices from Sheets
  3. Read Work Delivered from Sheets
  4. Read Payments from Sheets
  5. Read Follow-ups from Sheets
  6. Detect Revenue Leakage
  7. Append Recovery Tasks to Sheets
  8. Create AI Dispatch Prompts
  9. Revenue Recovery AI Agent
  10. Google Gemini AI Model
  11. Interpret AI Results
  12. Check Email Eligibility
  13. Send Slack Notification
  14. Compile Audit Summary

Insgesamt 17 Schritte.

Ähnliche Automatisierungen