AutomationFlowsAI & RAG › Ai-powered Sales Assistant with Airtable Crm, Gmail and Web Research

Ai-powered Sales Assistant with Airtable Crm, Gmail and Web Research

ByLeeWei @leeweihernandez07 on n8n.io

This n8n workflow automates sales processes using AI agents integrated with Airtable as a CRM and Gmail for email handling. It consists of two main workflows: one for handling Airtable status changes to send automated emails, and another for processing incoming emails to add new…

Event trigger★★★★★ complexityAI-powered40 nodesAirtable TriggerAgentOpenAI ChatGoogle DocsGmail ToolGmail TriggerHTTP RequestAirtable
AI & RAG Trigger: Event Nodes: 40 Complexity: ★★★★★ AI nodes: yes Added:

This workflow corresponds to n8n.io template #8322 — we link there as the canonical source.

This workflow follows the Agent → Airtable recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "9b0ba1c4-5dd1-43f8-98e5-abfd7bd1d8dc",
      "name": "Airtable Trigger",
      "type": "n8n-nodes-base.airtableTrigger",
      "position": [
        1088,
        -1072
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "9a344fcc-d384-4c60-acb3-99a44e46264d",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1888,
        -1104
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "c1e14790-ddb8-48f5-96e7-1ca20d4b63ff",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1888,
        -992
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "095cf6f4-8856-49ad-acf5-b9a7eb6e7866",
      "name": "Switch",
      "type": "n8n-nodes-base.switch",
      "position": [
        1296,
        -1136
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "5710d262-9fe6-4031-bf3d-17a0229a084e",
      "name": "Google Docs",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -1472
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "0b045dbc-0c8c-4bc0-be60-fc0186844b10",
      "name": "Google Docs1",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -1312
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1d92913a-78c7-4d03-9445-4afafcd89252",
      "name": "Google Docs2",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -1152
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "62a4d242-49e5-4537-bfb6-e8fb1f1fea95",
      "name": "Google Docs3",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -992
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "4bae46d2-5f57-43c3-af55-0886a89e54c1",
      "name": "Google Docs4",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -848
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "27eebad7-0a72-4e00-9868-22d6bf522d2a",
      "name": "Google Docs5",
      "type": "n8n-nodes-base.googleDocs",
      "position": [
        1568,
        -688
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "b807198b-8fc2-4331-bed4-c1f51ce7c547",
      "name": "Gmail",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        2048,
        -992
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "788f1409-ed9d-4b00-a347-d34c99515ea3",
      "name": "Gmail Trigger",
      "type": "n8n-nodes-base.gmailTrigger",
      "position": [
        -1104,
        -1040
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "2bf44ed5-f20b-4fe1-89e3-01e35d53a264",
      "name": "OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -592,
        -1168
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "335ea4a6-c1bc-4318-94bb-3942b8326cb9",
      "name": "Add lead to CRM",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -592,
        -1280
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "e8da2651-0cf3-44d7-bd0d-5481a78f76da",
      "name": "OpenAI Chat Model2",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        352,
        -1088
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "8e41c355-03cc-41e4-9a17-be85572f7db5",
      "name": "Lead summary Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        384,
        -1280
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "c093dea0-c354-47cb-89ac-974f36bd7048",
      "name": "Markdown",
      "type": "n8n-nodes-base.markdown",
      "position": [
        16,
        -1280
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4fa09741-3a4c-4844-859c-fda44a4e8485",
      "name": "Find website URL",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -288,
        -1280
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "c629527b-7105-4a46-8a7b-36dc53dd5574",
      "name": "Scrape website URL",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -144,
        -1280
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "f5e0c3ec-331d-42e9-86fb-d745dc81dea9",
      "name": "Find Linkedin URL",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        208,
        -1280
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "e3e621d9-30fa-4fda-85c6-fb532c4ecd90",
      "name": "Airtable",
      "type": "n8n-nodes-base.airtable",
      "position": [
        672,
        -1280
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "b9e4481b-06de-4990-8113-bd1392632750",
      "name": "Airtable1",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        -240,
        -688
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "bb1d0afb-459c-449a-935b-7d986477f0a2",
      "name": "Airtable2",
      "type": "n8n-nodes-base.airtableTool",
      "position": [
        -128,
        -688
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "1227903a-ea70-43db-81d7-c1e1fbd74d53",
      "name": "Airtable3",
      "type": "n8n-nodes-base.airtable",
      "position": [
        -592,
        -944
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "8f63a0b4-7624-4ea4-94bd-f5ab3bac8b4c",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        -432,
        -944
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "38dbcccb-b8fc-4304-8955-ba3a390e8898",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -432,
        -1168
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "6b04ceb7-3383-41dc-a1a9-7c96cb90973b",
      "name": "Gmail1",
      "type": "n8n-nodes-base.gmail",
      "position": [
        496,
        -976
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "957b79c2-7047-43b1-b119-6f941895aba1",
      "name": "Structured Output Parser1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        112,
        -736
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "306b01c1-ad55-4982-a3ff-985ca503095f",
      "name": "Switch1",
      "type": "n8n-nodes-base.switch",
      "position": [
        304,
        -960
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "19c7245a-8849-4517-881f-a4a77e0e2e8d",
      "name": "AI Agent1",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -224,
        -960
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "bdf20c43-42e9-499d-9423-b3e50bb8c245",
      "name": "OpenAI Chat Model3",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -320,
        -816
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "52910e39-56c9-447e-b58d-3e56432907c3",
      "name": "Switch2",
      "type": "n8n-nodes-base.switch",
      "position": [
        -896,
        -1040
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "aa51ae7c-7a98-456f-88f3-5c1ab6d6292b",
      "name": "Gmail2",
      "type": "n8n-nodes-base.gmail",
      "position": [
        128,
        -960
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "34f72c0c-d550-4d02-b31c-db242eff2d2c",
      "name": "Google Docs6",
      "type": "n8n-nodes-base.googleDocsTool",
      "position": [
        -32,
        -688
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "da40f628-84dd-475c-a33f-e5ea3f0da0c2",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2096,
        -1552
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ac9acec8-abd0-41be-80c3-f7d9b87ef63f",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1168,
        -1248
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1cb01be9-7a02-426e-9b66-db914bd95ad8",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -1472
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0ff676d6-4c73-4156-be91-5b11001cee0c",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        -1376
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "03a716df-9943-46da-a7c4-eecf08c32c50",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1232,
        -1568
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0e2a64cd-dcc3-4937-a7a9-120bac1c7ad9",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        -1568
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "AI Agent1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gmail": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Gmail2": {
      "main": [
        [
          {
            "node": "Switch1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch": {
      "main": [
        [
          {
            "node": "Google Docs",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs3",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs4",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Google Docs5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch1": {
      "main": [
        [
          {
            "node": "Gmail1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Switch2": {
      "main": [
        [
          {
            "node": "Add lead to CRM",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Airtable3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Markdown": {
      "main": [
        [
          {
            "node": "Find Linkedin URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent1": {
      "main": [
        [
          {
            "node": "Gmail2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Airtable1": {
      "ai_tool": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Airtable2": {
      "ai_tool": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Airtable3": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs1": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs2": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs3": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs4": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs5": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Docs6": {
      "ai_tool": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Gmail Trigger": {
      "main": [
        [
          {
            "node": "Switch2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Add lead to CRM": {
      "main": [
        [
          {
            "node": "Find website URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Airtable Trigger": {
      "main": [
        [
          {
            "node": "Switch",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find website URL": {
      "main": [
        [
          {
            "node": "Scrape website URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find Linkedin URL": {
      "main": [
        [
          {
            "node": "Lead summary Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Lead summary Agent": {
      "main": [
        [
          {
            "node": "Airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Add lead to CRM",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model2": {
      "ai_languageModel": [
        [
          {
            "node": "Lead summary Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model3": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Scrape website URL": {
      "main": [
        [
          {
            "node": "Markdown",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Add lead to CRM",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This n8n workflow automates sales processes using AI agents integrated with Airtable as a CRM and Gmail for email handling. It consists of two main workflows: one for handling Airtable status changes to send automated emails, and another for processing incoming emails to add new…

Source: https://n8n.io/workflows/8322/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Typeform IA - YT. Uses typeformTrigger, agent, lmChatOpenAi, toolWorkflow. Event-driven trigger; 75 nodes.

Typeform Trigger, Agent, OpenAI Chat +7
AI & RAG

Agent Nodes. Uses lmChatOpenAi, slack, stopAndError, errorTrigger. Event-driven trigger; 72 nodes.

OpenAI Chat, Slack, Stop And Error +12
AI & RAG

Transcript Evalu8r V2 is a robust browser-based transcript analysis tool powered by Deepgram’s speech-to-text API and built into an n8n workflow template. This release introduces full in-browser audio

Google Drive Trigger, HTTP Request, Agent +5
AI & RAG

Transcript Evalu8r is an AI-powered transcript analysis workflow that automates the processing, visualization, and evaluation of transcribed conversations. This n8n workflow template is designed to he

Google Drive Trigger, HTTP Request, Agent +5
AI & RAG

Generate personalized sales leads, ready-to-send, HTML-formatted emails, and send them automatically. This workflow is ideal for sales professionals, marketers, and business development teams aiming t

HTTP Request, Agent, Output Parser Structured +4