Website content scraper & SEO keyword extractor with GPT-5-mini and Airtable
This workflow allows you to scrape website content, clean the HTML, extract structured information using GPT-5-mini, and store the results along with SEO keywords into Airtable. Ideal for building keyword lists and organizing web content for SEO research. --- Setup Instructions Prerequisites n8n Community or Cloud instance Airtable account with a base and table ready OpenAI API Key with access to GPT-5-mini --- Airtable Structure Ensure your Airtable table has the following fields: | Field Name | Type | Notes | | ------------ | ------- | ------------------------------- | | Website Name | String | Name or URL of the website | | Data | String | Cleaned website text | | Keyword | String | Extracted SEO keyword list | | Status | Options | Values: Todo, In progress, Done | --- Node Setup ✅ Form Trigger: Collects website URL from the user. ✅ HTTP Request: Fetches the website content. ✅ HTML Cleaner (Code Node): Strips out styles, tags, and whitespace to get clean text. ✅ Topic Extractor (AI Agent + GPT-5-mini): Extracts topic-wise information from the cleaned website content. ✅ Text Cleaner (Code Node): Removes unwanted symbols like and . ✅ Keyword Extractor (AI Agent + GPT-5-mini): Generates a list of 90 important SEO keywords. ✅ Airtable Upsert: Stores the cleaned data, keywords, and status in Airtable. --- Key Features ✅ Automatic website content scraping ✅ Clean HTML and extract plain text ✅ Use GPT-5-mini for topic-wise information extraction ✅ Generate 90-keyword SEO lists ✅ Store and manage data in Airtable --- Use Cases SEO Keyword Research Competitor Website Content Analysis Structured Website Data Collection --- Additional Workflow Recommendations ✅ Rename Nodes for Clarity | Current Name | Suggested Name | | ------------ | ------------------------------- | | Website Name | Website URL Input Form | | HTTP Request | Fetch Website Content | | Code | HTML to Plain Text Cleaner | | Split Out1 | Clean Text Splitter | | AI Agent1 | Topic Extractor (GPT-5-mini) | | Code1 | Text Cleanup Formatter | | Split Out2 | Final Text Splitter | | AI Agent | Keyword Extractor (GPT-5-mini) | | Airtable | Airtable Data Upsert | | Wait1 | Delay Before Merge | | Merge | Combine Data for Airtable | ---
By Abhishek PatoliyaYouTube video to AI-powered auto blogging and affiliate automation
🚀 YouTube to WordPress AI-Powered Automation Transform your YouTube content into professional blog posts automatically! This n8n template seamlessly converts your YouTube videos into fully-formatted, SEO-optimized WordPress blog posts using AI-powered content generation—all without lifting a finger. --- 🎯 What This Automation Does 📺 Monitors your YouTube channel for new video uploads 🔍 Extracts key video information (title, description, URL, thumbnail) 🤖 Leverages AI to generate comprehensive blog content based on video material ✏️ Creates SEO-optimized titles, excerpts, and tags 🖼️ Formats posts beautifully with embedded videos and proper HTML structure 📝 Publishes directly to WordPress via secure API connection ⏱️ Runs on your schedule — daily, weekly, or after each new upload --- 🧑🏫 Step-by-Step Video Tutorial 🎥 Watch the implementation tutorial: [](https://youtu.be/IkFgllPNkCo) 📌 See the complete workflow setup and content transformation in action. --- 🌐 Useful Links 🔗 Get started with n8n Cloud: 👉 https://n8n.io/cloud/ 📘 YouTube Data API documentation: 👉 https://developers.google.com/youtube/v3 📚 WordPress REST API handbook: 👉 https://developer.wordpress.org/rest-api/ 🧠 OpenAI API documentation: 👉 https://platform.openai.com/docs/api-reference --- 🛠 Prerequisites ✅ n8n installation (self-hosted or cloud) ✅ YouTube Data API key ✅ AI provider API key (OpenAI, Google Gemini, etc.) ✅ WordPress website with REST API enabled ✅ WordPress application password for secure authentication --- 📋 Step-by-Step Implementation 1️⃣ YouTube Video Detection Youtube RSS Feedlink to fetch new video automatically Implement filtering to process only videos not yet published to WordPress 2️⃣ Content Preparation Extract essential video metadata (ID, title, description, thumbnail URL) Structure the information for AI processing and WordPress publication Format video thumbnails for use as featured images in blog posts 3️⃣ AI Content Generation Configure your preferred AI provider (OpenAI, Gemini, etc.) Create detailed prompts that instruct the AI to: Maintain your brand voice and writing style Structure content with proper headings and subheadings Creates Internal Links from existing blogposts Creators Extenal links using affilaite links and other link database. Engaging SEO frendly. Automatically monetizes by embedding social PartnerStack Links Include key points from the video Generate SEO-friendly paragraphs and conclusions 4️⃣ Content Enhancement Format the AI-generated content with proper HTML structure Add responsive embedded YouTube player Include attribution links back to original video Create custom intro and conclusion sections 5️⃣ WordPress Publishing Securely connect to WordPress via REST API Set post parameters (title, content, excerpt, categories, tags) Configure post status (publish immediately or save as draft) Add featured image using video thumbnail 6️⃣ Notification & Logging Receive email or Slack notifications when new posts are published Log workflow executions for troubleshooting Track successful publications for reporting --- 💰 Automatic Affiliate Marketing Integration Transform your blog posts into passive income generators by automatically embedding relevant affiliate links based on your video content: PartnerStack Integration Dynamically fetch relevant affiliate links from your PartnerStack account Intelligently match products to video content using AI-powered relevance scoring Automatically insert formatted affiliate links with proper disclosure notices Track performance metrics for each generated post's affiliate conversions Example setup: Connect PartnerStack API → Filter relevant products → Insert links in strategic post positions Custom Affiliate Database via Airtable Create a centralized product-keyword Airtable database: Product name and description Affiliate link with your unique ID Category and keyword triggers Commission rates and expiration dates Auto-scan blog content to identify keyword matches Insert highest-converting links based on historical performance Rotate affiliate links to test different products and placements Advanced Monetization Features Amazon Associates product matching based on video content Time-sensitive promo codes inserted for limited-time offers Geo-targeted affiliate links based on visitor location A/B testing system to optimize link placement and conversion Automated disclosure statements to maintain FTC compliance Implementation Steps Connect to your PartnerStack account via API Create an Airtable base with your affiliate product database Configure the AI to identify product-mention opportunities Add a post-processing node to insert relevant affiliate links Implement tracking parameters to measure performance This integration not only saves time manually adding affiliate links, but also increases conversion rates through intelligent product matching and optimal placement within your automatically generated blog content. > 💡 Pro Tip: Create separate tracking IDs for your automated YouTube-to-WordPress posts to measure this specific channel's performance in your affiliate dashboards. 💡 Advanced Customizations Content Templates Create specialized formatting based on video categories: Tutorial videos: Step-by-step instructions with timestamps Review videos: Pros/cons sections with ratings Interview videos: Question-answer format with speaker attribution Category & Tag Management Automatically organize your WordPress content: Assign categories based on video topics or playlists Generate tags from video keywords and descriptions Create custom taxonomies for video series Multi-Platform Distribution Extend your content reach by adding: Social media announcement posts Email newsletter inclusion Content syndication to Medium or LinkedIn --- ⚠️ Troubleshooting | Issue | Solution | |-------|----------| | AI generation timeout | Increase timeout settings or use chunked processing | | WordPress API errors | Verify application password and user permissions | | Missing video embedding | Check oEmbed settings in WordPress | | Duplicate posts | Implement content fingerprinting for detection | | Poor content quality | Refine AI prompts with better instructions | --- 🙌 Why Use This Template Content creators typically spend 2-4 hours converting each video into a quality blog post. This automation: ⏱️ Saves 10+ hours weekly for active YouTube creators 🔍 Boosts SEO performance with multi-platform content 🌐 Expands audience reach to text-preferring visitors 💰 Increases monetization opportunities across platforms 🧠 Frees creative energy for producing better videos Don't choose between video and written content—have both automatically! --- 🚀 Get Started Now Import the template → Connect your accounts → Watch your blog grow alongside your channel. 👉 AMJID ALI'S PROFILE 👉 website 👉 Explore more on youtube --- Knowledge Base: youtube-api, wordpress-automation, content-repurposing, ai-blog-generation, n8n-workflow, creator-tools, video-to-text, multi-platform-publishing
By Amjid AliBuild comprehensive literature reviews with GPT-4 and multi-database search
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Comprehensive Literature Review Automation Automate your literature review process by searching across multiple academic databases, parsing papers, and organizing findings into a structured review document. Features: Search multiple academic databases simultaneously (PubMed, ArXiv, Google Scholar, etc.) Parse and analyze top papers automatically Generate citation-ready summaries Export to various formats (Markdown, Word, PDF) Workflow Steps: Input: Research topic and parameters PDF Vector Search: Query multiple academic databases Filter & Rank: Select top relevant papers Parse Papers: Extract content from PDFs Synthesize: Create literature review sections Export: Generate final document Use Cases: PhD students conducting systematic reviews Researchers exploring new fields Grant writers needing background sections
By PDF VectorManage Odoo CRM with natural language using OpenAI and MCP Server
Odoo CRM MCP Server Workflow 📖 Overview This workflow connects an AI Agent with Odoo CRM using the Model Context Protocol (MCP). It allows users to manage CRM data in Odoo through natural language chat commands. The assistant interprets the user’s request, selects the appropriate Odoo action, and executes it seamlessly. 🔹 Key Features Contacts Management: Create, update, delete, and retrieve contacts. Opportunities Management: Create, update, delete, and retrieve opportunities. Notes Management: Create, update, delete, and retrieve notes. Conversational AI Agent: Understands natural language and maps requests to Odoo actions. Model Used: OpenAI Chat Model. This makes it easy for end-users to interact with Odoo CRM without needing technical commands—just plain language instructions. --- ▶️ Demo Video Watch the full demo here: 👉 YouTube Demo Video --- ⚙️ Setup Guide Follow these steps to set up and run the workflow: Prerequisites An Odoo instance configured with CRM enabled. An n8n or automation platform account where MCP workflows are supported. An OpenAI API key with access to GPT models. MCP Server installed and running. Import the Workflow Download the provided workflow JSON file. In your automation platform (n8n, Langflow, or other MCP-enabled tool), choose Import Workflow. Select the JSON file and confirm. Configure MCP Server Go to your MCP Server Trigger node in the workflow. Configure it to connect with your Odoo instance. Set API endpoint. Provide authentication credentials (API key). Test the connection to ensure the MCP server can reach Odoo. Configure the OpenAI Model Select the OpenAI Chat Model node in the workflow. Enter your OpenAI API Key. Choose the model (e.g., gpt-5 or gpt-5-mini). AI Agent Setup The AI Agent node links the Chat Model, Memory, and MCP Client. Ensure the MCP Client is mapped to the correct Odoo tools (Contacts, Opportunities, Notes). The System Prompt defines assistant behavior—use the tailored system prompt provided earlier. Activate and Test Turn the workflow ON (toggle Active). Open chat and type: "Create a contact named John Doe with email john@example.com." "Show me all opportunities." "Add a note to John Doe saying 'Follow-up scheduled for Friday'." Verify the results in your Odoo CRM. --- ✅ Next Steps Extend functionality with Tasks, Stages, Companies, and Communication Logs for a complete CRM experience. Add confirmation prompts for destructive actions (delete contact/opportunity/note). Customize the AI Agent’s system prompt for your organization’s workflows. ---
By Rohit DabraExecute Set node based on Function output
Companion workflow for IF node docs
By amudhanHealthcare policy monitoring with ScrapeGraphAI, Pipedrive and email alerts
Medical Research Tracker with Email and Pipedrive ⚠️ COMMUNITY TEMPLATE DISCLAIMER: This is a community-contributed template that uses ScrapeGraphAI (a community node). Please ensure you have the ScrapeGraphAI community node installed in your n8n instance before using this template. This workflow automatically scans authoritative healthcare policy websites for new research, bills, or regulatory changes, stores relevant findings in Pipedrive, and immediately notifies key stakeholders via email. It is ideal for healthcare administrators and policy analysts who need to stay ahead of emerging legislation or guidance that could impact clinical operations, compliance, and strategy. Pre-conditions/Requirements Prerequisites n8n instance (self-hosted or n8n cloud) ScrapeGraphAI community node installed Pipedrive account and API token SMTP credentials (or native n8n Email credentials) for sending alerts List of target URLs or RSS feeds from government or healthcare policy organizations Basic familiarity with n8n credential setup Required Credentials | Service | Credential Name | Purpose | |--------------------|-----------------|-----------------------------------| | ScrapeGraphAI | API Key | Perform web scraping | | Pipedrive | API Token | Create / update deals & notes | | Email (SMTP/Nodemailer) | SMTP creds | Send alert emails | Environment Variables (optional) | Variable | Example Value | Description | |-------------------------|------------------------------|-----------------------------------------------| | N8NDEFAULTEMAIL_FROM | policy-bot@yourorg.com | Default sender for Email Send node | | POLICY_KEYWORDS | telehealth, Medicare, HIPAA | Comma-separated keywords for filtering | How it works This workflow automatically scans authoritative healthcare policy websites for new research, bills, or regulatory changes, stores relevant findings in Pipedrive, and immediately notifies key stakeholders via email. It is ideal for healthcare administrators and policy analysts who need to stay ahead of emerging legislation or guidance that could impact clinical operations, compliance, and strategy. Key Steps: Manual Trigger: Kick-starts the workflow or schedules it via cron. Set → URL List: Defines the list of healthcare policy pages or RSS feeds to scrape. Split In Batches: Iterates through each URL so scraping happens sequentially. ScrapeGraphAI: Extracts headlines, publication dates, and links. Code (Filter & Normalize): Removes duplicates, standardizes JSON structure, and applies keyword filters. HTTP Request: Optionally enriches data with summary content using external APIs (e.g., OpenAI, SummarizeBot). If Node: Checks if the policy item is new (not already logged in Pipedrive). Pipedrive: Creates a new deal or note for tracking and collaboration. Email Send: Sends an alert to compliance or leadership teams with the policy summary. Sticky Note: Provides inline documentation inside the workflow. Set up steps Setup Time: 15–20 minutes Install ScrapeGraphAI: In n8n, go to “Settings → Community Nodes” and install n8n-nodes-scrapegraphai. Create Credentials: a. Pipedrive → “API Token” from your Pipedrive settings → add in n8n. b. ScrapeGraphAI → obtain API key → add as credential. c. Email SMTP → configure sender details in n8n. Import Workflow: Copy the JSON template into n8n (“Import from clipboard”). Update URL List: Open the initial Set node and replace placeholder URLs with the sites you monitor (e.g., cms.gov, nih.gov, who.int, state health departments). Define Keywords (optional): a. Open the Code node “Filter & Normalize”. b. Adjust the const keywords = [...] array to match topics you care about. Test Run: Trigger manually; verify that: Scraped items appear in the execution logs. New deals/notes show up in Pipedrive. Alert email lands in your inbox. Schedule: Add a Cron node (e.g., every 6 hours) in place of Manual Trigger for automated execution. Node Descriptions Core Workflow Nodes: Manual Trigger – Launches the workflow on demand. Set – URL List – Holds an array of target policy URLs/RSS feeds. Split In Batches – Processes each URL one at a time to avoid rate limiting. ScrapeGraphAI – Scrapes page content and parses structured data. Code – Filter & Normalize – Cleans results, removes duplicates, applies keyword filter. HTTP Request – Summarize – Calls a summarization API (optional). If – Duplicate Check – Queries Pipedrive to see if the policy item already exists. Pipedrive (Deal/Note) – Logs a new deal or adds a note with policy details. Email Send – Alert – Notifies subscribed stakeholders. Sticky Note – Embedded instructions inside the canvas. Data Flow: Manual Trigger → Set (URLs) → Split In Batches → ScrapeGraphAI → Code (Filter) → If (Duplicate?) → Pipedrive → Email Send Customization Examples Add Slack notifications javascript // Insert after Email Send { "node": "Slack", "parameters": { "channel": "policy-alerts", "text": New policy update: ${$json["title"]} - ${$json["url"]} } } Use different CRM (HubSpot) javascript // Replace Pipedrive node config { "resource": "deal", "operation": "create", "title": $json["title"], "properties": { "dealstage": "appointmentscheduled", "description": $json["summary"] } } Data Output Format The workflow outputs structured JSON data: json { "title": "Telehealth Expansion Act of 2024", "date": "2024-05-30", "url": "https://www.congress.gov/bill/118th-congress-house-bill/1234", "summary": "This bill proposes expanding Medicare reimbursement for telehealth services...", "source": "congress.gov", "status": "new" } Troubleshooting Common Issues Empty Scrape Results – Check if the target site uses JavaScript rendering; ScrapeGraphAI may need a headless browser option enabled. Duplicate Deals in Pipedrive – Ensure the “If Duplicate?” node compares a unique field (e.g., URL or title) before creating a new deal. Performance Tips Limit batch size to avoid API rate limits. Cache or store the last scraped timestamp to skip unchanged pages. Pro Tips: Combine this workflow with an n8n “Cron” or “Webhook” trigger for fully automated monitoring. Use environment variables for keywords and email recipients to avoid editing nodes each time. Leverage Pipedrive’s automations to notify additional teams (e.g., legal) when high-priority items are logged.
By vinci-king-01