AI Investor Manager -Sheets CRM

Sheets CRM is an AI-powered middleware platform designed to convert a standard Google Sheet into a functional Customer Relationship Management (CRM) system by automating the data ingestion pipeline. By authenticating securely via Google OAuth, the web application establishes a direct connection to a user's Google Drive and segments a target spreadsheet into two discrete components: a raw Intake Tab and a structured CRM Tab. The system begins its automated pipeline by executing a Gmail sync, pulling recent inbound correspondence into the Intake Tab based on customizable keyword filters that isolate high-value messages, such as those containing "pitch" or "investor." Once the raw data is staged, the platform's core Natural Language Processing (NLP) engine parses the unstructured email bodies and subject lines to perform entity extraction. This AI extraction phase identifies critical variables—such as prospective client names, contact details, and pipeline stages—and serializes them for database injection. The application then writes this structured data directly into the pre-mapped columns of the main CRM tab. Beyond this linear pipeline, Sheets CRM features an interactive Sheet Agent that leverages OpenAI's function-calling capabilities. This allows users to perform arbitrary database manipulations using natural language prompts; for example, entering a command like "Highlight all leads from last week" prompts the LLM to translate the request into programmatic API calls that modify the spreadsheet in real time. To maintain system stability, the application enforces rigid validation safeguards: it requires explicit column headers in row 1 to map schemas accurately, mandates matching OAuth permissions, and operates strictly as a cloud-native architecture, completely restricting the upload of offline file formats like .xlsx to prevent pipeline sync failures.