
In Progress
Posted
Paid on delivery
I need Twilio wired into an existing Laravel-based site to automate follow-up emails to our volunteers. Inside the MySQL database we store a session_start_date for every volunteer; exactly 60 calendar days after that date the system must generate and dispatch an email. Core requirements • Build a clean, reusable Laravel command (or job/queue) that scans the sessions table, finds records that hit the 60-day mark, and composes an email in BOTH plain-text and HTML. • Integrate with Twilio’s email service (SendGrid) so delivery, bounces, and templates are all handled there. • Respect each volunteer’s individual time zone; the send time should feel local to them. • Record every send in a dedicated database table so we can audit who was contacted and when. I’ll trigger the job from a cron, but the script should be idempotent—no duplicate messages even if the cron overlaps. Clean, commented code that follows PSR-12 and Laravel best practices is expected. Once finished I’d like a brief read-me explaining how to adjust the offset (currently 60 days) and where to modify the email template. If this sounds straightforward to you and you have solid PHP, Laravel, MySQL, and Twilio/SendGrid experience, let’s get started.
Project ID: 40278989
220 proposals
Remote project
Active 4 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs