Automate CVE monitoring with OpenAI processing for ServiceNow security incidents
This n8n workflow automatically fetches the latest CVE data at scheduled intervals, extracts relevant security details, and creates a corresponding Security Incident in ServiceNow for each new vulnerability. Schedule Trigger – Runs at predefined intervals. Jina Fetch – Retrieves the latest CVE feed. Information Extractor (OpenAI Chat Model) – Processes and extracts key details from the CVE data. Split Out – Separates each CVE entry for individual processing. Create Incident – Generates a ServiceNow Security Incident with the extracted CVE details. Ideal for security teams to ensure timely tracking and remediation of new vulnerabilities without manual monitoring.
By Tushar MishraBulk auto-publish videos to social networks with AI copy and client approval
This workflow automates batch video publishing prep from a Google Drive folder with AI-generated, platform-specific copy and a simple approval queue in Google Sheets. Perfect for Agencies, content creators or Teams --- What This Workflow Does Fetches videos from a Google Drive folder You provide a folder ID and the workflow lists all files, filtering to keep only .mp4. Builds a simple publishing calendar You configure: Start date Cadence (daily, 5/week, 3/week) Timezone One Publish Hour shared across all selected platforms The workflow creates: Schedule Date Schedule DateTime for each video Analyzes each video with AI Gemini performs a structured analysis of the video to understand: What happens in the content Key topics Tone Audience intent Generates platform-specific social copy For each video, the AI creates unique text for: TikTok Instagram Reels YouTube Shorts The prompts are language-aware: If the video is in English, the titles/descriptions are generated in English. If the video is in Spanish, they are generated in Spanish. Saves everything to Google Sheets as drafts Each video becomes one row with: Titles, descriptions, hashtags/tags A single shared Schedule DateTime Status = draft Auto-publishes approved rows (Flow 2) Every hour: Loads the sheet Filters rows where Status = approved Downloads the Drive file Schedules the video to the selected platforms Updates Status = scheduled --- Sheet Structure The tracking sheet is designed to be a clean approval queue. Recommended columns: Video ID Video Name Index Status Schedule Date Schedule DateTime TikTok Title TikTok Description TikTok Hashtags Instagram Title Instagram Description Instagram Hashtags YouTube Title YouTube Description YouTube Tags Summary Profile Platforms Created At --- How Approval Works New rows start as draft. You revise any copy directly in Sheets. When ready, change Status to approved. Flow 2 schedules the video and updates the row. --- Requirements Google Drive access Google Sheets access Gemini API key Upload-Post account with connected social profiles --- Installation & Setup Create your tracking sheet Copy this sheet in your drive https://docs.google.com/spreadsheets/d/1cegJHxj7Kx4Tg8gMr3uixpzToNc62VEvuuz37iFvnRw/edit?usp=sharing Connect credentials in n8n Google Drive OAuth Google Sheets OAuth Gemini credentials Upload-Post credentials Run the form Provide: Drive Folder ID Profile Username Platforms Timezone Start Date Cadence Publish Hour Google Sheet ID If you want to explore the API used for publishing These docs can help for custom extensions: social media API --- Ideal Use Cases Creators batching Shorts/Reels/TikToks and wanting a single approval queue Agencies that need a simple client-friendly review workflow Teams building internal content ops with predictable scheduling --- Notes This version keeps scheduling simple with one Schedule DateTime per video shared across all selected platforms. If you later want per-platform times, extend the calendar builder to generate separate datetimes again.
By Juan Carlos Cavero GraciaAutomate real estate construction site discovery with 99acres email scraper
This n8n workflow helps users easily discover nearby residential construction projects by automatically scraping and analyzing property listings from 99acres and other real estate platforms. Users can send an email with their location preferences and receive a curated list of available properties with detailed information, including pricing, area, possession dates, and construction status. Good to know The workflow focuses specifically on residential construction projects and active developments Property data is scraped in real-time to ensure the most current information Results are automatically formatted and structured for easy reading The system handles multiple property formats and data variations from different sources Fallback mechanisms ensure reliable data extraction even when website structures change How it works Trigger: New Email - Detects incoming emails with property search requests and extracts location preferences from email content Extract Area & City - Parses the email body to identify target areas (e.g., Gota, Ahmedabad) and falls back to city-level search if specific area is not mentioned Scrape Construction Projects - Performs web scraping on 99acres and other property websites based on the extracted area and city information Parse Project Listings - Cleans and formats the scraped HTML data into structured project entries with standardized fields Format Project Details - Transforms all parsed projects into a consistent email-ready list format with bullet points and organized information Send Results to User - Delivers a professionally formatted email with the complete list of matching construction projects to the original requester Email Format Examples Input Email Format To: properties@yourcompany.com Subject: Property Search Request Hi, I am interested in buying a flat. Can you please send me the list of available properties in Gota, Ahmedabad? Output Email Example html Subject: 🏘️ Property Search Results: 4 Projects Found in Gota, Ahmedabad 🏘️ Available Construction Projects in Gota, Ahmedabad Search Area: Gota, Ahmedabad Total Projects: 4 Search Date: August 4, 2025 📋 PROJECT LISTINGS: 🔷 Project 1 🏠 Name: Vivaan Oliver offers 🏢 BHK: 3 BHK 💰 Price: N/A 📐 Area: 851.0 Sq.Ft 🗓️ Possession: August 2025 📊 Status: under construction 📍 Location: Thaltej, Ahmedabad West 🕒 Scraped Date: 2025-08-04 ------------------------------------------- 🔷 Project 2 🏠 Name: Vivaan Oliver offers 🏢 BHK: 3 BHK 💰 Price: Price on Request 📐 Area: 891 Sq Ft 🗓️ Possession: N/A 📊 Status: Under Construction 📍 Location: Thaltej, Ahmedabad West 🕒 Scraped Date: 2025-08-04 ------------------------------------------- 🔷 Project 3 🏠 Name: It offers an exclusive range of 🏢 BHK: 3 BHK 💰 Price: N/A 📐 Area: 250 Sq.Ft 🗓️ Possession: 0 2250 📊 Status: Under Construction 📍 Location: Thaltej, Ahmedabad West 🕒 Scraped Date: 2025-08-04 ------------------------------------------- 🔷 Project 4 🏠 Name: N/A 🏢 BHK: 2 BHK 💰 Price: N/A 📐 Area: N/A 🗓️ Possession: N/A 📊 Status: N/A 📍 Location: Thaltej, Ahmedabad West 💡 Next Steps: • Contact builders directly for detailed pricing and floor plans • Schedule site visits to shortlisted properties • Verify possession timelines and construction progress • Compare amenities and location advantages 📞 For more information or specific requirements, reply to this email. How to use Setup Instructions Import the workflow into your n8n instance Configure Email Credentials: Set up email trigger for incoming property requests Set up SMTP credentials for sending property listings Configure Web Scraping: Ensure proper headers and user agents for 99acres access Set up fallback mechanisms for different property websites Test the workflow with sample property search emails Sending Property Search Requests Send an email to your configured property search address Include location details in natural language (e.g., "Gota, Ahmedabad") Optionally specify preferences like BHK, budget, or amenities Receive detailed property listings within minutes Requirements n8n instance (cloud or self-hosted) with web scraping capabilities Email account with IMAP/SMTP access for automated communication Reliable internet connection for real-time property data scraping Valid target websites (99acres, MagicBricks, etc.) access Troubleshooting No properties found: Verify area spelling and check if the location has active listings Scraping errors: Update user agents and headers if websites block requests Duplicate results: Implement better deduplication logic based on property names and locations Email parsing issues: Test with various email formats and improve regex patterns Website structure changes: Implement fallback parsers and regular monitoring of scraping success rates
By Oneclick AI Squad