Kütüphane / Finans, Faturalar ve Muhasebe
Finans, Faturalar ve Muhasebe
Gmail'den Gemini ile gider fişlerini çıkar ve Google Sheets'e kaydet
Gmail'e gelen fişleri bir yapay zeka modeliyle okur, çıkarılan tutarları Google Sheets'e kaydeder, limitin üzerindeki harcamalarda Slack'ten Finans ekibini uyarır ve çalışana onay e-postası gönderir.
Ne yapar
# AI Receipt & Expense Tracker This workflow automatically processes employee expense receipts received through Gmail, uses AI to read and extract receipt details, validates the expense amount, stores the expense in Google Sheets, alerts Finance through Slack when an expense exceeds the approved limit, and sends a confirmation email to the employee. ## Setup steps 1. Connect a Gmail account and enable receipt attachments. 2. Create a Google Sheet with columns for expense details. 3. Connect an AI model that can read receipt images/PDFs. 4. Set the company expense limit, such as ₹5,000 you can set as you wish. 5. Connect Slack and select the Finance channel. Configure the employee confirmation email. 6. Add a monthly Schedule Trigger for the expense report. 7. Connect the Finance email address for the monthly summary. 8. Test the workflow with a sample receipt before activating it.
Adımlar
- Gmail Trigger
- Analyze an image
- Code in JavaScript
- Code in JavaScript1
- Append or update row in sheet
- If
- Send a message
- Send a message1
- Send a message2
- Schedule Trigger
- Get row(s) in sheet
- Code in JavaScript2
- Send a message3
Benzer otomasyonlar
Finans, Faturalar ve MuhasebeGelir kaybını tespit edin ve Gmail ve Slack üzerinden Gemini kurtarma e-postaları gönderin17 adımFinans, Faturalar ve MuhasebeGemini, Google Sheets ve Slack ile Gmail'de mükerrer ödeme tahsilatlarını tespit edin18 adımFinans, Faturalar ve MuhasebeÖdenen Stripe Faturalarında HubSpot'u Güncelle ve Slack'i Uyar8 adımFinans, Faturalar ve MuhasebeSync Shopify orders to Xero invoices with Slack and email alerts12 adım