{
  "name": "Verify email content against Google Sheets and Gmail logs",
  "nodes": [
    {
      "id": "55bef248-1f8f-4c7a-85b5-51fcc9232c19",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -672,
        1136
      ]
    },
    {
      "id": "74bb545a-30c1-4822-b6e9-f7640d45b912",
      "name": "Get many messages",
      "type": "n8n-nodes-base.gmail",
      "position": [
        -464,
        1136
      ]
    },
    {
      "id": "7d6616c4-6535-406c-b705-08a241a339ef",
      "name": "Extracting Preheader From HTML",
      "type": "n8n-nodes-base.html",
      "position": [
        0,
        1248
      ]
    },
    {
      "id": "6396dbe1-4a71-4692-85c5-ba429a3e70aa",
      "name": "Combine HTML, Expected Content and Preheader",
      "type": "n8n-nodes-base.merge",
      "position": [
        320,
        1120
      ]
    },
    {
      "id": "620a25d1-d472-4bc9-8991-7fcfaf3fc427",
      "name": "Extract Actual Content and Results",
      "type": "n8n-nodes-base.code",
      "position": [
        608,
        1120
      ]
    },
    {
      "id": "34805684-af93-454c-850f-9c8fc3aa0c2b",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1584,
        848
      ],
      "parameters": {
        "width": 832,
        "height": 624,
        "content": "## Main Overview – Email Marketing Automation QA Workflow\n\nThis workflow automates the end‑to‑end content verification process for email QA by comparing expected content values stored in Google Sheets"
      }
    },
    {
      "id": "c8074a02-05b1-4924-a07f-727dc816120e",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -112,
        880
      ],
      "parameters": {
        "width": 1168,
        "height": 592,
        "content": "## Content Check \nReads expected email elements from Google Sheets—From address, Subject line, Preheader, Body copy, and Footer content. Extracts actual values from HTML, merges inputs, compares expec"
      }
    },
    {
      "id": "58537ad7-fc2a-4625-8e51-e81d2b290ed7",
      "name": "Log Content Checks to Excel",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        848,
        1120
      ]
    },
    {
      "id": "5b8662c9-8e5b-493e-bd66-85d840b44acd",
      "name": "Load Expected Content",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        16,
        1008
      ]
    }
  ],
  "connections": {
    "Get many messages": {
      "main": [
        [
          {
            "node": "Extracting Preheader From HTML",
            "type": "main",
            "index": 0
          },
          {
            "node": "Combine HTML, Expected Content and Preheader",
            "type": "main",
            "index": 1
          },
          {
            "node": "Load Expected Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Load Expected Content": {
      "main": [
        [
          {
            "node": "Combine HTML, Expected Content and Preheader",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extracting Preheader From HTML": {
      "main": [
        [
          {
            "node": "Combine HTML, Expected Content and Preheader",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Extract Actual Content and Results": {
      "main": [
        [
          {
            "node": "Log Content Checks to Excel",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get many messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine HTML, Expected Content and Preheader": {
      "main": [
        [
          {
            "node": "Extract Actual Content and Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}