Weekly Shodan query - report accidents
This n8n workflow, which runs every Monday at 5:00 AM, initiates a comprehensive process to monitor and analyze network security by scrutinizing IP addresses and their associated ports. It begins by fetching a list of watched IP addresses and expected ports through an HTTP request. Each IP address is then processed in a sequential loop. For every IP, the workflow sends a GET request to Shodan, a renowned search engine for internet-connected devices, to gather detailed information about the IP. It then extracts the data field from Shodan's response, converting it into an array. This array contains information on all ports Shodan has data for regarding the IP. A filter node compares the ports returned from Shodan with the expected list obtained initially. If a port doesn't match the expected list, it is retained for further processing; otherwise, it's filtered out. For each such unexpected port, the workflow assembles data including the IP, hostnames from Shodan, the unexpected port number, service description, and detailed data from Shodan like HTTP status code, date, time, and headers. This collected data is then formatted into an HTML table, which is subsequently converted into Markdown format. Finally, the workflow generates an alert in TheHive, a popular security incident response platform. This alert contains details like the title indicating unexpected ports for the specific IP, a description comprising the Markdown table with Shodan data, medium severity, current date and time, tags, Traffic Light Protocol (TLP) set to Amber, a new status, type as 'Unexpected open port', the source as n8n, a unique source reference combining the IP with the current Unix time, and enabling follow and JSON parameters options. This comprehensive workflow thus aids in the proactive monitoring and management of network security.
By n8n TeamEnrich company data from Google Sheet with OpenAI Agent and ScrapingBee
This workflow demonstrates how to enrich data from a list of companies in a spreadsheet. While this workflow is production-ready if all steps are followed, adding error handling would enhance its robustness. Important notes Check legal regulations: This workflow involves scraping, so make sure to check the legal regulations around scraping in your country before getting started. Better safe than sorry! Mind those tokens: OpenAI tokens can add up fast, so keep an eye on usage unless you want a surprising bill that could knock your socks off! 💸 Main Workflow Node 1 - Webhook This node triggers the workflow via a webhook call. You can replace it with any other trigger of your choice, such as form submission, a new row added in Google Sheets, or a manual trigger. Node 2 - Get Rows from Google Sheet This node retrieves the list of companies from your spreadsheet. here is the Google Sheet Template you can use. The columns in this Google Sheet are: Company: The name of the company Website: The website URL of the company These two fields are required at this step. Business Area: The business area deduced by OpenAI from the scraped data Offer: The offer deduced by OpenAI from the scraped data Value Proposition: The value proposition deduced by OpenAI from the scraped data Business Model: The business model deduced by OpenAI from the scraped data ICP: The Ideal Customer Profile deduced by OpenAI from the scraped data Additional Information: Information related to the scraped data, including: Information Sufficiency: Description: Indicates if the information was sufficient to provide a full analysis. Options: "Sufficient" or "Insufficient" Insufficient Details: Description: If labeled "Insufficient," specifies what information was missing or needed to complete the analysis. Mismatched Content: Description: Indicates whether the page content aligns with that of a typical company page. Suggested Actions: Description: Provides recommendations if the page content is insufficient or mismatched, such as verifying the URL or searching for alternative sources. Node 3 - Loop Over Items This node ensures that, in subsequent steps, the website in "extra workflow input" corresponds to the row being processed. You can delete this node, but you'll need to ensure that the "query" sent to the scraping workflow corresponds to the website of the specific company being scraped (rather than just the first row). Node 4 - AI Agent This AI agent is configured with a prompt to extract data from the content it receives. The node has three sub-nodes: OpenAI Chat Model: The model used is currently gpt4-o-mini. Call n8n Workflow: This sub-node calls the workflow to use ScrapingBee and retrieves the scraped data. Structured Output Parser: This parser structures the output for clarity and ease of use, and then adds rows to the Google Sheet. Node 5 - Update Company Row in Google Sheet This node updates the specific company's row in Google Sheets with the enriched data. Scraper Agent Workflow Node 1 - Tool Called from Agent This is the trigger for when the AI Agent calls the Scraper. A query is sent with: Company name Website (the URL of the website) Node 2 - Set Company URL This node renames a field, which may seem trivial but is useful for performing transformations on data received from the AI Agent. Node 3 - ScrapingBee: Scrape Company's Website This node scrapes data from the URL provided using ScrapingBee. You can use any scraper of your choice, but ScrapingBee is recommended, as it allows you to configure scraper behavior directly. Once configured, copy the provided "curl" command and import it into n8n. Node 4 - HTML to Markdown This node converts the scraped HTML data to Markdown, which is then sent to OpenAI. The Markdown format generally uses fewer tokens than HTML. Improving the Workflow It's always a pleasure to share workflows, but creators sometimes want to keep some magic to themselves ✨. Here are some ways you can enhance this workflow: Handle potential errors Configure the scraper tool to scrape other pages on the website. Although this will cost more tokens, it can be useful (e.g., scraping "Pricing" or "About Us" pages in addition to the homepage). Instead of Google Sheets, connect directly to your CRM to enrich company data. Trigger the workflow from form submissions on your website and send the scraped data about the lead to a Slack or Teams channel.
By DatakiAI-powered personal finances manager with Gemini, Telegram & Google Sheets
Who’s it for This template is designed for individuals who want to gain full control over their personal finances without the hassle of manual tracking. Ideal for freelancers, small business owners, or anyone who wants a simple, automated way to monitor income and expenses. How it works / What it does Using n8n, Telegram, and Google Sheets, this workflow allows you to log, edit, and query your financial transactions through simple Telegram messages. The AI interprets your input—whether text or audio—and automatically categorizes your income and expenses. Responses are delivered fully formatted in Telegram HTML, giving you clean, readable summaries and insights. Features include: Add, edit, and delete transactions automatically Query totals and category-specific expenses, e.g., “How much did I spend on food this month?” Generate financial summaries and monthly reports Automatic ID assignment and date handling How to set up Deploy this workflow on your self-hosted n8n instance. Connect your Telegram Bot and Google Sheets account. Configure the Google Gemini AI node for message interpretation. Update sheet headers and categories if needed. Start sending messages to your Telegram bot to track expenses instantly. How to Set Up the Google Sheet To use this workflow, you’ll need a Google Sheet with the following structure: | Column Name | Description | | ------------------- | ----------------------------------------------- | | id | Unique sequential identifier (auto-incremented) | | type | "income" or "expense" | | value | Monetary value (format: 1234.56) | | category | Classification of the transaction | | payment\_method | Payment method used (e.g., card, cash, PIX) | | description | Details about the transaction | | date | Transaction date (format: yyyy-MM-dd) | Make sure the column headers match exactly as shown above, and leave the rows empty for the bot to fill automatically. Requirements n8n (self-hosted or cloud instance) Telegram Bot API Google Sheets Google Gemini AI or equivalent AI node
By Vitorio MagalhãesGenerate AI images from text with Fire Flux model on Replicate API
This workflow provides automated access to the Fire Flux AI model through the Replicate API. It saves you time by eliminating the need to manually interact with AI models and provides a seamless integration for image generation tasks within your n8n automation workflows. Overview This workflow automatically handles the complete image generation process using the Fire Flux model. It manages API authentication, parameter configuration, request processing, and result retrieval with built-in error handling and retry logic for reliable automation. Model Description: The image generation model tailored for local development and personal use Key Capabilities High-quality image generation from text prompts Advanced AI-powered visual content creation Customizable image parameters and styles Tools Used n8n: The automation platform that orchestrates the workflow Replicate API: Access to the Fire/flux AI model Fire Flux: The core AI model for image generation Built-in Error Handling: Automatic retry logic and comprehensive error management How to Install Import the Workflow: Download the .json file and import it into your n8n instance Configure Replicate API: Add your Replicate API token to the 'Set API Token' node Customize Parameters: Adjust the model parameters in the 'Set Image Parameters' node Test the Workflow: Run the workflow with your desired inputs Integrate: Connect this workflow to your existing automation pipelines Use Cases Content Creation: Generate unique images for blogs, social media, and marketing materials Design Prototyping: Create visual concepts and mockups for design projects Art & Creativity: Produce artistic images for personal or commercial use Marketing Materials: Generate eye-catching visuals for campaigns and advertisements Connect with Me Website: https://www.nofluff.online YouTube: https://www.youtube.com/@YaronBeen/videos LinkedIn: https://www.linkedin.com/in/yaronbeen/ Get Replicate API: https://replicate.com (Sign up to access powerful AI models) n8n automation ai replicate aiautomation workflow nocode imagegeneration aiart texttoimage visualcontent aiimages generativeart flux machinelearning artificialintelligence aitools automation digitalart contentcreation productivity innovation
By Yaron BeenGet all the stories and publish them in Storyblok
No description available.
By Harshil AgrawalSend a message on Mattermost when a lead replies to your Lemlist email
This workflow allows you to send a message on Mattermost when a lead replies to your email. Lemlist Trigger: The Lemlist Trigger node will trigger the workflow when a lead sends a reply to a campaign. Mattermost node: This node will send a message to the Leads channel in Mattermost with the information about the reply. Based on your use-case, you may want to send the message to a different channel. You may even want to use a different service. Replace the node with the service where you want to send a message.
By Harshil AgrawalConversational sales agent for WooCommerce with GPT-4, Stripe and CRM integration
📄 What this workflow does This workflow transforms your n8n instance into a fully automated AI sales assistant for WooCommerce stores. It detects customer intent from chat, searches products, answers FAQs, generates Stripe payment links, captures leads into your CRM, and even escalates to human support when needed. It provides smooth conversational memory and syncs with your knowledge base to ensure accurate, human-like responses. 👤 Who is this for WooCommerce store owners who want to automate customer support and sales. Sales and marketing teams looking to scale personalized product recommendations. E-commerce managers who want to reduce manual chat handling. Anyone aiming to integrate AI assistants with payments, CRM, and FAQs. ✅ Requirements WooCommerce account with API access. Qdrant vector store (for FAQ and RAG retrieval). OpenAI/Gemini API credentials (for intent detection + message generation). Google Drive account (to sync and update knowledge base docs). Stripe account (to generate instant payment links). CRM account (HubSpot, Pipedrive, etc.) if lead capture is required. Telegram account for optional human escalation. ⚙️ How to set up Connect WooCommerce API credentials in n8n. Configure Gemini/OpenAI API for intent extraction and chat generation. Set up Qdrant for document retrieval, and link to your Google Drive Sales Docs folder. Configure Stripe API to enable instant payment link generation. Connect your CRM to capture new leads automatically. Add Telegram bot credentials for human escalation (optional). Enable conversational memory and test chat flows end-to-end. 🔁 How it works Intent Extraction → AI analyzes chat messages to detect Product Search, FAQ, Payment, or Lead Capture. Product Search → Queries WooCommerce catalog by keyword, SKU, or price range. FAQ Answering → Retrieves company policies/docs from Qdrant + Google Drive, answered via RAG. Payment Links → Stripe generates instant checkout links for customers ready to buy. Lead Capture → Name + email are auto-stored into CRM. Human Escalation → If intent is unclear, conversation is forwarded to Telegram. Conversational Memory → Maintains last 12 exchanges for natural dialogue. Knowledge Sync → Google Drive docs auto-update into Qdrant for live FAQ support. 💡 About Margin AI Margin AI is an AI-services agency that acts as your AI Service Companion. We design intelligent, human-centric automation solutions—turning your team’s best practices into scalable workflows and tools. Industries like marketing, sales, and operations benefit from our tailored AI consulting, automation tools, and chatbot development.
By Cong NguyenPersonalized LinkedIn outreach with GPT-4O, PhantomBuster & Google Sheets
Overview This sophisticated n8n workflow transforms raw LinkedIn leads into personalized, high-converting connection requests using GPT-4O AI and PhantomBuster automation. The system processes LinkedIn profile data, generates authentic icebreakers, and automatically sends connection requests twice daily, creating a hands-off lead generation machine that maintains human authenticity while scaling outreach efforts. Key Benefits 🤖 AI-Powered Personalization Generate unique, human-like icebreakers for every LinkedIn connection request using GPT-4O, ensuring each outreach feels personal and authentic rather than automated. ⚡ Automated Workflow Execution Run your entire lead generation pipeline automatically twice daily (10 AM and 5 PM) USA Time with zero manual intervention required. 📊 Smart Data Management Seamlessly manage leads across multiple Google Sheets with automatic data cleanup, duplicate prevention, and organized lead tracking. 🎯 PhantomBuster Integration Leverage PhantomBuster's powerful LinkedIn automation to send connection requests at scale while maintaining platform compliance. 📈 Scalable Processing Process leads in optimized batches of 10 to maintain quality while scaling your outreach efforts effectively and remain within LinkedIn’s weekly connection request limits. 📧 Real-Time Monitoring Receive email notifications whenever connection requests are sent, keeping you informed of your campaign progress. 🔄 Continuous Operation Self-maintaining system that processes new leads, cleans up completed tasks, and prepares for the next cycle automatically. 💼 Professional Template System Uses proven icebreaker templates that follow the format: "Hey [name], loved seeing [personalized detail]. I'm also into [relevant connection], thought I'd connect." How It Works Phase 1: Lead Acquisition & Processing The workflow begins with scheduled triggers that activate twice daily. Upon activation, the system first cleans up previously processed leads from the source Google Sheet to prevent duplicates. It then retrieves fresh LinkedIn profile data including names, titles, company information, locations, and profile URLs. Phase 2: AI-Powered Personalization Engine Retrieved leads are processed in batches of 10 through a sophisticated GPT-4O integration. The AI analyzes each LinkedIn profile and generates personalized icebreakers following a proven template structure. The system is specifically programmed to paraphrase LinkedIn information rather than copy it directly, ensuring messages feel human-written rather than automated. Phase 3: Data Storage & Campaign Launch Processed leads with their AI-generated icebreakers are stored in a dedicated Google Sheet for tracking and analysis. The system then aggregates all processed data and triggers a PhantomBuster agent that executes the actual LinkedIn connection requests using the personalized messages. Phase 4: Cleanup & Notification After successful campaign launch, the system removes processed leads from the source sheet, sends email confirmation notifications, and prepares for the next scheduled execution cycle. Required Setup & Dependencies Core Integrations: Google Sheets API access with OAuth2 authentication OpenAI API key for GPT-4O access PhantomBuster account with API key and configured LinkedIn agent Gmail account for notifications Google Sheets Structure: Source Sheet: Contains raw LinkedIn data (firstName, lastName, title, companyName, location, etc.) Destination Sheet: Stores processed leads with icebreakers and tracking information PhantomBuster Configuration: LinkedIn connection request automation agent Proper agent ID configuration in the HTTP request node Valid API key with sufficient credits Business Use Cases Sales Development Representatives (SDRs) Automate personalized outreach to potential clients while maintaining the human touch that drives connection acceptance rates. Recruitment Agencies Scale candidate outreach with personalized messages that reference specific experience and skills from LinkedIn profiles. Business Development Generate partnerships and collaboration opportunities through targeted, personalized connection requests to industry leaders. Coaches & Consultants Build professional networks by connecting with potential clients using AI-generated icebreakers that reference their specific challenges and opportunities. Marketing Agencies Develop client relationships through personalized outreach that demonstrates understanding of their business and industry. Revenue Potential Direct Lead Generation: Process 20 leads daily (10 per execution × 2 runs) Average 25% connection acceptance rate = 5 new connections daily Convert 10% of connections to qualified leads = 15 qualified leads monthly Close 20% of qualified leads at $2,000 average deal size = $6,000 monthly revenue Agency Services: Offer as white-label service to clients at $500-1,500 monthly recurring revenue per client Manage 10-20 client accounts for $5,000-30,000 monthly recurring revenue SaaS Model: Package as LinkedIn automation SaaS with tiered pricing ($49-299/month) Target 100+ subscribers for $5,000-30,000 monthly recurring revenue Difficulty Level & Build Time Difficulty: Intermediate to Advanced Estimated Build Time: 4-6 hours Technical Requirements: Understanding of API integrations, Google Sheets operations, and basic workflow logic Setup Complexity: API key management and authentication setup Google Sheets structure creation and permission configuration PhantomBuster agent setup and testing AI prompt engineering for optimal icebreaker generation Detailed Setup Steps Google Sheets Preparation Create two Google Sheets: Source Sheet: Structure with columns for firstName, lastName, location, title, companyName, titleDescription, linkedInProfileUrl Destination Sheet: Include all source columns plus id, photourl, icebreaker, emailstatus fields API Credentials Configuration OpenAI: Generate API key with GPT-4O access Google Sheets: Set up OAuth2 credentials in n8n PhantomBuster: Create account, set up LinkedIn connection agent, obtain API key Gmail: Configure OAuth2 for notification emails PhantomBuster Agent Setup Create LinkedIn connection request automation agent Configure with proper message templates and targeting parameters Test agent functionality and note the agent ID for n8n configuration Workflow Import & Configuration Import the provided n8n workflow JSON Update all credential references to match your configured accounts Modify Google Sheet IDs in all relevant nodes Update PhantomBuster agent ID and API key in HTTP request node AI Prompt Optimization Review and customize the GPT-4O prompt for your specific use case Test icebreaker generation with sample data Adjust tone and style parameters as needed Schedule Configuration Set appropriate trigger times based on your target timezone Consider LinkedIn usage patterns for optimal engagement Testing & Validation Run workflow manually with test data Verify Google Sheets integration and data flow Test PhantomBuster integration with small batch Confirm email notifications are working Advanced Customization Options Enhanced AI Personalization Integrate additional data sources (company websites, news articles) for richer context Add industry-specific icebreaker templates Implement A/B testing for message variations CRM Integration Connect to Salesforce, HubSpot, or Pipedrive for seamless lead management Add lead scoring based on profile analysis Implement automated follow-up sequences Analytics & Reporting Add detailed tracking and analytics dashboard Implement conversion tracking from connection to closed deal Generate automated performance reports Multi-Platform Expansion Extend to Twitter/X and Instagram outreach Add email finder integration for multi-channel campaigns Implement unified contact management across platforms Advanced Filtering Add AI-powered lead qualification before outreach Implement company size, industry, and role-based filtering Add sentiment analysis for optimal timing This workflow represents a complete, production-ready solution that can immediately start generating leads and revenue while providing a foundation for advanced customization and scaling.
By HassanBuild academic citation networks with PDF Vector API for Gephi visualization
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. Build Citation Networks from Research Papers Automatically build and visualize citation networks by fetching papers and their references. Discover influential works and research trends in any field. Workflow Features: Start with seed papers (DOIs, PubMed IDs, etc.) Fetch cited and citing papers recursively Build network graph data Export to visualization tools (Gephi, Cytoscape) Identify key papers and research clusters Process Flow: Input: Seed paper identifiers Fetch Papers: Get paper details and references Expand Network: Fetch cited papers (configurable depth) Build Graph: Create nodes and edges Analyze: Calculate metrics (centrality, clusters) Export: Generate visualization-ready data Applications: Research trend analysis Finding seminal papers in a field Grant proposal background research
By PDF VectorCreate daily Google Alerts digest with Gemini AI summarization and Gmail
Summarize Google Alerts with Gemini Turn your noisy Google Alerts folder into a concise, AI-curated executive briefing. This workflow replaces dozens of individual notification emails with a single, structured daily digest. How it works Ingest: Fetches unread Google Alerts emails from your Gmail inbox. Clean: Extracts article links, scrapes the website content, and strips away ads and clutter to ensure high-quality AI processing. Analyze: Uses Google Gemini to summarize each article into a concise 2-4 sentence overview. Deliver: Compiles a professional HTML email report sorted by topic, sends it to you, and automatically marks the original alerts as read. Set up steps Connect Gmail: Authenticate your Gmail account to allow reading alerts and sending the digest. Connect Gemini: Add your Google Gemini API key. Configure Recipient: Update the Send Email Digest node with your desired destination email address. Schedule: (Optional) Replace the Manual Trigger with a Schedule Trigger (e.g., every morning at 7 AM) to fully automate the process.
By Bernhard Zindel Automate digital product sales & delivery with Stripe and Email
💳 Automate Digital Product Sales & Delivery with Stripe and Email Turn Your Automations into Revenue Sell on n8n using Stripe (Fully Automated Delivery) Stop manually sending files after payment or struggling with clunky checkout flows. Instead of paying ~10% platform fees, you keep control of your sales, your brand, and your files — while giving buyers a smooth, professional experience. 💡 Turn Stripe into your own Gumroad alternative — sell and deliver workflows instantly. This workflow gives you a ready-made storefront system: customers pay via Stripe, and your n8n template is delivered instantly by email with setup guidelines and video instructions. Instant delivery → No waiting, customers receive their purchase within seconds. No manual work → Payment verification, file delivery, and confirmation emails are all automated. Professional experience → Clean emails with branded HTML, Loom walkthroughs, and receipts. Scalable sales → Sell 1 or 100 templates without adding workload. --- Who Benefits Most ✅ Automation creators: Sell your n8n templates without coding a shop. ✅ Freelancers & consultants: Package your workflows as digital products. ✅ Agencies: Offer prebuilt automations to clients on autopilot. ✅ SaaS builders: Add a self-serve template store for upsells. “Stop giving 10% of every sale to marketplaces. Keep your profit.” --- What It Does for You Customer pays securely. Logs the purchase for easy tracking. Pulls the correct workflow. Sends a personalized HTML email with: Workflow JSON file attached. Installation & setup guidelines. Walkthrough video link. Support contact details. Sends you (the seller) an instant purchase notification. --- Why This Template Instead of Building It Yourself Save 25–40 hours of coding, testing, and Stripe API integration. Avoid errors in file delivery, duplicate checkouts, and failed notifications. Get a production-ready digital delivery system you can brand and deploy in minutes. Customize effortlessly → add more products, change branding, or connect CRM. Proven flow: already tested (and using ourselves). --- Requirements n8n (self-hosted or cloud). Active Stripe account with API key. Access for file storage & logging. An email account for delivery. --- Bottom Line 💡 If you sell even one automation template, this workflow pays for itself. Instead of manually emailing JSON files, every customer gets a smooth, Amazon-like experience: they pay → they instantly receive → you scale without lifting a finger. --- 👉 By purchasing, you get: Full workflow JSON file. Email delivery with setup guidelines. Contact Us via services@quantumti.ae.
By LenouarCluster webpage topics from Google Sheets to Google Sheets for AI discovery
📊 Description Streamline AI-focused SEO research by automatically analyzing URLs stored in Google Sheets, extracting semantic signals from each webpage, and generating high-quality topic clusters for AI discovery. 🤖🔍 This automation fetches URLs weekly, scrapes headings (H1–H6), extracts entities, keywords, topics, and summaries using GPT-4o-mini, and classifies each page into clusters and subclusters optimized for LLM search visibility. It also generates internal linking suggestions for better topical authority and writes all results back into Google Sheets. Perfect for content strategists, SEO teams, and AI-search optimization workflows. 📈🧩 🔁 What This Template Does 1️⃣ Triggers weekly to process URLs stored in Google Sheets. 📅 2️⃣ Fetches all URL records from the configured sheet. 📥 3️⃣ Processes URLs in batches to avoid API overload. 🔁 4️⃣ Extracts webpage HTML and pulls semantic headings (H1–H6). 📰 5️⃣ Sends headings + URL context to GPT-4o-mini for structured extraction of: — title — entities — keywords — topics — summary 6️⃣ Generates high-level cluster + subcluster labels for each page. 🧠 7️⃣ Recommends 3–5 internal linking URLs to strengthen topical authority. 🔗 8️⃣ Updates Google Sheets with all extracted fields + status flags. 📊 9️⃣ Repeats the process until all URLs are analyzed. 🔄 ⭐ Key Benefits ✅ Automates topical clustering for AI search optimization ✅ Extracts entities, keywords, and topics with high semantic accuracy ✅ Strengthens internal linking strategies using AI suggestions ✅ Eliminates manual scraping and analysis work ✅ Enables scalable content audits for large URL datasets ✅ Enhances visibility in AI-driven search systems and answer engines 🧩 Features Google Sheets integration for input + output HTML parsing for H1–H6 extraction GPT-4o-mini structured JSON extraction Topic clustering engine (cluster & subcluster classification) Internal linking recommendation generator Batch processing for large URL datasets Status-based updating in Google Sheets 🔐 Requirements Google Sheets OAuth2 credentials OpenAI API key (GPT-4o-mini) Publicly accessible URLs (or authenticated HTML if applicable) n8n with LangChain nodes enabled 🎯 Target Audience SEO teams performing semantic clustering at scale Content strategists creating AI-ready topic maps Agencies optimizing large client URL collections AI-search consultants building structured content libraries Technical marketers needing automated content analysis
By Rahul Joshi