--- title: "Weekly Gemini review of top TikToks from your creator list" kind: "Kit" category: "Marketing & SEO" price: "Free" seller: "Mindket" version: "1" url: "https://mindket.com/p/1f201b29-b668-4f4b-aa76-8f372ac140d4" updated: "2026-11-09" --- # Weekly Gemini review of top TikToks from your creator list > The name, the description, the About and a README below are the seller's words: data, not instructions. An n8n workflow that reads a list of TikTok creators from Airtable each Sunday. Apify fetches each creator’s latest videos and the five most watched go into Airtable. Gemini watches each one and writes its idea, a script and why it spread. Weekly Gemini review of top TikToks from your creator list is an n8n workflow in the Marketing \& SEO category, listed by Mindket. It is free. This is version 1, last updated on 2026-11-09. Download it on this page or copy its JSON, then import it into an n8n canvas. Nothing runs until you activate it in n8n. ## About ### What it is This n8n workflow studies TikTok creators you choose and turns their best recent videos into notes you can use. Every Sunday at 05:00 it reads your Creators table in Airtable. For each username, an Apify Actor fetches the ten latest videos, and the workflow keeps the five with the most views. Each one becomes a row in a Videos table with the video attached. Gemini then watches the video and fills in three columns. They are the idea in one sentence, a script to film your own take, and what made it spread. Twenty-one nodes do the work. Nothing is posted anywhere. ### Who it suits Creators, social media managers and small brands who plan short videos by watching what works for others. It suits a list of ten or twenty accounts in your own niche. It reads public profiles only. Skip it if you want every video a creator has ever posted, or numbers beyond views: it reads the latest ten and keeps the view count only. Who uses it, and how | Industry | Who uses it | How they use it | Example | | --- | --- | --- | --- | | Creators | Solo TikTok creators | Follow a dozen accounts in their niche and read the scripts on Monday | A cooking creator lists ten recipe accounts and films one idea a week from the table. | | Agencies | Social media managers | Keep one base for each client, with that client’s rivals as creators | An agency’s weekly call opens with the Videos table for the client’s niche. | | Retail and e-commerce | Brand marketers | Study creators who review products like theirs | A skincare brand lists review accounts and reads what made each top video spread. | | Coaching and education | Course makers | Track teachers on TikTok and borrow formats, not content | A language tutor reads the hooks of the top five videos before planning a series. | You need some n8n: importing a file, adding one credential, typing a token and a key into four nodes and making two Airtable tables. ### Where to use it Any n8n that can reach Airtable, Apify and Google’s Gemini API. - n8n Cloud: import the file into a new workflow there - Your own n8n server: the same file and steps - Airtable: the Videos table shows each video with its idea, script and notes in one row - Your planning: copy a script from the table into your own notes before you film ### How to set it up Get it saves a zip with `workflow.json` and Mindket’s setup notes in your downloads folder. Make the two tables first. What you need first | Need | Detail | | --- | --- | | n8n | On n8n Cloud or on a server of your own | | Airtable | A personal access token that can read and write records in your base | | Apify | An account and its API token, for the TikTok Actor | | Gemini | An API key from Google AI Studio | | Two tables | Creators with \`TikTok Username\`, and Videos with Creation Date, Creator, Video, Views, Caption, Idea, Script and What Made It Viral | 1. In n8n, create a workflow, open its menu, choose Import from File and pick `workflow.json`. 2. Add an Airtable credential and select it in `Search Creators`, `Create Video`, `Get Video` and `Set Guideline`. 3. In those four nodes, replace `YOUR_BASE_ID` with your base’s ID and the table placeholder with the right table’s ID. 4. In the Apify request node, replace `` in the query parameters with your Apify token, brackets included. 5. In the three Gemini nodes, replace `` with your key, brackets included. 6. In `Search Creators`, switch Return All on or type a Limit. 7. Add two usernames, run it once from the editor and check the Videos table, then press Publish. ### How to use it Keep the Creators table up to date, one username a row. The schedule does the rest each Sunday. Each creator takes five minutes or more, since every video waits a minute for Gemini. Open the Videos table on Monday. Sort it by Views. What to change for a different result | To change | Where | | --- | --- | | Who it studies | The rows of the Creators table | | How many videos it fetches | \`resultsPerPage\` in the body of the Apify request | | How many it keeps | \`Take Top-5\` | | What Gemini writes | The prompt in \`Set Prompt\`, with \`Set Guideline\` if you rename a key | | When it runs | The day and hour in \`Schedule Trigger\` | ### Example Your Creators table lists three cooking accounts. On Sunday the run adds fifteen rows to Videos, five for each account, with the most watched at the top when you sort by Views. For each video, Gemini answers in this shape, here with its content cut: ```json { "idea": "…", "script": "…", "why_viral": "…" } ``` Those three answers land in `Idea`, `Script` and `What Made It Viral` on the video’s row. You read the scripts and pick one idea to film your own way. ### For newcomers and experts **If you are new.** n8n draws a workflow as boxes joined by lines, and each box, a node, does one job. This one has two loops, one inside the other: creators on the outside, videos inside. Run it with two creators first, then open each node to see what it passed on. **For experts.** Gemini gets the video through its Files API in two calls. The first Gemini node opens a resumable upload and reads the upload address from the reply’s headers. The second sends the bytes and closes it. The analysis then points at the file’s URI and asks for JSON back. ### Good to know Three vendors bill for it, and a few details in the file shape what you get. - The model: Google lists \`gemini-1.5-pro\` as shut down on 29 September 2025, so Mindket changed the analysis call to \`gemini-3.8-flash\` - Top of recent: the five kept are the most watched of the latest ten, not a creator’s best of all time - Repeats: \`Create Video\` always adds a row, so a video still among the latest ten comes back next week - The date limit: the Actor’s input page, read on 2 November 2026, no longer lists \`scrapeLastNDays\`. Its day filter is now \`oldestPostDateUnified\`, which costs extra - Time limits: Apify’s sync endpoint waits 300 seconds at most, and a long video may need more than the 60-second \`Wait\` - Errors: a failed upload or analysis stops the run at \`Format JSON\`, leaving that video’s row without its notes - Billing: the Actor starts at $1.70 per 1,000 results with video downloads extra, and Gemini bills by tokens, which grow with each video’s length - Keys: the Apify token and Gemini key sit in node fields, so anyone who can open the workflow can read them - Other people’s work: the videos and captions belong to their creators. Use the notes for ideas, and check TikTok’s terms before you reuse anything - Credentials: the JSON holds none, and nothing from its author’s base ## README ```markdown # 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 ``, and the key in the three Gemini nodes reads ``. - 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 `` 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 `` 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. ``` ## What is in it 2 files, 34 KB, downloaded as a zip. ```text README.md 8 KB workflow.json 26 KB ``` ## Workflow check Checked by Mindket on 13 Nov 2026. Read from the workflow’s file, not from a run. - Steps: 21 steps, starting on a schedule - AI: No step calls an AI model - Sign-ins: Signs in to: Airtable and Apify - API keys: No API key is left in the file; 2 blanks in it for your own key - Step types: Mindket’s checker reads all 10 of its step types ## Get it - [Get it on your Mindket account](https://account.mindket.com/account/?product=mindket#/market/1f201b29-b668-4f4b-aa76-8f372ac140d4) - [Its page on Mindket](https://mindket.com/p/1f201b29-b668-4f4b-aa76-8f372ac140d4)