You are helping me build the following AI agent workflow.

## Goal
TikTok Video Transcription: Reads TikTok URLs from a Google Sheet, generates clean transcripts via API, and updates the sheet with text and dates.

## Specification
- What it does: You get clean TikTok video transcripts automatically added to your Google Sheet without manual typing. The system reads your URLs, removes timestamps via an API call, and updates the sheet with dates while handling errors for missing data.
- Trigger: Run manually (Manual · on demand)
- Autonomy: Fully hands-off
- Expected setup effort: under an hour
- Tools/services involved:
  - Google Sheets: Store video URLs and transcripts
  - RapidAPI: Call TikTok Transcript Generator API
  - HTTP Request: Fetch transcript data from API
  - Code: Clean subtitle text and remove timestamps

## Known pitfalls, handle each one explicitly in your implementation
1. TikTok URLs can vary in format including short links so implement URL expansion logic before extracting the video ID.
2. The API might return HTML entities or special characters so ensure your code cleans these to prevent sheet formatting errors.

## Reference implementation
https://n8n.io/workflows/5882 (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/automate-tiktok-video-transcription/ via usecasesforagents.com