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
- Set Configuration Parameters
- Read Invoices from Sheets
- Read Work Delivered from Sheets
- Read Payments from Sheets
- Read Follow-ups from Sheets
- Detect Revenue Leakage
- Append Recovery Tasks to Sheets
- Create AI Dispatch Prompts
- Revenue Recovery AI Agent
- Google Gemini AI Model
- Interpret AI Results
- Check Email Eligibility
- Send Slack Notification
- Compile Audit Summary
Insgesamt 17 Schritte.
Ähnliche Automatisierungen
Web Scraping & RechercheUber-Eats-Pizzaangebote mit Bright Data finden4 SchritteKI-Agenten & AssistentenE-Mail-Fragen mit Ollama und Claude in SQL umwandeln23 SchritteKI-Agenten & AssistentenFragen zu E-Mails stellen und von Claude erzeugtes SQL ausführen28 SchritteFinanzen, Rechnungen & BuchhaltungKontoauszugs-Transaktionen mit Gemini aus PDFs in Google Sheets extrahieren7 Schritte