You are helping me build the following AI agent workflow.

## Goal
Extract YouTube Comments to Google Sheets: Manually triggers on a list of YouTube URLs to fetch all comments via the API and append them to a Google Sheet.

## Specification
- What it does: You can automatically collect comments from your specified YouTube videos and save them directly into a Google Sheet without manual copying. This workflow reads ready video URLs, fetches the comment data via the API, updates their status to finished, and appends everything to your designated tab for easy analysis.
- Trigger: Run manually (Manual · on demand)
- Autonomy: Fully hands-off
- Expected setup effort: about an afternoon
- Tools/services involved:
  - n8n: workflow orchestration
  - Google Sheets: storing video URLs and comment results
  - HTTP Request: fetching data from YouTube API

## Known pitfalls, handle each one explicitly in your implementation
1. YouTube API quotas deplete quickly with high-volume requests so implement strict throttling and batch processing to avoid hitting daily limits.
2. The API returns paginated results which means you must loop through all pages for each video or you will miss older comments in the dataset.
3. Google Sheets write operations can fail if row limits are reached or columns are misaligned so add validation logic to ensure data fits the target sheet schema.

## Reference implementation
https://n8n.io/workflows/5690 (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/extract-youtube-comments-to-google-sheets/ via usecasesforagents.com