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

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