SheetGenie is an intelligent web application that transforms messy product lists, unstructured text, and technical tables into clean, formatted spreadsheets using Google's Gemini AI.

It was designed to help users quickly organize data—like solar inverter specifications or shopping lists—and export them directly to Google Drive/Sheets without manual entry.

• ✨ AI-Powered Parsing: Uses Google's Gemini 2.5 Flash model to automatically detect column headers, extract rows, and clean data (fixing typos, preserving ratings, etc.).
• 📊 Dynamic Structures: Works with any type of data, not just specific products. It adapts the table schema on the fly.
• 🚀 Instant Export:
  • One-Click Google Sheets: Copies formatted data to your clipboard and opens sheets.new for instant pasting.
  • CSV Download: Standard export for local files.
  • Copy to Clipboard: Quick copy for other applications.
• 🧹 Batch Processing: Easily clear the workspace to process multiple lists in sequence.

1. Paste: Input any text (e.g., a copied table from a PDF, a list of items from a chat, or raw specs).
2. Process: The AI analyzes the text, determines the best column structure, and extracts the data.
3. Export: Review the preview table, then click "Open in Google Sheets" to finalize.

This project is built with React, TypeScript, and Tailwind CSS.

• A valid Google Gemini API Key.

The application requires the API key to be available in the environment:

API_KEY=your_google_genai_api_key

• Frontend: React 19, TypeScript, Tailwind CSS
• AI Integration: Google GenAI SDK (@google/genai)
• Icons: Lucide React
• Tooling: Vite (assumed for standard React setup)

MIT