Kütüphane / E-posta Otomasyonu
E-posta Otomasyonu
Claude, Gmail ve Google Sheets ile fatura hatırlatma yanıtlarını sınıflandırın
Fatura hatırlatmalarına gelen yeni Gmail yanıtlarını okur, alıntılanmış metni ayıklar ve Claude ile her birini ödendi, ödeme sözü, itiraz, soru veya ilgisiz olarak etiketler, ardından sonucu Sheets'e kaydeder.
Ne yapar
## Classify replies to invoice reminders with Claude, Gmail and Google Sheets Turns each reply to your payment reminders into a clear next step. ### Who's it for Small businesses, freelancers and bookkeepers who chase unpaid invoices by email. ### How it works 1. Watch for invoice replies picks up new replies (default search: "invoice" in the subject, not sent by you). 2. Clean reply strips quoted history and signatures. 3. An AI model sorts the reply into *Payment made*, *Promise to pay*, *Dispute*, *Question*, *Unrelated* or *Needs review*, with the promised payment date (one week ahead if the customer gives none) and a one-line reason. 4. Each reply is logged to Google Sheets and labelled in Gmail. *Needs review* is for replies a person should read: vague, mixed or sarcastic ones, or if the model fails (the error is logged). The workflow never sends email, so a tricky reply can at worst get a wrong label. It doesn't check your invoices either: *Payment made* means the customer says they paid. ### Setup - [ ] Credentials: connect Gmail, Google Sheets and your AI model (the Claude Haiku 5.5 node). - [ ] Gmail labels: create six labels in Gmail: Payment made, Promise to pay, Dispute, Question, Unrelated and Needs review. Open each Label node and pick the label with the same name. - [ ] Sheet: paste a blank Google Sheet's URL, copied from the address bar, into Your settings. The header row is written on the first run. - [ ] Search: edit the search in Watch for invoice replies to match your reminder subjects. ### Requirements Gmail and Google Sheets connected via Google OAuth (self-hosted n8n needs a Google Cloud app: guide), and an API key for Claude or another chat model. ### Customization tips - Another model: swap the Claude Haiku 5.5 node for any chat model node (OpenAI, Gemini, Mistral, Ollama). - Other classes: edit Classify reply, Reply class format and Route by class, then add a matching label.
Adımlar
- Watch for invoice replies
- Your settings
- Clean reply
- Classify reply
- Claude Haiku 5.5
- Reply class format
- Prepare log row
- Log to sheet
- Route by class
- Label: Payment made
- Label: Promise to pay
- Label: Dispute
- Label: Question
- Label: Unrelated
Toplam 16 adım.
Benzer otomasyonlar
E-posta OtomasyonuAnswer WhatsApp shop messages with Claude, Twilio, Google Sheets and Gmail26 adımE-posta OtomasyonuRun a voice assistant for Gmail, Google Calendar and Contacts with ElevenLabs and Claude23 adımE-posta OtomasyonuTriage dependency CVEs with OSV.dev, CISA KEV, Claude and Gmail17 adımE-posta OtomasyonuDraft payment reminder emails from freee Accounting with Claude and Gmail15 adım