{
  "name": "Send daily real estate construction updates via Gmail & WhatsApp with Google Sheets",
  "nodes": [
    {
      "id": "1ee0759b-7485-41cb-acdb-bda40a17f3e5",
      "name": "Daily Trigger (8:00 AM IST)",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2040,
        60
      ]
    },
    {
      "id": "640457a6-f3d3-492b-b9ca-7c3d8d0b34f8",
      "name": "Set Google Sheet Config",
      "type": "n8n-nodes-base.set",
      "position": [
        -1820,
        60
      ]
    },
    {
      "id": "a90e3dc3-fdcd-4d27-b1d1-02943146ad02",
      "name": "Read Google Sheet Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1600,
        60
      ]
    },
    {
      "id": "2a48679b-71b1-4479-8080-f3e16dc3498a",
      "name": "Filter Today's Reports",
      "type": "n8n-nodes-base.filter",
      "position": [
        -1380,
        60
      ]
    },
    {
      "id": "9f461a8c-2971-44a9-bbbf-b64b9a02ea60",
      "name": "Check If Reports Found",
      "type": "n8n-nodes-base.if",
      "position": [
        -1160,
        60
      ]
    },
    {
      "id": "18c77930-ada3-43a7-9835-54a1c6fbd8c2",
      "name": "Set Notification Recipients",
      "type": "n8n-nodes-base.set",
      "position": [
        -940,
        60
      ]
    },
    {
      "id": "01ee5331-df8e-4fe1-9156-d1c6258b33c8",
      "name": "Create Notification Content",
      "type": "n8n-nodes-base.set",
      "position": [
        -720,
        60
      ]
    },
    {
      "id": "8fe62b99-7e70-4ae0-9ecf-fa5cd5338f10",
      "name": "Send WhatsApp Notification",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        -500,
        160
      ]
    },
    {
      "id": "9576da40-cab9-4a20-b3bb-332696306e30",
      "name": "Send Email Notification",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -500,
        -40
      ]
    },
    {
      "id": "47dc08b6-d4b8-4380-af14-81732c6cf598",
      "name": "Log Successful Notifications",
      "type": "n8n-nodes-base.set",
      "position": [
        -280,
        60
      ]
    },
    {
      "id": "17c027f8-e22b-4169-9562-5e9e0c253344",
      "name": "Sticky Note - Trigger",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2080,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "Triggers every day at 8:00 AM IST to check Google Sheet for new construction reports from contractors."
      }
    },
    {
      "id": "5675361f-8fc5-462b-9591-3b273e5937af",
      "name": "Sticky Note - Config",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1860,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "Configure Google Sheet ID, sheet name, and today's date for filtering the latest reports."
      }
    },
    {
      "id": "27d8d7b0-7fa5-4c22-9921-168c46149118",
      "name": "Sticky Note - Read Sheet",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1640,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "Read all data from the Google Sheet containing contractor reports with project details, progress, and status."
      }
    },
    {
      "id": "26908522-c63d-4dd8-b50c-459e2e04389c",
      "name": "Sticky Note - Filter",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1420,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "Filter the sheet records to get only today's reports based on the Date column."
      }
    },
    {
      "id": "f8cb9405-eb82-4ebc-91c6-e1d332ba3717",
      "name": "Sticky Note - Check Reports",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1200,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "Check if any reports were found for today. If yes, send notifications. If no, send alert to admin."
      }
    },
    {
      "id": "75105320-736f-4c7e-bbcb-8461f26aac49",
      "name": "Sticky Note - Contacts",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -980,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "Email and WhatsApp contact lists for users who should receive daily construction report notifications."
      }
    },
    {
      "id": "5a93ee43-7991-434f-a0d1-da6950826479",
      "name": "Sticky Note - Send Notifications",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -540,
        -160
      ],
      "parameters": {
        "width": 180,
        "height": 500,
        "content": "Send detailed construction reports to all users via Email and WhatsApp with project summaries."
      }
    },
    {
      "id": "d4bd125e-a980-479b-9ab2-e2ba7cb01753",
      "name": "Sticky Note - Logging",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "Log all notification activities with timestamps, recipient count, and project details for audit trail."
      }
    },
    {
      "id": "d13a8eb1-946d-445a-a837-32a4be084e87",
      "name": "Sticky Note - Send Notifications1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -760,
        -120
      ],
      "parameters": {
        "width": 180,
        "height": 340,
        "content": "Create detailed construction reports."
      }
    }
  ],
  "connections": {
    "Check If Reports Found": {
      "main": [
        [
          {
            "node": "Set Notification Recipients",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Filter Today's Reports": {
      "main": [
        [
          {
            "node": "Check If Reports Found",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Google Sheet Data": {
      "main": [
        [
          {
            "node": "Filter Today's Reports",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email Notification": {
      "main": [
        [
          {
            "node": "Log Successful Notifications",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Google Sheet Config": {
      "main": [
        [
          {
            "node": "Read Google Sheet Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send WhatsApp Notification": {
      "main": [
        [
          {
            "node": "Log Successful Notifications",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Notification Content": {
      "main": [
        [
          {
            "node": "Send WhatsApp Notification",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Email Notification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Trigger (8:00 AM IST)": {
      "main": [
        [
          {
            "node": "Set Google Sheet Config",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set Notification Recipients": {
      "main": [
        [
          {
            "node": "Create Notification Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}