360 Secure SkillHub
360 安全技能中心

French Learning

该 Skill 通过 Python 脚本把源 Google Sheet 中的法语词汇经 Gemini 翻译并生成例句后写入目标 Sheet 的 6 列并设置自动换行，再按每 20 句分批用 ElevenLabs 生成 MP3 并上传到指定 Google Drive 文件夹；使用前需配置 Google Sheet/Drive 访问权限及相关 API Key。

clairproqc-star
clairproqc-star
热度 33.41
最近更新 2026-05-11 17:36:07
分类：知识依赖：代码执行 / 第三方 API / 读写文件 / 内部调用大模型应用场景：语言学习 / 翻译 / 文件转换 / 数据处理 ...

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add french-learning
Metadata
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

  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.