Structure gym FAQ data for AI chatbot matching with Google Sheets

Description

Quick overview
Fetches FAQ entries from Google Sheets for a specified gym branch, processes them with keyword extraction and language detection, and returns a structured object optimized for AI chatbot question matching. Supports English, Arabic, and French.

How it works
Receives branch and optional category parameters from the AI Agent
Reads the Spreadsheet ID from a central config sheet
Routes to the correct branch FAQ sheet
Processes each FAQ entry — extracts keywords, detects language (EN/AR/FR), generates similar question variations
Returns a fully structured response grouped by category with all metadata

Setup
Add a Google Sheets OAuth2 credential in n8n and connect it to all Google Sheets nodes in the workflow
Add your Google Spreadsheet ID to the Gymbot_Config sheet under the sheet_id column
Create two FAQ sheets named FAQ_Rabieh and FAQ_Bikfaya — or rename them to match your branch names
Add your FAQ content with these required columns: Question, Answer, Tags, ImageURL

Requirements
Google Sheets account with OAuth2 credential
A Gymbot_Config sheet with a sheet_id column
Called by an AI Agent as a tool sub-workflow
Part of the GymBot Pro WhatsApp AI Booking System

Customization
Add more branches by duplicating the IF routing logic
Extend keyword extraction with domain-specific stop words
Add more language detection patterns for your target market