Today's reservations sent to your staff group

{
  "name": "Today's reservations sent to your staff group (Flowngn)",
  "nodes": [
    {
      "parameters": {
        "content": "## Today's reservations sent to your staff group\nEvery afternoon, your floor team gets today's bookings on Telegram: times, names, guests and notes.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
        "height": 260,
        "width": 340
      },
      "id": "2473c6c3-ba78-4235-a758-cbde9652839a",
      "name": "Setup notes",
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        -420,
        -60
      ]
    },
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 16
            }
          ]
        }
      },
      "id": "2473c6c3-ba78-4235-a758-cbde9652839a",
      "name": "Every day 16:00",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        0,
        0
      ]
    },
    {
      "parameters": {
        "operation": "read",
        "documentId": {
          "__rl": true,
          "value": "YOUR_SPREADSHEET_ID",
          "mode": "id"
        },
        "sheetName": {
          "__rl": true,
          "value": "Reservations",
          "mode": "name"
        },
        "options": {}
      },
      "id": "2473c6c3-ba78-4235-a758-cbde9652839a",
      "name": "Read reservations",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        300,
        0
      ]
    },
    {
      "parameters": {
        "jsCode": "// Reservations sheet columns: date (YYYY-MM-DD) | time | name | phone | guests | notes | status\n// Builds today's booking list for the floor team, in time order.\nconst today = new Date().toISOString().slice(0, 10);\n\nconst rows = $input.all()\n  .map((item) => item.json)\n  .filter((r) => String(r.date).slice(0, 10) === today && String(r.status).toLowerCase() !== \"cancelled\")\n  .sort((a, b) => String(a.time).localeCompare(String(b.time)));\n\nif (!rows.length) return [{ json: { message: `No reservations today (${today}).` } }];\n\nconst guests = rows.reduce((sum, r) => sum + (Number(r.guests) || 0), 0);\nconst list = rows.map((r) => `${r.time}  ${r.name} · ${r.guests} guests${r.notes ? ` · ${r.notes}` : \"\"}`).join(\"\\n\");\n\nreturn [{ json: { message: `🍽 Today: ${rows.length} bookings, ${guests} guests\\n\\n${list}` } }];"
      },
      "id": "2473c6c3-ba78-4235-a758-cbde9652839a",
      "name": "Today's bookings",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        600,
        0
      ]
    },
    {
      "parameters": {
        "chatId": "YOUR_CHAT_ID",
        "text": "={{ $json.message }}",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "id": "2473c6c3-ba78-4235-a758-cbde9652839a",
      "name": "Send to staff group",
      "type": "n8n-nodes-base.telegram",
      "typeVersion": 1.2,
      "position": [
        900,
        0
      ]
    }
  ],
  "connections": {
    "Every day 16:00": {
      "main": [
        [
          {
            "node": "Read reservations",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read reservations": {
      "main": [
        [
          {
            "node": "Today's bookings",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Today's bookings": {
      "main": [
        [
          {
            "node": "Send to staff group",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "meta": {
    "templateCredsSetupCompleted": false
  },
  "tags": []
}