Slack Onboarding Assistant with Anthropic, Pinecone & Google Sheets (n8n)

Turn Slack onboarding questions into instant, knowledge-based answers—with smart escalation

This n8n workflow creates a Slack Onboarding Assistant that identifies the requester from Google Sheets, retrieves answers from a Pinecone knowledge base using OpenAI embeddings, and generates responses with an Anthropic chat model—replying in the Slack thread or escalating to the right manager when needed.

What this workflow does

• Listens for Slack mentions: Triggers when the Slack app is mentioned, extracts message/channel/thread details, and deduplicates repeated events.
• Validates and identifies the user: Checks the message isn’t empty, then looks up the sender by Slack user ID in a Google Sheets roster.
• Routes missing users to HR: If the user isn’t found in the roster, it posts a Slack reply asking HR to add them to the onboarding system.
• Builds conversation context: If the user is found, it fetches recent Slack thread replies to provide context.
• Retrieves onboarding answers and responds: Uses OpenAI embeddings to query a Pinecone namespace, then calls an Anthropic chat model agent to answer strictly from retrieved onboarding documents, or returns ESCALATE/NEED_MORE_INFO.
• Escalates when required: On ESCALATE, it looks up the department’s manager in a Google Sheets routing table and posts an in-thread message tagging the manager.
• Helps the user find the right owner: On NEED_MORE_INFO, it looks up the manager (fallback) and directs the user accordingly; otherwise it posts the generated answer to the thread.
• Manual knowledge-base loader: Clears the Pinecone onboarding namespace and loads Google Doc content (exported as text) into Pinecone.

Use cases

• New hires ask onboarding process questions in Slack and receive accurate answers from your onboarding docs.
• When the assistant can’t answer, it automatically escalates to the correct department manager.
• HR updates onboarding coverage in Google Docs and refreshes the Pinecone knowledge base via the manual loader.

Technical details

• Integrations: Slack, Google Sheets, Pinecone, OpenAI embeddings, Anthropic
• Core n8n elements: if, set, code, merge, slack, and sticky note