Task Deadline Reminders with Google Sheets, ChatGPT & Gmail

This n8n workflow automates task deadline reminders for project managers, team leads, and teams tracking tasks in Google Sheets. It runs daily at 8 AM, pulls tasks due today, crafts friendly personalized messages using ChatGPT, and sends them directly via Gmail—no manual effort required.

The workflow begins with a Schedule Trigger at 8 AM, followed by a Google Sheets node that reads your Tasks sheet (columns: Name, Email, Task, Due Date in YYYY-MM-DD format). An If node filters only rows where Due Date matches today. It then uses a ChatGPT HTTP Request to summarize tasks per person, followed by a 'Message a model' node to interact with your OpenAI Assistant for polished, friendly reminders. Finally, Gmail sends individualized emails to each assignee.

Benefits include massive time savings (no daily manual checks or copy-pasting), AI-powered personalization for better engagement, reduced missed deadlines, and scalability for teams of any size. It boosts productivity by keeping everyone aligned without nagging.

Use cases: Remote teams in project management, agile sprints, marketing campaigns, freelance operations, or any Google Sheets-based task tracking. Quick setup: Add Google Sheets/Gmail/OpenAI credentials in n8n, create a ChatGPT Assistant, and import the workflow.