Build a Google Sheets–Based Automated Debt Collection Email System
Budget: -
HOURLY / PART_TIME
⭐ 0.00 (0)
Italy
machine-learning, chatbot-software, deep-learning, predictive-analytics, convolutional-neural-network, computer-vision, anomaly-detection-technique, classification, automation, pytorch, api, web-programming, automated-workflow-deliverable, django-framework
I’m looking for an experienced automation developer to build a system that streamlines part of our debt collection workflow.
The system should use Google Sheets as its data source. The sheet contains contact records — names, email addresses, and payment/overdue details for clients who are late on payments.
Based on this data, the system needs to:
- Read client records automatically from the Google Sheet
- Send follow-up emails on a recurring schedule (every 2 days) to the relevant contacts
- Use pre-set email templates that are automatically personalized with each client's data (name, amount, due date, and other fields from the sheet)
- Track which emails have been sent and when, so the timing stays consistent per contact
- Stop or pause sending for a given contact when their status changes (e.g., marked as paid)
Additional features will be discussed in a call — there are further requirements beyond the core email automation described above.
Openen op Upwork