Daily Hod Report (8 Am)

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": "04 - Daily HOD Report (8 AM)",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 8 * * *"
            }
          ]
        }
      },
      "id": "schedule-8am",
      "name": "Every Day at 8 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        240,
        300
      ]
    },
    {
      "parameters": {
        "operation": "getAll",
        "documentId": {
          "value": "={{ $env.GOOGLE_SHEETS_ID }}"
        },
        "sheetName": {
          "value": "Leads"
        },
        "filters": {}
      },
      "id": "get-leads",
      "name": "Get All Leads",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        460,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "// Compute today's summary from Google Sheets data\nconst today = new Date().toISOString().split('T')[0];\nconst items = $input.all();\n\nlet total = 0, hot = 0, warm = 0, cold = 0, enrolled = 0;\nconst sources = {};\n\nfor (const item of items) {\n  const ts = String(item.json.Timestamp || '');\n  if (!ts.startsWith(today)) continue;\n  total++;\n  const score = String(item.json['Lead Score'] || '').trim();\n  if (score === 'Hot') hot++;\n  else if (score === 'Warm') warm++;\n  else cold++;\n  if (String(item.json['Lead Status']).toLowerCase() === 'enrolled') enrolled++;\n  const src = String(item.json['Source Channel'] || 'Other');\n  sources[src] = (sources[src] || 0) + 1;\n}\n\nconst srcSummary = Object.entries(sources).map(([k,v]) => `${k}: ${v}`).join(', ');\n\nreturn [{\n  json: { total, hot, warm, cold, enrolled, sources_summary: srcSummary, date: today }\n}];"
      },
      "id": "compute-summary",
      "name": "Compute Daily Summary",
      "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\": \"{{ $env.HOD_WHATSAPP_NUMBER.replace('+','') }}\",\n  \"type\": \"text\",\n  \"text\": {\n    \"body\": \"\ud83d\udcca *IIST AdmitBot \u2014 Daily Report*\\n\ud83d\udcc5 {{ $json.date }}\\n\\n\ud83d\udce5 Total Enquiries: {{ $json.total }}\\n\ud83d\udd25 Hot Leads: {{ $json.hot }}\\n\ud83d\udfe1 Warm Leads: {{ $json.warm }}\\n\ud83d\udd35 Cold Leads: {{ $json.cold }}\\n\u2705 Enrolled Today: {{ $json.enrolled }}\\n\\n\ud83d\udce1 Sources: {{ $json.sources_summary }}\\n\\n\ud83d\udc49 Full dashboard: {{ $env.LOOKER_DASHBOARD_URL }}\"\n  }\n}"
      },
      "id": "send-hod-report",
      "name": "Send HOD Report",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        900,
        300
      ]
    }
  ],
  "connections": {
    "Every Day at 8 AM": {
      "main": [
        [
          {
            "node": "Get All Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get All Leads": {
      "main": [
        [
          {
            "node": "Compute Daily Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Compute Daily Summary": {
      "main": [
        [
          {
            "node": "Send HOD Report",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "tags": [
    "admitbot",
    "phase-4"
  ]
}

About this workflow

04 - Daily HOD Report (8 AM). Uses googleSheets, httpRequest. Scheduled trigger; 4 nodes.

Source: https://github.com/anshika-codes-AI/IIST-AdmitBot/blob/d62fdcdd848b062920b1787d81ac106df7797652/n8n-workflows/04-daily-hod-report.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.