n8n Automation for Product Query System
Budget: $8 – $15 USD
Overview
I’m looking for an experienced n8n automation developer to build a smart query system that retrieves pricing and product specifications for electronic products. The system should be capable of handling structured data (spreadsheets) and unstructured data (vector-based search on product manuals) while outputting responses in natural language.
This automation will initially function as a bot (Telegram, WhatsApp, or another chat interface) that allows users to quickly retrieve pricing and product details through conversational queries.
Project Scope
1️⃣ Data Retrieval Mechanism
Price Lookup: Query Google Sheets, Airtable, or CSV files for the latest product prices.
Specification Lookup: Use a vector-based database (FAISS, Pinecone, Weaviate, etc.) to retrieve technical details from unstructured text (e.g., PDFs, manuals, product descriptions).
Hybrid Query Handling: If an exact price is found in the spreadsheet, return it. Otherwise, fall back on AI-powered vector search for relevant information.
2️⃣ Conversational AI & Natural Language Output
Integrate GPT-4, Claude, or another LLM to format retrieved data into clear, user-friendly responses.
Example query: "How much is the latest iPhone?"
✅ If found in the spreadsheet, return: "The iPhone 15 Pro costs $999 as of Feb 2025."
✅ If found in vector search, return: "The iPhone 15 Pro features a 6.1-inch OLED display, A17 Bionic chip, and titanium frame."
3️⃣ Chatbot & Automation Integration
The system will be accessible via chatbot (Telegram, WhatsApp, or API-based interface).
Must be scalable to handle multiple product queries simultaneously.
4️⃣ AI-Powered Query Classification
Use an LLM (GPT-4, Claude, or a fine-tuned model) to classify whether a query is price-related or specification-related and route it to the appropriate retrieval method.
Example classification:
"What's the price of Product X?" → Price Lookup
"What are the specifications of Product Y?" → Vector Search
I’m looking for an experienced n8n automation developer to build a smart query system that retrieves pricing and product specifications for electronic products. The system should be capable of handling structured data (spreadsheets) and unstructured data (vector-based search on product manuals) while outputting responses in natural language.
This automation will initially function as a bot (Telegram, WhatsApp, or another chat interface) that allows users to quickly retrieve pricing and product details through conversational queries.
Project Scope
1️⃣ Data Retrieval Mechanism
Price Lookup: Query Google Sheets, Airtable, or CSV files for the latest product prices.
Specification Lookup: Use a vector-based database (FAISS, Pinecone, Weaviate, etc.) to retrieve technical details from unstructured text (e.g., PDFs, manuals, product descriptions).
Hybrid Query Handling: If an exact price is found in the spreadsheet, return it. Otherwise, fall back on AI-powered vector search for relevant information.
2️⃣ Conversational AI & Natural Language Output
Integrate GPT-4, Claude, or another LLM to format retrieved data into clear, user-friendly responses.
Example query: "How much is the latest iPhone?"
✅ If found in the spreadsheet, return: "The iPhone 15 Pro costs $999 as of Feb 2025."
✅ If found in vector search, return: "The iPhone 15 Pro features a 6.1-inch OLED display, A17 Bionic chip, and titanium frame."
3️⃣ Chatbot & Automation Integration
The system will be accessible via chatbot (Telegram, WhatsApp, or API-based interface).
Must be scalable to handle multiple product queries simultaneously.
4️⃣ AI-Powered Query Classification
Use an LLM (GPT-4, Claude, or a fine-tuned model) to classify whether a query is price-related or specification-related and route it to the appropriate retrieval method.
Example classification:
"What's the price of Product X?" → Price Lookup
"What are the specifications of Product Y?" → Vector Search