AutomationFlowsData & Sheets › Automated Daily Task Reminder Emails with Google Sheets & SMTP

Automated Daily Task Reminder Emails with Google Sheets & SMTP

ByRahul Joshi @rahul08 on n8n.io

Description:

Cron / scheduled trigger★★★★☆ complexity12 nodesGoogle SheetsEmail Send
Data & Sheets Trigger: Cron / scheduled Nodes: 12 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #6365 — we link there as the canonical source.

This workflow follows the Emailsend → Google Sheets recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "id": "4CEVNvAxTcHxo9DD",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Reminder email",
  "tags": [],
  "nodes": [
    {
      "id": "d0351dad-1983-4dbc-a823-33aacbac1610",
      "name": "Daily Reminder Trigger",
      "type": "n8n-nodes-base.cron",
      "position": [
        -1328,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "72e59a50-855c-46c4-a08f-86ba7fef5f7e",
      "name": "Read Content Calendar",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1104,
        0
      ],
      "parameters": {},
      "typeVersion": 4
    },
    {
      "id": "88e008b6-d682-47f4-98b0-174c4539fcdb",
      "name": "Filter Today's Tasks",
      "type": "n8n-nodes-base.filter",
      "position": [
        -880,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "7c5f2a5f-e1fa-411f-a902-2ffa5c42a384",
      "name": "Send Reminder Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -656,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1c81c65c-b547-400f-89d2-4821bc8c546f",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        -432,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "01e7103e-017c-4daa-ae24-39acebda4443",
      "name": "Update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -208,
        0
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "98dfa376-a5d8-4e1b-b304-a5218ee74cc4",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1424,
        -224
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7a1a69e6-f3d2-4a83-8dba-ebca9afe62e9",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1200,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3447d4fc-6e15-483e-ab07-26ff743b369c",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1008,
        -288
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "dd89d395-60e8-431c-a402-ecbe544a0555",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -752,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "31404004-0e48-46e8-b530-d08d8ecce0a7",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -576,
        -272
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "bf511f72-5e9b-4bb4-a2e4-633e666a0ca8",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -224,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "8f5f4fbb-9a1e-43ca-bc6f-d813247f6450",
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Reminder Email": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Today's Tasks": {
      "main": [
        [
          {
            "node": "Send Reminder Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Content Calendar": {
      "main": [
        [
          {
            "node": "Filter Today's Tasks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Reminder Trigger": {
      "main": [
        [
          {
            "node": "Read Content Calendar",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Description:

Source: https://n8n.io/workflows/6365/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

Security teams, DevOps engineers, vulnerability analysts, and automation builders who want to eliminate repetitive Nessus scan parsing, AI-based risk triage, and manual reporting. Designed for orgs fo

Email Send, HTTP Request, Google Sheets +1
Data & Sheets

This workflow fully automates the reconciliation process between your Local Database transactions and Payment Gateway transactions. It compares both data sources, identifies mismatches, categorizes di

Google Sheets, Email Send
Data & Sheets

This n8n workflow automatically finds apartments for rent in Germany, filters them by your city, rent budget, and number of rooms, and applies to them via email. Each application includes: A personali

HTTP Request, Google Drive, Email Send +1
Data & Sheets

👤 Who it’s for Blue Team leads, CISOs, and SOC managers who want automated visibility into threat metrics, endpoint alerts, and response actions — without needing a full SIEM or BI platform.

HTTP Request, Email Send, Google Sheets
Data & Sheets

Workflow Overview Zoom Attendance Evaluator with Follow-up is an n8n automation workflow that automatically evaluates Zoom meeting attendance and sends follow-up emails to no-shows and early leavers w

Zoom, Item Lists, HTTP Request +3