Automate task deadline reminders with Google Sheets and Gmail (Today/3-Day/7-Day)

Task Deadline Reminder Workflow (Today / 3-Day / 7-Day) Task deadline management manually is inefficient and leads to missed deadlines—especially when teams rely on spreadsheets and individual reminders. This workflow automates the entire follow-up process by reading a centralized task sheet in Google Sheets every morning, checking the deadline for each task, and sending automatic email notifications to the responsible person based on urgency. Tasks due today, within three days, or within one week are identified and routed to customized Gmail notifications, ensuring that every team member is aware of upcoming deadlines without manual checking.

Who’s it for This workflow is ideal for teams and organizations that manage multiple tasks across departments and need a reliable way to stay on top of deadlines. It is especially useful for:

- Project managers coordinating many deadlines - Back-office teams monitoring routine operational tasks - Organizations with distributed members - Anyone who relies on spreadsheets but needs automated follow-up

By integrating Google Sheets, n8n, and Gmail, you gain a proactive notification system that keeps everyone aligned and reduces the risk of forgotten tasks.

How it works 1. Daily trigger The workflow runs every morning at 9:00 using a Schedule Trigger.

2. Load task list from Google Sheets The workflow retrieves all rows from the designated spreadsheet, including task name, deadline, responsible person, and email address.

3. Process tasks individually A loop node evaluates each task one by one.

4. Evaluate deadline conditions - Due today: Deadline matches today’s date - Due within 3 days: Deadline falls between today and three days ahead - Due within 7 days: Deadline falls between today and one week ahead