- name
- french-learning
- description
- French vocab automation. Formats Excel vocab to Google Sheet, generates ElevenLabs audio, uploads to Drive. Triggers: process french vocab, generate audio, French Excel file.
- metadata
- {"clawdbot":{"emoji":"🇫🇷","requires":{"bins":["sag","gog","gemini"],"env":["GEMINI_API_KEY","ELEVENLABS_API_KEY"]},"primaryEnv":"GEMINI_API_KEY"}}
French Learning Skill
This skill automates the creation of French learning materials.
Resource Locations
- Configuration: Refer to references/config.md for target Google Sheet and Drive Folder IDs.
- Scripts: Automation logic resides in
scripts/.
Prerequisites
- Google Sheet Setup: Ensure you have access to the target Google Sheet:
https://docs.google.com/spreadsheets/d/1Nnwv4DbbUgfiNDiJdgCvnyxH6oPBis_99fm-2voehl4. - Google Drive Folder: You must provide a Google Drive Folder ID where the generated audio files will be saved.
- ElevenLabs API Key: The
ELEVENLABS_API_KEYenvironment variable must be set to use thesagTTS skill for audio generation.
Standard Workflows
1. Format Excel to Google Sheet
scripts/format_excel.py — Reads source Sheet, calls Gemini for Chinese translation + example sentences, writes 6 columns (Index, Fr Original, En Translation, Chinese Translation, Example Sentence (FR), Example Sentence (CN)) into target Sheet, then applies wrap text (wrapStrategy: WRAP) to all cells so long sentences stay within the cell.
2. Generate & Upload Audio
scripts/generate_audio.py — Fetches Example Sentence (FR) + Index, chunks into batches of 20, generates MP3 via ElevenLabs (sag skill), uploads to specified Drive folder named 1-20.mp3, 21-40.mp3, etc. Requires Drive Folder ID.