How a Developer Synced 48,000 CRM Contacts to Firestore for AI-Powered Chat Search
A developer built a system to sync an external CRM's contacts and conversation history into Firestore, enabling an AI assistant to answer natural-language queries like 'what did this contact write me.' The project involved nearly 48,000 contacts and a growing daily chat archive, making it an architectural challenge rather than a simple feature addition. Key technical choices included using Firestore over Realtime Database for scalability, implementing server-side search with debounced queries, and setting up webhooks to keep data current. The build encountered repeated bundling errors, a pagination cursor that failed to advance, and a phone number mismatch that routed queries to the wrong contact. Vector search was ultimately integrated to allow the AI assistant to surface relevant conversations by semantic meaning rather than exact keyword matching.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in