Deadline Reminder (june 23)

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 →

{
  "name": "06 - Deadline Reminder (June 23)",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 10 23 6 *"
            }
          ]
        }
      },
      "id": "schedule-june23",
      "name": "June 23 at 10 AM (7 days before deadline)",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        240,
        300
      ]
    },
    {
      "parameters": {
        "operation": "getAll",
        "documentId": {
          "value": "={{ $env.GOOGLE_SHEETS_ID }}"
        },
        "sheetName": {
          "value": "Leads"
        },
        "filters": {}
      },
      "id": "get-warm-leads",
      "name": "Get All Leads",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        460,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "// Filter Warm leads who haven't enrolled\nconst items = $input.all();\nreturn items.filter(item => {\n  const score = item.json['Lead Score'];\n  const status = item.json['Lead Status'];\n  return score === 'Warm' && status !== 'Enrolled' && status !== 'Lost' && item.json['Phone Number'];\n});"
      },
      "id": "filter-warm",
      "name": "Filter Warm Leads",
      "type": "n8n-nodes-base.code",
      "position": [
        680,
        300
      ]
    },
    {
      "parameters": {
        "url": "=https://graph.facebook.com/v19.0/{{ $env.WHATSAPP_PHONE_NUMBER_ID }}/messages",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "=Bearer {{ $env.WHATSAPP_ACCESS_TOKEN }}"
            }
          ]
        },
        "sendBody": true,
        "contentType": "json",
        "body": "={\n  \"messaging_product\": \"whatsapp\",\n  \"to\": \"{{ $json['Phone Number'].replace('+','') }}\",\n  \"type\": \"text\",\n  \"text\": {\n    \"body\": \"\u23f0 *Admission Closing Soon \u2014 IIST Indore*\\n\\nHi{{ $json['Student Name'] ? ' ' + $json['Student Name'] : '' }}! Only *7 days left* to apply for B.Tech 2026! \ud83c\udf93\\n\\n\ud83d\udcc5 Last date: *June 30, 2026*\\n\ud83c\udfeb Courses: CSE, ECE, IT, ME, Civil, MBA\\n\ud83d\udca1 Scholarships available!\\n\\n\ud83d\udc49 Apply now: iist.ac.in/apply\\nOr reply to this message \u2014 we'll help you! \ud83d\ude0a\"\n  }\n}"
      },
      "id": "send-deadline-reminder",
      "name": "Send Deadline Reminder",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        900,
        300
      ]
    }
  ],
  "connections": {
    "June 23 at 10 AM (7 days before deadline)": {
      "main": [
        [
          {
            "node": "Get All Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get All Leads": {
      "main": [
        [
          {
            "node": "Filter Warm Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Warm Leads": {
      "main": [
        [
          {
            "node": "Send Deadline Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "tags": [
    "admitbot",
    "phase-4"
  ]
}

About this workflow

06 - Deadline Reminder (June 23). Uses googleSheets, httpRequest. Scheduled trigger; 4 nodes.

Source: https://github.com/anshika-codes-AI/IIST-AdmitBot/blob/d62fdcdd848b062920b1787d81ac106df7797652/n8n-workflows/06-deadline-reminder.json — 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.