{
  "name": "Send cold outreach emails and follow-ups with Resend, Postgres and HubSpot",
  "nodes": [
    {
      "id": "eeebdbe7-00df-4419-a947-e142a85b22d3",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -576,
        0
      ]
    },
    {
      "id": "bb239eff-c26c-4dd0-a514-f23de7fc6b2a",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        320,
        16
      ]
    },
    {
      "id": "4ff5ce66-c0dc-4337-95b2-b63c39baa20f",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        -80
      ],
      "parameters": {
        "width": 1440,
        "height": 320,
        "content": "## 1. Get data, send emails and update"
      }
    },
    {
      "id": "b573b321-49c6-4692-86b6-e348a08a396e",
      "name": "Select rows from a table",
      "type": "n8n-nodes-base.postgres",
      "position": [
        -368,
        0
      ]
    },
    {
      "id": "8b26e5b6-9f80-43c6-a885-3d485e8cf958",
      "name": "Update rows in a table",
      "type": "n8n-nodes-base.postgres",
      "position": [
        512,
        16
      ]
    },
    {
      "id": "632c17cb-a473-4cee-ad25-e13a53b42675",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -128,
        0
      ]
    },
    {
      "id": "7e9919bd-0c49-4422-902d-5e82b06d5fef",
      "name": "Wait",
      "type": "n8n-nodes-base.wait",
      "position": [
        96,
        16
      ]
    },
    {
      "id": "4bbc7425-4559-40cd-9070-c9a6eb57b70a",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -560,
        368
      ]
    },
    {
      "id": "03a57adb-aaf0-4e5a-ad5c-556e0a40f7f5",
      "name": "HTTP Request1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        544,
        384
      ]
    },
    {
      "id": "944bbf6e-c413-44ab-ab15-b595e189eaf3",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -704,
        288
      ],
      "parameters": {
        "width": 1712,
        "height": 320,
        "content": "## 2. Filter by last day contacted, send follow-up, then update"
      }
    },
    {
      "id": "4bd07ed9-e390-47fb-8b13-643ff88beff0",
      "name": "Select rows from a table1",
      "type": "n8n-nodes-base.postgres",
      "position": [
        -352,
        368
      ]
    },
    {
      "id": "27341419-41cb-4bb6-956b-d4456e4d74aa",
      "name": "Update rows in a table1",
      "type": "n8n-nodes-base.postgres",
      "position": [
        736,
        384
      ]
    },
    {
      "id": "3766fe7b-03f1-4638-86af-d06092ef1b2b",
      "name": "Loop Over Items1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        96,
        368
      ]
    },
    {
      "id": "66167648-b165-4a89-8c2f-0841c817f870",
      "name": "Wait1",
      "type": "n8n-nodes-base.wait",
      "position": [
        320,
        384
      ]
    },
    {
      "id": "8c99d9b2-2ccb-4582-aa33-d678ce2632bf",
      "name": "Filter",
      "type": "n8n-nodes-base.filter",
      "position": [
        -144,
        368
      ]
    },
    {
      "id": "d428a0d7-0026-4ad4-a509-70e347b1f9de",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        848,
        16
      ]
    },
    {
      "id": "754080cf-10ce-4db1-b00d-4c65dee32054",
      "name": "Update rows in a table2",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1056,
        16
      ]
    },
    {
      "id": "ddb82642-f103-42aa-a90d-21e059cb2347",
      "name": "Create or update a contact",
      "type": "n8n-nodes-base.hubspot",
      "position": [
        1264,
        16
      ]
    },
    {
      "id": "39e20889-37d6-4426-b747-18247c563841",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        768,
        -80
      ],
      "parameters": {
        "width": 688,
        "height": 320,
        "content": "## 3. Listen to email and stop when user reply. Then append to Hubspot"
      }
    },
    {
      "id": "beb8f635-e03d-473f-81aa-2d9a3c69076d",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1632,
        -208
      ],
      "parameters": {
        "width": 800,
        "height": 1072,
        "content": "## Stop Manual Follow-ups with Automated Email Outreach Pipeline using n8n, Postgres and Resend\n\n## Watch my tutorial \n@[youtube](ZmN8jMhNJS4)\n\n## How it works\n- **The schedule Trigger nodes** are use"
      }
    }
  ],
  "connections": {
    "Wait": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait1": {
      "main": [
        [
          {
            "node": "HTTP Request1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter": {
      "main": [
        []
      ]
    },
    "Webhook": {
      "main": [
        []
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Update rows in a table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request1": {
      "main": [
        [
          {
            "node": "Update rows in a table1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Wait",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items1": {
      "main": [
        [],
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Select rows from a table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "Select rows from a table1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update rows in a table": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update rows in a table1": {
      "main": [
        [
          {
            "node": "Loop Over Items1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update rows in a table2": {
      "main": [
        [
          {
            "node": "Create or update a contact",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Select rows from a table": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Select rows from a table1": {
      "main": [
        [
          {
            "node": "Filter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}