You are helping me build the following AI agent workflow.

## Goal
Multilingual YouTube Metadata Translator: Automatically detects new YouTube videos, translates titles and descriptions into multiple languages via AI.

## Specification
- What it does: You get new YouTube videos automatically translated into your target languages so global audiences can understand them immediately. The system detects fresh uploads, converts titles and descriptions using AI, and updates the channel while logging results in your spreadsheet.
- Trigger: On a schedule (Scheduled · daily or hourly)
- Autonomy: Fully hands-off
- Expected setup effort: about an afternoon
- Tools/services involved:
  - n8n: Workflow orchestration and scheduling
  - Google Sheets: Storing video URLs, languages, and status logs
  - YouTube API: Fetching video info and updating metadata
  - Google Gemini Chat Model: Translating titles and descriptions into target languages

## Known pitfalls, handle each one explicitly in your implementation
1. Gemini responses may include markdown formatting like backticks which will break YouTube's metadata fields, so add a code node to strip non-text characters.
2. The workflow might fail silently if the video ID is invalid or the account lacks permissions, so add error handling nodes that log specific API error codes to Sheets.
3. Translating long descriptions can exceed token limits or cause truncation, so split the description into chunks before sending them to the LLM for processing.

## Reference implementation
https://n8n.io/workflows/5902 (workflow template)
Fetch and inspect this before building. If it matches my stack, adapt it;
if not, rebuild the pattern with my tools.

## Process requirements
1. Before building: ask me which of the listed tools I actually use and
   what my platform is (n8n / Make / code / other). Do not assume.
2. Adapt the pattern to my answers; do not force the reference stack.
3. Address every pitfall above; tell me how you handled each.
4. Provide a test plan I can run before letting this touch real data.
5. Ask before any step that sends messages, modifies data, or spends money.

Source: https://usecasesforagents.com/use-case/multilingual-youtube-metadata-translator/ via usecasesforagents.com