YouTube trends finding agent
Who this is for
This workflow is for content creators, digital marketers, or YouTube strategists who want to automatically discover trending videos in their niche, analyze engagement metrics, and get data-driven insights for their content strategy — all from one simple form submission.
What this workflow does
This workflow starts every time someone submits the YouTube Trends Finder Form. It then:
- Searches YouTube videos based on your topic and specified time range using the YouTube Data API.
- Fetches detailed analytics (views, likes, comments, engagement rates) for each video found.
- Calculates engagement rates and filters out low-performing content (below 2% engagement).
- Applies smart filters to exclude videos with less than 1000 views, content outside your timeframe, and hashtag-heavy titles.
- Removes duplicate videos to ensure clean data.
- Creates a Google Spreadsheet with all trending video data organized by performance metrics.
- Delivers the results via a completion form with a direct link to your analytics report.
Setup
To set this workflow up:
- Form Trigger – Customize the "YouTube Trends Finder" form fields if needed (Topic Name, Last How Many Days).
- YouTube Data API – Add your YouTube OAuth2 credentials and API key in the respective nodes.
- Google Sheets – Connect your Google Sheets account for automatic report generation.
- Engagement Filters – Adjust the 2% engagement rate threshold based on your quality standards.
- View Filters – Modify the minimum view count (currently 1000+) in the filter conditions.
- Regional Settings – Update the region code (currently "US") to target specific geographic markets.
How to customize this workflow to your needs
- Change the engagement rate threshold to be more or less strict based on your niche requirements.
- Add additional filters like video duration, subscriber count, or specific keywords to refine results.
- Modify the Google Sheets structure to include extra metrics like "Channel Name", "Video Duration", or "Trending Score".
- Switch to different output formats like CSV export or direct email reports instead of Google Sheets.
YouTube Trending Video Finder and Google Sheet Logger
This n8n workflow helps you discover trending YouTube videos based on a user-provided search query and logs the results into a Google Sheet. It's designed to automate the process of finding popular content, making it easier to track trends or gather data for content creation.
What it does
- Triggers on Form Submission: The workflow starts when a user submits a form with a YouTube search query.
- Fetches Trending YouTube Videos: It uses the provided search query to find trending videos on YouTube.
- Filters out Duplicates: Ensures that only unique video entries are processed, preventing redundant data in your Google Sheet.
- Extracts Relevant Data: Transforms the YouTube video data into a structured format, selecting key fields like video ID, title, and channel name.
- Logs to Google Sheets: Appends the extracted trending video information as new rows to a specified Google Sheet.
Prerequisites/Requirements
- n8n Instance: A running n8n instance.
- Google Account: A Google account with access to Google Sheets.
- YouTube API Key: A YouTube Data API v3 key configured as a credential in n8n.
- Google Sheets Credential: A Google Sheets credential configured in n8n, typically using OAuth 2.0.
Setup/Usage
- Import the Workflow:
- Copy the provided JSON workflow definition.
- In your n8n instance, click "New" to create a new workflow.
- Go to the "Workflows" menu, select "Import from JSON", and paste the workflow JSON.
- Configure Credentials:
- YouTube Node (ID: 357): Edit the "YouTube" node and select your YouTube API credential. If you don't have one, create a new "Google" OAuth2 API credential, ensuring it has access to the YouTube Data API.
- Google Sheets Node (ID: 18): Edit the "Google Sheets" node and select your Google Sheets credential. If you don't have one, create a new "Google" OAuth2 API credential, ensuring it has access to Google Sheets.
- Configure Google Sheet:
- In the "Google Sheets" node (ID: 18), specify the Spreadsheet ID and Sheet Name where you want to log the trending videos. Ensure the sheet exists and the n8n credential has write access.
- Configure the Form Trigger:
- The "On form submission" node (ID: 1225) will automatically generate a unique URL when the workflow is activated. This URL can be used to submit search queries. The form expects a field named
query. - Alternatively, you can use the "n8n Form" node (ID: 1274) to create a user-friendly form interface directly within n8n.
- The "On form submission" node (ID: 1225) will automatically generate a unique URL when the workflow is activated. This URL can be used to submit search queries. The form expects a field named
- Activate the Workflow: Toggle the workflow to "Active" to start listening for form submissions.
- Submit a Query: Use the form URL (from the "On form submission" node) or the n8n Form to submit a search query (e.g., "AI tools", "gaming news"). The workflow will then execute, fetch trending videos, and log them to your Google Sheet.
Related Templates
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.
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.
Create, update, and get a person from Copper
This workflow allows you to create, update, and get a person from Copper. Copper node: This node will create a new person in Copper. Copper1 node: This node will update the information of the person that we created using the previous node. Copper2 node: This node will retrieve the information of the person that we created earlier.