Skip to main content
M

Msaid Mohamed el hadi

6
Workflows

Workflows by Msaid Mohamed el hadi

Workflow preview: Scrape and analyze websites with custom prompts using Gemini, Apify, and LangChain
Free intermediate

Scrape and analyze websites with custom prompts using Gemini, Apify, and LangChain

# 🔍 AI-Powered Website Prompt Executor (Apify + OpenRouter) This workflow combines the power of [Apify](https://apify.com) and [OpenRouter](https://openrouter.ai) to **scrape website content** and **execute any custom prompt** using AI. You define what you want — whether it’s extracting contact details, summarizing content, collecting job offers, or anything else — and the system intelligently processes the site to give you results. ## 🚀 Overview This workflow allows you to: 1. Input a URL and define a prompt. 2. Scrape the specified number of pages from the website. 3. Process each page’s metadata and Markdown content. 4. Use AI to interpret and respond to the prompt on each page. 5. Aggregate and return structured output. ## 🧠 How It Works ### Input Example ```json { "enqueue": true, "maxPages": 5, "url": "https://apify.com", "method": "GET", "prompt": "collect all contact informations available on this website" } ```` ### Workflow Steps | Step | Action | | ---- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | | 1 | Triggered by another workflow with JSON input. | | 2 | Calls the Apify actor [`firescraper-ai-website-content-markdown-scraper`](https://apify.com/mohamedgb00714/firescraper-ai-website-content-markdown-scraper) to scrape content. | | 3 | Loops through the scraped pages. | | 4 | AI analyzes each page based on the input prompt. | | 5 | Aggregates AI outputs across all pages. | | 6 | Final AI processing step to return a clean structured result. | --- ## 🛠 Technologies Used * **Apify** – Scrapes structured content and Markdown from websites. * **OpenRouter** – Provides access to advanced AI models like Gemini. * **LangChain** – Handles AI agent orchestration and prompt interpretation. --- ## 🔧 Customization Customize the workflow via the following input fields: * `url`: Starting point for scraping * `maxPages`: Limit the number of pages to crawl * `prompt`: Define any instruction (e.g., “summarize this website,” “extract product data,” “list all emails,” etc.) This allows dynamic, flexible use across various use cases. --- ## 📦 Output The workflow returns a JSON result that includes: * Processed prompt responses from each page * Aggregated AI insights * Structured and machine-readable format --- ## 🧪 Example Use Cases * 🔍 Extracting contact information from websites * 📄 Summarizing articles or company profiles * 🛍️ Collecting product information * 📋 Extracting job listings or news * 📬 Generating outreach lists from public data * 🤖 **Used as a tool within other AI agents for real-time web analysis** * 🧩 **Integrated as an external tool in MCP (Multi-Component Prompt) servers to enhance AI capabilities** --- ## 🔐 API Credentials Required You will need: * **Apify API token** – For running the scraper actor * **OpenRouter API key** – For AI-powered prompt processing Set these credentials in your environment or n8n credential manager before running.

M
Msaid Mohamed el hadi
Document Extraction
1 Aug 2025
1573
0
Workflow preview: AI-powered Google Maps business scraper with enrichment & export to sheets
Free advanced

AI-powered Google Maps business scraper with enrichment & export to sheets

### Overview This workflow automates the discovery, extraction, enrichment, and storage of business information from **Google Maps** search queries using AI tools, scrapers, and Google Sheets. It is ideal for: * Lead generation agencies * Local business researchers * Digital marketing firms * Automation & outreach specialists --- ### 🔧 Tools & APIs Used * **Google Maps Search (via HTTP)** * **Custom JavaScript Parsing** * **URL Filtering & De-duplication** * **Google Sheets (Read/Write)** * **APIFY Actor** for business scraping * **LangChain AI Agent** (OpenRouter - Gemini 2.5) * **n8n Built-in Logic** (Loops, Conditions, Aggregators) --- ### 🧠 Workflow Summary 1. **Trigger** The automation starts via schedule (every hour). 2. **Read Queries from Google Sheet** Loads unprocessed keywords from a Google Sheet tab named `keywords`. 3. **Loop Through Keywords** Each keyword is used to search Google Maps for relevant businesses. 4. **Extract URLs** JavaScript parses HTML to find all external website URLs from the search results. 5. **Clean URLs** Filters out irrelevant domains (e.g., Google-owned, example.com, etc.), and removes duplicates. 6. **Loop Through URLs** For each URL: * Checks if it already exists in the Google Sheet (to prevent duplication). * Calls the **APIFY Actor** to extract full business data. * Optionally uses **AI Agent (Gemini)** to provide detailed insight on the business, including: * Services, About, Market Position, Weaknesses, AI suggestions, etc. * Converts the AI result (text) to a structured JSON object. 7. **Save to Google Sheet** Adds all extracted and AI-enriched business information to a separate tab (`Sheet1`). 8. **Mark Queries as Processed** Updates the original row in `keywords` to avoid reprocessing. --- ### 🗃️ Output Fields Saved The following information is saved per business: * Business Name, Website, Email, Phone * Address, City, Postal Code, Country, Coordinates * Category, Subcategory, Services * About Us, Opening Hours, Social Media Links * Legal Links (Privacy, Terms) * Logo, Languages, Keywords * **AI-Generated Description** * Google Maps URL --- ### 📈 Use Cases * Build a **prospect database** for B2B cold outreach. * Extract **local SEO insights** per business. * Feed CRMs or analytics systems with **enriched business profiles**. * Automate market research for **regional opportunity detection**. --- ### 📩 Want a Similar Workflow? If you’d like a custom AI-powered automation like this for your business or agency, feel free to contact me: **📧 [[email protected]](mailto:[email protected])**

M
Msaid Mohamed el hadi
Lead Generation
25 Jul 2025
2338
0
Workflow preview: Analyze browsing history and generate automation suggestions with OpenRouter AI and Google Sheets
Free intermediate

Analyze browsing history and generate automation suggestions with OpenRouter AI and Google Sheets

# 🧠 Browsing History Automation Analyzer – Automation Toolkit (Google Sheets + AI) This **n8n workflow** analyzes your browsing history to identify opportunities for automation. It reads history from a Google Sheet, groups visits by domain, filters out irrelevant entries, and uses AI to recommend what can be automated — including how and why. --- ## 📌 What It Does - 📄 **Reads** your browsing history from Google Sheets - 🌐 **Groups** history by domain - 🚫 **Filters out** common non-actionable domains (e.g., YouTube, Google) - 🤖 **Uses AI** to analyze whether your activity on each site is automatable - 💡 **Provides suggestions** including what to automate, how to do it, and which tools to use - 📝 **Saves results** into a new tab in the same Google Sheet - 🔍 **Searches for n8n workflow templates** related to the suggested automation --- ## 📊 Demo Sheet Input + output are handled via the following Google Sheet: **📎 Spreadsheet**: [View on Google Sheets](https://docs.google.com/spreadsheets/d/1V26KDJLBZno6e_VxaBqhsK_JOOOn_5N6uww2apcAeoc/edit?usp=drivesdk) - **Sheet: `history`** → Input browsing history - **Sheet: `automations`** → Output AI automation suggestions --- ## 🧠 AI Analysis Logic The AI agent receives each domain's browsing history and responds with: - `domain`: The website domain - `automatable`: true/false - `what_to_automate`: Specific actions that can be automated - `reason`: Why it's suitable (or not) for automation - `tool`: Suggested automation tool (e.g., n8n, Apify) - `automation_rating`: High, Medium, Low, or Not Automatable - `n8n_template`: Relevant automation template (if found) --- ## 🔧 Technologies Used | Tool | Purpose | |--------------------------|-------------------------------------| | **n8n** | Workflow automation | | **LangChain AI Agent** | AI-based analysis | | **Google Sheets Node** | Input/output data handling | | **OpenRouter (LLM)** | Language model for intelligent reasoning | | **JavaScript Code Node** | Grouping and formatting logic | | **Filter Node** | Remove unwanted domains | | **HTTP Request Node** | Search n8n.io templates | --- ## 💻 Chrome History Export You can use this Chrome extension to export your browsing history in a format compatible with the workflow: 🔗 [Export Chrome History Extension](https://chromewebstore.google.com/detail/export-chrome-history/dihloblpkeiddiaojbagoecedbfpifdj?pli=1) --- ## 📧 Want Personalized Automation Advice? If you'd like **personalized automation recommendations** based on your browsing history—just like what this workflow provides—feel free to contact me directly: > 📩 **[email protected]** I'll help you discover what tasks you can automate to save time and boost productivity. --- ## 🚀 Example Use Cases - Automate daily logins to dashboards - Auto-fill forms on repetitive websites - Schedule data exports from web portals - Trigger reminders based on recurring visits - Discover opportunities for scraping and integration --- ## 📜 License This workflow is provided as-is for educational and personal use. For commercial or customized use, contact the author. ---

M
Msaid Mohamed el hadi
Personal Productivity
25 Jul 2025
441
0
Workflow preview: Instagram full profile scraper with Apify and Google Sheets
Free intermediate

Instagram full profile scraper with Apify and Google Sheets

# 📸 Instagram Full Profile Scraper with Apify and Google Sheets This n8n workflow automates the process of scraping full Instagram profiles using a [custom Apify actor](https://apify.com/mohamedgb00714/instagram-full-profile-scraper), and logs the results into a Google Sheet. It is designed to run at scheduled intervals and process a list of usernames by calling the API, appending the results, and marking them as processed. --- ## 🚀 Features * ⏱ **Scheduled Execution** – Runs automatically every few minutes. * 📄 **Google Sheets Integration** – Reads a list of Instagram usernames and updates the same sheet. * 🧠 **Apify Actor** – Fetches full public Instagram profile data. * 🧮 **Aggregation** – Batches usernames for bulk scraping. * ✍️ **Data Logging** – Appends scraped data to a second sheet. * ✅ **Tracking** – Marks usernames as processed once scraped. --- ## 📁 Workflow Structure ```mermaid graph TD; ScheduleTrigger --> GetUsernames; GetUsernames --> LimitItems; LimitItems --> AggregateUsernames; AggregateUsernames --> CallApifyActor; CallApifyActor --> AppendToSheet; CallApifyActor --> MarkAsScraped; ``` --- ## 🛠 Setup 1. **Google Sheet** Create a Google Sheet with: * **Sheet 1** named `Usernames` (GID: 0) Columns: `username`, `scraped` * **Sheet 2** named `fullprofiles` (GID: 458127000) Sample sheet: 🔗 [`Instagram Profile Sheet`](https://docs.google.com/spreadsheets/d/1SQWfZLJscnPoVd7AgtMxo4mltpbZo3WtMzl0AM_lWE4/edit?usp=sharing) 2. **n8n Configuration** * Import this workflow into your n8n instance. * Set up your **Google Sheets credentials** (`googleSheetsOAuth2Api`). * Replace `apify_api_your token` in the HTTP Request node with your [Apify API token](https://console.apify.com/account/integrations). --- ## 📦 Required Credentials * **Google Sheets OAuth2** – For reading and writing sheet data. * **Apify API Token** – To call the custom actor for profile scraping. --- ## 📊 Sheets Used | Sheet Name | Purpose | | -------------- | -------------------------------- | | `Usernames` | Source of usernames to scrape | | `fullprofiles` | Destination of full profile data | --- ## 📌 Apify Actor Info > **Instagram Full Profile Scraper** > This actor fetches extended profile information from public Instagram profiles. 🔗 [View on Apify](https://apify.com/mohamedgb00714/instagram-full-profile-scraper) --- ## 🔁 Workflow Nodes Overview | Node | Purpose | | ------------------------ | ----------------------------------------------------------------- | | Schedule Trigger | Triggers the workflow periodically. | | Get Usernames | Reads usernames from the `Usernames` sheet. | | Limit | Limits processing to 20 usernames per run. | | Aggregate | Groups usernames into a batch for the API call. | | Call Apify Actor | Sends the usernames to the Apify actor and receives profile data. | | Append Full Profiles | Appends the scraped data to the `fullprofiles` sheet. | | Mark Username as Scraped | Marks the processed usernames as `scraped = TRUE`. | | Sticky Note | Provides a reference link to the Apify actor used. | --- ## 📌 Example Sheet Structure ### `Usernames` Sheet | username | scraped | | ------------ | ------- | | exampleuser1 | | | exampleuser2 | TRUE | ### `fullprofiles` Sheet | username | full\_name | biography | follower\_count | ... | | -------- | ---------- | --------- | --------------- | --- | --- ## 🔐 Security & Notes * This workflow **does not** bypass any Instagram privacy restrictions. * It works **only with public Instagram profiles**. * You are responsible for ensuring that scraping complies with **Instagram’s terms of service** and any applicable laws. --- ## 📬 Support For any issues, feel free to reach out: 👤 [@mohamedgb00714](https://github.com/mohamedgb00714) 📧 [[email protected]](mailto:[email protected])

M
Msaid Mohamed el hadi
Market Research
20 Jul 2025
3077
0
Workflow preview: Instagram content & DM automation with Gemini, Telegram, and Apify
Free advanced

Instagram content & DM automation with Gemini, Telegram, and Apify

# 🤖 Instagram Automation Suite: AI Chatbot & Content Powerhouse ## Workflow Overview This cutting-edge n8n workflow is a comprehensive automation solution designed to streamline various Instagram operations. It combines an intelligent AI chatbot for direct message management, automated user following, and an advanced content generation system, all integrated to enhance your Instagram presence and efficiency. This workflow automatically: * **Manages Instagram Direct Messages via Telegram Chatbot**: * Listens for new messages on **Telegram**. * Routes messages from a specific Instagram user (`Wolf23000`) for processing. * Utilizes an **AI agent (powered by OpenRouter's cutting-edge models)** to determine the intent of the message (e.g., chat back, run an Instagram-related action like getting profile info, posting, or following). * Sends AI-generated responses back to the user via **Telegram**. * **Automates Instagram User Following**: * Scheduled to run at regular intervals (hourly). * Processes a list of usernames (likely from a Google Sheet, though not explicitly shown in the provided JSON, it's a common pattern for "Auto Follow users from sheet" sticky note). * Initiates following actions on Instagram for the specified users. * **Generates & Schedules Instagram Posts**: * Scheduled to run monthly. * Leverages an **AI agent (powered by OpenRouter)** to generate **30 or 31 Instagram post ideas** for the current month, based on a predefined "Instagram personality profile." * Each post idea includes an `imagePrompt` (for AI image generation), a `caption` with emojis and hashtags, and a `scheduledDate`. * Refines these post ideas by enhancing the `imagePrompt` to be more vivid and detailed for AI image generation, and polishing the `caption` for optimal engagement. * Updates a Google Sheet ("posts generation plan") with the generated content, including the enhanced image prompts and the resulting image URLs (presumably from a separate image generation step not fully detailed in the provided JSON, but implied by `image_url` updates). ----- ## Key Benefits * **Intelligent DM Management**: Automate responses and actions for Instagram direct messages, ensuring timely and relevant interactions without manual effort. * **Effortless Audience Growth**: Automatically follow target users, expanding your reach and potential engagement on Instagram. * **AI-Powered Content Creation**: Generate a full month's worth of diverse, engaging Instagram post ideas tailored to a specific personality, complete with image prompts and captions. * **Content Optimization**: Automatically enhance image prompts for better AI image generation and refine captions for maximum impact. * **Time-Saving**: Significantly reduce the manual workload associated with Instagram management, from direct messages to content planning and execution. * **Consistent Brand Voice**: Maintain a consistent and engaging presence on Instagram with AI-generated content aligned with your defined personality. ----- ## Setup Requirements To set up and run this workflow, you'll need the following: * **n8n Installation**: * Install n8n (cloud or self-hosted). The latest stable version, as of July 2025, is **v1.101.1**. * Import the workflow configuration. * Configure API credentials for all integrated services. * Set up scheduling preferences for continuous operation. * **System Requirements for Self-Hosting**: A modern multi-core processor (2 cores minimum, 4 recommended), 2 GB RAM (4 GB or more recommended), and 20 GB of free SSD storage. Node.js version 16 or later (18.x LTS recommended) is required. PostgreSQL is the recommended database for production. * **Telegram API Access**: * Create a Telegram bot via BotFather and obtain your API token. * Configure the **Telegram Trigger** node with your bot's API credentials to receive messages. * **Pricing**: Telegram's API is free to use. * **OpenRouter API Access**: * Create an OpenRouter account and generate an API key. * This key (`{{your open router api key }}` as seen in the code) is used to access their chat models (e.g., `google/gemini-2.5-flash-preview`) for AI agent operations. * **Pricing**: OpenRouter offers a variety of models with different pricing structures, including some free models like DeepSeek R1. Most models operate on a pay-per-usage basis, with costs clearly displayed for each model and prompt. * **Instagram Session ID**: * You'll need a valid Instagram session ID (`{{ your instagram session ID }}` as seen in the code) for the workflow to interact with Instagram. This usually involves extracting it from your browser's cookies after logging into Instagram. * **Caution**: Instagram's terms of service generally prohibit automated interactions, and using session IDs for scraping or automation can lead to account suspension. Use with extreme caution and at your own risk. * **Apify token setup**: *You'll need to replace `{{ your apify token }}` with you apify token in https requests * **Google Sheets Credentials**: * A Google Cloud API key with access to Google Sheets. * Set up OAuth2 authentication in n8n for read/write access to your "posts generation plan" spreadsheet (Document ID: `1XHNwAXR4USThaAzX1Y6M5PF2P8WqCBU8mi34FBLkV6M`). This sheet is used to store and manage generated post ideas. * **Pricing**: The Google Sheets API is generally free for most common use cases, with generous per-minute quotas (300 read and 300 write requests per minute per project, 60 per user per project). No additional charges are incurred for exceeding these limits. [https://docs.google.com/spreadsheets/d/1Ze5SC1g6Q5VzMAKYx0zmqlT00Db1HOchUth1jrPyM2Y/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1Ze5SC1g6Q5VzMAKYx0zmqlT00Db1HOchUth1jrPyM2Y/edit?usp=sharing) [https://docs.google.com/spreadsheets/d/1XHNwAXR4USThaAzX1Y6M5PF2P8WqCBU8mi34FBLkV6M/edit?usp=sharing](https://docs.google.com/spreadsheets/d/1XHNwAXR4USThaAzX1Y6M5PF2P8WqCBU8mi34FBLkV6M/edit?usp=sharing) * **Predefined Instagram Personality JSON**: * The workflow relies on a detailed JSON object defining an "Instagram personality" (e.g., `user_id`, `username`, `full_name`, `bio`, `content_preferences`, `personality_traits`, `unfulancer_attributes`). This JSON needs to be correctly set within the **Code** nodes (`Variables`, `Variables1`, `Variables2`) to guide the AI content generation. ----- ## Workflow Architecture ``` [Telegram New Message Trigger] ⬇️ [Variables (Set OpenRouter API Key, Instagram Personality, Session ID)] ⬇️ [Switch (Filter messages from 'Wolf23000' and ensure message text exists)] ⬇️ [Edit Fields (Extract message text)] ⬇️ [AI Agent (Determine action based on message intent)] ⬇️ [Structured Output Parser (Parse AI agent's JSON output)] ⬇️ [Switch1 (Route based on AI agent's determined action: chat_back, run_agent, get_instagram_profile)] ⬇️ ┌─────────────┬─────────────┬─────────────┐ │ │ │ │ ▼ ▼ ▼ ▼ [Send a text message1 (Chat back)] [Send a text message (Run agent confirmation)] [Send a text message2 (Get profile confirmation)] ▲ │ [Schedule Trigger (Hourly for Instagram follow)] ⬇️ [Variables (Set OpenRouter API Key, Instagram Personality, Session ID)] ⬇️ [Code (Prepare usernames for following)] ⬇️ [Code1 (Process followed usernames)] ⬇️ [Schedule Trigger2 (Monthly for Instagram post generation)] ⬇️ [AI Agent1 (Generate monthly Instagram post ideas)] ⬇️ [OpenRouter Chat Model (AI Model for content generation)] ⬇️ [Code2 (Parse AI agent's JSON output)] ⬇️ [Schedule Trigger3 (Daily for post generation refinement and auto-posting)] ⬇️ [AI Agent2 (Enhance image prompts and captions)] ⬇️ [OpenRouter Chat Model2 (AI Model for prompt refinement)] ⬇️ [Update row in sheet1 (Update Google Sheet with enhanced content)] ⬇️ [Get row(s) in sheet2 (Retrieve data from Google Sheet)] ``` ----- ## Connect With Me Exploring AI-Powered Social Media Automation? 📧 **Email**: [email protected] 💼 **LinkedIn**: [Mohamed el Hadi Msaid](https://www.linkedin.com/in/mohamed-el-hadi-m-said-1a9a5095/) **Supercharge your Instagram presence with intelligent automation and AI-driven content\!** 🚀

M
Msaid Mohamed el hadi
Social Media
17 Jul 2025
3411
0
Workflow preview: YouTube lead generation: Turn comments into enriched prospects with Apify and Gemini AI
Free advanced

YouTube lead generation: Turn comments into enriched prospects with Apify and Gemini AI

# Automated YouTube Leads: Turn Comments into Enriched Prospects ## Workflow Overview This cutting-edge n8n workflow is a powerful automation tool designed to revolutionize how businesses and marketers identify and qualify leads directly from YouTube video comments. By leveraging specialized Apify Actors and an intelligent AI agent, this workflow seamlessly transforms raw comment data into comprehensive lead profiles, saving valuable time and resources. This workflow automatically: * **Discovers & Scrapes Comments:** * Monitors a Google Sheet for new YouTube video URLs. * Automatically extracts all comments from specified YouTube videos using a dedicated Apify Actor. * Marks videos as "scrapped" to avoid reprocessing. * **Intelligent Lead Enrichment:** * Retrieves unprocessed comments from Google Sheets. * Activates an advanced AI agent (powered by OpenRouter's cutting-edge models) to research comment authors. * Utilizes Google Search (via Serper API) and specialized Apify scrapers (for website content and Instagram profiles) to find publicly available information like social media links, bios, and potential contact details. * Generates concise descriptions for each lead based on gathered data. * **Organized Data Storage:** * Creates new entries in a dedicated Google Sheet for each new lead. * Updates lead profiles with all discovered enriched data (email, social media, short bio, etc.). * Marks comments as "processed" once their authors have been researched and enriched. ## Key Benefits 🤖 **Full Automation:** Eliminates manual data collection and research, freeing up your team for strategic tasks. 💡 **Smart Lead Enrichment:** AI intelligently sifts through information to build rich, actionable lead profiles. ⏱️ **Time-Saving:** Instant, scalable lead generation without human intervention. 📈 **Enhanced Lead Quality:** Go beyond basic contact info with comprehensive social and professional context. 📊 **Centralized Data:** All leads are neatly organized in Google Sheets for easy access and integration. ## Setup Requirements * **n8n Installation:** * Install n8n (cloud or self-hosted). * Import the workflow configuration. * Configure API credentials. * Set up scheduling preferences for continuous operation. * **Google Sheets Credentials:** * A Google Cloud API key with access to Google Sheets. * Set up OAuth2 authentication in n8n for read/write access to your "youtube leads" spreadsheet (containing "videos", "comments", and "leads" sheets). * **OpenRouter API Access:** * Create an OpenRouter account. * Generate an API key to access their chat models (e.g., `google/gemini-2.5-flash-preview-05-20`) for AI agent operations. * **Apify API Access:** * Create an Apify account. * Generate a personal API token. * This token is used to run the following Apify Actors: * [mohamedgb00714/youtube-video-comments](https://apify.com/mohamedgb00714/youtube-video-comments) (for comment extraction) * [mohamedgb00714/fireScraper-AI-Website-Content-Markdown-Scraper](https://apify.com/mohamedgb00714/firescraper-ai-website-content-markdown-scraper) (for website content extraction) * [mohamedgb00714/instagram-full-profile-scraper](https://apify.com/mohamedgb00714/instagram-full-profile-scraper) (for Instagram profile details) * **Serper API Key:** * Sign up for an account on Serper.dev. * Obtain an API key for performing Google searches to find social media profiles and other information. ## Potential Use Cases * **Content Creators:** Identify highly engaged audience members for community building or direct outreach. * **Marketing Teams:** Discover potential customers or influencers interacting with competitor content. * **Sales Professionals:** Build targeted lead lists based on specific interests expressed in comments. * **Market Researchers:** Analyze audience demographics and interests by enriching profiles of commenters on relevant videos. * **Recruiters:** Find potential candidates based on their expertise or engagement in industry-specific discussions. ## Future Enhancement Roadmap * **CRM Integration:** Directly push enriched leads into popular CRM systems (e.g., HubSpot, Salesforce). * **Automated Outreach:** Implement automated email or social media messaging for qualified leads. * **Sentiment Analysis:** Analyze comment sentiment before enrichment to prioritize positive interactions. * **Multi-Platform Support:** Expand comment extraction and lead enrichment to other platforms (e.g., TikTok, Facebook). * **Advanced Lead Scoring:** Develop a scoring model based on engagement, profile completeness, and relevance. ## Ethical Considerations * **Data Privacy:** Ensure all collected data is publicly available and used in compliance with relevant privacy regulations (e.g., GDPR, CCPA). * **Platform Guidelines:** Adhere strictly to YouTube's Terms of Service and Apify's usage policies. * **Transparency:** If engaging with leads, be transparent about how their information was obtained (if applicable). * **No Spam:** This tool is designed for lead identification, not for unsolicited mass messaging. ## Technical Requirements * n8n v1.0.0 or higher (recommended for latest features and stability) * Google Sheets API access * OpenRouter API access * Apify API access * Serper API access * Stable internet connection ## Workflow Architecture ``` [YouTube Video URLs (Google Sheet)] ⬇️ [Schedule/Manual Trigger] ⬇️ [Extract Comments (Apify YouTube Scraper)] ⬇️ [Save Raw Comments (Google Sheet)] ⬇️ [AI Agent (OpenRouter) for Lead Research] ⬇️ [Google Search (Serper) & Web Scraping (Apify FireScraper/Instagram Scraper)] ⬇️ [Save Enriched Leads (Google Sheet)] ⬇️ [Mark Comments Processed (Google Sheet)] ``` ## Connect With Me Exploring AI-Powered Lead Generation? 📧 **Email:** [email protected] 💼 **LinkedIn:** [Mohamed el Hadi Msaid](https://www.linkedin.com/in/mohamed-el-hadi-m-said-1a9a5095/) **Transform your YouTube engagement into a powerful lead generation engine with intelligent, automated insights\!**

M
Msaid Mohamed el hadi
Lead Generation
8 Jul 2025
1280
0