Библиотека / Автоматизация эл. почты
Автоматизация эл. почты
Классификация ответов на напоминания об оплате с Claude, Gmail и Google Sheets
Читает новые ответы в Gmail на напоминания об оплате счетов, удаляет цитируемый текст, с помощью Claude присваивает каждому ответу метку: оплачено, обещание оплатить, спор, вопрос или не относится к делу, и записывает результат в Sheets.
Что делает
## 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.
Шаги
- 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
Всего шагов: 16.
Похожие автоматизации
Автоматизация эл. почтыAnswer WhatsApp shop messages with Claude, Twilio, Google Sheets and GmailШагов: 26Автоматизация эл. почтыRun a voice assistant for Gmail, Google Calendar and Contacts with ElevenLabs and ClaudeШагов: 23Автоматизация эл. почтыTriage dependency CVEs with OSV.dev, CISA KEV, Claude and GmailШагов: 17Автоматизация эл. почтыDraft payment reminder emails from freee Accounting with Claude and GmailШагов: 15