# AI Schema Detection: LLM API Workflows in Excel

Connect Excel directly to Gemini or OpenAI APIs for AI-powered schema detection with structured JSON output, automated EDA, and data type detection. Identify categorical and numerical variables, generate SQL-compatible data types.

## Links
- App: https://app.tigzig.com/xlwings-llm-api
- Video Guide: https://www.youtube.com/watch?v=lAADII7ZDuM

## Tags
python-in-excel, xlwings-lite

## Download
- Excel Workbook: https://www.tigzig.com/files/xlwings/LLM_API_CALL_SCHEMA_DETECT_EDA_MACHINE_LEARNING.xlsx

## What It Does
- Connect to Gemini (2.0-Flash) or OpenAI (GPT-4o)
- Automatic schema detection with structured JSON output
- Identify categorical and numerical variables
- Generate SQL-compatible data types
- AI-guided exploratory data analysis (EDA)
- Data visualizations based on detected schema

### How It Works

**LLM API Integration**
- Samples your data table and sends to chosen LLM
- Crafted prompt instructs LLM to return structured JSON
- JSON response parsed and formatted for Excel display
- Best performance with Gemini Flash model

**Automated Workflows**
- Detected schema configures EDA operations
- Numeric columns: statistical analysis
- Categorical columns: frequency distributions
- Enables automation of database operations

**Practical Use Cases**
- Web scraping with structured output
- Text classification and summarization
- Text-to-SQL with Excel frontend
- Data preparation for database uploads

### Built-in Functions
- `analyze_table_schema_gemini` - Schema detection via Gemini
- `analyze_table_schema_openai` - Schema detection via OpenAI
- `perform_eda` - EDA with visualizations

### API Keys
- Gemini: Free at https://aistudio.google.com
- OpenAI: At https://platform.openai.com

## Resources
- xlwings Lite: https://lite.xlwings.org
- xlwings Documentation: https://docs.xlwings.org/en/latest/