{
  "name": "Jobs newsletter automation system (N8N, Bolt.new, RapidAPI, Mails.so & ChatGPT)",
  "nodes": [
    {
      "id": "e125e5b8-eb83-4907-a149-6975df76fc80",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -280,
        0
      ]
    },
    {
      "id": "7e5fd2a0-5e1b-461c-b24d-bacd248bd471",
      "name": "Confirm Email Validity",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        380,
        180
      ]
    },
    {
      "id": "fc0c24fd-8243-4892-862e-61d31d62ac0e",
      "name": "Send Email1",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        380,
        -160
      ]
    },
    {
      "id": "c14789f7-06b6-42de-8459-7fd7a30a4b38",
      "name": "If1",
      "type": "n8n-nodes-base.if",
      "position": [
        580,
        180
      ]
    },
    {
      "id": "3b23881d-e393-4686-9356-aa43e08611bf",
      "name": "Merge",
      "type": "n8n-nodes-base.merge",
      "position": [
        1140,
        -160
      ]
    },
    {
      "id": "82960352-541b-49a6-b1f7-114583be0feb",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -300,
        1200
      ]
    },
    {
      "id": "a246e968-15be-4492-bbc1-c99a5937d794",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        540,
        1040
      ]
    },
    {
      "id": "a284e406-f403-4837-abf9-e770d222f773",
      "name": "Merge1",
      "type": "n8n-nodes-base.merge",
      "position": [
        1640,
        1180
      ]
    },
    {
      "id": "e8a459f4-e498-42b8-a901-e107864e260c",
      "name": "Aggregate",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1320,
        1040
      ]
    },
    {
      "id": "ad32bd78-a7f9-4225-9a8b-410330a5c043",
      "name": "Aggregate1",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1220,
        1320
      ]
    },
    {
      "id": "ff46019a-9524-4d0c-954b-4a796c531534",
      "name": "Webhook1",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -280,
        660
      ]
    },
    {
      "id": "347f8cbe-52f4-4f99-81d0-99e93c4860fc",
      "name": "get rows in all subscribers sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -60,
        660
      ]
    },
    {
      "id": "de531168-450e-4177-9c88-6bdeb51170b8",
      "name": "change status to unsubscribed",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        160,
        660
      ]
    },
    {
      "id": "6202d3eb-4f86-4b19-84c9-50a02f136cac",
      "name": "add to unsubscribed sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        380,
        660
      ]
    },
    {
      "id": "e567a35a-83be-48aa-bca6-7f560b18ad0a",
      "name": "get row in subscribed sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        600,
        660
      ]
    },
    {
      "id": "1fad75fe-83a6-4a1d-a235-0890cbc7932f",
      "name": "delete row from subscribed",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        820,
        660
      ]
    },
    {
      "id": "150912ac-0735-4e09-a04e-4dfa2e98def8",
      "name": "Get Subscribers",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -120,
        1200
      ]
    },
    {
      "id": "3f79310b-2609-43b7-b5f4-9b355b9dd5aa",
      "name": "Get Jobs",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        320,
        1040
      ]
    },
    {
      "id": "59c28a80-2863-4a60-b846-5fbf02507140",
      "name": "Summarize Job Descriprions",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        960,
        1040
      ]
    },
    {
      "id": "6fb33d05-c609-460a-8302-e87628380bc4",
      "name": "Format Newsletter",
      "type": "n8n-nodes-base.code",
      "position": [
        1820,
        1180
      ]
    },
    {
      "id": "f4814333-4ec8-4dc0-bedc-df24f54d5abe",
      "name": "Get All Subscribers",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -60,
        0
      ]
    },
    {
      "id": "419bfccb-9d98-4a62-961b-a537ffbc121f",
      "name": "If email is already in database",
      "type": "n8n-nodes-base.if",
      "position": [
        160,
        0
      ]
    },
    {
      "id": "62936656-05ba-4492-9cb3-e924c510c689",
      "name": "Send Welcome Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        780,
        -320
      ]
    },
    {
      "id": "f0e80aea-bd08-4a58-b8ae-89782a9662a5",
      "name": "Add Email to All Subscribers Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        780,
        -160
      ]
    },
    {
      "id": "cb8d80f2-06d5-4409-a896-e802cc32dab5",
      "name": "Add Email to Subscribed Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        780,
        0
      ]
    },
    {
      "id": "5a877277-10be-4076-887d-f23477222dbb",
      "name": "Notification of Already Exists",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        540,
        -320
      ]
    },
    {
      "id": "51152701-7da3-499e-84dc-eb3fda51cc50",
      "name": "Notification of Invalid Email",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        780,
        280
      ]
    },
    {
      "id": "dc2166ef-eb75-4203-a88a-6d10009eb19e",
      "name": "Notification of Successful Subscription",
      "type": "n8n-nodes-base.respondToWebhook",
      "position": [
        1340,
        -160
      ]
    },
    {
      "id": "59497004-29f0-4ef5-9cc6-5b5ff43b8cf5",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        -420
      ],
      "parameters": {
        "width": 1920,
        "height": 900,
        "content": "## Manage Subscriptions with bolt.new frontend"
      }
    },
    {
      "id": "0de46767-048c-4c0f-972a-6e14e05921ea",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        960
      ],
      "parameters": {
        "width": 2540,
        "height": 560,
        "content": "## Scrap Jobs, Format Newsletter and Send to Subscribers"
      }
    },
    {
      "id": "f0d3506b-8a79-44c7-b2a3-206d32f03749",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -340,
        560
      ],
      "parameters": {
        "width": 1700,
        "height": 320,
        "content": "## Manage Unsubscriptions"
      }
    },
    {
      "id": "add9d4b3-e004-44ea-8055-a206a3a367f2",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2420,
        1200
      ]
    },
    {
      "id": "3d879853-1a3b-4612-a65d-1f8710a5e3f0",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2340,
        1120
      ],
      "parameters": {
        "width": 280,
        "height": 260,
        "content": "## Gmail Send Email Alternative (Newsletter)"
      }
    },
    {
      "id": "e5c32535-c5e7-44d2-81fb-481108f726bd",
      "name": "Stop and Error",
      "type": "n8n-nodes-base.stopAndError",
      "position": [
        320,
        1300
      ]
    },
    {
      "id": "d6c2a737-5cb9-4ba8-81e6-72d0fb280780",
      "name": "If there are subscribers",
      "type": "n8n-nodes-base.if",
      "position": [
        60,
        1200
      ]
    },
    {
      "id": "ca6c833f-04fe-4979-9221-949e6acc52e7",
      "name": "Send Newsletter",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        2000,
        1180
      ]
    },
    {
      "id": "49e25db4-3183-4afc-ad93-5a681d27ff8b",
      "name": "Send Email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        1040,
        660
      ]
    },
    {
      "id": "cc9f78ed-8de0-436c-a164-a0b151517f13",
      "name": "Gmail1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1540,
        680
      ]
    },
    {
      "id": "22152918-e32b-40c0-8924-c4f4f854b290",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1460,
        600
      ],
      "parameters": {
        "width": 280,
        "height": 260,
        "content": "## Gmail Send Email Alternative (Unscubscription)"
      }
    },
    {
      "id": "ed07df99-2c29-4229-a094-83eae1d77965",
      "name": "Gmail2",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1780,
        -240
      ]
    },
    {
      "id": "a37b27ce-a796-40b7-8fa0-8ab2fd276b6d",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1700,
        -320
      ],
      "parameters": {
        "width": 280,
        "height": 260,
        "content": "## Gmail Send Email Alternative (Email Exists)"
      }
    },
    {
      "id": "e01f3884-309e-4e04-ad5f-77acd08a42d2",
      "name": "Gmail3",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1780,
        220
      ]
    },
    {
      "id": "b4c5f6d4-7fad-45b7-ba78-d95b16bd181e",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1700,
        140
      ],
      "parameters": {
        "width": 280,
        "height": 260,
        "content": "## Gmail Send Email Alternative (Welcome Email)"
      }
    }
  ],
  "connections": {
    "If1": {
      "main": [
        [
          {
            "node": "Send Welcome Email",
            "type": "main",
            "index": 0
          },
          {
            "node": "Add Email to All Subscribers Sheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Add Email to Subscribed Sheet",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Notification of Invalid Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "Notification of Successful Subscription",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge1": {
      "main": [
        [
          {
            "node": "Format Newsletter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook": {
      "main": [
        [
          {
            "node": "Get All Subscribers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Jobs": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Webhook1": {
      "main": [
        [
          {
            "node": "get rows in all subscribers sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Summarize Job Descriprions",
            "type": "main",
            "index": 0
          },
          {
            "node": "Aggregate1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate1": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Send Email1": {
      "main": [
        [
          {
            "node": "Notification of Already Exists",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Subscribers": {
      "main": [
        [
          {
            "node": "If there are subscribers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Subscribers",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Newsletter": {
      "main": [
        [
          {
            "node": "Send Newsletter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Welcome Email": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get All Subscribers": {
      "main": [
        [
          {
            "node": "If email is already in database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Confirm Email Validity": {
      "main": [
        [
          {
            "node": "If1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If there are subscribers": {
      "main": [
        [
          {
            "node": "Get Jobs",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Stop and Error",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "add to unsubscribed sheet": {
      "main": [
        [
          {
            "node": "get row in subscribed sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Summarize Job Descriprions": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "delete row from subscribed": {
      "main": [
        [
          {
            "node": "Send Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get row in subscribed sheet": {
      "main": [
        [
          {
            "node": "delete row from subscribed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Email to Subscribed Sheet": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "change status to unsubscribed": {
      "main": [
        [
          {
            "node": "add to unsubscribed sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If email is already in database": {
      "main": [
        [
          {
            "node": "Send Email1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Confirm Email Validity",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "get rows in all subscribers sheet": {
      "main": [
        [
          {
            "node": "change status to unsubscribed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add Email to All Subscribers Sheet": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    }
  }
}