π What this workflow does
This workflow turns TikTok videos into high-quality marketing insights and social-ready posts using Dumpling AI and GPT-4.
It takes a TikTok URL, keyword, and product name, then automatically extracts the video transcript, analyzes the content for key marketing insights (pain points, outcomes, triggers), and rewrites it as a social media post that positions your product as the solution. Everything is logged to Google Sheets for use by your content or product team.
π€ Who is this for
- Product marketers doing UGC research
- Copywriters repurposing TikTok into content
- Founders or VAs turning viral clips into assets
- Agencies building research-based social proof
βοΈ How to set up
β
Requirements
-
Dumpling AI : For TikTok transcript extraction
-
OpenAI GPT-4 or GPT-4o-mini : For analysis and rewriting
-
Google Sheets : To log the results
-
n8n Form Trigger : To input
TikTok URL
, Keyword
, and Product
π§ Setup Instructions
-
Google Sheets
- Create a sheet with the following columns:
-
Video URL
, Original Transcription
, Pain points
, Desired outcomes
,
Triggers or motivating events
, Interesting direct quotes
, New Script
- Update the sheet ID and tab in the Google Sheets node
-
Credentials
- Add your Dumpling AI key using
HTTP Header Auth
- Use GPT-4 via OpenAI credentials
- Connect your Google Sheets using OAuth2
-
Customization (Optional)
- You can modify the GPT-4 prompts in the LangChain nodes to change tone, output structure, or content depth
π§ How it works
- A form is submitted with a TikTok URL, keyword, and product
- Dumpling AI fetches and returns the TikTok transcript
- The VTT format is cleaned into plain text
- GPT-4 (via LangChain agent) extracts:
- Pain points
- Desired outcomes
- Motivating events
- Direct quotes
- GPT-4 then rewrites the transcript into a compelling marketing post
- Results are saved to Google Sheets for further use
π οΈ Customization ideas
- Push insights to Notion or Airtable instead of Sheets
- Use Claude or Gemini instead of GPT-4
- Automatically generate image prompts to pair with the rewritten script
- Add notification email or Slack post when draft is ready
This workflow gives marketers and founders a fast way to convert real social content into reusable copy, backed by authentic user voice and GPT-powered insights.