Automated invoice follow-ups with smart response tones via Google Sheets & email

🔍 How It Works This AI Agent checks your invoice database (Google Sheets) daily and looks for unpaid invoices that are past their due date. It calculates how many days each invoice is overdue (Days Past Due / DPD), then automatically crafts a follow-up message with an appropriate tone: 1–7 days overdue: Friendly reminder 8–14 days overdue: Slightly firm nudge 15+ days overdue: Final warning tone After generating the message, it sends the follow-up via email to the client and logs the interaction. You can extend this to send WhatsApp messages, Slack alerts, or update a CRM. ⚙️ Set Up Steps Connect Google Sheets : Replace YOURSHEETID in the workflow with the actual Sheet ID Make sure your sheet has these columns: clientname, email, invoicenumber, due_date, status Adjust Cron Trigger By default, it runs daily — you can change the frequency in the “Daily Trigger” node. Configure Email Node Set your email sender (Gmail, SMTP, or Mailgun) in the “Send Email” node. Customize Messages (Optional) Modify tone and content in the “Generate Message” node based on your brand style. Run & Monitor Activate the workflow Monitor activity in Google Sheets or add a logging step (Notion, Slack, etc.)

By Marth

539