{
  "name": "Automate bounce email management for lead generation with Gmail and NocoDB",
  "nodes": [
    {
      "id": "32987478-6fa0-4af1-a228-506d1de3b155",
      "name": "DATA",
      "type": "n8n-nodes-base.code",
      "position": [
        -4464,
        960
      ]
    },
    {
      "id": "e0c2ec34-f541-4516-ba88-3f533c0300c2",
      "name": "MERGE",
      "type": "n8n-nodes-base.code",
      "position": [
        -3856,
        544
      ]
    },
    {
      "id": "f274460e-3394-46b3-818f-3f2ddfb831a6",
      "name": "EXTRACT EMAIL",
      "type": "n8n-nodes-base.code",
      "position": [
        -4368,
        544
      ]
    },
    {
      "id": "13ff3901-bad6-4615-83d6-3e4d891e73d4",
      "name": "CHECK INBOX",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        -4608,
        544
      ]
    },
    {
      "id": "ef0f0d7f-d898-411e-8ac1-353c115edf4c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4688,
        288
      ],
      "parameters": {
        "width": 736,
        "height": 480,
        "content": "\n### Step 1: GMAIL TRIGGER\n\n⁠->Monitors your Gmail inbox for bounce or spam messages (like mailer-daemon replies) and extracts the email to compare with your MAIN outreach sheet\n"
      }
    },
    {
      "id": "e7d866ef-2051-48a7-b026-88585a9d99af",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3680,
        288
      ],
      "parameters": {
        "width": 352,
        "height": 480,
        "content": "### Step 3:  CHECK SPAM STATUS\n-> If the email has already been marked as spam, do nothing; else move on to add the \"SPAM\" tag"
      }
    },
    {
      "id": "e9869de3-6f6a-4996-b513-b7ec7082611d",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4000,
        800
      ],
      "parameters": {
        "width": 672,
        "height": 576,
        "content": "### Step 5: GMAIL TAG\n-> Adds \"Unsubscribe\" and/or \"Spam\" in GMAIL\n->Marks as read in GMAIL"
      }
    },
    {
      "id": "66ac7a9f-412d-44c0-8050-cb07de8a700e",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -5232,
        272
      ],
      "parameters": {
        "width": 512,
        "height": 1104,
        "content": "## SPAM MANAGER FOR LEAD GENERATION\n\n\n\n\n## HOW?\n\nThis workflow keeps your sender reputation high \n\nby removing dead, blocked, and invalid emails before they drag down your \n\ncampaigns.\n\nEvery “Deliver"
      }
    },
    {
      "id": "3e1cade6-d84e-46ce-adfb-358df4c24ede",
      "name": "MAIN OUTREACH SHEET",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        -4112,
        544
      ]
    },
    {
      "id": "aa762630-8b44-42ec-b2f2-3d5d46016899",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3936,
        288
      ],
      "parameters": {
        "width": null,
        "height": 480,
        "content": "\n### Step 2: MERGE\n\n⁠->Merge email from the GMAIl node with the emails in your MAIN outreach sheet\n"
      }
    },
    {
      "id": "f561fc71-7f90-4064-b58a-82507091dd8e",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -4688,
        800
      ],
      "parameters": {
        "width": 672,
        "height": 576,
        "content": "### Step 4:  CHECK SPAM STATUS\n->Add the \"SPAM\" tag to the MAIN outreach sheet and also create a copy of the contact in your SPAM sheet"
      }
    },
    {
      "id": "dca0cd60-08a4-4168-9264-7d6e810584be",
      "name": "ADD TO SPAM SHEET",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        -4448,
        1184
      ]
    },
    {
      "id": "12b61410-b706-4e93-a018-37de475581f9",
      "name": "UPDATE SPAM NAME IN MAIN OUTREACH SHEET",
      "type": "n8n-nodes-base.nocoDb",
      "position": [
        -4192,
        912
      ]
    },
    {
      "id": "be8fc34c-bd32-4628-9477-f563cdeecf4a",
      "name": "Already has the spam tag?",
      "type": "n8n-nodes-base.if",
      "position": [
        -3632,
        544
      ]
    },
    {
      "id": "ab021db2-f90b-46e9-99bd-7ade97ea512e",
      "name": "Do Nothing",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -3504,
        416
      ]
    },
    {
      "id": "5f1bd35e-9957-47c8-a403-adc4ab7967ee",
      "name": "1 EMAIL AT A TIME",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -4672,
        1168
      ]
    },
    {
      "id": "72d95930-533d-44a8-ba05-3a7d1b138a7d",
      "name": "1 EMAIL AT A TIME. ",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -3936,
        1120
      ]
    },
    {
      "id": "3bb27522-7756-42eb-be80-841f5b107c1f",
      "name": "ADD UNSUBSCRIBE AND/OR SPAM TAG TO EMAIL",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -3712,
        1088
      ]
    },
    {
      "id": "cc35433e-ef69-433d-817d-44eec777c5e7",
      "name": "MARK EMAIL AS READ",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -3488,
        1184
      ]
    },
    {
      "id": "d6dac5e9-8593-4b8a-a34f-206abb2d20ae",
      "name": "NO OPERATION",
      "type": "n8n-nodes-base.noOp",
      "position": [
        -3536,
        928
      ]
    }
  ],
  "connections": {
    "DATA": {
      "main": [
        [
          {
            "node": "UPDATE SPAM NAME IN MAIN OUTREACH SHEET",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "MERGE": {
      "main": [
        [
          {
            "node": "Already has the spam tag?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "CHECK INBOX": {
      "main": [
        [
          {
            "node": "EXTRACT EMAIL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "EXTRACT EMAIL": {
      "main": [
        [
          {
            "node": "MAIN OUTREACH SHEET",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1 EMAIL AT A TIME": {
      "main": [
        [
          {
            "node": "DATA",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ADD TO SPAM SHEET",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ADD TO SPAM SHEET": {
      "main": [
        [
          {
            "node": "1 EMAIL AT A TIME",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "MARK EMAIL AS READ": {
      "main": [
        [
          {
            "node": "1 EMAIL AT A TIME. ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1 EMAIL AT A TIME. ": {
      "main": [
        [
          {
            "node": "NO OPERATION",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ADD UNSUBSCRIBE AND/OR SPAM TAG TO EMAIL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "MAIN OUTREACH SHEET": {
      "main": [
        [
          {
            "node": "MERGE",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Already has the spam tag?": {
      "main": [
        [
          {
            "node": "Do Nothing",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "1 EMAIL AT A TIME",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "UPDATE SPAM NAME IN MAIN OUTREACH SHEET": {
      "main": [
        [
          {
            "node": "1 EMAIL AT A TIME. ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ADD UNSUBSCRIBE AND/OR SPAM TAG TO EMAIL": {
      "main": [
        [
          {
            "node": "MARK EMAIL AS READ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}