{
  "name": "Send Emails from Google Sheets (no code)",
  "nodes": [
    {
      "id": "e94546ef-bfe5-411f-9b9c-3ae9e1504c52",
      "name": "Manual Trigger - Start Email Campaign",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "430db32d-7a8a-4431-90f8-14117a927662",
      "name": "Get Pending Emails from Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        208,
        0
      ]
    },
    {
      "id": "88df1718-90fc-48ee-b0d9-0af76c205e8c",
      "name": "Send Email via Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        416,
        0
      ]
    },
    {
      "id": "c1551e54-79a8-4e5d-880c-41a36e2ba393",
      "name": "Mark Email as Sent",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        640,
        0
      ]
    },
    {
      "id": "de5ec251-db30-4d13-89a7-2606f0a255f4",
      "name": "On New Email Received",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        112,
        256
      ]
    },
    {
      "id": "31379967-644d-4bb0-a09f-357168c02896",
      "name": "Find Original Email Row",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        320,
        256
      ]
    },
    {
      "id": "b5e7505f-2ee5-4da8-a890-a1cdedf60374",
      "name": "Save Email Response",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        528,
        256
      ]
    },
    {
      "id": "doc-note-1774531506929",
      "name": "Workflow Description",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -700,
        -150
      ],
      "parameters": {
        "width": 600,
        "height": 943,
        "content": "## Workflow Overview\n\nThis workflow automates repetitive email sending directly from Google Sheets and tracks responses, helping you reclaim hours spent on manual emailing. Simply maintain your email "
      }
    },
    {
      "id": "contact-note-1774531551219",
      "name": "Creator Contact Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -700,
        -610
      ],
      "parameters": {
        "width": 600,
        "height": 440,
        "content": "# Contact Us:\n## Milan @ SmoothWork - [Book a Free Consulting Call](https://smoothwork.ai/book-a-call/)\n![Milan](https://gravatar.com/avatar/95700d17ba300a9f14c1b8cacf933df7720027b3adda9cbe6183d891429"
      }
    },
    {
      "id": "video-note-1774531563386",
      "name": "Video Walkthrough",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -90,
        -610
      ],
      "parameters": {
        "width": 420,
        "height": 340,
        "content": "# Video Walkthrough\n[![image.png](https://vasarmilan-public.s3.us-east-1.amazonaws.com/blog_thumbnails/thumbnail_recrji7w9W5rhpyhr.jpg)](https://www.youtube.com/watch?v=jxT6XO4eUwI)"
      }
    }
  ],
  "connections": {
    "Send Email via Gmail": {
      "main": [
        [
          {
            "node": "Mark Email as Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On New Email Received": {
      "main": [
        [
          {
            "node": "Find Original Email Row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find Original Email Row": {
      "main": [
        [
          {
            "node": "Save Email Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Pending Emails from Sheet": {
      "main": [
        [
          {
            "node": "Send Email via Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Manual Trigger - Start Email Campaign": {
      "main": [
        [
          {
            "node": "Get Pending Emails from Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}