AutomationMart
Home/Browse/Generate contextual recommendations from Slack using Pinecone
n8n

Generate contextual recommendations from Slack using Pinecone

n8nn8n22 modulesv1.0
SlackGoogle SheetsOpenAIGoogle Drive

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 from Google Drive, performs semantic retrieval from Pinecone, and generates next-step advice using GPT-4o — tailored specifically for executives and knowledge workers. Perfect for AI copilots, Slack-based assistants, or CTO coaching tools, this no-code RAG implementation gives you the building block

At a glance

Generate contextual recommendations from Slack using Pinecone is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Slack, Google Sheets, OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Slack, Google Sheets, OpenAI, Google Drive
Modules
22
Price
Free
Version
v1.0
Generate contextual recommendations from Slack using Pinecone workflow diagram

About this workflow

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 from Google Drive, performs semantic retrieval from Pinecone, and generates next-step advice using GPT-4o — tailored specifically for executives and knowledge workers. Perfect for AI copilots, Slack-based assistants, or CTO coaching tools, this no-code RAG implementation gives you the building blocks to combine unstructured inputs with memory-augmented intelligence. What This Template Does ✅ Triggers from a Slack Message or Mention Monitors a Slack channel using a bot, capturing user input in real-time. 🔍 Extracts Key Info from Message GPT-4o parses the message to identify the subject person and Google Drive link (if present). 📥 Downloads File from Google Drive Automatically fetches and extracts PDF content using the built-in extractor. 📇 Retrieves Metadata from Google Sheets & Pinecone Looks up user ID from Google Sheets and retrieves context from Pinecone based on embeddings and reranking. 🧠 Contextual Response via GPT-4o (RAG) Combines user data and document context to generate a single, actionable next step using a tightly scoped GPT-4o prompt. 🛠️ Auto-Fixes & Structures Output Ensures formatted response with recommendedaction, rationale, and optional risknote. 📨 Sends Final Output Back to Slack Posts the recommendation directly to the channel as a reply. Required Integrations - Slack Bot with channels:history & appmentions:read - Google Drive OAuth for file fetching - Google Sheets for ID mapping - Pinecone for vector document retrieval - Azure OpenAI or OpenAI GPT-4o for language processing - (Optional) Cohere for reranking results Ideal Use Cases 🧑‍💼 Executive coaching bots (e.g., for CTOs or founders) 🧠 Slack-based internal AI assistants 📄 AI-powered document summarization with memory 💬 Actionable recommendations based on real Slack conversations 📊 Enterprise knowledge augmentation from vector DBs Why This Template Stands Out 1. Combines live Slack interaction, file ingestion, and Pinecone retrieval into a fully RAG-powered response system. 2. AI prompts are carefully scoped for actionable, context-aware, and time-bound responses. 3. No-code setup with modular components for scaling or adapting to new use cases (e.g., different roles or goals).

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 images and share them on LinkedIn using ChatGPT and Custom Mail Hook

This template generates stunning images using ChatGPT and share them on LinkedIn via Custom Mail Hook, enhancing your social media presence effortlessly.

Free

AI-powered X (Twitter) content generator and scheduler with LangChain and Blotato

This n8n template demonstrates how to use AI to fully automate the generation and scheduling of X (formerly Twitter) content based on a specific, predefined persona. Use cases are many: It's perfect for social media marketers looking to streamline content creation, individual experts building a consistent brand voice, or businesses aiming to drive traffic to specific services with a steady stream of relevant content. Good to know The AI model used in this workflow (via OpenRouter) re

Free

Facebook ads competitive analysis using Gemini and Open AI

How it works - User submits a keyword through a form to trigger the workflow. - Ads matching the keyword are scraped from Facebook Ads Library. - Ads are filtered by media type (image or video). - Images are analyzed using an AI model to describe visuals and text. - Videos are downloaded, processed, and sent to Gemini for visual and spoken content analysis. - Text, URLs, and media descriptions are compiled. - All ad insights are saved into a Google Sheet for easy viewing. Set up steps - Requires

Free

Store chat data in Supabase PostgreSQL for WhatsApp/Slack chatbot

n8n Template: Store Chat Data in Supabase PostgreSQL for WhatsApp/Slack Integration This n8n template captures chat data (like user ID, name, or address) and saves it to a Supabase PostgreSQL database. It’s built for testing now but designed to work with WhatsApp, Slack, or similar platforms later, where chat inputs aren’t predefined. Guide with images can be found on: Step 1: Configure Firewall Rules in Your VPC Network To let your n8n instance talk to Supabase, add a firewall rule in your VPC

Free

Generate barcodes from Loyverse new items and saving them to Google Drive

This template periodically checks for new items in Loyverse and uses the retrieved information to generate a barcode for the item id using Barcodes and upload it to a Google Drive folder. The template is scheduled to run every 15 minutes. You can change the schedule after you set up the template.

Free

Add a new row to a Google Sheets spreadsheet from a new affiliate in Tapfiliate

Every time a new affiliate is added to Tapfiliate, a new row will be inserted to a Google Sheet spreadsheet. The template is using [this sample](https://docs.google.com/spreadsheets/d/1t09y0smGpAEJxtbZqOGgtSsGAJNrKtFvofdpYnBHpos/edit?usp=sharing) Google Sheets spreadsheet as a destination for the Tapfiliate data. You should make a copy of it before configuring the template.

Free

Send a daily media briefing email with GPT-4.1-mini, NewsAPI, Gmail and Google Sheets

This workflow creates a daily media briefing based on public news sources. It retrieves relevant articles, summarizes key coverage, evaluates sentiment, and compares the current media volume against historical data. If an unusual spike in coverage is detected, the agent autonomously performs additional research and highlights the anomaly in the briefing. The result is sent as a structured HTML email, ready for executive consumption.

Free

Send personalized birthday and anniversary emails with Google Sheets, Gemini, and Gmail

Birthday & Milestone Message Automation (n8n Google Sheets + Gemini AI + Gmail) This workflow automatically sends personalized birthday and anniversary emails to clients. It runs daily, checks a Google Sheet for matching dates, generates a warm AI message using Google Gemini and sends it via Gmail. It also includes a thoughtful investment idea tailored to the client’s age, risk profile and relationship type. Quick Implementation Steps 1. Connect Google Sheets OAuth2 2. Add your Google Gemini API

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