AI-Powered Query Engine for AppSheet
Project Overview
A core technology that significantly enhances AppSheet data retrieval. This engine, which powers our AI Tender Analysis, validates query syntax and employs vector search with an advanced reranking mechanism to enable superior natural language search across your AppSheet data.
Workflow Details
Query Reception & Syntax Validation
An automated workflow receives an AppSheet query object, including selector, columns, and natural language query. An AI agent validates and corrects syntax against the database schema.
Initial Data Filtering & Aggregation
The validated query retrieves a primary dataset from AppSheet based on selector logic. Relevant fields are aggregated for the reranking process.
Advanced Relevance Reranking via Vector Search
The prepared documents and the original natural language query are sent to an advanced reranking service (e.g., Cohere Rerank). This service re-evaluates the relevance of each document to the query, providing a new, more accurate ranking.
Refined Output Delivery to AppSheet
The reranked results are processed, re-ordered based on the new ranking, and relevance scores are added. This refined dataset is then returned to the AppSheet application for display or further use.