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.