{
  "name": "Automate email follow-ups with Gmail & Google Sheets using multi-stage sequences",
  "nodes": [
    {
      "id": "8d075e52-b287-42cd-b875-13e9db056ffc",
      "name": "Daily at 9 AM",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -608,
        128
      ]
    },
    {
      "id": "5fbc9862-fee7-4a3d-a12f-c75e200cd1e0",
      "name": "Read All Follow-Up Leads",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -320,
        128
      ]
    },
    {
      "id": "f06c504b-931d-45a7-9e4a-f451cbfd1c74",
      "name": "Filter Today's Follow-Ups",
      "type": "n8n-nodes-base.filter",
      "position": [
        64,
        144
      ]
    },
    {
      "id": "f636570a-a769-4bab-a5b1-8bab12c95936",
      "name": "Process One at a Time",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        400,
        144
      ]
    },
    {
      "id": "b9b6cdf6-705e-4ca6-a0f1-be0ce3f81846",
      "name": "Route by Follow-Up Stage",
      "type": "n8n-nodes-base.switch",
      "position": [
        -624,
        720
      ]
    },
    {
      "id": "94ea2fb4-1c48-4b53-a4e2-12a247598f94",
      "name": "Send Day 1 Follow-Up",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -320,
        480
      ]
    },
    {
      "id": "2b6551c3-a614-495b-a00b-e95be20d774f",
      "name": "Send Day 3 Follow-Up",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -320,
        656
      ]
    },
    {
      "id": "14e055f7-79ad-469d-a7ee-34414d75406f",
      "name": "Send Day 7 Follow-Up",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -320,
        848
      ]
    },
    {
      "id": "df6840e0-319a-4a7c-81f0-cb80971d2554",
      "name": "Send Day 14 Final Follow-Up",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -320,
        1040
      ]
    },
    {
      "id": "68c62208-ed32-4a69-a99f-e8db094d3a4c",
      "name": "Update Last Sent Date",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        64,
        752
      ]
    },
    {
      "id": "321778a9-d503-4a77-bbac-4c7c2b9e34bd",
      "name": "Calculate Next Follow-Up",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        400,
        752
      ]
    },
    {
      "id": "d0a52a65-4899-4943-ac7f-85ac1001581b",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1856,
        -32
      ],
      "parameters": {
        "width": 576,
        "height": 1280,
        "content": "# 🔄 Daily Follow-Up System with Multi-Stage Sequences\n\n## What It Does\nAutomatically sends timed follow-up emails to leads based on a 4-stage sequence (Day 1, 3, 7, 14), updates tracking automatically"
      }
    },
    {
      "id": "d3cf7fe8-01d9-4815-b183-674e24489234",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        -32
      ],
      "parameters": {
        "width": 608,
        "height": 368,
        "content": "## Step 1: Start Daily Follow-Up Run\nPurpose: Trigger the workflow every morning and load all leads that are part of the follow-up sequence."
      }
    },
    {
      "id": "2c0fc58e-a357-4ae8-b298-0e49d8f00707",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        -32
      ],
      "parameters": {
        "width": 640,
        "height": 368,
        "content": "## Step 2: Select And Queue Today's Leads\nPurpose: Filter only active leads scheduled for follow-up today and queue them to be processed one by one.\n"
      }
    },
    {
      "id": "973d3182-409b-4383-8430-2fb2f6e164d8",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -672,
        352
      ],
      "parameters": {
        "width": 608,
        "height": 896,
        "content": "## Step 3: Send Stage-Specific Follow-Up Email\nPurpose: Route each lead to the correct follow-up stage and send the appropriate email template for that day in the sequence."
      }
    },
    {
      "id": "729333d1-5e9e-4505-83ac-7ff5c6210731",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -48,
        352
      ],
      "parameters": {
        "width": 640,
        "height": 896,
        "content": "## Step 4: Update Timeline And Next Follow-Up\nPurpose: Log when the last follow-up was sent and calculate the next follow-up date and stage status in the tracker.\n"
      }
    },
    {
      "id": "051e1ca3-186f-4062-ba38-ef7af1eec8b7",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1264,
        -32
      ],
      "parameters": {
        "width": 576,
        "height": 1280,
        "content": "## 🔧 Customization Options\n\n- **Change Timing**: Modify intervals in node 8 (currently 2, 4, 7 days between stages)\n- **Add More Stages**: Add new Switch outputs and email templates (e.g., Day 21, Day"
      }
    }
  ],
  "connections": {
    "Daily at 9 AM": {
      "main": [
        [
          {
            "node": "Read All Follow-Up Leads",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Day 1 Follow-Up": {
      "main": [
        [
          {
            "node": "Update Last Sent Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Day 3 Follow-Up": {
      "main": [
        [
          {
            "node": "Update Last Sent Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Day 7 Follow-Up": {
      "main": [
        [
          {
            "node": "Update Last Sent Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Process One at a Time": {
      "main": [
        [
          {
            "node": "Route by Follow-Up Stage",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "Update Last Sent Date": {
      "main": [
        [
          {
            "node": "Calculate Next Follow-Up",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read All Follow-Up Leads": {
      "main": [
        [
          {
            "node": "Filter Today's Follow-Ups",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route by Follow-Up Stage": {
      "main": [
        [
          {
            "node": "Send Day 1 Follow-Up",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Day 3 Follow-Up",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Day 7 Follow-Up",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Send Day 14 Final Follow-Up",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Today's Follow-Ups": {
      "main": [
        [
          {
            "node": "Process One at a Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Day 14 Final Follow-Up": {
      "main": [
        [
          {
            "node": "Update Last Sent Date",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}