Bibliothek / E-Mail-Automatisierung
E-Mail-Automatisierung
Rechnungserinnerungs-Antworten mit Claude, Gmail und Google Sheets klassifizieren
Liest neue Gmail-Antworten auf Rechnungserinnerungen, entfernt zitierten Text und nutzt Claude, um jede als bezahlt, Zahlungszusage, Streitfall, Frage oder unbezogen zu kennzeichnen, und protokolliert das Ergebnis in Sheets.
Was sie bewirkt
## 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.
Die Schritte
- 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
Insgesamt 16 Schritte.
Ähnliche Automatisierungen
E-Mail-AutomatisierungAnswer WhatsApp shop messages with Claude, Twilio, Google Sheets and Gmail26 SchritteE-Mail-AutomatisierungRun a voice assistant for Gmail, Google Calendar and Contacts with ElevenLabs and Claude23 SchritteE-Mail-AutomatisierungTriage dependency CVEs with OSV.dev, CISA KEV, Claude and Gmail17 SchritteE-Mail-AutomatisierungDraft payment reminder emails from freee Accounting with Claude and Gmail15 Schritte