This Google Apps Script system adds a 🏠 Smart Home Tools menu to the Smart Home Inventory Google Sheet, with tools for keeping the inventory complete and tidy — autofilling device info from a model number, validating rows against a device database, sorting, and more. Explore the menu (including ℹ️ Help) to see what's available.

• ✅ Automatic population: Enter a model number → related fields auto-fill instantly
• ✅ Smart detection: Only fills empty fields or fields with "-" placeholder
• ✅ Non-intrusive: Won't overwrite data you've already entered
• ✅ User feedback: Shows notifications on success or if model not found

• ✅ Comprehensive checks: Validates all items against the device database
• ✅ Beautiful HTML report: Shows discrepancies in an easy-to-read format
• ✅ Cell references: Identifies exactly which cells have issues
• ✅ Auto-fix option: Automatically correct all discrepancies with one click
• ✅ Database stats: View statistics about your device database

• ✅ Custom menu: Easy access to all tools via "🏠 Smart Home Tools" menu
• ✅ Clean code: Well-structured with separated concerns
• ✅ Device database: Pre-loaded with your existing inventory

Open the Google Spreadsheet containing your "Items" sheet.

1. In Google Sheets, click Extensions → Apps Script
2. This opens the script editor in a new tab

Copy every file from src/autofill/ into the Apps Script editor, keeping the same file names. Delete the default Code.gs file if it still exists. (Or push them with clasp — see the deploy notes.)

1. Click "Untitled project" at the top
2. Rename it to "Smart Home Inventory - Autofill"
3. Click away to save the name

1. Close the Apps Script tab
2. Go back to the spreadsheet
3. Reload the page
4. A new menu should appear: 🏠 Smart Home Tools

1. Click 🏠 Smart Home Tools → ✅ Validation → Show Database Stats
2. Google will ask for authorization
3. Click Review Permissions → Choose your account
4. Click Advanced → Go to Smart Home Inventory - Autofill
5. Click Allow