
Completed
Posted
Paid on delivery
Project Title: [login to view URL] & AI Developer Needed: Fix RAG Logic, UI Bugs, Smart Cross-Selling & Optimize AI Assistant for Active Site ([login to view URL]) Project Description: We are looking for an experienced Full-Stack [login to view URL] & AI Developer to audit, fix, and upgrade the existing live platform askraghadai.com. The website is already fully deployed and live (built on [login to view URL]) and connected to a Google Sheet as its active database. However, we need an expert to fix critical logic gaps, refine the AI's data-retrieval (RAG & Function Calling) to act like a smart advisor (similar to Gemini), clean up the UI by completely removing image placeholders, and implement smart cross-selling, bundle curation, and flawless Google Sheet synchronization and data binding. Budget, Timeline & Payment Terms: Budget: $10 – $30 (Fixed Price) Timeline: 2 Days Payment Terms: Payment will be released only after all the specified bugs and tasks are fully resolved and tested. No requests for additional funds or milestone increases related to these fixes will be accepted; the agreed fixed price covers the entire scope of work. Scope of Work & Google Sheet / Code Fixes: Strict Text-Only UI & Code/Sheet Cleanup (Remove All Images): The UI currently renders image boxes that incorrectly fall back to displaying our site logo when an image is missing. Images and image containers must be completely removed. The layout must switch to a 100% text-only structured card format containing only: Item Name, Short Description, and the Affiliate CTA Button. Developer Action for Google Sheet: The unused Image_URL column must be dropped/ignored in the Google Sheet, and any parsing functions or fallback logo logic in the [login to view URL] code querying images must be completely stripped out. Fix RAG Data Retrieval & Precise Category Filtering: Currently, the AI returns generic store homepages or broad categories instead of matching user intents (like "Trip to Phuket" or a specific dress) to precise offers, hotels, or items. Developer Action: Ensure the API connection properly filters and reads rows based on the 6 main categories, subcategories, and keyword tags in the Google Sheet. Smart Cross-Selling, Bundles & Exact Link Binding (Gemini-Like Experience): The AI agent must act as a smart, persuasive advisor capable of generating complete weekly packages (e.g., combining flights, hotels, and activities) or fashion sets/cross-selling (e.g., suggesting matching accessories or complementary items from the sheet). Crucial Rule: Whenever the AI suggests a product, hotel, or item, it must output the exact name paired precisely with its corresponding direct affiliate link retrieved from the Google Sheet—no random or generic homepage links are allowed. API Caching & Performance: Implement an in-memory or Redis caching layer for the Google Sheets data to prevent hitting Google API rate limits during high traffic and ensure fast, seamless AI responses. Strict Data Binding (No Hallucinations): The AI must only return items, links, and details retrieved directly from the Google Sheet via Function Calling. Generating external links or products not present in the database is strictly prohibited. Required Skills: Strong expertise in [login to view URL] and full-stack web development. Proven experience with LLM APIs (OpenAI/Anthropic), RAG pipelines, and Function Calling. Deep experience working with Google Sheets API integration and data parsing in production environments. High attention to UI/UX clean text-based layouts. How to Apply: When submitting your proposal, please confirm your agreement with the fixed budget ($10-$30), the 2-day timeline, and the payment terms (payment upon successful completion), and briefly state how you plan to tackle these fixes, including Google Sheet synchronization, smart cross-selling, bundle generation, and precise link binding.
Project ID: 40614501
97 proposals
Remote project
Active 7 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Auditing and fixing [login to view URL] — repairing the RAG retrieval logic, closing UI bugs, adding smart cross-selling and tightening the AI assistant on a live [login to view URL] site backed by Google Sheets. I build exactly this. Closest build: an agentic RAG assistant over a private knowledge base with sub-500ms retrieval, where the whole job was making the model answer from the right chunk instead of guessing. You can try it yourself right now: [login to view URL] — login admin / admin1234. That's a live agentic RAG chatbot I built and deployed for Dr Essa Laboratory. How I'd approach yours: audit the current retrieval path first (chunking, embedding, top-k, prompt) -> fix the data-retrieval gaps -> add a cross-sell step driven by the same index -> then the UI bugs, on the live [login to view URL] codebase without a rebuild. 5.0-star rated on Freelancer. What is the assistant getting wrong most often right now — wrong answers, or no answer? — Zohaib, AI Engineer (Voice AI · Autonomous Agents · RAG)
$20 USD in 7 days
0.5
0.5
97 freelancers are bidding on average $146 USD for this job

Hi, I can fix the RAG logic and UI bugs to optimize your AI assistant for askraghadai.com. I have worked on similar projects where I improved AI data retrieval and UI layouts. For instance, I helped a client streamline their e-commerce platform by refining their AI's product recommendations and enhancing the user interface for better engagement. My plan is to first audit the existing code and identify the critical logic gaps. I will then remove all image placeholders and ensure the UI is text-only. Next, I will refine the RAG data retrieval process to match user intents accurately. I will implement smart cross-selling features and ensure that the AI outputs exact names with their corresponding affiliate links. Finally, I will set up caching to improve performance and prevent API rate limits. I agree with your budget of $30 and the 2-day timeline. I am ready to start immediately. Do you have any specific requirements for the smart cross-selling feature? I invite you to chat further about this project and how I can help.
$30 USD in 2 days
8.3
8.3

Hi, I checked your requirements and the live site. I can fix the RAG logic, improve Google Sheets filtering and exact link binding, remove all image-related UI, add smart cross-selling/bundles, and implement caching for faster responses without hallucinated results. I agree to the fixed budget ($150), 2-day timeline, and payment after successful testing. Thank you. Regards, Sai
$150 USD in 2 days
7.6
7.6

I am an expert full stack developer ready to optimize your Next. js and AI Developer project. I have extensive experience building RAG pipelines using Redis for vector storage and integrating LLMs into production Next. js applications. I will sharpen your RAG logic to improve retrieval accuracy and eliminate UI bugs using clean Tailwind and TypeScript. I have previously built smart cross selling engines that leverage user data to drive affiliate conversions and can seamlessly sync your backend with Google Sheets and external APIs for better reporting. I focus on high performance and clean database management to ensure scalability. I am available to start immediately and turn this around quickly. When can we discuss your specific optimization goals over a brief call?
$90 USD in 7 days
6.3
6.3

RAG pipelines only work if the match between AI output and Sheets data is exact—otherwise you get off-target links and hallucinated bundles. I’ve cleaned up similar RAG-to-Google Sheets flows for production SaaS, full Function Calling, and tightly bound product/offer cards. For your stack, I’d strip all image code and containers, refactor to a text-only layout (Item Name, Description, Affiliate CTA only), and update the backend to ignore/drop all image logic. Sheets parsing would be refactored: only active categories and keyword tagging for precise offer matching, and no external links or generics. Smart cross-selling logic comes from multi-pass sheet queries and deterministic join rules, not AI generation. In-memory cache (Node.js/Redis) goes between API and the Sheet for rate-limit control. Can you confirm Sheets schema and LLM provider (OpenAI or Anthropic) is fixed, or do you need me to tweak that? Pradeep
$20 USD in 7 days
5.2
5.2

I am an expert full stack developer with extensive experience building AI applications using Next. js and Redis. I have a deep understanding of RAG architectures and can resolve your logic issues while ensuring your vector database retrieval is optimized for speed and accuracy. Regarding the project Next. js and AI Developer Needed: Fix RAG Logic, UI Bugs, Smart Cross-Selling and Optimiz, I will quickly debug your user interface and implement a data driven cross selling system that leverages your Google Sheets and database integrations. I have previously built similar affiliate marketing tools and automated workflows that sync external APIs with Next. js frontends. I can start immediately to refine your codebase and improve your performance metrics.
$30 USD in 1 day
4.4
4.4

The image fallback that shows the site logo is caused by the component still trying to render an Image_URL field. I'll strip the image handling code, drop the column from the sheet parser, and redesign the card to output text and the affiliate CTA. At the same time I'll add a Redis cache layer so sheet reads stay fast and avoid Google API rate limits. A common mistake with RAG pipelines is letting the model hallucinate links when the prompt doesn't force a function call. The AI will always return the exact product name and its affiliate URL directly from the sheet. The UI will be a pure text-only card layout with no image placeholders.
$20 USD in 3 days
2.2
2.2

Your biggest risk is trust: if the assistant returns generic links or non-sheet items, conversion and credibility drop immediately. I would first remove all image logic end to end (UI, parser, and sheet mapping) so cards stay text-only with clean CTA binding. Then I would refactor retrieval to enforce category, subcategory, and tag filtering, and lock responses to function-called rows only, with exact name to affiliate-link pairing from Google Sheets. I would also add a cache layer for sheet reads to reduce latency and API quota pressure under traffic. Scope condition: this assumes access to current prompts, function schema, and sheet structure on day one. Can we start with one paid milestone for audit plus the first production patch set within 48 hours?
$30 USD in 4 days
1.8
1.8

Hi, I read your project carefully and I can deliver exactly what you need. I can start immediately and show you the first preview in a few hours. Let’s discuss the details
$16 USD in 2 days
0.6
0.6

Hello, I Have 8+ Years Of Experience In Mobile And App Development And Have Worked On Such Projects. I Can Do Your Work On The Best Budget. Can We Discuss This Further In Chat? Thank You.
$15 USD in 5 days
0.0
0.0

Hello, I’m Bercyy, a full-stack developer with 10+ years of experience building production-ready systems and SaaS platforms. I focus on clean architecture, real business logic and scalable solutions
$200 USD in 3 days
0.0
0.0

Hi, Thanks for sharing your project. It aligns well with work I’ve successfully completed for other clients, and I’m confident I can deliver a high-quality solution tailored to your requirements. Before providing an accurate timeline, scope, and budget, I’d like to clarify a few key details to ensure we're aligned from the start. Freelancer’s proposal character limit makes it difficult to cover everything thoroughly here. If you're available, let's connect via chat. I can walk you through similar projects I've completed, discuss the best approach for your specific requirements, and answer any questions you may have. Once I understand your expectations, I'll provide a clear execution plan with realistic timelines and pricing. I’m ready to get started as soon as we finalize the details and look forward to working with you. Best regards, Mayank Sahu
$10 USD in 10 days
0.1
0.1

❤️ Hi there! ❤️ I'm Sofia, a developer with 8+ years of experience in AI, Web, and Mobile development. I help businesses turn their ideas into reliable, user-friendly, and scalable digital solutions. ✔ I carefully read your project details and understand that you are looking for someone who can not only write code, but also understand the business goal behind the product. 1️⃣ I can help with a clean development approach, clear communication, and a focus on building a solution that works smoothly in real-world use. 2️⃣ My experience includes: ✅ AI-powered applications and integrations ✅ Web platforms and custom development ✅ Mobile apps for iOS and Android ✅ API integrations and backend systems ✅ Performance optimization and long-term maintenance I would be happy to discuss your project, understand your current challenges, and suggest the best approach before starting. Looking forward to working with you. Warm regards, Sofia
$10 USD in 5 days
0.0
0.0

I am a Full-Stack Developer and Software Engineering graduate who enjoys building secure, scalable, and user-friendly web applications. I quickly adapt to new technologies and enjoy solving real-world problems through software. Rather than focusing on a single framework, I learn whatever technology is needed to deliver the best solution. My experience includes developing full-stack applications using Node.js, React, Svelte, Flask, PostgreSQL, and REST APIs. I have built systems such as digital signature platforms, inventory and sales management systems, and business process automation tools. I also have experience designing databases, implementing authentication and authorization, integrating third-party APIs, and deploying applications. I enjoy writing clean, maintainable code while prioritizing performance, security, and a great user experience. Whether working independently or collaborating with a team, I strive to deliver high-quality solutions efficiently. I am passionate about continuous learning and enjoy exploring modern technologies, including AI integration, automation, cloud services, and scalable system architecture. I believe that technology should simplify complex processes and create meaningful value for users. Currently, I am seeking opportunities as a Full-Stack Developer or Software Engineer where I can contribute, grow alongside experienced engineers, and build impactful products that reach thousands of users.
$30 USD in 7 days
0.0
0.0

The platform will be refined into a reliable AI assistant with accurate retrieval, clean data handling, and a smoother user experience. The RAG pipeline will be optimized so every response is generated from the Google Sheet data through proper filtering of categories, subcategories, and keyword tags. Function Calling will enforce strict data binding, ensuring the AI only recommends available products, hotels, or offers with the exact matching affiliate links from the database. The Google Sheet integration will be cleaned and improved by removing unused image handling, eliminating fallback logo logic, and converting the UI into a structured text-only card system with only relevant details and CTAs. Smart recommendation logic will be enhanced to support bundle creation, cross-selling, and personalized suggestions by combining related items from the available dataset while preventing unsupported recommendations or hallucinated links. Performance will be improved by adding caching for Google Sheet data to reduce API calls, improve response speed, and provide a more stable experience during higher usage. All fixes will be tested across the live platform to ensure accurate AI responses, reliable synchronization, clean UI behavior, and production-ready performance within the agreed timeline and fixed scope.
$10 USD in 7 days
0.0
0.0

Dammam, Saudi Arabia
Payment method verified
Member since Jul 3, 2026
$10-50 USD
$10-150 USD
$30-250 USD
₹1500-12500 INR
$250-750 USD
₹12500-37500 INR
₹12500-37500 INR
$250-750 USD
$30-250 USD
₹250000-500000 INR
$1500-3000 USD
₹12500-37500 INR
$250-750 USD
₹1500-12500 INR
₹12500-37500 INR
₹12500-37500 INR
$750-1500 AUD
₹37500-75000 INR
₹12500-37500 INR
£250-750 GBP
₹1500-12500 INR
₹12500-37500 INR
₹75000-150000 INR