Import DevExpert testimonials from Google Sheets (gog) or pasted TSV lists, format text with line breaks, crop profile images to 400x400, copy them to src/assets/testimonials, update src/data/testimonials.json, and optionally update AI Expert IDs in src/pages/cursos/expert/ai.astro.
Import DevExpert testimonials from Google Sheets (gog) or pasted TSV lists, format text with line breaks, crop profile images to 400x400, copy them to src/assets/testimonials, update src/data/testimonials.json, and optionally update AI Expert IDs in src/pages/cursos/expert/ai.astro.
Use when adding new testimonials or processing images.
Similar popular skills
Related neighbors and high-traction skills in the same topics — useful to compare before installing.
Import from Google Sheets (recommended). Run from the repo root:
- Ensure gog is authenticated: gog auth login or gog auth manage. ``bash python scripts/synctestimonialsfrom_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. - Crops images to 400x400 with face detection. - (Optional) Updates src/pages/cursos/expert/ai.astro. - Marks "Publicado en web" with x. - Stores temporary downloads in tmp/testimonials-sync.