#!/usr/bin/env python3
"""
Convert 505 facilities to format for gog sheets append
"""
import csv
import json

# Read the 505 facilities
facilities = []
with open('/Users/max/.openclaw/workspace/postharvest/4-states-apple-facilities.csv', 'r') as f:
    reader = csv.DictReader(f)
    for row in reader:
        facilities.append(row)

print(f"Loaded {len(facilities)} facilities")

# Prepare rows
# Format: Company, Website, Country, Region, Primary Fruit, CA Storage, Qualified, Employee, Revenue, Notes, Contact Name, Title, Email, Phone, Source
rows = []

for f in facilities:
    row = [
        f['Company'],
        f.get('Website', ''),
        'USA',
        f['Region'],
        'Apples',
        '',  # CA Storage
        '',  # Qualified
        '',  # Employee
        '',  # Revenue
        'Apple facility from 4-state scrape',
        '',  # Contact Name
        '',  # Title
        '',  # Email
        f.get('Phone', ''),
        f['Source']
    ]
    rows.append(row)

# Save as JSON for gog
with open('/Users/max/.openclaw/workspace/postharvest/505-to-add.json', 'w') as f:
    json.dump(rows, f)

print(f"Saved {len(rows)} rows to 505-to-add.json")
print(f"\nFirst row example:")
print(rows[0])