{
  "name": "AI Agent to send Emails from Google Sheets (video tutorial)",
  "nodes": [
    {
      "id": "eb23cbf0-55cf-4f1c-a4bf-ee8598d6213e",
      "name": "Manual Trigger - Start Email Workflow",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "59af511c-c4fb-49d7-a8b4-0528ff378e4e",
      "name": "Get Pending Emails from Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        208,
        0
      ]
    },
    {
      "id": "e1d68fb7-f3e8-457f-aab6-9f146ab07aaf",
      "name": "Send Personalized Email via Gmail",
      "type": "n8n-nodes-base.gmail",
      "position": [
        784,
        0
      ]
    },
    {
      "id": "508de6cd-00af-41df-af5e-8a37bc8b0e9a",
      "name": "Update Email Status to Sent",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1008,
        0
      ]
    },
    {
      "id": "066151f8-ec42-40a1-8856-2986b3164dfe",
      "name": "Gmail Trigger - New Email Responses",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        112,
        336
      ]
    },
    {
      "id": "97530849-28a4-47d1-b9b1-4177dbe221bb",
      "name": "Get Matching Email Row by Sender",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        320,
        336
      ]
    },
    {
      "id": "ff9cb97d-2960-4abb-b408-e1c4034d9dc6",
      "name": "Update Sheet with Email Response",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        528,
        336
      ]
    },
    {
      "id": "f916cc07-667a-4ad3-b383-bd547b2a3202",
      "name": "AI Agent - Generate Personalized Email",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        416,
        0
      ]
    },
    {
      "id": "aeedf3ca-ce6d-4288-9fce-b5878c7717bf",
      "name": "OpenAI Chat Model - GPT",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        416,
        160
      ]
    },
    {
      "id": "doc-note-1774531506930",
      "name": "Workflow Description",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -700,
        -150
      ],
      "parameters": {
        "width": 600,
        "height": 1166,
        "content": "## Workflow Overview\n\nThis workflow automates sending and tracking emails directly from Google Sheets, saving hours of manual work each week. It reads email data from your spreadsheet, generates perso"
      }
    },
    {
      "id": "contact-note-1774531551220",
      "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-1774531563388",
      "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": {
    "OpenAI Chat Model - GPT": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent - Generate Personalized Email",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Get Pending Emails from Sheet": {
      "main": [
        [
          {
            "node": "AI Agent - Generate Personalized Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Matching Email Row by Sender": {
      "main": [
        [
          {
            "node": "Update Sheet with Email Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Personalized Email via Gmail": {
      "main": [
        [
          {
            "node": "Update Email Status to Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail Trigger - New Email Responses": {
      "main": [
        [
          {
            "node": "Get Matching Email Row by Sender",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Manual Trigger - Start Email Workflow": {
      "main": [
        [
          {
            "node": "Get Pending Emails from Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent - Generate Personalized Email": {
      "main": [
        [
          {
            "node": "Send Personalized Email via Gmail",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}