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#

1. Google Sheet Setup: Ensure you have access to the target Google Sheet: https://docs.google.com/spreadsheets/d/1Nnwv4DbbUgfiNDiJdgCvnyxH6oPBis_99fm-2voehl4.
2. Google Drive Folder: You must provide a Google Drive Folder ID where the generated audio files will be saved.
3. ElevenLabs API Key: The ELEVENLABS_API_KEY environment variable must be set to use the sag TTS 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.