AutomationFlowsAI & RAG › Create a Context-aware Slack Assistant with Google Sheets, Pinecone & Gpt-4o

Create a Context-aware Slack Assistant with Google Sheets, Pinecone & Gpt-4o

ByRahul Joshi @rahul08 on n8n.io

This advanced n8n automation template empowers your Slack bot to act as an intelligent assistant: when a user asks a question or requests a suggestion (by mentioning the bot), it automatically retrieves the user’s historical data and previous interactions from both Google Sheets…

Event trigger★★★★☆ complexityAI-powered24 nodesSlack TriggerAgentLm Chat Azure Open AiSlackPinecone Vector StoreEmbeddings Azure Open AiGoogle Sheets ToolReranker Cohere
AI & RAG Trigger: Event Nodes: 24 Complexity: ★★★★☆ AI nodes: yes Added:

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

This workflow follows the Agent → Google Sheets Tool 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
{
  "id": "PS6MqPybTzbUpzIK",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Slack messages update to Pinecone",
  "tags": [],
  "nodes": [
    {
      "id": "a1c92a1d-e74f-4f48-8285-f858ca61b4c9",
      "name": "Slack Trigger",
      "type": "n8n-nodes-base.slackTrigger",
      "position": [
        -304,
        448
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "00ab2770-9c81-49d8-8bee-fcab5066a78f",
      "name": "AI Agent1",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        384,
        448
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "b1cac577-56b9-4bfb-be4d-846a0b439b18",
      "name": "Azure OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        144,
        672
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1651d6da-06f0-4422-b9fc-45ec3c0de7f3",
      "name": "Get a user's profile",
      "type": "n8n-nodes-base.slack",
      "position": [
        -80,
        448
      ],
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "08cd364d-006c-410b-a69b-9ff02cc40bbc",
      "name": "Pinecone Vector Store2",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        272,
        672
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "1063099d-0a92-4d1f-b2f5-8eff53581a18",
      "name": "Embeddings Azure OpenAI2",
      "type": "@n8n/n8n-nodes-langchain.embeddingsAzureOpenAi",
      "position": [
        304,
        880
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "37c8a73e-cb36-462b-ab03-d6b90f64dc60",
      "name": "Get row(s) in sheet in Google Sheets",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        592,
        672
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "bfc17a2c-1f9c-4119-a521-3c582c51c6da",
      "name": "Pinecone Vector Store3",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        2048,
        448
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "a55f71c9-1e2d-4aad-8b0b-1db68b4e001d",
      "name": "Embeddings Azure OpenAI3",
      "type": "@n8n/n8n-nodes-langchain.embeddingsAzureOpenAi",
      "position": [
        2144,
        672
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1f8020e7-f290-4172-b8b0-b44f9f49778b",
      "name": "Reranker Cohere1",
      "type": "@n8n/n8n-nodes-langchain.rerankerCohere",
      "position": [
        432,
        880
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3ad72eab-4620-40c7-a3cb-e34dac4e34d2",
      "name": "Structured Output Parser1",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        720,
        672
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "01b23deb-f228-43ca-8817-0423d35ba5dc",
      "name": "Pinecone Vector Store5",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        928,
        448
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "d3975a99-384f-4b27-9c9d-2c6a3a408858",
      "name": "Embeddings Azure OpenAI5",
      "type": "@n8n/n8n-nodes-langchain.embeddingsAzureOpenAi",
      "position": [
        960,
        672
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a92ceeb5-1635-4f1c-a48f-22ee7456a65b",
      "name": "Reranker Cohere3",
      "type": "@n8n/n8n-nodes-langchain.rerankerCohere",
      "position": [
        1088,
        672
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a22246ca-4203-4bde-8a30-a978bd132825",
      "name": "AI Agent3",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1328,
        448
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "4740068f-b378-45bc-861e-02eda49c58a5",
      "name": "Azure OpenAI Chat Model3",
      "type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
      "position": [
        1360,
        880
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d7b96829-1adf-44bd-b9ff-432bf2f49d65",
      "name": "Auto-fixing Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserAutofixing",
      "position": [
        1424,
        672
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ab60fa7a-f941-43f9-bc7d-a99792401cf2",
      "name": "Structured Output Parser2",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1536,
        880
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "c49423df-50e9-40f6-af52-bb46d84ba502",
      "name": "Edit Fields1",
      "type": "n8n-nodes-base.set",
      "position": [
        1824,
        448
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "dac8a8bf-f935-459c-9342-8a081b5d5485",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -336,
        48
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "baba3093-11eb-42e3-96ec-b0c328ee90a9",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        368,
        64
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1a004cf6-1e62-47f0-9d10-19f155579d8e",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        928,
        64
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1bc5b309-db94-4575-b810-fec2479fb5f9",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        64
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "83749fb2-f6b3-4b96-a6d1-44428d6105f3",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1968,
        64
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "604317ed-0e44-492f-9e6f-56d69bdcc79a",
  "connections": {
    "AI Agent1": {
      "main": [
        [
          {
            "node": "Pinecone Vector Store5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent3": {
      "main": [
        [
          {
            "node": "Edit Fields1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields1": {
      "main": [
        [
          {
            "node": "Pinecone Vector Store3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Slack Trigger": {
      "main": [
        [
          {
            "node": "Get a user's profile",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Reranker Cohere1": {
      "ai_reranker": [
        [
          {
            "node": "Pinecone Vector Store2",
            "type": "ai_reranker",
            "index": 0
          }
        ]
      ]
    },
    "Reranker Cohere3": {
      "ai_reranker": [
        [
          {
            "node": "Pinecone Vector Store5",
            "type": "ai_reranker",
            "index": 0
          }
        ]
      ]
    },
    "Get a user's profile": {
      "main": [
        [
          {
            "node": "AI Agent1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pinecone Vector Store2": {
      "ai_tool": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Pinecone Vector Store5": {
      "main": [
        [
          {
            "node": "AI Agent3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Azure OpenAI Chat Model3": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent3",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "Auto-fixing Output Parser",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings Azure OpenAI2": {
      "ai_embedding": [
        [
          {
            "node": "Pinecone Vector Store2",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings Azure OpenAI3": {
      "ai_embedding": [
        [
          {
            "node": "Pinecone Vector Store3",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings Azure OpenAI5": {
      "ai_embedding": [
        [
          {
            "node": "Pinecone Vector Store5",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "Auto-fixing Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent3",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser1": {
      "ai_outputParser": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser2": {
      "ai_outputParser": [
        [
          {
            "node": "Auto-fixing Output Parser",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet in Google Sheets": {
      "ai_tool": [
        [
          {
            "node": "AI Agent1",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

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

About this workflow

This advanced n8n automation template empowers your Slack bot to act as an intelligent assistant: when a user asks a question or requests a suggestion (by mentioning the bot), it automatically retrieves the user’s historical data and previous interactions from both Google Sheets…

Source: https://n8n.io/workflows/6020/ — 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

Streamline client onboarding and lay the groundwork for future Retrieval-Augmented Generation (RAG) capabilities by automatically transforming Slack messages into structured data using GPT-4o, Google

Google Drive Trigger, Google Drive, Pinecone Vector Store +11
AI & RAG

This advanced Retrieval-Augmented Generation (RAG) automation template for n8n enables contextual, real-time recommendations using Slack messages as input. The workflow extracts referenced documents f

Slack Trigger, Agent, Lm Chat Azure Open Ai +8
AI & RAG

Your AI workforce is ready. Are you?

Google Sheets Tool, Mcp Trigger, Google Drive +29
AI & RAG

Unleash the full potential of your HighLevel CRM by adding an intelligent GPT-5 Agent that does more than just follow commands — it understands context, retrieves the right data, and executes actions

High Level Tool, Mcp Trigger, Chat Trigger +21
AI & RAG

This advanced n8n workflow automates the full lead enrichment, qualification, and personalized outreach process tailored specifically for the B2B real estate sector. Integrating top platforms like Api

N8N Nodes Fillout, OpenAI Chat, Pinecone Vector Store +11