Back to Templates

Extract Marketing Insights & Generate Content from TikTok Videos with Dumpling AI & GPT-4

Created by

Created by: Yang || yang

Yang

Last update

Last update 16 hours ago

Share


📄 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

  1. 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
  2. Credentials

    • Add your Dumpling AI key using HTTP Header Auth
    • Use GPT-4 via OpenAI credentials
    • Connect your Google Sheets using OAuth2
  3. Customization (Optional)

    • You can modify the GPT-4 prompts in the LangChain nodes to change tone, output structure, or content depth

🧠 How it works

  1. A form is submitted with a TikTok URL, keyword, and product
  2. Dumpling AI fetches and returns the TikTok transcript
  3. The VTT format is cleaned into plain text
  4. GPT-4 (via LangChain agent) extracts:
    • Pain points
    • Desired outcomes
    • Motivating events
    • Direct quotes
  5. GPT-4 then rewrites the transcript into a compelling marketing post
  6. 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.