Industry: Beauty & Personal Care — Barbershop (B2C Services)

📌Title

AI-Driven Lead Processing System: Automation and Classification of Leads for Barbershop (Stack: n8n, Klaviyo, OpenAI, Google Sheets, Zoho CRM, Telegram)

📖Context

For a modern barbershop, the speed of processing an application is a key conversion factor. The project is implemented as a connecting link between the lead collection form and the ecosystem of tools (CRM, spreadsheets, messengers).

❌Problem

  1. Routine: Need to manually copy data into CRM and Google Sheets.

  2. Low prioritization: Admin doesn't know who to call first (someone who "just asked" or someone who "wants to make an appointment today").

  3. Lack of structure: Raw customer comments are often ignored.

✅Solution

An intelligent workflow has been created in n8n that:

Receives data via Webhook.

Automatically classifies leads using AI (LLM Chain).

Simultaneously synchronizes data in Google Sheets (database), Zoho CRM (sales), and Telegram (instant notifications).

Email Marketing: Automatically add leads to Klaviyo marketing lists for further retargeting and warm-ups.

⚙️Process (key block)

  1. Ingestion (Webhook): Receiving raw JSON data from a frontend form.

  2. Data Transformation (JavaScript): Custom code was written in JS to parse the submissions array into an object understandable to the system.

  3. AI Classification (LangChain):

    1. LLM was used to analyze the note field (customer comment).