🚀 Introducing Jarvis AI Assistant — A Smart AI Chatbot Powered by Google Sheets & OpenAI
I’m excited to share a new project I’ve been developing: Jarvis AI Assistant, a fully customizable AI-powered chatbot built with Google Apps Script, Google Sheets, and OpenAI.
The goal of this project was simple:
👉 Create an intelligent business assistant that is:
- easy to manage,
- low cost,
- secure,
- fast,
- and fully customizable without complex infrastructure.
Unlike traditional chatbot systems that require databases and expensive platforms, Jarvis uses the power of Google Sheets as a dynamic knowledge base, allowing anyone to manage AI content directly from a spreadsheet.
💡 Key Features:
✔ Secure Login System with hashed passwords
✔ Role-based access control
✔ AI-powered search using OpenAI
✔ Greek & English language support
✔ Smart keyword matching
✔ Product recommendations
✔ Image thumbnail support inside chat
✔ Mobile-friendly responsive design
✔ Theme customization
✔ Help questions & guided prompts
✔ Copy-to-clipboard responses
✔ Google Apps Script deployment with no server needed
📊 The chatbot can read information from multiple sheets such as:
- Company
- Team
- Services
- Products
- FAQs / Data
This makes it ideal for:
✅ Company websites
✅ Internal knowledge bases
✅ Educational institutions
✅ Product catalogs
✅ Customer support systems
✅ Small business AI assistants
One of the most interesting parts of the project was improving the search engine to properly support Greek language searches, including:
- accented Greek words,
- plural/singular matching,
- keyword expansion,
- and optimized token usage to reduce OpenAI costs.
🧠 The assistant now intelligently searches spreadsheet content and returns:
- relevant answers,
- formatted text,
- product thumbnails,
- and structured recommendations.
⚡ Tech Stack:
- Google Apps Script
- Google Sheets
- OpenAI GPT-4o Mini
- HTML / CSS / JavaScript
- Tailwind CSS
- DaisyUI
- SweetAlert2
The entire system runs serverless through Google infrastructure, making deployment incredibly simple and affordable.
This project demonstrates how modern AI tools can be integrated into everyday business workflows using accessible technologies that many companies already use.
More improvements are already planned, including:
🔹 semantic search
🔹 embeddings
🔹 document upload support
🔹 analytics dashboard
🔹 admin panel
🔹 multilingual expansion
🔹 voice interaction
AI assistants are no longer only for large enterprises. With the right architecture, small and medium businesses can now build practical AI solutions quickly and cost-effectively.
Comments are closed.