Kütüphane / Finans, Faturalar ve Muhasebe
Finans, Faturalar ve Muhasebe
Gelir kaybını tespit edin ve Gmail ve Slack üzerinden Gemini kurtarma e-postaları gönderin
Zamanlı olarak Google Sheets faturalarını ve ödemelerini kayıp açısından denetler, Gemini ile kurtarma mesajları taslağı hazırlar ve bunları Gmail ile gönderir ya da Slack uyarısı paylaşır.
Ne yapar
## 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
Adımlar
- 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
Toplam 17 adım.
Benzer otomasyonlar
Finans, Faturalar ve MuhasebeGemini ile banka ekstresi PDF'lerindeki işlemleri Google E-Tablolar'a aktar7 adımFinans, Faturalar ve MuhasebeTelegram fiş fotoğraflarını Gemini ile gider çıkarımı yaparak Google Sheets'e kaydet28 adımFinans, Faturalar ve MuhasebeLlamaParse ve Gemini ile Fatura Verilerini Sheets'e Çıkar17 adımFinans, Faturalar ve MuhasebeGmail'den Fatura ve Ödeme Ayrıntılarını Sheets'e Çıkarma21 adım