Templates / Automated daily task reminder emails with Google Sheets & SMTP

Automated daily task reminder emails with Google Sheets & SMTP

Needs changes

by Rahul Joshi ✓ · 207 views · created 2025-07-24 · Project Management

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 6 nodes and runs on a schedule (legacy Cron node). Along the way it connects Google Sheets.

How it runs

Trigger: On a schedule (legacy Cron node).

  1. Read Content Calendar (Google Sheets): uses Google Sheets
  2. Filter: keeps only the items that match a condition
  3. Send Reminder Email (Send Email): sends an email over SMTP
  4. Code: runs custom JavaScript code
  5. Update row in sheet (Google Sheets): uses Google Sheets

Services it uses

Google Sheets

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • Cron in Daily Reminder Trigger: replace with Schedule Trigger.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
Cron
Daily Reminder Trigger
Schedule Trigger

Nodes used (5)

From the author

Description: Automatically send daily reminder emails to your team using this prebuilt n8n workflow integrated with Google Sheets and SMTP. This automation scans a content calendar spreadsheet, filters pending tasks due today, sends personalized reminders to…

Excerpt from Rahul Joshi's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.