Overview

Automates testimonial import, profile image cropping, and AI Expert section management.

Quick start

Install dependencies (first time only):

python -m pip install -r scripts/requirements.txt

Import from Google Sheets (recommended). Run from the repo root:
- Ensure gog is authenticated: gog auth login or gog auth manage.
```
python scripts/sync_testimonials_from_sheet.py \
  --ai-auto
```
The script:
- Detects rows where "Publicado en web" is empty.
- Downloads photos from Drive via gog drive download.
- Inserts line breaks automatically.
- Generates new IDs in src/data/testimonials.json.

fecha \t nombre \t posicion \t titulo \t texto \t rating \t ruta_imagen

{
  "devexpert_testimonials": {
    "account": "[email protected]",
    "sheet_id": "spreadsheet_id_here",
    "gid": 123456789
  }
}

To write a specific list:

python scripts/import_testimonials.py \
  --input /ruta/testimonios.txt \
  --ai-ids "35051,42724,42725"

To auto-update with new IDs:

python scripts/import_testimonials.py \
  --input /ruta/testimonios.txt \
  --ai-auto

Devexpert Testimonials | Skills Pool