Track and analyze TikTok videos with Apify, OpenAI, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets and OpenAI.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Configuration (Edit Fields (Set)): sets 5 fields: openai_model, days_limit, results_limit…
- Get Accounts (Google Sheets): uses Google Sheets
- Build Apify Input (Code): runs custom JavaScript code
- Run TikTok Scraper (HTTP Request): calls an HTTP API (POST)
- Normalize TikTok Videos (Code): runs custom JavaScript code
- Download Video (HTTP Request): calls an HTTP API
- Transcribe Video (OpenAI): transcribe (audio)
- Analyze Content (OpenAI): uses OpenAI
- Build Row (Code): runs custom JavaScript code
- Save Insights to Google Sheets (Google Sheets): append or update
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick overview This workflow runs daily (or manually) to fetch recent videos from a list of TikTok accounts via Apify, transcribes each video with OpenAI, generates content insights and translations, and then appends or updates one row per video in Google…