Bulk TikTok Transcripts: Transcribe a List of Videos and Compare Them

To transcribe many TikToks at once, put the video links in one list, one per line, and run the list through a transcriber that accepts more than one link. Most of the value comes after that step. A folder of transcripts tells you little until you move them into a sheet with columns for the opening line, the word count and the call to action, so you can compare the videos side by side.

TikTok's own transcript data goes to researchers

TikTok's Research API returns a voice_to_text field with the text TikTok already generated for videos that have voice to text turned on, and it hands back up to 100 videos per request (Research API specs). Access is limited to academic institutions in the U.S., EEA, UK, Canada and Switzerland plus some not-for-profit research groups, and applicants must be independent of commercial interests (TikTok Research API). Brands, agencies and creators doing ad research fall outside those terms, so they work from the video links instead.

Build the link list around one question

Pick the question before you collect links, because it decides which videos go in the batch:

• Competitor research: a competitor's last 20 or 30 videos, to find the claims and offers they repeat.
• Category research: the top videos for one product type, to compare how each one opens.
• Creator vetting: a creator's recent videos before you hire them, to judge how they talk on camera.
• Your own deals: your past brand videos, to find the openings you keep reusing.

To copy a link in the TikTok app, tap the Share button on the video or press and hold it, then copy the link from the sharing options (TikTok Help Center). On a computer, copy the address from the browser bar. Private videos cannot be shared, so leave them out.

Paste every link into a plain note, one per line. Delete duplicates and anything other than a video post, such as profile links.

Run the batch

UGC Script takes up to 50 TikTok or Instagram Reels links pasted into the box at once, transcribes them in order and exports the finished batch as .txt or .csv. The free plan covers 5 videos a day, so a 30-video competitor batch needs a paid plan or several days.

Before you sort anything, open a few transcripts and check the brand and product names against the videos. A misspelled name breaks every search and filter you run on the sheet later.

Add columns that make the videos comparable

Import the CSV into Google Sheets. The export holds url, platform, author, title, duration in seconds, language and transcript, in columns A to G. Add these columns next to them:

Column	What it holds	How to fill it
H: Word count	Length of the script	=COUNTA(SPLIT(G2," "))
I: Words per second	Speaking pace	=H2/E2
J: Opening line	The first sentence	=REGEXEXTRACT(G2,"^[^.?!]+[.?!]?")
K: Product named at	Seconds before the product is named	By hand, from the video
L: Call to action	The last line	By hand, from the transcript
M: Angle	Problem, demo, comparison or story	By hand

SPLIT treats consecutive spaces as one by default, so double spaces in a transcript do not inflate the count (Google Docs Editors Help). REGEXEXTRACT returns the first part of the text that matches the pattern, here everything up to the first period, question mark or exclamation point (Google Docs Editors Help).

Read the sheet for patterns

Sort by word count and read the opening lines from the top and bottom of the list together. Then check:

• How many seconds pass before the product is named, and whether the longer waits belong to the story videos.
• Whether the openings talk to the viewer ("you") or about the speaker ("I").
• Which calls to action repeat word for word across different creators. Identical lines across accounts probably came from a brand brief.

Then put the findings to use:

• Briefs: paste two or three openings that fit your product as references, and say which part to keep (the situation) and which to change (the wording).
• Swipe files: keep the sheet, add a column for why each video went in, and keep the URL column so anyone can watch the original.
• Creator direction: send the creator the word counts and pace of the videos you liked, so the script fits the same length when they read it aloud.