Answer HR policy questions in Slack DMs with GPT-4.1, Google Drive and Pinecone

Description

This template gives your HR or operations team an AI-powered Slack bot that answers employee questions about internal policies — directly in DM, available to everyone in the workspace, with no per-user setup required.

Employees simply send a direct message to the bot. It searches your Google Drive HR documents using RAG (Retrieval-Augmented Generation) via Pinecone, and replies in the same thread using GPT-4.1 — based strictly on your documents, not general knowledge.

Who this is for
HR, operations, and IT teams who want to reduce repetitive policy questions (leave, expenses, remote work, etc.) without building a custom chatbot from scratch.

What's included
This template contains two workflows on a single canvas:

HR Document Indexer — Runs daily at 3:00 AM. Indexes all documents in a specified Google Drive folder into Pinecone automatically.
HR QA Bot — Listens for Slack DMs workspace-wide. Filters out bot messages to prevent infinite loops, retrieves relevant document chunks, generates an answer, and replies in-thread.

A built-in RAG quality evaluator automatically scores every response (faithfulness & answer relevancy) and logs results to Google Sheets for continuous quality monitoring.

Key features
Works for the entire Slack workspace with a single setup — no per-user configuration
Strictly document-grounded answers — the bot will not hallucinate outside your documents
Infinite loop prevention via bot_id filtering
Automatic daily re-indexing with duplicate prevention (namespace clear before upsert)
Built-in answer quality logging to Google Sheets

Prerequisites
Google Drive folder with HR documents (txt, pdf, docx)
Pinecone account (index: dimension 1536, metric cosine)
OpenAI API key
Slack App with DM permissions (setup guide included in the workflow)
Google Sheets (copy link provided in the workflow)