Workflow Templates

Who is this for This workflow is for sales teams, growth hackers, and lead generation agencies who want to build a targeted list of Shopify store owners -- complete with emails, phone numbers, and social profiles -- and receive those contacts directly in Slack for immediate follow-up. How it works A manual trigger starts the workflow and passes your search parameters (country, platform, lead count) to the ScraperCity store-leads API. The API returns a runId immediately. Because scrapes can take 10--60 minutes, the workflow enters an async polling loop -- waiting 60 seconds between each status check. Once the scrape status returns SUCCEEDED, the workflow downloads the full CSV result set. A Code node parses the CSV, removes duplicates, and formats each lead into a clean Slack message block. Each contact (store name, email, phone, social links) is posted as a structured Slack message so your team can act on leads in real time. How to set up Create a ScraperCity account at scrapercity.com and copy your API key. In n8n, add an HTTP Header Auth credential named ScraperCity API Key with the header name Authorization and value Bearer YOUR_KEY. Add a Slack credential (OAuth2) and connect it to the Post Lead to Slack node. In the Configure Search Parameters node, update countryCode, totalLeads, and slackChannel to match your needs. Click Execute workflow to run. Requirements ScraperCity account and API key (scrapercity.com) n8n instance (cloud or self-hosted) Slack workspace with a bot token and target channel How to customize the workflow Change platform in Configure Search Parameters from shopify to woocommerce to target WooCommerce stores instead. Increase totalLeads up to 5000 per run. Add a Filter node after CSV parsing to keep only leads with verified emails. Replace the Slack node with a Google Sheets or HubSpot node to store leads in a CRM.

Who’s it for This template is ideal for recruiters, founders, sales teams, and lead-generation specialists who want to quickly collect LinkedIn profiles based on role, industry, and region. It is perfect for users who want profile lists for outreach, research, hiring, or market analysis without manually searching LinkedIn. What it does / How it works This workflow begins with a web form where you enter three inputs: position, industry, and region. Once the form is submitted, the workflow performs a Google Custom Search query restricted to LinkedIn profile URLs. The results are processed to extract structured profile information such as: Name Job title (cleaned using custom logic) LinkedIn profile link Description / bio snippet Profile image URL The workflow automatically handles pagination by detecting whether more results are available and continues fetching until the limit is reached. All extracted profiles are appended or updated in a Google Sheet so you always maintain an organized and deduplicated list. Requirements Google Sheets OAuth2 credentials Google Custom Search API key Google CSE (Custom Search Engine) ID A Google Sheet with the required columns (name, title, profile link, description, image link, searched position, searched industry, searched region) How to set up Connect your Google Sheets credentials. Add your Custom Search API key and CSE ID inside the HTTP Request node. Select your target Google Sheet in the “Append or update row in sheet” node. Open the form URL and submit your position, industry, and region. Run the workflow to begin scraping profiles. How to customize the workflow Modify search query structure for niche industries Add enrichment tools (Hunter.io, Clearbit, People Data) Expand pagination limit beyond the default Add filters to remove non-relevant results Output data to CRM tools like HubSpot, Notion, Airtable, or Sheets

🚀 Convert PDF to MCQ Question Bank in Excel with AI (Gemini) Convert any PDF into a structured Multiple Choice Question (MCQ) bank with answer keys and explanations — fully automated using n8n and Google Gemini. 🎯 Use Case Teachers & Educators Trainers & Course Creators HR & Corporate Training Teams EdTech Builders ⚙️ Features Webhook-based PDF upload File validation (max 5MB + file existence check) PDF text extraction Automatic text chunking AI-generated MCQs using Google Gemini Clean JSON parsing Export to Excel (.xlsx) Upload to Google Drive Send results via Email & Telegram 🔄 Workflow Steps Webhook Trigger Validate File Conditional Check (Success / Failed) Extract Text from PDF Chunk Text Generate MCQs (Google Gemini) Clean JSON Output Convert to Excel Upload to Google Drive Send via Telegram Send via Email 🔌 Requirements n8n (self-hosted or cloud) Google Gemini API Key Google Drive credentials Email (SMTP / Gmail) Telegram Bot Token 📥 How to Use Send POST request to webhook with form-data: file → PDF file email → (optional) telegram_chat_id → (optional) 📤 Output Excel file with MCQs Stored in Google Drive Delivered via Email / Telegram ⚠️ Notes Max file size: 5MB Works best with text-based PDFs AI output quality depends on input clarity 💡 Ideas for Improvement Difficulty level classification Multi-language support LMS export (Moodle, Google Forms) Bulk PDF processing 💰 Commercial Use This workflow can be used for: Internal automation Client services Digital product monetization ❤️ Support If you find this useful: Upvote on n8n Share with others

How It Works This workflow automates legal case tracking, deadline management, and exception handling for law firms, corporate legal departments, and court systems managing complex litigation portfolios. Designed for attorneys, paralegals, and legal operations teams, it solves the challenge of monitoring court filings, tracking critical deadlines, identifying case exceptions, and coordinating multi-stakeholder responses while preventing costly missed deadlines and procedural violations. The system schedules regular monitoring (every 15 minutes for time-sensitive matters), fetches court case data from legal databases, validates filings through AI agents (Classifier categorizes case types and urgency, Validation confirms data accuracy), checks for exceptions requiring immediate attention, and orchestrates specialized responses through Administration Orchestration Agent coordinating multiple sub-agents: Admin Agent manages administrative tasks, Deadline Tracking monitors critical dates, Exception Escalation handles urgent matters with Gmail and Slack alerts. Routes findings by validation status—validated cases store normally while exceptions trigger multi-channel notifications and specialized handling. Organizations reduce missed deadline risk by 95%, automate routine case administration, ensure consistent procedural compliance, and enable attorneys to focus on legal strategy rather than docket management. Setup Steps Connect Schedule Trigger for monitoring frequency Configure court data sources with API credentials Add AI model API keys to Classifier Validation Agent and Administration Orchestration Agent nodes Define case classification rules and exception criteria in agent prompts based on jurisdiction requirements Set deadline thresholds for alert triggers Link Gmail credentials for attorney and client notifications with templated messages Configure Slack webhooks for urgent exception alerts to legal team channels Prerequisites Court system API access (PACER, state portals), case management system integration Use Cases Litigation deadline tracking, court filing monitoring, statute of limitations management Customization Modify classification rules for practice area specializations (patent, corporate, criminal) Benefits Reduces missed deadline risk by 95%, automates routine case administration tasks

Automate B2B lead research from Google Sheets to Airtable With BrowserAct This workflow automates the time-consuming process of B2B market research. It takes a list of company website URLs from a Google Sheet, uses BrowserAct to scrape their profiles and news sections, analyzes the data using AI to determine strategic focus and key activities, and saves a comprehensive executive summary into an Airtable database. Target Audience Sales operations managers, SDRs (Sales Development Representatives), market researchers, and venture capital analysts who need to process large volumes of company data efficiently. How it works Ingest Data: The workflow retrieves a list of target company URLs from a Google Sheet. Scrape Content: It loops through each URL and triggers BrowserAct (using the "B2B Contact Research" template) to scrape company profiles, about pages, and news sections. Analyze & Stage: An AI Agent (using OpenRouter/GPT-5) processes the raw scraped text to identify whether it is news or profile data, extracting key insights like strategic focus and recent updates. This raw analysis is staged back into the Google Sheet. Synthesize: The workflow retrieves the staged data and aggregates it. Final Summary: A second AI Agent compiles all data points into a cohesive "Research Record," writing a high-impact executive summary and formatting notes with Markdown. Database Entry: The final structured data (Name, Notes, Strategic Focus) is created as a new record in Airtable. How to set up Configure Credentials: Connect your BrowserAct, Google Sheets, Airtable, and OpenRouter accounts in n8n. BrowserAct Template: Ensure you have the B2B Contact Research template saved in your BrowserAct account. Prepare Google Sheet: Create a Google Sheet with a tab named "DataBase". Add the headers listed below. Populate the Page URL column with the companies you want to research. Configure Nodes: Open the Google Sheets nodes and select your file. Open the Airtable node and select your Base and Table. Run: Execute the workflow to start processing the list. Google Sheet Headers To use this workflow, create a Google Sheet with the following headers: Page URL (Input - put your links here) Page Data (Output - leave blank, populated by bot) row_number (Output - leave blank, populated by bot) Requirements BrowserAct* account with the *B2B Contact Research** template. Google Sheets** account. Airtable** account. OpenRouter** account (or credentials for a specific LLM like GPT-4o or Gemini). How to customize the workflow Change the CRM: Replace the final Airtable node with HubSpot, Salesforce, or Pipedrive nodes to inject research directly into your CRM deals. Adjust AI Prompts: Modify the system prompt in the "Analyze the Company Page" agent to focus on specific criteria relevant to your business (e.g., look specifically for "pricing models" or "hiring trends"). Email Alerts: Add a Gmail or Slack node at the end of the workflow to notify your sales team immediately when a high-value prospect has been researched. Need Help? How to Find Your BrowserAct API Key & Workflow ID How to Connect n8n to BrowserAct How to Use & Customize BrowserAct Templates Workflow Guidance and Showcase Video How to Structure Airtable for Automated Company Research (n8n Tutorial)

📊 Description This workflow automatically classifies new Stack Overflow questions by topic, generates structured FAQ content using GPT-4o-mini, logs each entry in Google Sheets, saves formatted FAQs in Notion, and notifies your team on Slack — ensuring your product and support teams stay aligned with real-world developer discussions. 🤖💬📚 ⚙️ What This Template Does Step 1: Monitors Stack Overflow RSS feeds for new questions related to your selected tags. ⏱️ Step 2: Filters out irrelevant or incomplete questions before processing. 🧹 Step 3: Uses OpenAI GPT-4o-mini to classify each question into a topic category (Frontend, Backend, DevOps, etc.). 🧠 Step 4: Generates structured FAQ content including summaries, technical insights, and internal guidance. 📄 Step 5: Saves formatted entries into your Notion knowledge-base database. 📚 Step 6: Logs all FAQ data into a connected Google Sheet for analytics and tracking. 📊 Step 7: Sends real-time Slack notifications with quick links to the new FAQ and the original Stack Overflow post. 🔔 Step 8: Provides automatic error detection — any failed AI or Notion step triggers an instant Slack alert. 🚨 💡 Key Benefits ✅ Builds a continuously updated, AI-driven knowledge base ✅ Reduces repetitive support and documentation work ✅ Keeps product and dev teams aware of trending community issues ✅ Enhances internal docs with verified Stack Overflow insights ✅ Maintains an audit trail via Google Sheets ✅ Alerts your team instantly on errors or new FAQs 🧩 Features Automatic Stack Overflow RSS monitoring Dual-layer OpenAI integration (Topic Classification + FAQ Generation) Structured Notion database integration Google Sheets logging for analytics Slack notifications for new FAQs and error alerts Custom tag-based question filtering Near real-time updates (every minute) Built-in error handling for reliability 🔐 Requirements OpenAI API Key (GPT-4o-mini access) Notion API credentials with database access Google Sheets OAuth2 credentials Slack bot token with chat:write permissions Stack Overflow RSS feed URL for your preferred tags 👥 Target Audience SaaS or product teams building internal FAQ and knowledge systems Developer relations and documentation teams Customer-support teams automating knowledge reuse Technical communities curating content from Stack Overflow 🧭 Setup Instructions Add your OpenAI API credentials in n8n. Connect your Notion database and update the page or database ID. Connect Google Sheets credentials and select your tracking sheet. Connect your Slack account and specify your notification channel. Update the RSS Feed URL with your chosen Stack Overflow tags. Run the workflow manually once to test connectivity, then enable automation.

Author: Jadai Kongolo Overview This comprehensive n8n workflow automates the entire production pipeline for creating viral "versus" style battle videos. The system generates dramatic AI-powered fight scenes between animals (or any characters you choose), complete with photorealistic imagery, cinematic effects, and automatic multi-platform publishing. Perfect for content creators looking to generate engaging short-form content at scale without manual editing or design work. Use Cases Viral Social Media Content: Automatically produce trending "X vs Y" battle videos that perform exceptionally well on TikTok, Instagram Reels, and YouTube Shorts. These comparison-style videos consistently generate high engagement and shares. Educational Entertainment: Create visually stunning educational content comparing animals, historical figures, sports teams, or any competitive matchups while maintaining viewer interest through dramatic AI-generated imagery. Automated Content Pipeline: Build a hands-free content factory that can produce multiple videos per day on schedule, complete with automatic posting to all major social platforms through integrated social media management tools. 👉 check out the UGC version of this here How It Works Stage 1 - Scene Generation The workflow begins by fetching a main character from your Google Sheets database (filtered by "To Do" status). An AI agent powered by GPT-4.1-mini then generates eight unique opponents from your specified category, ensuring each comes from a different environment or background for maximum variety and interest. Stage 2 - AI Image Creation The system creates three distinct types of images for each matchup: Close-Up Portraits: Generates fierce, intimidating close-up shots of both the main character and each opponent using Flux image generation through PiAPI. The AI creates hyper-realistic, photorealistic images showing each character roaring with detailed textures, dramatic lighting, and threatening expressions. Battle Aftermath Scenes: A separate AI agent determines the realistic winner based on each character's strengths, then generates a dramatic full-body scene showing the victor standing dominantly over the defeated opponent. These images include visible battle scars, wounds, and cinematic composition that makes the outcome unmistakably clear. The workflow includes intelligent polling mechanisms (90-second waits) to ensure all images are fully generated before proceeding, then aggregates and stores all image URLs in your Google Sheet for reference. Stage 3 - Video Assembly Using Creatomate's video rendering API, the workflow combines all generated images with background music and animated transitions into a polished final video. The template creates a fast-paced montage showing all eight battles with "VS" graphics and dynamic cuts timed to music beats. Stage 4 - Multi-Platform Publishing Once rendered, the video is automatically uploaded to Blotato's social media management platform and simultaneously published to: Instagram Reels** with optimized captions TikTok** with proper AI-generated content disclosure YouTube Shorts** as unlisted for review The workflow updates your Google Sheet with "Created" status and final video URL for tracking and analytics. Customization Options Content Themes Modify the Google Sheet to change from animals to any category: superheroes, historical warriors, vehicles, mythical creatures, sports teams, etc. Adjust AI prompts in the "Scene Creator" node to control opponent selection criteria Edit the "Image Prompt Generator" to customize visual style (fantasy, sci-fi, realistic, cartoon, etc.) Video Production Change video dimensions in "Generate Close Ups" and "Generate Scene" nodes for different platform requirements Replace the Creatomate template with your own design for different visual styles Swap background music by updating the music source URL in the "Render Video" node Adjust the number of battles per video (currently 8 scenes) Publishing Settings Configure posting schedules via the Schedule Trigger node Modify platform-specific settings (privacy levels, comments, duets) in Instagram/TikTok/YouTube nodes Add or remove social platforms by connecting additional Blotato API endpoints Customize captions using data from your Google Sheet AI Models Switch between different OpenRouter models for cost/quality tradeoffs Use GPT-4.1 for complex winner determination and GPT-4.1-mini for faster scene generation Experiment with different Flux models through PiAPI for various artistic styles Prerequisites Google Sheets**: Connected Google account with access to the workflow template OpenRouter API**: For GPT-4.1 and GPT-4.1-mini access PiAPI Account**: For Flux image generation (use referral code for bonus credits) Creatomate Account**: For video rendering with template access Blotato Account**: For multi-platform social media publishing (use promo code "NATE30" for 30% off for 6 months) 🛠️ Setup Guide Make a copy of this Google Sheet Template and connect it to the five Google Sheet nodes in the workflow: Get Main Character Add Close Ups Add Winner Get Elements Update Video Status Connect your OpenRouter API key to the two OpenRouter nodes in the "Output Parser & Chat Models" section: GPT 4.1-mini GPT 4.1 Create a PiAPI account and connect your API key to: Generate Close Ups Generate Scene Get Close Ups Get Winners Create a Creatomate account and connect your template ID and API key to the Render Video node. You can duplicate the same template shown in the video by using the source code linked in the same Skool post where you downloaded the workflow. Connect your Blotato account and get your API key to enable auto-publishing: Configure the Upload to Blotato node Add your account IDs to Instagram, TikTok, and YouTube nodes Customize the Schedule Trigger node to set your desired posting frequency (daily, weekly, etc.) The Generate authentic, influencer-style UGC videos on autopilot version of this AI video generator can be found here.

WooCommerce Failed Order Fetch, Airtable Logging & Slack Alerts This workflow automatically checks WooCommerce for failed orders on a schedule, processes each order individually, prevents duplicate entries using Airtable, stores new failed orders centrally, and sends clear AI-generated Slack alerts. It ensures clean data, avoids duplicate records and helps teams act quickly on failed payments. Quick Implementation Steps Set your WooCommerce domain in the Set WooCommerce Domain node. Add WooCommerce API Key + Secret in the Fetch Failed Orders From WooCommerce node. Connect your Airtable Base/Table in the Search Records and Save Failed Order to Airtable nodes. Add your OpenAI API key to the AI node. Connect your Slack account + target channel. Enable the workflow and let it run automatically. What It Does This workflow continuously monitors your WooCommerce store for failed orders without relying on webhooks. On every scheduled run, it fetches all orders marked as failed, processes them one by one, and checks Airtable using the order\_id to see whether the order has already been logged. If the order already exists, the workflow safely stops processing for that order and optionally sends an informational Slack message. If the order is new, the workflow formats the data, saves it into Airtable, generates a clean AI-written summary, and sends a Slack alert to the team. This approach ensures data accuracy and prevents duplicate records. Who’s It For WooCommerce store owners needing reliable failed-payment tracking Finance teams monitoring recovery opportunities Support teams requiring instant alerts Developers building reusable, idempotent workflows Agencies managing multiple WooCommerce stores Ops teams using Airtable for reporting and audits Requirements to Use This Workflow Active n8n instance (cloud or self-hosted) WooCommerce store with REST API access Airtable account with Base and Table Slack workspace with API access OpenAI API key (for AI-generated messages) Permission to write data to Airtable and Slack How It Works & How To Set Up Step 1: Configure the Scheduler Set how often the workflow runs in Check Failed Orders (Scheduler) (e.g., every 5 minutes, 15 minutes, or hourly). Step 2: Set Your WooCommerce Domain In Set WooCommerce Domain, enter your store domain: Plain textANTLR4BashCC#CSSCoffeeScriptCMakeDartDjangoDockerEJSErlangGitGoGraphQLGroovyHTMLJavaJavaScriptJSONJSXKotlinLaTeXLessLuaMakefileMarkdownMATLABMarkupObjective-CPerlPHPPowerShell.propertiesProtocol BuffersPythonRRubySass (Sass)Sass (Scss)SchemeSQLShellSwiftSVGTSXTypeScriptWebAssemblyYAMLXML yourstore.com This value is reused across the workflow. Step 3: Fetch Failed Orders In Fetch Failed Orders From WooCommerce, configure Basic Authentication using: Consumer Key Consumer Secret The workflow fetches: Plain textANTLR4BashCC#CSSCoffeeScriptCMakeDartDjangoDockerEJSErlangGitGoGraphQLGroovyHTMLJavaJavaScriptJSONJSXKotlinLaTeXLessLuaMakefileMarkdownMATLABMarkupObjective-CPerlPHPPowerShell.propertiesProtocol BuffersPythonRRubySass (Sass)Sass (Scss)SchemeSQLShellSwiftSVGTSXTypeScriptWebAssemblyYAMLXML https://{{wc_domain}}/wp-json/wc/v3/orders?status=failed Step 4: Loop & Duplicate Check Each failed order is processed individually using Loop Over Items. The workflow searches Airtable using Search Records to check whether the order\_id already exists. A Merge node ensures safe data handling, and the IF node decides whether the order is a duplicate or a new entry. Step 5: Format New Order Data The Format Order Data node normalizes WooCommerce data, maps failure reasons, builds admin and retry URLs, and prepares the data for storage. Step 6: Save to Airtable New failed orders are saved in Airtable using Save Failed Order to Airtable. Duplicate orders are skipped to prevent data duplication. Step 7: Generate & Send Slack Alerts For new failed orders, the workflow generates a concise AI-based summary and sends it to Slack. Duplicate orders can optionally trigger an informational Slack message. How To Customize Polling Frequency:** Change scheduler interval Duplicate Logic:** Modify Airtable search or IF condition Stored Fields:** Adjust Airtable field mappings Formatting Rules:* Edit JavaScript in *Format Order Data** Slack Message Style:** Update AI prompt Optional Enhancements Retry-payment tracking with attempts count Customer notification via email or SMS Jira/Trello ticket creation Google Sheets or BI dashboard sync Multi-store WooCommerce support Example Use Cases Centralized failed-payment tracking in Airtable Instant Slack alerts for support and finance teams Clean reporting without duplicate records Faster issue resolution with AI summaries Scalable foundation for recovery automation Troubleshooting Guide | Issue | Possible Cause | Solution | | --------------------------- | ----------------------------------- | ------------------------------------------------------ | | No orders fetched | Wrong WooCommerce domain or API URL | Check Set WooCommerce Domain and HTTP Request URL | | 401 Unauthorized | Invalid API key/secret | Regenerate keys from WooCommerce → REST API | | Airtable record not created | Field mismatch | Confirm column names and types in Airtable | | Slack message empty | AI node prompt or path mismatch | Confirm output path: $json.output[0].content[0].text | | Workflow not running | Scheduler disabled | Ensure workflow is Active | | API timeout | Store too slow or blocked | Whitelist server IP or increase timeout in HTTP node | Need Help? If you need assistance customizing this workflow, adding new features or integrating more systems, feel free to reach out. The n8n automation team at WeblineIndia can help with: Advanced WooCommerce automations Multi-store workflows Airtable/Slack/OpenAI integrations Custom logic, validations and data pipelines And many such advanced automation solutions. We’re here to support you in scaling your automation journey.

Sometimes you need the rich text field to be in HTML instead of Markdown. This template either syncs a single record or all records at once. Youtube tutorial

Overview Healthcare organizations face significant challenges in digitizing and processing medical records while maintaining strict HIPAA compliance. This workflow provides a secure, automated solution for extracting clinical data from various medical documents including discharge summaries, lab reports, clinical notes, prescription records, and scanned medical images (JPG, PNG). What You Can Do Extract clinical data from medical documents while maintaining HIPAA compliance Process handwritten notes and scanned medical images with OCR Automatically identify and protect PHI (Protected Health Information) Generate structured data from various medical document formats Maintain audit trails for regulatory compliance Who It's For Healthcare providers, medical billing companies, clinical research organizations, health information exchanges, and medical practice administrators who need to digitize and extract data from medical records while maintaining HIPAA compliance. The Problem It Solves Manual medical record processing is time-consuming, error-prone, and creates compliance risks. Healthcare organizations struggle to extract structured data from handwritten notes, scanned documents, and various medical forms while protecting PHI. This template automates the extraction process while maintaining the highest security standards for Protected Health Information. Setup Instructions: Configure Google Drive credentials with proper medical record access controls Install the PDF Vector community node from the n8n marketplace Configure PDF Vector API credentials with HIPAA-compliant settings Set up secure database storage with encryption at rest Define PHI handling rules and extraction parameters Configure audit logging for regulatory compliance Set up integration with your Electronic Health Record (EHR) system Key Features: Secure retrieval of medical documents from Google Drive HIPAA-compliant processing with automatic PHI masking OCR support for handwritten notes and scanned medical images Automatic extraction of diagnoses with ICD-10 code validation Medication list processing with dosage and frequency information Lab results extraction with reference ranges and flagging Vital signs capture and normalization Complete audit trail for regulatory compliance Integration-ready format for EHR systems Customization Options: Define institution-specific medical terminology and abbreviations Configure automated alerts for critical lab values or abnormal results Set up custom extraction fields for specialized medical forms Implement medication interaction warnings and contraindication checks Add support for multiple languages and international medical coding systems Configure integration with specific EHR platforms (Epic, Cerner, etc.) Set up automated quality assurance checks and validation rules Implementation Details: The workflow uses advanced AI with medical domain knowledge to understand clinical terminology and extract relevant information while automatically identifying and protecting PHI. It processes various document formats including handwritten prescriptions, lab reports, discharge summaries, and clinical notes. The system maintains strict security protocols with encryption at rest and in transit, ensuring full HIPAA compliance throughout the processing pipeline. Note: This workflow uses the PDF Vector community node. Make sure to install it from the n8n community nodes collection before using this template.

Simplify event planning with this automated n8n workflow. Triggered by incoming requests, it fetches speaker and audience data from Google Sheets, analyzes profiles and preferences, and generates optimized session recommendations. The workflow delivers formatted voice responses and updates tracking data, ensuring organizers receive real-time, tailored suggestions. 🎙️📊 Key Features Real-time analysis of speaker and audience data for personalized recommendations. Generates optimized session lineups based on profiles and preferences. Delivers responses via voice agent for a seamless experience. Logs maintain a detailed recommendation history in Google Sheets. Workflow Process The Webhook Trigger node initiates the workflow upon receiving voice agent or external system requests. Parse Voice Request** processes incoming voice data into actionable parameters. Fetch Database** retrieves speaker ratings, past sessions, and audience ratings from Google Sheets. Calculate & Analyze** combines voice request data with speaker profiles and audience insights for comprehensive matching. AI Optimization Engine** analyzes speaker-audience fit and recommends optimal session lineups. Format Recommendations** structures the recommendations for voice agent response. Voice Agent Response** returns formatted recommendations to the user with natural language summary and structured data. Update Tracking Sheet** saves recommendation history and analytics to Google Sheets. If errors occur, the Check for Errors node branches to: Format Error Response prepares an error message. Send Error Response delivers the error notification. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set up the Webhook Trigger with your voice agent or external system's API credentials. Configure the AI Optimization Engine node with a suitable language model (e.g., Anthropic Chat Model). Test the workflow by sending sample voice requests and verifying recommendations. Adjust analysis parameters as needed for specific event requirements. Prerequisites Google Sheets OAuth2 credentials Voice agent API or integration service AI/LLM service for optimization (e.g., Anthropic) Structured speaker and audience data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Speaker Name Rating Past Sessions Audience Rating Preferences Updated At Modification Options Customize the Calculate & Analyze node to include additional matching criteria (e.g., topic expertise). Adjust the AI Optimization Engine to prioritize specific session formats or durations. Modify voice response templates in the Voice Agent Response node with branded phrasing. Integrate with event management tools (e.g., Eventbrite) for live data feeds. Set custom error handling rules in the Check for Errors node. Discover more workflows – Get in touch with us

Scrape Google Maps leads and find emails with Apify and Anymailfinder Short Description This workflow automates lead generation by scraping business data from Google Maps using Apify, enriching it with verified email addresses via Anymailfinder, and storing the results in a NocoDB database. It's designed to prevent duplicates by checking against existing records before saving new leads. Key Features Automated Scraping**: Kicks off a Google Maps search based on your query, city, and country. Email Enrichment**: For businesses with a website, it automatically finds professional email addresses. Data Cleaning**: Cleans website URLs to extract the root domain, ignoring social media links. Duplicate Prevention**: Checks against existing entries in NocoDB using the Google placeId to avoid adding the same lead twice. Structured Storage**: Saves enriched lead data into a structured NocoDB database. Batch Processing**: Efficiently handles and loops through all scraped results. Who This Workflow Is For Sales Teams** looking for a source of local business leads. Marketing Agencies** building outreach campaigns for local clients. Business Developers** prospecting for new partnerships. Freelancers** seeking clients in specific geographical areas. How It Works Trigger: The workflow starts when you submit the initial form with a business type (e.g., "plumber"), a city, a country code, and the number of results you want. Scrape Google Maps: It sends the query to Apify to scrape Google Maps for matching businesses. Process Leads: The workflow loops through each result one by one. Clean Data: It extracts the main website domain from the URL provided by Google Maps. Check for Duplicates: It queries your NocoDB database to see if the business (placeId) has already been saved. If so, it skips to the next lead. Find Emails: If a valid website domain exists, it uses Anymailfinder to find associated email addresses. Store Lead: The final data, including the business name, address, phone, website, and any found emails, is saved as a new row in your NocoDB table. Setup Requirements Required Credentials Apify API Key**: To use the Google Maps scraping actor. Anymailfinder API Key**: For email lookup. NocoDB API Token**: To connect to your database for storing and checking leads. Database Structure You need to create a table in your NocoDB instance with the following columns. The names should match exactly. Table: leads (or your preferred name) title (SingleLineText) website (Url) phone (PhoneNumber) email (Email) email_validation (SingleLineText) address (LongText) neighborhood (SingleLineText) rating (Number) categories (LongText) city (SingleLineText) country (SingleLineText) postal code (SingleLineText) domain (Url) placeId (SingleLineText) - Important for duplicate checking date (Date) Customization Options Change Trigger**: Replace the manual Form Trigger with a Schedule Trigger to run searches automatically or an HTTP Request node to start it from another application. Modify Scraper Parameters**: In the "Scrape Google Maps" node, you can adjust the Apify actor's JSON input to change language, include reviews, or customize other advanced settings. Use a Different Database**: Replace the NocoDB nodes with nodes for Google Sheets, Baserow, Airtable, or any SQL database to store your leads. Installation Instructions Import the workflow into your n8n instance. Create the required table structure in your NocoDB instance as detailed above. Configure the credentials for Apify, Anymailfinder, and NocoDB in the respective nodes. In the two NocoDB nodes ("Get all the recorded placeIds" and "Create a row"), select your project and table from the dropdown menus. Activate the workflow. You can now run it by filling out the form in the n8n UI.