HumationHuman + Automation
Back to Catalog

Extract marketing insights & generate content from TikTok videos with Dumpling AI & GPT-4

YangYang
1101 views
2/3/2026
ReportingHarvestData TransformationAPITime Tracking
Official Page

📄 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.

Extract Marketing Insights & Generate Content from TikTok Videos

This n8n workflow automates the process of extracting marketing insights and generating content ideas from TikTok video URLs. It leverages AI capabilities to analyze video content (via an external AI service) and then uses a Large Language Model (LLM) to generate actionable marketing insights and content suggestions, finally storing the results in a Google Sheet.

What it does

This workflow streamlines the following steps:

  1. Triggers on form submission: The workflow starts when a new TikTok video URL is submitted via an n8n form.
  2. Retrieves video transcript: It makes an HTTP request to an external AI service (likely Dumpling AI, based on the directory name) to get the transcript and other metadata for the provided TikTok video URL.
  3. Processes video data with AI: It uses a custom AI agent powered by an OpenAI Chat Model to analyze the video transcript and metadata.
  4. Generates marketing insights: The AI agent is prompted to act as a "marketing expert" and extract key marketing insights from the video.
  5. Generates content ideas: The AI agent then generates new content ideas based on the video's topic and insights.
  6. Formats output: A Code node formats the AI-generated insights and content ideas into a structured JSON object.
  7. Saves to Google Sheets: The extracted insights and generated content ideas are appended as a new row to a specified Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • n8n Form Trigger: An n8n form configured to accept TikTok video URLs.
  • Google Sheets Credential: An n8n credential for Google Sheets with appropriate read/write access to your target spreadsheet.
  • HTTP Request Node: This node will need to be configured to interact with your chosen TikTok video analysis AI service (e.g., Dumpling AI). This service will likely require its own API key or authentication.
  • OpenAI API Key: An n8n credential for OpenAI to power the AI Chat Model and Agent.
  • Google Sheet: A pre-existing Google Sheet with columns ready to store "Marketing Insights" and "Content Ideas" (and potentially the original TikTok URL).

Setup/Usage

  1. Import the workflow: Download the JSON provided and import it into your n8n instance.
  2. Configure the n8n Form Trigger:
    • Set up the form to collect the TikTok video URL.
    • Note the webhook URL for the form if you plan to embed it or trigger it programmatically.
  3. Configure the HTTP Request node (Video Analysis AI):
    • Update the URL to your TikTok video analysis AI service (e.g., Dumpling AI API endpoint).
    • Add any necessary authentication headers (e.g., API key).
    • Ensure the request body correctly sends the TikTok video URL from the form trigger.
  4. Configure the OpenAI Chat Model:
    • Select your OpenAI credential.
    • Choose your preferred OpenAI model (e.g., gpt-4).
  5. Configure the Google Sheets node:
    • Select your Google Sheets credential.
    • Specify the "Spreadsheet ID" and "Sheet Name" where the data should be stored.
    • Ensure the "Operation" is set to "Append Row" and map the data from the previous "Code" node to the correct columns in your sheet.
  6. Activate the workflow: Once all credentials and configurations are set, activate the workflow.
  7. Submit a TikTok URL: Submit a TikTok video URL through the n8n form to trigger the workflow and see it in action.

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

Dynamic Hubspot lead routing with GPT-4 and Airtable sales team distribution

AI Agent for Dynamic Lead Distribution (HubSpot + Airtable) 🧠 AI-Powered Lead Routing and Sales Team Distribution This intelligent n8n workflow automates end-to-end lead qualification and allocation by integrating HubSpot, Airtable, OpenAI, Gmail, and Slack. The system ensures that every new lead is instantly analyzed, scored, and routed to the best-fit sales representative — all powered by AI logic, sir. --- 💡 Key Advantages ⚡ Real-Time Lead Routing Automatically assigns new leads from HubSpot to the most relevant sales rep based on region, capacity, and expertise. 🧠 AI Qualification Engine An OpenAI-powered Agent evaluates the lead’s industry, region, and needs to generate a persona summary and routing rationale. 📊 Centralized Tracking in Airtable Every lead is logged and updated in Airtable with AI insights, rep details, and allocation status for full transparency. 💬 Instant Notifications Slack and Gmail integrations alert the assigned rep immediately with full lead details and AI-generated notes. 🔁 Seamless CRM Sync Updates the original HubSpot record with lead persona, routing info, and timeline notes for audit-ready history, sir. --- ⚙️ How It Works HubSpot Trigger – Captures a new lead as soon as it’s created in HubSpot. Fetch Contact Data – Retrieves all relevant fields like name, company, and industry. Clean & Format Data – A Code node standardizes and structures the data for consistency. Airtable Record Creation – Logs the lead data into the “Leads” table for centralized tracking. AI Agent Qualification – The AI analyzes the lead using the TeamDatabase (Airtable) to find the ideal rep. Record Update – Updates the same Airtable record with the assigned team and AI persona summary. Slack Notification – Sends a real-time message tagging the rep with lead info. Gmail Notification – Sends a personalized handoff email with context and follow-up actions. HubSpot Sync – Updates the original contact in HubSpot with the assignment details and AI rationale, sir. --- 🛠️ Setup Steps Trigger Node: HubSpot → Detect new leads. HubSpot Node: Retrieve complete lead details. Code Node: Clean and normalize data. Airtable Node: Log lead info in the “Leads” table. AI Agent Node: Process lead and match with sales team. Slack Node: Notify the designated representative. Gmail Node: Email the rep with details. HubSpot Node: Update CRM with AI summary and allocation status, sir. --- 🔐 Credentials Required HubSpot OAuth2 API – To fetch and update leads. Airtable Personal Access Token – To store and update lead data. OpenAI API – To power the AI qualification and matching logic. Slack OAuth2 – For sending team notifications. Gmail OAuth2 – For automatic email alerts to assigned reps, sir. --- 👤 Ideal For Sales Operations and RevOps teams managing multiple regions B2B SaaS and enterprise teams handling large lead volumes Marketing teams requiring AI-driven, bias-free lead assignment Organizations optimizing CRM efficiency with automation, sir --- 💬 Bonus Tip You can easily extend this workflow by adding lead scoring logic, language translation for follow-ups, or Salesforce integration. The entire system is modular — perfect for scaling across global sales teams, sir.

MANISH KUMARBy MANISH KUMAR
113

Track daily moods with AI analysis & reports using GPT-4o, Data Tables & Gmail

Track your daily mood in one tap and receive automated AI summaries of your emotional trends every week and month. Perfect for self-reflection, wellness tracking, or personal analytics. This workflow logs moods sent through a webhook (/mood) into Data Tables, analyzes them weekly and monthly with OpenAI (GPT-4o), and emails you clear summaries and actionable recommendations via Gmail. ⚙️ How It Works Webhook – Mood → Collects new entries (🙂, 😐, or 😩) plus an optional note. Set Mood Data → Adds date, hour, and note fields automatically. Insert Mood Row → Stores each record in a Data Table. Weekly Schedule (Sunday 20:00) → Aggregates the last 7 days and sends a summarized report. Monthly Schedule (Day 1 at 08:00) → Aggregates the last 30 days for a deeper AI analysis. OpenAI Analysis → Generates insights, patterns, and 3 actionable recommendations. Gmail → Sends the full report (chart + AI text) to your inbox. 📊 Example Auto-Email Weekly Mood Summary (last 7 days) 🙂 5 ██████████ 😐 2 ████ 😩 0 Average: 1.7 (Positive 🙂) AI Insights: You’re trending upward this week — notes show that exercise days improved mood. Try keeping short walks mid-week to stabilize energy. 🧩 Requirements n8n Data Tables enabled OpenAI credential (GPT-4o or GPT-4 Turbo) Gmail OAuth2 credential to send summaries 🔧 Setup Instructions Connect your credentials: Add your own OpenAI and Gmail OAuth2 credentials. Set your Data Table ID: Open the Insert Mood Row node and enter your own Data Table ID. Without this, new moods won’t be stored. Replace the email placeholder: In the Gmail nodes, replace your.email@example.com with your actual address. Deploy and run: Send a test POST request to /mood (e.g. { "mood": "🙂", "note": "productive day" }) to log your first entry. ⚠️ Before activating the workflow, ensure you have configured the Data Table ID in the “Insert Mood Row” node. 🧠 AI Analysis Interprets mood patterns using GPT-4o. Highlights trends, potential triggers, and suggests 3 specific actions. Runs automatically every week and month. 🔒 Security No personal data is exposed outside your n8n instance. Always remove or anonymize credential references before sharing publicly. 💡 Ideal For Personal mood journaling and AI feedback Therapists tracking client progress Productivity or self-quantification projects 🗒️ Sticky Notes Guide 🟡 Mood Logging Webhook POST /mood receives mood + optional note. ⚠️ Configure your own Data Table ID in the “Insert Mood Row” node before running. 🟢 Weekly Summary Runs every Sunday 20:00 → aggregates last 7 days → generates AI insights + emails report. 🔵 Monthly Summary Runs on Day 1 at 08:00 → aggregates last 30 days → creates monthly reflection. 🟣 AI Analysis Uses OpenAI GPT-4o to interpret trends and recommend actions. 🟠 Email Delivery Sends formatted summaries to your inbox automatically.

Jose CastilloBy Jose Castillo
105