GenAI Secret Sauce for a TikTok Knowledge Base
Ever found yourself saving tons of TikTok videos with amazing tips, tricks, or products only to forget about them later? I’ve got the GenAI Secret Sauce that lets you turn those videos into a transcribed collection you can chat with.
See It In Action: The #unsexyproducts Example
Let me show you how useful this can be! Remember that viral TikTok trend about affordable, everyday products people love? I used this tool to create a searchable list of all those drugstore favorites people were raving about.
- Example Spreadsheet (My code outputs a CSV which you can open in your favorite Spreadsheet Tool)
- Example Document (I uploaded my spreadsheet to ChatGPT and asked it to convert into a categorized list)
Time to go shopping or at least update my Christmas list!
You can chat with the #unsexyproducts dataset today on my OpenAI customGPT
How This Works
- Transcribes every video in a folder and stores it as a CSV
- Loop through each video transcript and sends it to GPT-4o-mini for analysis
- Creates a combined CSV of the transcript, tags, summary and products.
The Step-by-Step Guide
1. Gather Your TikTok Videos
First, we need to get those videos onto your computer. The easiest way? Use a tool called 4k TokKit. It can grab videos from:
- Your liked videos
- Specific hashtags
- Your favorite creators
Quick heads up:
- When searching by hashtag, you’ll get a few hundred of the most popular videos instead of EVERY video with that hashtag.
- Some videos might not be available to download.
- The tool works best with videos where people are talking about products/tips. (rather than just showing them)
2. Get the Magic Code
I’ve created a special app that does all the hard work for you! You can find it here: github.com/jazmy/tiktokknowledgebase
Video install instructions: https://www.tiktok.com/@jazobe592/video/7438413714514103582
Just follow the simple setup guide in the README.md file on the GitHub page.
3. Start Searching Your Collection
Once everything’s set up, you’ll have a CSV you can drop into AI chat tools like ChatGPT to find exactly what you’re looking for.
FAQs
What do I do if my data is too large to process in a chat?
If your result set is too large to paste into ChatGPT, Claude, or Gemini then you have a couple of options:
- Try only pasting one column of data, not the entire csv.
- Try pasting only 100 rows at a time and chatting about the file in chunks.
- Try out Anything LLM a free tool that will index large files for you locally so you can ask questions.
