Laravel Email Scheduler via Twilio
Budget: $30 – $250 USD
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.
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.
Related categories:
PHP
MySQL
HTML
Software Development
Laravel
Web Development
Twilio
Database Management
API Integration
SendGrid