Weekly Gemini review of top TikToks from your creator list

Weekly Gemini review of top TikToks from your creator list

An n8n workflow that studies TikTok creators you follow for content ideas. Every Sunday morning it reads your list of creators
from Airtable. For each one, an Apify Actor fetches their ten latest videos and the workflow keeps the five with the most views.
Each of those five becomes a row in a second Airtable table, with the video attached. Gemini then watches the video and writes
back three things: the idea in one sentence, a script you could film yourself, and what made it spread.

What is inside

• workflow.json: the workflow as n8n exports it, twenty-one working nodes and four sticky notes. It holds no credential.
• README.md: these notes.

What we changed from the original copy

• The original copy held a live-looking Apify token and Gemini API key, typed into four nodes. Both are gone. The token in
  Apify - Scrape TikToks now reads <YOUR_APIFY_TOKEN>, and the key in the three Gemini nodes reads <YOUR_GEMINI_API_KEY>.
• The author's Airtable base and tables are gone. The four Airtable nodes ask for YOUR_BASE_ID, and for
  YOUR_CREATORS_TABLE_ID or YOUR_VIDEOS_TABLE_ID.
• Gemini - Analyse Video called gemini-1.5-pro, which Google has shut down, so that call could no longer run. It now calls
  gemini-3.8-flash, a current Gemini model that reads video. Nothing else in the node changed.

Before you start

• An n8n instance, on n8n Cloud or your own server.
• An Airtable account and a personal access token that can read and write records in your base.
• An Apify account and its API token.
• A Gemini API key from Google AI Studio.

Set it up

1. In n8n, create a workflow, open its menu and choose Import from File. Pick workflow.json.
2. Make the Airtable base, with the two tables below. Copy the base ID (it starts with app) and each table's ID (it starts
   with tbl) from the address bar while the table is open.
3. Add an Airtable Personal Access Token credential and select it in Search Creators, Create Video, Get Video and
   Set Guideline. In each of them, put your base ID in place of YOUR_BASE_ID. Search Creators takes the Creators table's
   ID in place of YOUR_CREATORS_TABLE_ID, and the other three take the Videos table's ID in place of YOUR_VIDEOS_TABLE_ID.
4. In Apify - Scrape TikToks, open Query Parameters and replace <YOUR_APIFY_TOKEN> with your Apify token, brackets
   included. The token is under Settings, API and Integrations in the Apify Console.
5. In Gemini - Generate Upload URL, Gemini - Upload File and Gemini - Analyse Video, replace <YOUR_GEMINI_API_KEY> in
   the key query parameter with your key, brackets included.
6. Open Search Creators and either switch Return All on or type a Limit, up to 100. The file leaves Return All off with an
   empty Limit.
7. Add two or three usernames to the Creators table, run the workflow once from the editor, and check the Videos table.
8. Press Publish to let the schedule start it each week.

The tables

• Creators: one column, TikTok Username, with one username a row. Every row is read on each run.
• Videos: Creation Date and Creator as single line text, Video as an attachment, Views as a number, and
  Caption, Idea, Script and What Made It Viral as long text. Spell them exactly so.

How a run goes

1. Schedule Trigger starts the run every Sunday at 05:00, in the time zone your n8n uses.
2. Search Creators reads the Creators table, and Loop Over Creators takes one creator at a time.
3. Apify - Scrape TikToks runs the clockworks~tiktok-scraper Actor on that username and waits for its results. It asks
   for the ten latest videos and for the videos themselves to be downloaded into an Apify store named tiktok.
4. Check If Video keeps the results that carry a video address. Save Fields keeps the address, views, caption, creator and
   date, then Sort Videos By Views and Take Top-5 keep the five most watched.
5. Loop Over Videos takes one of the five at a time. Format Date writes the date as day-month-year, and Create Video
   adds the row with the video attached. Airtable fetches the file from the address it is given.
6. Get Video reads the row back for the attachment's Airtable address, size and type. Gemini - Generate Upload URL opens
   an upload, Download File fetches the video from Airtable, and Gemini - Upload File sends it to Gemini.
7. Save Values keeps the file's Gemini address, and Wait gives Gemini 60 seconds to process the video.
8. Set Prompt builds the request, with the view count in it. Gemini - Analyse Video sends it with the video and asks for a
   JSON answer with idea, script and why_viral.
9. Format JSON reads that answer, and Set Guideline writes it into Idea, Script and What Made It Viral on the row.
   The loop moves to the next video, and after the fifth, to the next creator.

Change the look

• Who it studies: the Creators table. Add or remove usernames between runs.
• How many videos: resultsPerPage in the body of Apify - Scrape TikToks sets how many it fetches, and Take Top-5 how
  many it keeps.
• What Gemini writes: the prompt in Set Prompt. Keep the same three keys, or change Set Guideline to match.
• When it runs: the day and hour in Schedule Trigger.

Good to know

• Top of recent, not of all time: the Actor returns the ten latest videos, so the five kept are the most watched of those ten.
• Repeats: Create Video always adds a row. A video that stays in a creator's latest ten shows up again next week.
• The date limit: the body asks for the last 360 days with scrapeLastNDays. The Actor's input page, read on the same
  day as its prices below, no longer lists that field. Its day limit is now oldestPostDateUnified, which it bills as a filter.
• No video found: if Check If Video passes nothing, open one Apify result in the run and check where the video's address
  sits. The file reads it from videoMeta.downloadAddr.
• Time limits: Apify's run-sync endpoint waits at most 300 seconds and then answers with a 408 error, which stops the run.
  A long video can also still be processing after the 60-second Wait. Raise the wait if the analysis fails on long videos.
• Errors: Gemini - Upload File, Save Values, Wait, Set Prompt and Gemini - Analyse Video carry on after an error,
  but Format JSON does not. A failed upload or analysis stops the run there, and that video's row stays without its
  analysis. Rows already finished keep theirs.
• The prompt goes into the request body as it is. A double quote or a line break typed into Set Prompt breaks the request.
• The model: Google's changelog lists gemini-1.5-pro as shut down on 29 September 2025, so this copy calls
  gemini-3.8-flash instead. Any newer model that takes video fits in the same place in the address.
• Gemini files: Google keeps uploaded files for 48 hours and then deletes them, so nothing builds up there.
• Billing: Apify's page for the Actor, read on 2 November 2026, starts at $1.70 per 1,000 results, and video downloads are a
  paid add-on. Gemini bills each analysis by tokens, which grow with the video's length. Airtable counts the attached videos
  against your plan's attachment space.
• Keys in plain sight: the Apify token and Gemini key sit in node fields, not in n8n credentials, so anyone who can open the
  workflow can read them.
• Your data: the workflow copies other people's videos and captions into your base and sends them to Google. Use what it
  writes as notes for your own ideas, and check TikTok's terms and the creators' rights before you reuse anything.