{
  "name": "Automate task deadline reminders with Google Sheets and Gmail (Today/3-Day/7-Day)",
  "nodes": [
    {
      "id": "08768d18-2772-427a-974a-d30c58d1ef17",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1344,
        176
      ]
    },
    {
      "id": "a6384770-85d5-44d9-922d-d8cbbd6ef1b1",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -976,
        176
      ]
    },
    {
      "id": "52601fc4-d727-4fc2-9e0a-55ef26f15890",
      "name": "3日以内",
      "type": "n8n-nodes-base.if",
      "position": [
        -304,
        192
      ]
    },
    {
      "id": "12de70d4-d78b-43a5-8f7e-bc5993156fe5",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1696,
        176
      ]
    },
    {
      "id": "d7dd5c40-dc43-43d4-8436-67795810d2af",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1760,
        0
      ],
      "parameters": {
        "width": null,
        "height": 352,
        "content": "## Schedule Trigger \nRuns the workflow every morning at the specified time so task deadlines are checked automatically without manual execution."
      }
    },
    {
      "id": "8776e349-fc05-4267-a514-984938c61a2b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2784,
        -688
      ],
      "parameters": {
        "width": 992,
        "height": 1632,
        "content": "## Task Deadline Reminder Workflow (Today / 3-Day / 7-Day)\nTask deadline management manually is inefficient and leads to missed deadlines—especially when teams rely on spreadsheets and individual remi"
      }
    },
    {
      "id": "72348edd-acc7-4680-afa0-f146fc0cc26c",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1440,
        0
      ],
      "parameters": {
        "width": null,
        "height": 352,
        "content": "## Fetch Tasks from Google Sheets\nLoads all task records from the Google Sheets task table, including task name, deadline, person in charge, and email address."
      }
    },
    {
      "id": "a12c8197-4ca2-4dcc-8316-bbd025920234",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1104,
        0
      ],
      "parameters": {
        "width": 352,
        "height": 352,
        "content": "## Loop Over Task Items\nIterates through each task row one by one so the workflow can evaluate deadlines individually."
      }
    },
    {
      "id": "3e166602-8714-4e91-a9a4-fe992a6ce102",
      "name": "Check Due Today (IF)",
      "type": "n8n-nodes-base.if",
      "position": [
        -752,
        -240
      ]
    },
    {
      "id": "86f8b164-298c-4eae-bda9-845260819e1d",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -864,
        -400
      ],
      "parameters": {
        "width": 304,
        "height": 352,
        "content": "## Check Due Today (IF)\nChecks whether the task deadline matches today’s date to identify tasks that are due today and require immediate notification."
      }
    },
    {
      "id": "6ee54db5-53ae-4797-a2f9-5e2808789ae3",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -544,
        -432
      ],
      "parameters": {
        "width": 304,
        "height": 384,
        "content": "## Send Today Reminder (Gmail)\nSends an email to the responsible person informing them that their task is due today, including task details and assignee information."
      }
    },
    {
      "id": "9df08c88-0741-4e23-9a71-d08f2a4c4e67",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -32
      ],
      "parameters": {
        "width": null,
        "height": 352,
        "content": "## Check Within 3 Days (IF)\nDetermines whether the task deadline falls within the next three days, allowing early reminders before the final due date."
      }
    },
    {
      "id": "5300b4c9-d828-48bd-8bee-d9c1baa57a6b",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -144,
        16
      ],
      "parameters": {
        "width": null,
        "height": 368,
        "content": "## Send 3-Day Reminder (Gmail)\nSends an email to notify the responsible person that the task deadline is approaching within three days."
      }
    },
    {
      "id": "f4cd32ed-a34b-4145-a736-7ddba10671e3",
      "name": "Send 3-Day Reminder (Gmail)",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -80,
        208
      ]
    },
    {
      "id": "ab9f3b5f-596d-4b02-b4c4-deeda51c177e",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        176
      ],
      "parameters": {
        "width": null,
        "height": 352,
        "content": "## Check Within 7 Days (IF)\nChecks if the task deadline is within seven days from today to provide weekly reminder notifications."
      }
    },
    {
      "id": "636a78d4-956c-4410-b83f-1b0f5ee7fe48",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        256
      ],
      "parameters": {
        "width": null,
        "height": 352,
        "content": "## Send 7-Day Reminder (Gmail)\nSends a weekly deadline reminder email to the assigned person for tasks that are due within the next seven days."
      }
    },
    {
      "id": "a9fbc2c9-d40b-4ad5-8d1d-d53d55f5b6e6",
      "name": "Check Within 7 Days (IF)",
      "type": "n8n-nodes-base.if",
      "position": [
        176,
        368
      ]
    },
    {
      "id": "6d1d23a2-cc0c-4be9-bb48-e7807556e397",
      "name": "Send 7-Day Reminder",
      "type": "n8n-nodes-base.gmail",
      "position": [
        464,
        448
      ]
    }
  ],
  "connections": {
    "3日以内": {
      "main": [
        [
          {
            "node": "Send 3-Day Reminder (Gmail)",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Check Within 7 Days (IF)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Check Due Today (IF)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send 7-Day Reminder": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Due Today (IF)": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "3日以内",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Within 7 Days (IF)": {
      "main": [
        [
          {
            "node": "Send 7-Day Reminder",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send 3-Day Reminder (Gmail)": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}