AutomationMart
Home/Browse/Create a context-aware Slack assistant with Google Sheets, Pinecone & GPT-4o
n8n

Create a context-aware Slack assistant with Google Sheets, Pinecone & GPT-4o

n8nn8n19 modulesv1.0
agentembeddingsAzureOpenAigoogleSheetsToollmChatAzureOpenAioutputParserAutofixingoutputParserStructuredrerankerCoheresetslackslackTriggervectorStorePinecone

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 and Pinecone. Using GPT-4o, the bot analyzes past updates, status reports, and context to generate a personalized, context-aware response—directly in Slack. Perfect for teams seeking instant, data-driven support, this wo

At a glance

Create a context-aware Slack assistant with Google Sheets, Pinecone & GPT-4o is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects agent, embeddingsAzureOpenAi, googleSheetsTool, lmChatAzureOpenAi. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
agent, embeddingsAzureOpenAi, googleSheetsTool, lmChatAzureOpenAi, outputParserAutofixing, outputParserStructured
Modules
19
Price
Free
Version
v1.0
Create a context-aware Slack assistant with Google Sheets, Pinecone & GPT-4o workflow diagram

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 and Pinecone. Using GPT-4o, the bot analyzes past updates, status reports, and context to generate a personalized, context-aware response—directly in Slack. Perfect for teams seeking instant, data-driven support, this workflow transforms your Slack bot into a smart knowledge assistant that references your own organizational history to provide relevant answers and suggestions. What This Template Does (Step-by-Step) Slack Bot Mention Trigger - Listens for message or appmention events where a user asks a question or requests a suggestion. - Captures the message body and user ID. User Profile & Data Fetch - Uses the Slack API to retrieve the user’s profile. - Queries Google Sheets and Pinecone to collect the user’s historical updates and interactions. Contextual AI Lookup - GPT-4o reviews the user’s past status reports, messages, and activity. - Synthesizes a contextually relevant answer or suggestion based on prior data. Personalized Response Generation - The bot replies in Slack with a tailored answer, referencing the user’s previous updates and current context. Auto-Fix & Schema Validation - Ensures the generated response is well-structured and matches your organization’s data schema. Document Update (Optional) - Optionally logs the new interaction or suggestion back to Pinecone for future reference. Required Integrations - Slack Bot with channels:history, appmentions:read, and users.profile:read - Google Sheets OAuth2 (for lead or user status records) - Pinecone Vector Store (for storing user status documents) - Azure OpenAI or OpenAI GPT-4o (for document generation and merging) - Cohere API (optional) for reranking relevance in vector search Ideal For - Remote teams running async daily standups - People ops tracking onboarding or churn signals - Founders building internal GPT-powered tools - Managers consolidating Slack-based updates across teams - Teams wanting a Slack bot that provides personalized answers and suggestions based on past activity - Managers and team members seeking quick, AI-powered support and insights from their own work history - Organizations aiming to leverage internal data for smarter, context-aware assistance in Slack

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Generate SEO content audit reports with DataForSEO and Google Search Console

Introduction The Content SEO Audit Workflow is a powerful automated solution that generates comprehensive SEO audit reports for websites. By combining the crawling capabilities of DataForSEO with the search performance metrics from Google Search Console, this workflow delivers actionable insights into content quality, technical SEO issues, and performance optimization opportunities. The workflow crawls up to 1,000 pages of a website, analyzes various SEO factors including metadata, content qua

Free

AI-powered NDA review & instant alert system - Jotform, Gemini, Telegram

This workflow automates the process of analyzing a contract submitted via a web form. It extracts the text from an uploaded PDF, uses AI to identify potential red flags, and sends a summary report to a Telegram chat. Prerequisites Before you can use this workflow, you'll need a few things set up. 1. JotForm Form You need to create a form in JotForm with at least two specific fields: Email Address: A standard field to collect the user's email. File Upload: This field will be used to upload the

Free

Create new Google Sheets rows from Formstack submissions, verifying the email by Zerobounce, and sending on slack

Every time a new Formstack form is submitted, Make will automatically validate the email with ZeroBounce. If the status of the email is "valid" it will look the person up with Clearbit. If a result is returned it will add a row in a Google Sheet and send a Slack message. This example uses the sheet in [this link](https://docs.google.com/spreadsheets/d/1l205VTOGWG-wurkvc2UmsbVnN0cJbX-6evHJnWcMfaM/edit#gid=0). It will also look the company up with Clearbit. If a result is returned it will add a ne

Free

Send Slack messages for new group messages using ChatGPT completions

Monitor Slack channel messages and automatically send them over to ChatGPT then send the AI generated response to either the same channel or another channel or user of your choice.

Free

Create an automated customer support assistant with GPT-4o and GoHighLevel SMS

AI Agent via GoHighLevel SMS with Website-Based Knowledgebase This n8n workflow enables an AI agent to interact with users through GoHighLevel SMS, leveraging a knowledgebase dynamically built by scraping the company's website. --- ❓ Problem It Solves Traditional customer support systems often require manual data entry and lack real-time updates from the company's website. This workflow automates the process by: - Scraping the company's website at set intervals to update the knowledgebase. - Int

Free

RAG Starter Template using Simple Vector Stores, Form trigger and OpenAI

This template quickly shows how to use RAG in n8n. Who is this for? This template is for everyone who wants to start giving knowledge to their Agents through RAG. Requirements Have a PDF with custom knowledge that you want to provide to your agent. Setup No setup required. Just hit Execute Workflow, upload your knowledge document and then start chatting. How to customize this to your needs 1. Add custom instructions to your Agent by changing the prompts in it. 2. Add a differen

Free

Generate personalized language learning news digests with LLaMA-3.1 & DeepSeek AI

Automatically generate and email level-appropriate language learning content based on trending news. This workflow reads learner preferences from Google Sheets (language, level, and topic of interest), uses an AI web search model to fetch relevant news, and formats the result into a structured HTML digest featuring grammar explanations and vocabulary highlights. Emails are sent automatically to each learner in a clean, mobile-friendly format. --- ⚙️ What it does 1. ⏰ Daily Trigger at 6 AM 2.

Free

Midjourney Image Generator via Telegram and GoAPI

This workflow connects Telegram to Midjourney through GoAPI, enabling automated image generation and upscaling directly from chat. How it Works Telegram Command Trigger: The workflow activates upon receiving a message in Telegram. Image Generation: Your prompt is sent to GoAPI, which then generates an image using Midjourney. Upscale Selection: You receive the generated image and select an option for upscaling. Image Upscaling: The selected image is upscaled via GoAPI

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free