Automated daily task reminder emails with Google Sheets & SMTP
Needs changesWhat 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).
- Read Content Calendar (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Send Reminder Email (Send Email): sends an email over SMTP
- Code: runs custom JavaScript code
- Update row in sheet (Google Sheets): uses Google Sheets
Services it uses
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.0 | Replace with |
|---|---|
| Cron Daily Reminder Trigger | Schedule Trigger |
Nodes used (5)
- Cron
n8n-nodes-base.cron - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Send Email
n8n-nodes-base.emailSend - Code
n8n-nodes-base.code
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…