Skip to content
FlowHubFluxonLab

HTTP Request workflows

1,200 results — 3 downloadable workflow files, 1,197 source-linked n8n references

CW
free

Track Pennylane invoice payment status with Slack notifications

Who is this for Teams using Pennylane (French accounting platform) who want automatic alerts when invoices are paid or become overdue, without checking Pennylane manually. What it does This workflow runs every 15 minutes, fetches all customer invoices from Pennylane, and classifies them as paid, overdue, or upcoming. If any invoices have been paid or are overdue, it sends a summary notification to Slack. If everything is normal, the workflow ends silently. How to set up Import this workflow into n8n Create a Header Auth credential with name Authorization and value Bearer <YOUR_PENNYLANE_TOKEN> Select your Slack channel in the SL Send Notification node Adjust the schedule interval in the Schedule Trigger node if needed Requirements Pennylane account with API access (Essentiel plan or higher) Pennylane API token with scope: customer_invoices:all (Optional) Slack workspace for notifications How to customize Change the polling interval in the Schedule Trigger node (default: every 15 minutes) Replace Slack with Telegram, Email, or any other notification channel Note: Pennylane API does not support filtering by status or paid fields, all classification is done client-side in a Code

by Gauthier Huguenin
CWtelegram
free

Send daily Brent crude oil futures prices to Telegram with 0 API cost

Who is this for? Oil traders, energy analysts, commodity research desks, shipping operations teams, refinery planners, equity investors in oil stocks, macro researchers, and anyone whose day starts with "where is Brent trading?" If you track the international oil benchmark and want hands-free price updates delivered to Telegram multiple times a day without paying for a Bloomberg terminal or a commodity data API, this workflow is built for you. What problem does this solve? Most professional oil price data sources charge steep monthly fees. Bloomberg terminals run into thousands per month. Refinitiv, CQG, and similar platforms are priced for institutions. Free alternatives exist but require manually checking websites throughout the day, which breaks focus and wastes time. This workflow silently scrapes the public Brent Crude futures page on oilprice.com, extracts the 10-month forward curve, formats the data into a clean tabular Telegram message, and delivers it on a configurable schedule. You get institutional-grade visibility into the Brent forward curve without spending a rupee on data feeds. Zero ongoing cost to run This workflow has no API keys, no subscriptions, and no metered

by Rahul Shah
ACWopenaichatmodel
free

Generate AI-powered pro vs con debates with GPT-4o and Google Sheets tracking

This workflow automatically processes incoming debate topic requests, generates structured, evidence-backed Pro vs Con debates with balanced arguments, rebuttals, and final verdicts using AI, delivers them via email, and logs everything in Google Sheets. Who’s it for • Students and debaters preparing arguments • Content creators and podcasters • Researchers and analysts needing balanced views • Decision-makers and AI enthusiasts exploring topics How it works / What it does Captures new debate requests (webhook or scheduled poll) Validates the topic and prepares context AI generates full structured debate (Pro/Con arguments with evidence, rebuttals, verdict) Formats professional markdown output Emails the complete debate to the requester Logs topic, verdict summary, and generation details in Google Sheets How to set up Import this workflow Set up credentials (Webhook, Google Sheets, OpenAI/Anthropic) Update default instructions and email sender Activate workflow Requirements • Webhook endpoint for topic submissions • Google Sheets • OpenAI / Anthropic / Grok API • Clear debate topic input How to customize the workflow • Modify AI prompt for depth, tone, or format in the AI node • Ad

by Oneclick AI Squad
ACgmailsheets
free

Audit multi-page CRO with GPT-4o-mini, Google Sheets, and Gmail alerts

Description Submit up to 3 landing page URLs using a simple form and the workflow audits each one automatically. For every page, GPT-4o-mini scrapes the content, scores it across five dimensions, identifies the top conversion issue, and generates five specific page fixes. Every result is logged to Google Sheets and pages that score below your alert threshold trigger an automatic Gmail alert with the full breakdown. Built for marketing managers, agency owners, and growth teams who need structured, repeatable conversion audits without spending hours reviewing pages manually. What This Workflow Does Scrapes and cleans each page automatically** — Fetches the raw HTML for every URL submitted, strips all scripts and styles, and prepares clean text for AI analysis Scores pages across five CRO dimensions** — GPT-4o-mini rates each page on overall conversion potential, CTA strength, trust score, and message clarity on a 1–10 scale Generates a letter grade per page** — Assigns A+ through F based on the overall score so you can rank pages at a glance Produces five page-specific fixes** — Every fix references actual content from the page and is scoped to be doable within 1–2 days — no generic

by Incrementors
ACWopenaichatmodel
free

Optimize blog and product pages for Google AI Overviews with GPT-4 and Sheets

This workflow automatically monitors blog posts or product pages for new/updated content, analyzes Google AI Overviews to identify optimization gaps, auto-generates optimized titles, summaries, and schema markup, and applies these improvements to enhance visibility in AI search results. Who's it for • SEO managers optimizing for AI-driven search results • Content teams publishing 5+ articles per week • E-commerce teams managing product page visibility • Digital marketers tracking AI Overview presence How it works / What it does Detects new or updated blog posts / product pages via webhook or schedule Fetches raw content and existing metadata Queries Google Search API to analyze AI Overview coverage gaps AI generates optimized title, meta summary, and JSON-LD schema markup Pushes improvements back to CMS or target endpoint Logs all changes and scores to Google Sheet tracker How to set up Import this workflow Set up credentials (Google Search API, OpenAI/Anthropic, CMS/HTTP, Google Sheets) Update your site URL and content preferences Activate workflow Requirements • Webhook endpoint or CMS trigger • Google Custom Search API key • OpenAI / Anthropic / Grok API • CMS REST API or target

by Oneclick AI Squad
W
free

Qualify insurance quote leads with Aloware SMS and AI voice agent

Description Automate insurance lead qualification with an AI Voice Agent. When a prospect requests a quote — auto, home, life, or commercial — this workflow instantly acknowledges the request via SMS and routes urgent leads to an AI-powered qualification call that captures coverage details, timeline, and budget. Insurance agencies live and die by speed-to-quote. This workflow eliminates the lag between a quote request landing in your inbox and an agent picking up the phone. Urgent leads get an immediate AI Voice Agent call that qualifies them on the spot, while standard leads enter a nurture drip until they're ready. How it works A Webhook receives a quote request from your website form, landing page, or lead vendor. A Set node normalizes the prospect data — phone, name, email, insurance type (auto/home/life/commercial), current coverage status, urgency, and ZIP code. An HTTP Request creates the contact in Aloware with insurance type, coverage status, and ZIP stored in custom fields and notes. A second HTTP Request sends an instant SMS: "Hi {name}! This is {agent} from {agency}. We received your {insurance type} quote request…" An IF node checks the urgency field. Urgent leads → en

by Maxim Dudnik
W
free

Route CRM new leads to Aloware for instant SMS and AI qualification calls

Description Connect your CRM to Aloware so every new lead gets an instant SMS and is routed to the right AI-powered follow-up sequence — all within seconds of form submission. Speed-to-lead is everything. Studies show responding within 5 minutes makes you 100x more likely to connect. This workflow eliminates the gap between "lead submitted" and "rep reached out" by automating the entire handoff from your CRM to Aloware's voice and SMS platform. How it works A Webhook receives new lead data from your CRM (HubSpot, Salesforce, Pipedrive, or any system that can POST JSON). A Set node normalizes the payload — it pulls phone, name, email, company, lead score, and source from whichever field structure your CRM sends, so you don't have to rewrite the workflow per CRM. An HTTP Request creates or updates the contact in Aloware via the /webhook/forms endpoint, storing lead source and score as custom fields. A second HTTP Request fires a personalized SMS to the lead within seconds: "Hi {name}! Thanks for your interest in {company}…" An IF node checks the lead score against your configurable threshold (default: 70). Hot leads (score ≥ threshold) → enrolled in an AI Qualification Sequence that

by Maxim Dudnik
AChtml
free

Route and triage support tickets with Claude Sonnet and your CRM

Overview This workflow automates customer support ticket processing using AI-powered analysis, classification, and intelligent routing. It processes incoming tickets from email or webhook, translates messages when needed, analyzes sentiment and urgency, and routes tickets to auto-reply or escalation flows. The system also updates CRM platforms and logs observability metrics for monitoring. This enables faster response times, improved customer experience, and scalable support operations. How It Works Input Sources Receives tickets via: IMAP Email Trigger Webhook endpoint Workflow Configuration Defines: CRM/Helpdesk API endpoint Escalation webhook URL Observability logging endpoint Data Cleaning & Normalization Extracts and cleans HTML content Normalizes ticket data: Ticket ID User email Message content Timestamp Source channel Language Detection & Translation Detects the original language Translates message into English if needed Returns confidence score AI Support Intelligence Classifies ticket into: Sentiment (positive/neutral/negative) Urgency (low → critical) Category (billing, bug, technical, etc.) Generates: Short summary Churn risk score (0–1) Recommended action path Decision

by ResilNext
CsheetsWpostgres
free

Check job apply URLs and deactivate dead links in Postgres and Google Sheets

Keep your job listings database clean without manual checks. Every three days, this workflow fetches all active jobs from your Postgres database, runs each application URL through a validation check, identifies dead links via HTTP status codes and soft-404 redirect detection, then marks failed entries as inactive in both Supabase and Google Sheets simultaneously. Who it's for Teams running a job aggregator, career platform, or internal hiring tracker who store job listings in Postgres and want stale or broken apply links removed automatically — without waiting for user reports. How it works A Schedule Trigger fires every 3 days All active jobs are fetched from your Postgres (Supabase) database via a SQL query A Prepare URLs node filters out any rows with missing, malformed, or non-HTTP URLs before they're checked An HTTP Request node sends a HEAD request to each apply_url A Find Dead Jobs code node analyzes each response and flags a job as dead if: Status code is 404 or 410 DNS resolution fails (ENOTFOUND) Connection is refused (ECONNREFUSED) A 301/302/307 redirect points to a different path — indicating the job was removed and the ATS is silently redirecting (soft-404 detection) I

by Panth1823
CsheetsWpostgres
free

Aggregate multi-source job boards into Supabase and Google Sheets

Stop manually checking dozens of career pages. This workflow runs every morning, hits the public APIs of 8+ ATS platforms and job boards, normalizes every listing into a single clean schema, and syncs everything to Supabase and Google Sheets deduplicated and ready to query. Who it's for Job seekers, recruiters, or career platforms that want a consolidated, up-to-date feed of openings from specific companies without scraping, without API keys, and without paying for a jobs aggregator. How it works A Schedule Trigger fires daily at 8 AM IST A Company List code node defines all sources grouped by ATS type (Greenhouse, Lever, Ashby, Workable, SmartRecruiters, RemoteOK, and board APIs like Remotive, Himalayas, Arbeitnow, Jobicy) A Prepare Request node builds the correct API URL and headers for each source, including multi-page pagination for SmartRecruiters (up to 500 jobs via offset) and Himalayas (up to 500 via page param) An HTTP Request node fetches all sources in batches of 5 A Parse + Enrich + Filter node normalizes all divergent JSON structures into a unified schema — resolving ISO country codes, Indian city detection, salary parsing across all formats, and domain-based filtering

by Panth1823
CsheetsW
free

Generate 7 new LinkedIn posts from top Apify posts using OpenAI and save to Google Sheets

This workflow helps you turn your best-performing LinkedIn posts into a repeatable content creation system. It pulls LinkedIn post data from Apify, normalizes and ranks the posts by impressions, identifies the strongest-performing content, and sends the top posts to OpenAI for pattern analysis. Based on those insights, it generates 7 new LinkedIn post ideas, then saves both the insights and generated posts to Google Sheets for easy review and planning. It is ideal for founders, creators, consultants, marketers, and social media teams who want to use real LinkedIn performance data to guide new content creation with a faster and more structured workflow.

by Jonas Frewert
CsheetsW
free

Send personalized LinkedIn connection requests with Google Sheets and Unipile

Send personalized LinkedIn connection requests automatically using n8n, Google Sheets, and Unipile — with built-in safety limits, duplicate prevention, and full invitation tracking. Scale your LinkedIn outreach without manually sending a single connection request. This workflow reads your leads from a Google Sheet, filters out already-contacted prospects, and sends each one a personalized connection note via LinkedIn — automatically, on a schedule, and safely within LinkedIn's limits. Built for founders, sales teams, and recruiters who want consistent LinkedIn outreach without repetitive manual work. Every request is tracked back to your sheet with its invitation ID and status, making follow-up workflows easy to build on top. Good to know Unipile pricing is based on the number of connected accounts, not per API call or per message sent. The base plan starts at €49/$55 per month and includes up to 10 linked accounts For this workflow, connecting one LinkedIn account counts as one account Unipile does not enforce usage limits — you can send as many requests as you need. However, LinkedIn itself applies its own rate limits and usage policies A 7-day free trial is available with all fe

by Salman Mehboob
W
free

Get LinkedIn profile data via TexAU API

This workflow automates the extraction of detailed LinkedIn profile information through the TexAU API. It is designed for lead enrichment, prospect research, hiring workflows, and any automation requiring structured profile data from LinkedIn. How it Works The workflow is triggered manually or through another workflow. A request is sent to TexAU’s LinkedIn Profile Scraper task, providing the target LinkedIn profile URL or ID. TexAU starts a profile-scraping job in the background. The workflow waits briefly to allow processing time. A follow-up request retrieves the completed results from TexAU’s results endpoint. The workflow outputs a structured JSON representation of the profile, typically including name, headline, role, location, experience, skills, and education. Setup Steps Add your TexAU API key to the HTTP Request node. Supply the LinkedIn profile URL dynamically or manually. Adjust the wait time depending on TexAU’s queue speed. Connect your CRM, database, or AI logic to process the profile results. Good to Know Data availability depends on what is publicly visible. Processing time varies based on TexAU queue load.

by Spiritec
BCsheets
free

Enrich and score Japanese B2B leads with gBizINFO, web scraping, and Gemini AI

Enrich and score Japanese company leads with government APIs, web scraping, and Gemini AI What this workflow does This workflow automates B2B lead research for Japanese companies. Submit a company name through a web form, and the workflow queries two free Japanese government APIs for corporate registry and business data, checks Google Maps for reputation, scrapes the company website for contact details and tech stack, and uses Gemini AI to score the lead and write a personalized outreach message in Japanese. Results are saved to Google Sheets, and high-scoring leads trigger a Slack alert. How it works Lead input form — A sales rep submits a company name along with industry, prefecture, priority, and notes National Tax Agency API — Retrieves the official corporate number, registered name, address, and entity type using the free 法人番号 API gBizINFO API — Enriches the lead with employee count, capital, establishment date, representative, subsidies, certifications, patents, and business summary using the free Ministry of Economy API Google Maps Places API — Fetches the company's star rating, review count, and business status for reputation assessment Website scraping — Fetches the compan

by Oka Hironobu
CW
free

Notify customers on WhatsApp when Stripe payment succeeds with MoltFlow

How it works Stripe fires a checkout.session.completed webhook when a payment succeeds Customer name, phone, email, and payment amount are extracted If the customer has a phone number, a WhatsApp receipt is sent via MoltFlow Payments without phone numbers are logged and skipped Set up steps (~5 min) Create a MoltFlow account at molt.waiflow.app and connect your WhatsApp Generate an API key in MoltFlow (Sessions page > API Keys tab) Activate this workflow and copy the webhook URL In Stripe Dashboard > Developers > Webhooks, add the n8n URL for checkout.session.completed Set YOUR_SESSION_ID in the Format Receipt code node Add your MoltFlow API Key as Header Auth credential (header name: X-API-Key) Prerequisites MoltFlow account with active WhatsApp session Stripe account with webhook access Customer phone numbers collected during checkout (Stripe customer_details.phone)

by Alex Pekler
ACDembeddingsopenai
free

Generate M&A due diligence PDF reports with LlamaIndex, OpenAI, Pinecone, and S3

Streamline M&A due diligence with AI. This n8n workflow automatically parses financial documents using LlamaIndex, embeds data into Pinecone, and generates comprehensive, AI-driven reports with GPT-5-mini, saving hours of manual review and ensuring consistent, data-backed insights. Why Use This Workflow? Time Savings: Reduces manual document review and report generation from days to minutes. Cost Reduction: Minimizes reliance on expensive human analysts for initial data extraction and summary. Error Prevention: AI-driven analysis ensures consistent data extraction, reducing human error and oversight. Scalability: Effortlessly processes multiple documents and deals in parallel, scaling with your business needs. Ideal For Investment Analysts & Private Equity Firms:** Quickly evaluate target companies by automating the extraction of key financials, risks, and business models from deal documents. M&A Advisors:** Conduct preliminary due diligence efficiently, generating comprehensive overview reports for clients without extensive manual effort. Financial Professionals:** Accelerate research and analysis of company filings, investor presentations, and market reports for critical decision

by Khairul Muhtadin
CsheetsW
free

Make outbound sales calls from Google Sheets using a VAPI voice agent

This n8n workflow automates outbound phone calls to new leads using VAPI, with built-in timezone detection to ensure you're only calling during business hours. Use cases include appointment setting, lead qualification, follow-up surveys, payment reminders, and sales outreach—anywhere you need to scale phone conversations without scaling headcount. Good to know You'll need a VAPI phone number and configured voice agent before using this workflow. VAPI offers $10 free credit when you sign up (~70 minutes of calls). Create your account here. The timezone logic covers common country codes (UK, US, EU, Australia, India, UAE, Singapore, Japan). You can extend this in the Code node. How it works A new row in Google Sheets triggers the workflow (you can swap this for a webhook, form, or CRM trigger). The phone number is sanitised—stripping spaces, dashes, and brackets so it's in the correct format for dialling. The lead's timezone is determined from their country code, and the workflow checks whether it's between 8am-5pm local time. If not, it waits and retries. VAPI places the outbound call using your configured voice agent. The workflow polls VAPI's API until the call ends, then retrieve

by Marcus Taylor
CW
free

Summarize YouTube videos in Slack using AssemblyAI transcription and OpenAI

🧠 How it works This workflow lets users generate structured summaries from YouTube videos directly inside Slack using n8n, AssemblyAI, and OpenAI. When a user submits a YouTube link via a Slack slash command, the workflow extracts the video ID and validates the video duration. Videos longer than the supported limit are stopped early with a clear message sent back to Slack. For valid videos, the workflow downloads the video audio as an MP3 file and sends it to AssemblyAI for transcription. Once the transcription is complete, the transcript is passed to an AI model to generate a structured summary. The final result includes a concise TL;DR, key takeaways, and notable quotes, which are formatted and posted back to Slack asynchronously using the original response URL. ⚙️ Features • Triggers from a Slack slash command with a YouTube link • Validates video length before processing (maximum 10 minutes) • Downloads YouTube audio as MP3 using RapidAPI • Transcribes audio using AssemblyAI • Generates structured summaries (TL;DR, key takeaways, notable quotes) • Posts the summarized result back to Slack asynchronously 💡 Use cases & expected outcomes • Educational YouTube videos → Receive a

by Marsel Bait
asanagmailgoogledocsgoogledrive
free

Automate client onboarding with Asana, Google Docs, Gmail, Slack and Sheets

📊 Description Automate short-term trading research by generating high-quality trade ideas using MCP (Market Context Protocol) signals and AI-powered analysis. 📈🤖 This workflow evaluates market context, catalysts, momentum, and risk factors to produce structured trade ideas with clear reasoning, confidence scores, and execution notes. Designed for fast-moving markets, it helps traders and analysts spot actionable opportunities consistently—without manual screening or emotional bias. Perfect for systematic traders, research teams, and AI-driven trading desks. ⚡📊 🔁 What This Template Does 1️⃣ Ingests market context and asset data from MCP inputs. 📥 2️⃣ Normalizes symbols, sectors, and time horizons for analysis. 🧾 3️⃣ Evaluates short-term momentum and catalyst strength. 🚀 4️⃣ Analyzes risk, volatility, and downside exposure. ⚠️ 5️⃣ Uses AI to generate a structured trade thesis. 🤖 6️⃣ Assigns a confidence score and risk level to each idea. 📊 7️⃣ Produces clear entry logic, rationale, and trade direction. 🧠 8️⃣ Filters out low-quality or low-conviction setups. 🚫 9️⃣ Outputs clean JSON-ready trade ideas for downstream systems. 🔁 ⭐ Key Benefits ✅ Automates short-term trade id

by Rahul Joshi
ACsheetsW
free

Score HubSpot deal conversion risk with OpenAI and Slack alerts

How it works This workflow runs daily to review all active deals and evaluate their likelihood of closing successfully. It enriches deal data with recent engagement activity and applies AI-based behavioral scoring to predict conversion probability. High-risk or stalled deals are flagged automatically. Actionable alerts are sent to the sales team, and all analysis is logged for forecasting and tracking. Step-by-step Trigger and fetch deals** Schedule Trigger – Runs the workflow automatically at a fixed time each day. Get Active Deals from HubSpot – Retrieves all open, non-closed deals with key properties. Formatting Data – Normalizes deal fields such as value, stage, age, contacts, and activity dates. Enrich deals with engagement data** If – Filters only active deals for further processing. Loop Over Items – Processes each deal individually. HTTP Request – Fetches engagement associations for the current deal. Get an engagement – Retrieves detailed engagement records from HubSpot. Extracts Data – Structures engagement content, timestamps, and metadata for analysis. Analyze risk, alert, and store results** OpenAI Chat Model – Provides the language model used for analysis. AI Agent – E

by Avkash Kakdiya
BWopenaichatmodelstructuredoutputparser
free

Automate Gmail Organization with AI-Powered Email Classification and Smart Labeling

📧 AI-Powered Gmail Auto-Labeling with Smart Classification This n8n workflow automatically organizes your Gmail inbox by intelligently categorizing incoming emails and applying custom labels using AI-powered sentiment analysis. Say goodbye to manual email sorting and hello to an organized inbox! Use Cases Business Email Management**: Automatically sort partnership inquiries, meeting requests, and promotional emails Sales Team Automation**: Identify and label cold outreach and high-priority leads Executive Assistants**: Filter important meetings and urgent matters for busy professionals Marketing Teams**: Separate promotional content from genuine business communications Good to Know The workflow runs every minute to check for new emails Each email is processed only once - already labeled emails are automatically skipped Uses OpenAI's GPT model for accurate email classification (API costs apply) Processes emails in batches to handle multiple incoming messages efficiently How It Works Gmail Trigger continuously monitors your inbox for new emails every minute Switch Node checks if emails already have labels (Other, Promotion, or Meeting) to avoid duplicate processing Loop Node process

by Bhavy Shekhaliya
BCW
free

Summarize YouTube Videos with Gemini AI and Send via Telegram

This automated TLDW (Too Long; Didn't Watch) generator using Decodo's scraping API to extract complete video transcripts and metadata, then uses Google Gemini 3 to create intelligent summaries with key points, chapters breakdown, tools mentioned, and actionable takeaways—eliminating hours of manual note-taking and video watching. Why Use This Workflow? Time Savings: Convert a 2-hour video into a readable 5-minute summary, reducing research time by 95% Comprehensive Coverage: Captures key points, chapters, tools, quotes, and actionable steps that manual notes often miss Instant Accessibility: Receive structured summaries directly in Telegram within 30-60 seconds of sharing a link Multi-Language Support: Process transcripts in multiple languages supported by YouTube's auto-caption system Ideal For Content Creators & Researchers:** Quickly extract insights from competitor videos, educational content, or industry talks without watching hours of footage Students & Educators:** Generate study notes from lecture recordings, online courses, or tutorial videos with chapter-based breakdowns Marketing Teams:** Analyze competitor content strategies, extract tools and techniques mentioned, and

by Khairul Muhtadin
googledriveWsendemail
free

Generate Videos Automatically with Veo3 Fast API, Google Drive & Email Notifications

Automated Video Generation, Google Drive Upload, and Email Notification with Veo 3 Fast API This workflow automates the process of generating videos using the Veo 3 Fast API, uploading the video to Google Drive, and notifying the user via email. All tasks are executed seamlessly, ensuring a smooth user experience with automatic error handling. Node-by-Node Explanation On Form Submission: Triggers the workflow when a user submits a form with a prompt. Veo 3 Fast API Processor: Sends the user's prompt to the Veo 3 Fast API to generate a video. Wait for API Response: Pauses the workflow for 35 seconds to allow the API response. API Request: Check Task Status: Sends a request to check the status of the video generation task. Condition: Task Output Status: Evaluates whether the task was successful, still processing, or failed. Wait for Task to Complete: Pauses the workflow for 30 seconds to recheck the task status if processing is ongoing. Send Email: API Error - Task Failed: Sends an email if the task fails to generate the video. Send Email: API Error - Task ID Missing: Sends an email if the task ID is missing in the response. Download Video: Downloads the processed video from the prov

by Sk developer
AsheetsW
free

Automate YouTube Content Strategy with AI, Apify & Google Sheets

📌 Overview This advanced multi-phase n8n workflow automates the complete research, analysis, and ideation pipeline for a YouTube strategist. It scrapes competitor channels, analyzes top-performing titles and thumbnails, identifies niche trends, gathers audience sentiment from comments, and produces data-driven content ideas—automatically writing them into a structured Google Sheets dashboard. This system is ideal for: YouTube creators Agencies Content strategists Automation engineers Anyone who wants to generate YouTube content ideas backed by real data 🧠 High‑Level Architecture The workflow is split into 5 phases, each building on the previous: Phase 1 — Niche Outliers (Input: User Form) Scrapes 3 high‑quality channels from your niche, extracts their outlier videos, and analyzes why they work. Phase 2 — Broad Niche Insights (Weekly) Scrapes the top trending content in your broad niche (e.g., "AI", "fitness", "personal finance") and logs weekly insights. Phase 3 — Niche Insights (Daily) Scrapes the top videos in your specific micro‑niche daily to keep track of content momentum. Phase 4 — Comment Analysis Analyzes real comments from your channel to understand what your audience li

by PrideVel