👉 n8n No Limits Access :

https://www.hostg.xyz/SHHAd

Hébergement VPS n8n | Automatisation sécurisée et évolutive

coupon -15% : DRFIRAS15

👉 Formation n8n en Français

Formation n8n en Français : Automatisation & Agents IA

coupon -20% : LANCEMENT : HERE

Copy my Google Sheets :

🎯 What you will build

A workflow that watches a list of TikTok creators, pulls their latest videos, transcribes and analyzes each one with OpenAI, and stores structured insights in Google Sheets — one row per video.

This document is a build-along script: everything is copy‑paste ready so you can recreate the workflow node by node, live, without opening the finished version.

Flow (build order):

Run manually / Schedule Trigger
  → Configuration (Set)
  → Get Accounts (Google Sheets: read)
  → Build Apify Input (Code)
  → Run TikTok Scraper (HTTP → Apify)
  → Normalize TikTok Videos (Code)
  → Download Video (HTTP)
  → Transcribe Video (OpenAI Whisper)
  → Analyze Content (OpenAI GPT)
  → Build Row (Code)
  → Save Insights to Google Sheets (Google Sheets: appendOrUpdate)

💡 The Apify TikTok scraper is called through a plain HTTP Request node (run‑sync endpoint), so this workflow runs on both self‑hosted and n8n Cloud — no community node required.

🔑 Prerequisites & credentials

You need three credentials. Create them once, then attach them in the nodes below.