AI · Automation 2025 Completed

BambooHR AI Chatbot — Policies & Benefits Assistant

An n8n RAG chatbot for employees that answers HR policy and benefits questions from BambooHR documents in a Supabase vector store and looks up the right people to contact.

Built by Redoan Uzzaman, Full-Stack Developer & AI Engineer.

BambooHR AI Chatbot — Policies & Benefits Assistant

Overview

Employees regularly need answers about policies, benefits and who to contact — information usually scattered across HR documents and directories. This project is an AI HR assistant that brings it together in a single chat interface on top of BambooHR.

How it works

An ingestion workflow pulls company documents from BambooHR, loads the PDFs, splits them with a recursive character text splitter and stores OpenAI embeddings in a Supabase vector store.

The chat workflow runs an AI agent with window buffer memory and two main tools. The first is a vector-store tool that retrieves relevant passages for policy and benefits questions. The second is an employee-lookup sub-workflow: a text classifier decides whether the user is asking about a specific person or about a department, and the workflow then queries the BambooHR employee directory accordingly. For department questions, it identifies the most senior person by walking the reporting structure, using an information extractor and LLM chain to interpret the results.

Structured and auto-fixing output parsers keep tool responses well-formed, and when the documents cannot answer a question, the assistant escalates by pointing the employee to the appropriate HR contact.

Key Features

  • RAG over BambooHR company documents
  • Supabase vector store with OpenAI embeddings
  • Employee lookup by name or by department
  • Seniority detection to find the right department lead
  • Classifier-based routing between person and department queries
  • Conversation memory for multi-turn chats
  • Smart escalation to HR contacts

Tech Stack

  • n8n
  • OpenAI
  • BambooHR API
  • Supabase
  • LangChain
  • Vector Database

Want something like this built?

Redoan Uzzaman takes on AI, automation and full-stack projects for clients worldwide.