Deadline Reminder Bot

{
  "id": "6D4OcntV18Okzk0L",
  "meta": {
    "instanceId": "7b35059aff065837b1c7d24142b37474554b08b3370f3096b2e57345690d178e",
    "templateCredsSetupCompleted": true
  },
  "name": "Deadline Reminder Bot",
  "tags": [],
  "nodes": [
    {
      "id": "3e1e6a13-1d58-4ce1-917c-facf8de988ef",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -920,
        -40
      ],
      "parameters": {
        "color": 6,
        "width": 1480,
        "height": 520,
        "content": "Deadline Reminder Bot\n\nThis workflow will:\n\n📅 Check for tasks due today → 🧠 Summarize using OpenAI → 📧 Send personalized reminder to each person\n"
      },
      "typeVersion": 1
    },
    {
      "id": "0d4ce22a-af27-493f-a3f3-60cc4159b80c",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -860,
        220
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ad804a56-f16b-49f3-8a08-67f77036e98e",
      "name": "Get row(s) in sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -660,
        220
      ],
      "parameters": {
        "options": {},
        "sheetName": "YOUR_SHEET_NAME",
        "documentId": "YOUR_SHEET_ID"
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "ysB9wq12yE1X904W",
          "name": "Google Sheets – Team Account"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "f01c9f74-1ea7-4a1e-96bb-6cc47fc767f8",
      "name": "If1",
      "type": "n8n-nodes-base.if",
      "position": [
        -440,
        220
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "a7001922-5150-4890-adeb-5c1fabfe206b",
              "operator": {
                "name": "filter.operator.equals",
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json['Due Date'] }}",
              "rightValue": "={{ $now.format('yyyy-MM-dd') }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "09c04680-a24a-47fd-81a4-0294c0fb1393",
      "name": "Summarize1",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -180,
        140
      ],
      "parameters": {
        "options": {
          "outputFormat": "separateItems"
        },
        "fieldsToSplitBy": "Assignee",
        "fieldsToSummarize": {
          "values": [
            {
              "field": "Task"
            },
            {
              "field": "Task",
              "aggregation": "append"
            },
            {
              "field": "Email",
              "aggregation": "min"
            },
            {
              "field": "Status",
              "aggregation": "append"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "dd85219d-245e-4c62-9bb2-336a72e86498",
      "name": "Message a model1",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        0,
        140
      ],
      "parameters": {
        "modelId": "chatgpt-4o-latest",
        "options": {},
        "messages": {
          "values": [
            {
              "role": "assistant",
              "content": "=You are a productivity assistant. Write a short task summary email for {{ $json[\"Assignee\"] }}.\nalso write to and put their email {{ $json.min_Email }} into it.\nHere are their tasks due today:{{ $json.appended_Task }}\nStatuses:{{ $json.appended_Status }}\nMake it clear, professional, and motivating.\n"
            }
          ]
        },
        "jsonOutput": true
      },
      "credentials": {
        "openAiApi": {
          "id": "a0jh6VCqkdOTDXdO",
          "name": "OpenAI – Assistant API"
        }
      },
      "typeVersion": 1.8
    },
    {
      "id": "b21439e6-67c4-4550-9315-cb0e8757a267",
      "name": "Send a message1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        340,
        140
      ],
      "parameters": {
        "sendTo": "={{ $json.message.content.to }}",
        "message": "={{ $json.message.content.body }}",
        "options": {},
        "subject": "={{ $json.message.content.subject }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "7hMKLS1iFqJfK2dk",
          "name": "Gmail – Notification Account"
        }
      },
      "typeVersion": 2.1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d70e8a4a-3faf-4ac8-8127-09473d053254",
  "connections": {
    "If1": [
      [
        {
          "node": "Summarize1",
          "type": "main",
          "index": 0
        }
      ]
    ],
    "Summarize1": [
      [
        {
          "node": "Message a model1",
          "type": "main",
          "index": 0
        }
      ]
    ],
    "Message a model1": [
      [
        {
          "node": "Send a message1",
          "type": "main",
          "index": 0
        }
      ]
    ],
    "Schedule Trigger1": [
      [
        {
          "node": "Get row(s) in sheet1",
          "type": "main",
          "index": 0
        }
      ]
    ],
    "Get row(s) in sheet1": [
      [
        {
          "node": "If1",
          "type": "main",
          "index": 0
        }
      ]
    ]
  }
}