Synchronize Slack status updates with Pinecone, Google Sheets & GPT-4o

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 Sheets, and Pinecone—all orchestrated within n8n.

Perfect for teams setting up new client workspaces or preparing project data, this template listens to onboarding updates in Slack, retrieves the client’s latest files, and intelligently merges new information with existing records—ensuring a seamless, organized handoff and persistent data integrity for future AI-powered retrieval.

Setup Instructions

Connect Slack - Set up a bot with access to channels:history, appmentions:read, and users.profile:read. - Paste your channel ID into the Slack Trigger node.

Set Up Google Sheets - Prepare a sheet that stores basic user metadata like names, emails, IDs, etc. - Connect your Google Sheets account via OAuth2 and point the template to your doc.

Configure Pinecone - Create a Pinecone project with a vector index named n8n (or update accordingly). - Connect using your Pinecone API key and environment.

Integrate OpenAI or Azure OpenAI - Use GPT-4o or GPT-4 via OpenAI or Azure. - Provide your API credentials in the AzureOpenAI nodes.

Optional: Enable Cohere Reranking - Add Cohere API credentials to enhance document relevance for retrieval steps.