Workflow Templates

🤖 Automated AI News Video Creation and Social Media Publishing Workflow ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 🎯 Overview: This workflow fully automates the creation and social media distribution of AI-generated news videos. It fetches news, crafts captions, generates avatar videos via HeyGen, stores them, and publishes them across Instagram, Facebook, and YouTube via Postiz. 🔄 WORKFLOW PROCESS: News Fetching: Reads the latest news from an RSS feed. AI Captioning: Generates concise, engaging captions using an AI agent (GPT-4o-mini). Video Generation: Creates an AI avatar video using HeyGen with the generated caption. Video Storage: Downloads the video and uploads it to Google Drive for archival. Data Logging: Records all news and video metadata into Google Sheets. Postiz Upload: Uploads the video to Postiz's internal storage for publishing. Social Publishing: Fetches Postiz integrations and routes the video to Instagram, Facebook, and YouTube after platform-specific content cleaning. ⚙️ KEY TECHNOLOGIES: RSS Feeds:** News source. LangChain (n8n nodes):** AI Agent and Chat OpenAI for caption generation. HeyGen API:** AI avatar video creation. Google Drive:** Video file storage. Google Sheets:** Data logging and tracking. Postiz API:** Unified social media publishing platform. ⚠️CRITICAL CONFIGURATIONS: API Keys:** Ensure HeyGen and Postiz API keys are correctly set in credentials and the 'Setup Heygen Parameters' node. HeyGen IDs:** Verify avatar_id and voice_id in 'Setup Heygen Parameters'. Postiz URL:** Confirm https://postiz.yourdomain.com is your correct Postiz instance URL across all HTTP Request nodes. Credentials:** All Google, OpenAI, and Postiz credentials must be properly linked. 📈BENEFITS: Automated content creation and distribution, saving significant time. Consistent branding and messaging across multiple platforms. Centralized logging for tracking and performance analysis. Scalable solution for high-volume content demands.

Who’s it for Creators who want to create faceless videos automatically, while keeping human oversight and quality control. How it works / What it does AI generates 8 story beats, which can be reviewed, edited, or re-ordered by a human. Each beat is converted into narration (audio), imagery, and short clips. Final video is assembled and stored in Google Drive, ready for review and regeneration if needed. Chat commands trigger each step, giving full human control. How to set up Set up Google Drive and Google Sheets Get necessary credentials Requirements Google Drive account for storing videos. Access to AI tools for text, voice, and visuals. Basic familiarity with triggering chat commands or automation steps. How to customize the workflow Adjust the number of story beats or narration style Use models of your choice Use for any theme by updating Story prompt

Description Turn incoming Gmail messages into structured Zendesk tickets, enriched by Azure OpenAI, and log key details to Google Sheets for tracking. Ideal for IT Support teams needing fast, consistent intake and documentation. ⚡ What This Template Does Fetches new emails via Gmail Trigger. ✉️ Normalizes Gmail data and formats it for downstream steps. Enriches and structures content with Azure OpenAI Chat Model and Output Parsers. Creates Zendesk tickets from the processed data. 🎫 Appends or updates logs in Google Sheets for auditing and reporting. 📊 Key Benefits Saves time by automating ticket creation and logging. ⏱️ Improves ticket quality with AI-driven normalization and structure. Ensures consistent records in Google Sheets for easy reporting. Reduces manual errors in IT Support intake. ✅ Features Gmail-triggered intake flow for new messages. AI enrichment using Azure OpenAI Chat Model with parsing and memory tooling. Zendesk ticket creation (create: ticket) with structured fields. Google Sheets logging (appendOrUpdate: sheet). Modular design with Execute Workflow nodes for reuse and scaling. Requirements n8n instance (Cloud or self-hosted). Gmail credentials configured in n8n for the Gmail Trigger. Zendesk credentials with permission to create tickets. Google Sheets credentials with access to the target spreadsheet (append/update enabled). Azure OpenAI credentials configured for the Azure OpenAI Chat Model and associated parsing. Target Audience IT Support and Helpdesk teams handling email-based requests. 🛠️ Operations teams standardizing inbound email workflows. Agencies and MSPs offering managed support intake. Internal automation teams centralizing ticket capture and logging. Step-by-Step Setup Instructions Connect Gmail credentials in n8n and select the inbox/label for the Gmail Trigger. Add Zendesk credentials and confirm ticket creation permissions. Configure Google Sheets credentials and select the target sheet for logs. Add Azure OpenAI credentials to the Azure OpenAI Chat Model node and verify parsing steps. Import the workflow, assign credentials to each node, update any placeholders, and run a test. Rename the final email/logging nodes descriptively (e.g., “Log to Support Sheet”) and schedule if needed.

Description Process new resumes from Google Drive, extract structured candidate data with AI, save to Google Sheets, and auto-create a ClickUp hiring task. Gain a centralized, searchable candidate database and instant task kickoff—no manual data entry. 🚀 What This Template Does Watches a Google Drive folder for new resume PDFs and triggers the workflow. 📂 Downloads the file and converts the PDF to clean, readable text. 📄 Analyzes resume text with an AI Resume Analyzer to extract structured candidate info (name, email, phone, experience, skills, education). 🤖 Cleans and validates the AI JSON output for reliability. 🧹 Appends or updates a candidate row in Google Sheets and creates a ClickUp hiring task. ✅ Key Benefits Save hours with end-to-end, hands-off resume processing. ⏱️ Never miss a candidate—every upload triggers automatically. 🔔 Keep a single source of truth in Sheets, always up-to-date. 📊 Kickstart hiring instantly with auto-created ClickUp tasks. 🗂 Works with varied resume formats using AI extraction. 🧠 Features Google Drive “Watch for New Resumes” trigger (every minute). ⏲ PDF-to-text extraction optimized for text-based PDFs. 📘 AI-powered resume parsing into standardized JSON fields. 🧩 JSON cleanup and validation for safe storage. 🧰 Google Sheets append-or-update for a central candidate database. 📑 ClickUp task creation with candidate-specific titles and assignment. 🎯 Requirements n8n instance (cloud or self-hosted); recommended n8n version 1.106.3 or higher. 🔧 Google Drive access to a dedicated resumes folder (PDF resumes recommended). 📂 Google Sheets credential with edit access to the candidate database sheet. 📈 ClickUp workspace/project access to create tasks for hiring. 📌 AI service credentials for the Resume Analyzer step (add in n8n Credentials). 🤖 Target Audience HR and Talent Acquisition teams needing faster screening. 👥 Recruiters and staffing agencies handling high volumes. 🏢 Startups and ops teams standardizing candidate intake. 🚀 No-code/low-code builders automating hiring workflows. 🧩 Step-by-Step Setup Instructions Connect Google Drive, Google Sheets, ClickUp, and your AI service in n8n Credentials. 🔐 Set the Google Drive “watched” folder (e.g., Resume_store). 📁 Import the workflow, assign credentials to all nodes, and map your Sheets columns. 🗂️ Adjust the ClickUp task details (title pattern, assignee, list). 📝 Run once with a sample PDF to test, then enable scheduling (every 1 minute). ▶️ Optionally rename the email/task nodes for clarity (e.g., “Create Hiring Task in ClickUp”). ✍️

🚀 HR Resume Screening Workflow — Smart Hiring on Autopilot 🤖 🎯 Overview: "This workflow builds an AI-powered resume screening system inside n8n. It begins with Gmail and Form triggers that capture incoming resumes, then uploads each file to Google Drive for storage. The resume is downloaded and converted into plain text, where two branches run in parallel: one extracts structured contact details, and the other uses an AI agent to summarize education, job history, and skills while assigning a suitability score. A cleanup step normalizes the data before merging both outputs, and the final candidate record is saved into Google Sheets and Airtable, giving recruiters a centralized dashboard to identify top talent quickly and consistently.” 🔑 Prerequisites: To run this workflow successfully, you’ll need: Gmail OAuth** → to read incoming resumes. Google Drive OAuth** → to upload and download resume files. Google Sheets OAuth** → to save structured candidate records. Airtable Personal Access Token** → for dashboards and record-keeping. OpenAI / OpenRouter API Key** → to run the AI summarizer and evaluator. ⚙️ Setup Instructions: Import the Workflow Clone or import the workflow into your n8n instance. Add Credentials Go to n8n → Credentials and connect Gmail, Google Drive, Google Sheets, Airtable, and OpenRouter/OpenAI. Configure Key Nodes Gmail Trigger → Update filters.q with the job title you are hiring for (e.g., "Senior Software Engineer"). Google Drive Upload → Set the folderId where resumes will be stored. Google Sheets Node → Link to your HR spreadsheet (e.g., “Candidates 2025”). Airtable Node → Select the correct base & table schema for candidate records. Test the Workflow Send a test resume (via email or form). Check Google Sheets & Airtable for structured candidate data. Go Live Enable the workflow. It will now run continuously and process new resumes as they arrive. 📊 End-to-End Workflow Walkthrough: 🟢 Section 1 – Entry & Intake Nodes: 📧 Gmail Trigger → Polls inbox every minute, captures job application emails, and downloads resume attachments (CV0, CV1, …). 🌐 Form Trigger → Alternate entry for resumes submitted via a careers page or job portal. ✅ Quick Understanding: Think of this section as the front desk of recruitment - resumes received either by email or online form, and the system immediately grabs them for processing. 📂 Section 2 – File Management Nodes: ☁️ Upload File (Google Drive) → Saves the incoming resume into a structured Google Drive folder, naming it after the applicant. ⬇️ Download File (Google Drive) → Retrieves the stored resume file for further processing. 🔎 Extract from File → Converts the resume (PDF/DOC) into plain text so the AI and extractors can work with it. ✅ Quick Understanding: This is your digital filing room. Every resume is safely stored, then converted into a readable format for the hiring system. 🤖 Section 3 – AI Processing (Parallel Analysis) Nodes: 🧾 Information Extractor → Pulls structured contact information (candidate name, candidate email and candidate phone number) using regex validation and schema rules. 🤖 AI Agent (LangChain + OpenRouter) → Reads the full CV and outputs: 🎓 Educational Qualifications 💼 Job History 🛠 Skills Set 📊 Candidate Evaluation Score (1–10) 📝 Justification for the score ✅ Quick Understanding: Imagine having two assistants working in parallel, one quickly extracts basic contact info, while the other deeply reviews the CV and gives an evaluation. 🛠️ Section 4 – Data Cleanup & Merging Nodes: ✏️ Edit Fields → Standardizes the AI Agent’s output into a consistent field (output). 🛠 Code (JS Parsing & Cleanup) → Converts the AI’s free-text summary into clean JSON fields (education, jobHistory, skills, score, justification). 🔗 Merge → Combines the structured contact info with the AI’s evaluation into a single candidate record. ✅ Quick Understanding: This is like the data cleaning and reporting team, making sure all details are neat, structured, and merged into one complete candidate profile. 📊 Section 5 – Persistence & Dashboards Nodes: 📑 Google Sheets (Append Row) → Saves candidate details into a Google Sheet for quick team access. 🗄 Airtable (Create Record) → Stores the same structured data into Airtable, enabling dashboards, analytics, and ATS-like tracking. ✅ Quick Understanding: Think of this as your HR dashboard and database. Every candidate record is logged in both Google Sheets and Airtable, ready for filtering, reporting, or further action. 📊 Workflow Overview Table: | Section | Key Roles / Nodes | Model / Service | Purpose | Benefit | | --- | --- | --- | --- | --- | | 📥 Entry & Intake | Gmail Trigger, Form Trigger | Gmail API / Webhook | Capture resumes from email or forms | Resumes collected instantly from multiple sources | | 📂 File Management | Google Drive Upload, Google Drive Download, Extract from File | Google Drive + n8n Extract | Store resumes & convert to plain text | Centralized storage + text extraction for processing | | 🤖 AI Processing | Information Extractor, AI Agent (LangChain + OpenRouter) | Regex + OpenRouter AI {gpt-oss-20b (free)} | Extract contact info + AI CV analysis | Candidate details + score + justification generated automatically | | 🛠 Data Cleanup & Merge | Edit Fields, Code (JS Parsing & Cleanup), Merge | n8n native + Regex Parsing | Standardize and merge outputs | Clean, structured JSON record with all candidate info | | 📊 Persistence Layer | Google Sheets Append Row, Airtable Create Record | Google Sheets + Airtable APIs | Store structured candidate data | HR dashboards & ATS-ready records for easy review and analytics | | 🔄 Execution Flow | All connected | Gmail + Drive + Sheets + Airtable + AI | End-to-end automation | Automated resume → structured record → recruiter dashboards | 📂 Workflow Output Overview: Each candidate’s data is standardized into the following fields: Candidate Name Candidate Email Contact Number Educational Qualifications Job History Skills Set AI Score (1–10) Justification 📌 Example (Google Sheet row): 📊 Benefits of This Workflow at a Glance: ⏱️ Lightning-Fast Screening** → Processes hundreds of resumes in minutes instead of hours. 🤖 AI-Powered Evaluation** → Automatically summarizes candidate education, work history, skills, and gives a suitability score (1–10) with justification. 📂 Centralized Storage** → Every resume is securely saved in Google Drive for easy access and record-keeping. 📊 Data-Ready Outputs** → Structured candidate profiles go straight into Google Sheets and Airtable, ready for dashboards and analytics. ✅ Consistency & Fairness** → Standardized AI scoring ensures every candidate is evaluated on the same criteria, reducing human bias. 🛠️ Flexible Intake** → Works with both Gmail (email applications) and Form submissions (job portals or career pages). 🚀 Recruiter Productivity Boost** → Frees HR teams from manual extraction and data entry, allowing them to focus on interviewing and hiring the best talent. 👉 Practical HR Use Case: “Screen resumes for a Senior Software Engineer role and shortlist top candidates.” Gmail Trigger → Captures incoming job applications with CVs attached. Google Drive → Stores resumes for record-keeping. Extract from File → Converts CVs into plain text. Information Extractor → Pulls candidate name, email, and phone number. AI Agent → Summarizes education, job history, skills, and assigns a suitability score (1–10). Code & Merge → Cleans and combines outputs into a structured candidate profile. Google Sheets → Logs candidate data for quick HR review. Airtable → Builds dashboards to filter and identify top-scoring candidates. ✅ Result: HR instantly sees structured candidate records, filters by score, and focuses interviews on the best talent.

🔧 Automated Video Generator (n8n Workflow) 🚀 Features End-to-End Video Creation from user idea or transcript AI-Powered Scriptwriting using LLMs (e.g., DeepSeek via OpenRouter) Voiceover Generation with customizable TTS voices Image Scene Generation using generative models like together.ai Clip Creation & Concatenation into a full video Dynamic Caption Generation with styling options Google Drive & Sheets Integration for asset storage and progress tracking ⚙️ How It Works User Submits Form with: Main topic or transcript Desired duration TTS voice Visual style (e.g., Pixar, Lego, Cyberpunk) Image generation provider AI generates a script: A catchy title, description, hook, full script, and CTA using a language model. Text-to-Speech (TTS): The script is turned into audio using the selected voice, with timestamped captions generated. Scene Segmentation: The script is split into 5–6 second segments for visual storyboarding. Image Prompt Creation: Each scene is converted into an image prompt in the selected style (e.g., "anime close-up of a racing car"). Image Generation: Prompts are sent to together.ai or fal.ai to generate scenes. Clip Creation: Each image is turned into a short video clip (Ken Burns-style zoom) based on script timing. Video Assembly: All clips are concatenated into a single video. Captions are overlaid using the earlier timestamps. Final Output is uploaded to Google Drive, Telegram and links are saved in Google Sheets. 🛠 Inital Setup 🗣️ 1. Set Up TTS Voice (Text-to-Speech) Run your TTS server locally using Docker. 🧰 2. Set Up NCA-Toolkit The nca-toolkit appears to be a custom video/image processing backend used via HTTP APIs: http://host.docker.internal:9090/v1/image/transform/video http://host.docker.internal:9090/v1/video/concatenate http://host.docker.internal:9090/v1/ffmpeg/compose 🔧 Steps: Clone or build the nca-toolkit container (if it's a private tool): Ensure it exposes port 9090. It should support endpoints for: Image to video (zoom effect) Video concatenation Audio + video merging Caption overlay via FFmpeg Run it locally with Docker: docker run -d -p 9090:80 your-nca-toolkit-image 🧠 3. Set Up together.ai (Image Generation) (Optional You can use ChatGPT API Instead) This handles image generation using models like FLUX.1-schnell. 🔧 Steps: Create an account at: https://www.together.ai Generate your API key

NGO TPM Request Management System Benefits For Beneficiaries: 24/7 Accessibility** - Submit requests anytime via familiar Telegram interface Language Flexibility** - Communicate in Arabic through text or voice messages Instant Acknowledgment** - Receive immediate confirmation that requests are logged No Technical Barriers** - Works on basic smartphones without special apps For TPM Teams: Centralized Tracking** - All requests automatically logged with timestamps and user details Smart Prioritization** - AI categorizes issues by urgency and type for efficient response Action Guidance** - Specific recommended actions generated for each request type Performance Analytics** - Track response patterns and common issues over time For NGO Operations: Cost Reduction** - Automated intake reduces manual processing overhead Data Quality** - Standardized categorization ensures consistent reporting Audit Trail** - Complete record of all beneficiary interactions for compliance Scalability** - Handle high volumes without proportional staff increases How it Works Multi-Input Reception - Accepts both text messages and voice recordings via Telegram Voice Transcription - Uses OpenAI Whisper to convert Arabic voice messages to text AI Categorization - GPT-4 analyzes requests and categorizes issues (aid distribution, logistics, etc.) Action Planning - AI generates specific recommended actions for TPM team in Arabic Data Logging - Records all requests, categories, and actions in Google Sheets with user details Confirmation Feedback - Sends acknowledgment message back to users via Telegram Set up Steps Setup Time: ~20 minutes Create Telegram Bot - Get bot token from @BotFather and configure webhook Configure APIs - Set up OpenAI (transcription + chat) and Google Sheets credentials Customize AI Prompts - Adjust system messages for your NGO's specific operations Set Up Spreadsheet - Link Google Sheets for request tracking and reporting Test Workflows - Verify both text and voice message processing paths Detailed Arabic language configuration and TPM-specific categorization examples are included as sticky notes within the workflow. What You'll Need: Telegram Bot Token (free from @BotFather) OpenAI API key (Whisper + GPT-4) Google Sheets API credentials Google Spreadsheet for logging requests Sample Arabic text/voice messages for testing Key Features: Dual input support (text + voice messages) Arabic language processing and responses Structured data extraction (category + recommended action) Complete audit trail with user information Real-time confirmation messaging TPM team-specific workflow optimization

Estimate embodied carbon (CO2e) for grouped BIM/CAD elements. The workflow accepts an existing XLSX (grouped element data) or, if missing, can trigger a local RvtExporter.exe to generate one. It detects category fields, filters out non-building elements, infers aggregation rules with AI, computes CO2 using densities & emission factors, and exports a multi-sheet Excel plus a clean HTML report. What it does Reads or builds XLSX** (from your model via RvtExporter.exe when needed). Finds category/volumetric fields**; separates building vs. annotation elements. Uses AI to infer aggregation rules (sum/mean/first) per header. Groups** rows by your group_by field and aggregates totals. Prepares enhanced prompts and calls your LLM to classify materials and estimate CO2 (A1-A3 minimum). Computes project totals* and generates a *multi-sheet XLSX* + *HTML** report with charts and hotspots. Prerequisites LLM credentials** for one provider (e.g., OpenAI, Anthropic, Gemini, Grok/OpenRouter). Enable one chat node and connect credentials. Windows host* only if you want to auto-extract from .rvt/.ifc via RvtExporter.exe. If you already have an XLSX, Windows is *not required**. Optional: mapping/classifier files (XLSX/CSV/PDF) to improve material classification. How to use Import this JSON into n8n. Open the Setup/Parameters node(s) and set: project_file — path to your .rvt/.ifc or to an existing grouped *_rvt.xlsx path_to_converter — C:\\DDC_Converter_Revit\\datadrivenlibs\\RvtExporter.exe (optional) group_by — e.g., Type Name / Category / IfcType sheet_name — default Summary (if reading from XLSX) Enable one LLM node and attach credentials; keep others disabled. Execute (Manual Trigger). The workflow detects/builds the XLSX, analyzes, classifies, estimates CO2, then writes Excel and opens the HTML report. Outputs Excel** (CO2_Analysis_Report_YYYY-MM-DD.xlsx, ~8 sheets): Executive Summary, All Elements, Material Summary, Category Analysis, Impact Analysis, Top 20 Hotspots, Data Quality, Recommendations. HTML**: executive report with key KPIs and charts. Per-group fields include: Material (EU/DE/US), Quantity & Unit, Density, Mass, CO2 Factor, Total CO2 (kg/tonnes), CO2 %, Confidence, Assumptions. Notes & tips Input quantities (volumes/areas) are already aggregated per group — do not multiply by element count. Use -no-collada upstream if you only need XLSX in extraction. Prefer ASCII-safe paths and ensure write permissions to output folder. Categories Data Extraction · Files & Storage · ETL · CAD/BIM · Carbon/ESG Tags cad-bim, co2, carbon, embodied-carbon, lca, revit, ifc, xlsx, html-report, llm Author DataDrivenConstruction.io info@datadrivenconstruction.io Consulting and Training We work with leading construction, engineering, consulting agencies and technology firms around the world to help them implement open data principles, automate CAD/BIM processing and build robust ETL pipelines. If you would like to test this solution with your own data, or are interested in adapting the workflow to real project tasks, feel free to contact us. Docs & Issues: Full Readme on GitHub

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically tracks regional sentiment across social media and news outlets, giving you a real-time pulse on how people in a specific area feel about your brand or topic. Overview The automation queries Twitter, Reddit, and major news APIs filtered by geolocation. Bright Data handles location-specific scraping where APIs are limited. OpenAI performs sentiment and keyword extraction, aggregating scores into a daily report stored in Google Sheets and visualized in Data Studio. Tools Used n8n** – Coordinates all steps Bright Data** – Collects geo-targeted data beyond API limits OpenAI** – Runs sentiment analysis and topic modeling Google Sheets** – Houses cleaned sentiment metrics Data Studio / Looker** – Optional dashboard for visualization How to Install Import the Workflow into n8n with the provided .json. Configure Bright Data credentials. Set Up OpenAI API key. Connect Google Sheets and create a destination spreadsheet. Customize Regions & Keywords in the Start node. Use Cases Brand Monitoring**: Measure public opinion in target markets. Political Campaigns**: Gauge voter sentiment by district. Market Entry**: Understand regional attitudes before launching. Crisis Management**: Detect negative spikes early. Connect with Me Website**: https://www.nofluff.online YouTube**: https://www.youtube.com/@YaronBeen/videos LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #sentimentanalysis #geolocation #brightdata #openai #sociallistening #n8nworkflow #nocode #brandmonitoring

Description This workflow automatically monitors your competitors' product prices and notifies you of any changes. It helps you stay competitive in the market by providing real-time insights into pricing strategies without manual checking. Overview This workflow automatically tracks your competitors' pricing across their websites and notifies you of any changes. It uses Bright Data to scrape pricing data and can generate reports or send alerts when prices change. Tools Used n8n:** The automation platform that orchestrates the workflow. Bright Data:** For scraping competitor websites without being blocked. Spreadsheets/Databases:** For storing and analyzing price data. Notification Services:** For alerting you to significant price changes. How to Install Import the Workflow: Download the .json file and import it into your n8n instance. Configure Bright Data: Add your Bright Data credentials to the Bright Data node. Set Up Data Storage: Configure where you want to store the price data. Customize: Add your competitors' URLs and the specific products to monitor. Use Cases E-commerce Businesses:** Stay competitive with real-time price monitoring. Pricing Analysts:** Automate data collection for pricing strategy. Retailers:** Adjust your pricing strategy based on market trends. Connect with Me Website:** https://www.nofluff.online YouTube:** https://www.youtube.com/@YaronBeen/videos LinkedIn:** https://www.linkedin.com/in/yaronbeen/ Get Bright Data:** https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #pricing #competitoranalysis #brightdata #ecommerce #pricemonitoring #competitiveintelligence #pricetracking #marketanalysis #n8nworkflow #workflow #nocode #pricingstrategy #competitortracking #ecommercetools #pricecomparison #businessintelligence #marketresearch #competitivepricing #retailautomation #pricealerts #datadriven #webscraping #pricinganalysis #competitorinsights

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically scrapes local business directories (Yelp, Yellow Pages, Google Maps, etc.) to build a structured database of prospects. Stop copying listings by hand—get fresh leads delivered straight to Google Sheets. Overview Using Bright Data, the automation fetches business names, contact details, ratings, and categories for a given city or ZIP code. OpenAI cleans and normalizes the data, while duplicate detection ensures each business appears only once. The result is emailed as a CSV and stored in Sheets for easy filtering. Tools Used n8n** – Workflow orchestration Bright Data** – Handles large-scale directory scraping OpenAI** – Performs entity cleanup and deduplication Google Sheets** – Houses the resulting lead list Gmail** – Sends the CSV file to your inbox How to Install Import the Workflow: Load the .json into n8n. Configure Bright Data: Add your credentials. Set Up OpenAI: Enter your API key. Connect Google Sheets & Gmail: Authorize both integrations. Customize Locations & Categories: Adjust parameters in the Start node. Use Cases Local Lead Generation**: Build outreach lists for agencies or SaaS. Market Research**: Analyze density of businesses in a region. Franchise Expansion**: Identify potential partners within a territory. Startup Sales**: Discover SMBs that match your ICP. Connect with Me Website**: https://www.nofluff.online YouTube**: https://www.youtube.com/@YaronBeen/videos LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #webscraping #localbusiness #brightdata #leadgeneration #n8nworkflow #nocode #businessdirectories #openai

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. This workflow automatically discovers and collects information about events and attendee data from event platforms. It saves you time by eliminating the need to manually browse through event listings and provides a centralized database of event information including categories, venues, and attendee feedback. Overview This workflow automatically scrapes event data from 10times.com and other event platforms to extract categories, featured events, attendee feedback, and venue information. It uses Bright Data to access event websites without being blocked and AI to intelligently parse event data into structured format for storage in Google Sheets. Tools Used n8n**: The automation platform that orchestrates the workflow Bright Data**: For scraping event websites without being blocked OpenAI**: AI agent for intelligent event data extraction and parsing Google Sheets**: For storing and organizing event information How to Install Import the Workflow: Download the .json file and import it into your n8n instance Configure Bright Data: Add your Bright Data credentials to the MCP Client node Set Up OpenAI: Configure your OpenAI API credentials Configure Google Sheets: Connect your Google Sheets account and specify the target spreadsheet Customize: Adjust the event platform URLs and event criteria you want to monitor Use Cases Event Planners**: Monitor competing events and industry trends Marketing Teams**: Identify events for sponsorship and networking opportunities Business Development**: Find relevant events for lead generation and partnerships Market Research**: Track event attendance patterns and industry insights Connect with Me Website**: https://www.nofluff.online YouTube**: https://www.youtube.com/@YaronBeen/videos LinkedIn**: https://www.linkedin.com/in/yaronbeen/ Get Bright Data**: https://get.brightdata.com/1tndi4600b25 (Using this link supports my free workflows with a small commission) #n8n #automation #events #eventdiscovery #brightdata #webscraping #eventplanning #eventscraping #attendeedata #eventmarketing #n8nworkflow #workflow #nocode #eventautomation #eventmonitoring #eventresearch #10times #eventintelligence #venuedata #eventfeedback #eventtracking #eventcalendar #eventanalytics #businessevents #eventorganizer #eventtech #eventindustry #eventcollection #networkingevents #conferencedata