Workflow Templates

⚠️ This template uses only official n8n nodes. No community nodes required. 🧑‍💼 Who is this for? This workflow is designed for: Legal tech founders Marketing freelancers or consultants Agencies supporting lawyers and small law firms Anyone doing outbound outreach in the legal niche ❓ What problem is this solving? LinkedIn is a goldmine for targeting legal professionals — but scraping and personalizing outreach is tedious and expensive. Most tools either: Require paid LinkedIn Sales Navigator Can’t personalize at scale Violate LinkedIn’s TOS This workflow solves that by using free Google Search, OpenRouter AI, and GPT-4o to find, enrich, and message up to 1,000 solo lawyers per day — without using browser automation or scrapers. ⚙️ What this workflow does Uses Google Programmable Search to find solo lawyers and small firm founders on LinkedIn Parses each profile’s name, title, profile URL, and snippet Saves raw lead data to Google Sheets Uses OpenRouter Sonar Pro to enrich each profile with external content Generates a personalized, 1-line message using GPT-4o Appends the final message into Google Sheets for outreach 🛠️ Setup Estimated time: 15–20 minutes ✅ Google Programmable Search Enable the Custom Search API on Google Cloud Create a programmable search engine set to search the full web Copy your API key and CX ID ✅ Google Sheets Create a sheet with columns: Name, Title, Profile URL, Outreach Message Share the sheet with your OAuth-connected Google account ✅ OpenRouter Sign up at openrouter.ai Fund with at least $5 and generate your API key Use the model perplexity/sonar-pro for real-time research ✅ GPT-4o (optional) You can use your OpenAI key or route GPT-4o via OpenRouter All setup-specific values are marked clearly in sticky notes and placeholders. 🛠️ How to customize this workflow to your needs Change the Google search query to match your industry (e.g., "founder" AND "therapist" site:linkedin.com/in) Modify the AI prompt to match your tone (formal, casual, humorous) Connect the final output to your CRM (like HubSpot, Airtable, etc.) Add a second outreach message variant to A/B test performance 📌 Sticky Notes & Annotations All nodes are clearly renamed for understandability (e.g., Find Lawyer Profiles, Parse LinkedIn Search Results) Color-coded sticky notes explain: Setup instructions Required credentials Use case 🗂 Category AI Sales Marketing

What this template does This workflow will collect order data as it is produced, then send a summary email of all orders at the end of every day, formatted in a table. It receives new orders via webhook and stores in Airtable. At 7PM every day, it sends a summary email with the day's orders in a HTML table Setup: Instructions Video Create a new table in Airtable and give it a field time with type date, orderID with type number, and orderPrice also with type number. Create a new access token if you haven't already at https://airtable.com/create/tokens/new. Make sure to give the token the scopes data.records:read, data.records:write, schema.bases:read and access to whichever table you choose to store the orders. A pop-up window appears with the token. Use this token to make Create New Credential > Access Token for Airtable in the Store Order and Airtable Get Today's Orders nodes. Create access credentials for your Gmail as described here: https://developers.google.com/workspace/guides/create-credentials. Use the credentials from your client_secret.json in the Send to Gmail node. In the Store Order node, change Base and Table to the database and table in your Airtable account you wish to use to store orders. Make sure to use these same values in the Airtable Get Today's Orders node. Every time an order is created in your system, send a POST request to Webhook from your order software. Each request must contain a single order containing fields 'orderID' and 'orderPrice' (or, edit Set Order Fields to select which incoming fields you wish to save) Change the schedule time for sending email from Everyday at 7PM to whichever time you choose. Test: Activate the workflow. From the node Webhook, copy Production URL Send the following CURL request to the URL given to you: curl -X POST -H "Content-Type: application/json" -d '{"orderID": 12345, "orderPrice": 99.99}' YOUR_URL_HERE It should say Node executed successfully. Now check your Airtable and confirm the order was stored in the right place.

A smart personal assistant that can reason, search, calculate, and remember — powered by Google Gemini and ready in one click. Most AI agents only respond — this one thinks before replying, pulls in real-time facts, does the math, and even remembers the last 5 things you said. 🔧 How it works This template builds a conversational agent using the Google Gemini API. It uses multiple tools like: 🧠 Think – to reason step-by-step 🔍 SerpAPI – to search live data on Google ➗ Calculator – to solve math problems 💾 Memory – to remember short-term chat history You can embed this agent into a chatbot, web app, or automate any customer support, research, or productivity workflow. 🧠 Your agent will: Understand what you're asking Think logically using the Think tool Search facts in real-time using SerpAPI Calculate numbers using a math engine Recall past context using a memory buffer And respond clearly — just like a real assistant. 🧑‍💼 Who is this template for? This template is ideal for: Creators & developers building AI agents Teams needing a Gemini-powered assistant Beginners exploring LangChain + n8n Anyone curious about combining LLMs + tools + memory 🚀 How to set up Plug in your Google Gemini API key Add your SerpAPI key Run the workflow and start chatting! Everything is pre-wired for you — just import and go. 📬 Use cases You can connect this agent to: Telegram bots 🤖 WhatsApp via Twilio 📱 Slack, Discord, or Gmail 💬 Or just trigger it inside n8n manually 🔁 👉 Check out my other templates https://n8n.io/creators/digimetalab

Transform your creative sparks into professional Instagram Reel scripts instantly! This AI-powered workflow takes your raw ideas (text or voice messages) via Telegram and generates complete, viral-ready Reel scenarios with hooks, scripts, captions, and visual concepts. Who is this template for? This template is perfect for: Content creators looking to streamline their Reel production process Social media managers who need to generate multiple Reel concepts quickly Marketing professionals seeking data-driven, psychology-based content strategies Influencers and entrepreneurs who want to maintain consistent, engaging content Small business owners looking to create viral marketing content without hiring expensive copywriters Anyone who struggles with writer's block or wants to improve their Instagram engagement What this template does This comprehensive workflow provides a complete Reel creation assistant that: 🎯 Accepts Multiple Input Types: Text messages with your Reel ideas Voice notes that get automatically transcribed Processes ideas in real-time through Telegram 🧠 AI-Powered Content Generation: Creates 3 attention-grabbing hook variants designed to stop the scroll Generates a complete 30-60 second script with Hook, Subtitle, Body, and Call-to-Action Writes engaging captions that complement (not repeat) your video content Provides specific visual concepts with cinematic direction for filming 📊 Smart Features: Memory system that remembers your conversation context for personalized suggestions Optional Google Sheets integration to automatically log and organize all your Reel ideas Error handling for seamless user experience Instant delivery of results back to your Telegram chat 🎨 Professional Quality Output: Scripts based on proven marketing psychology from industry legends Hooks designed using viral content strategies Visual concepts that are specific and actionable (not generic "film yourself" advice) Captions optimized for engagement and shareability Sample Results Input (Idea): How I Saved 10 Hours a Week with Blog Automation? Output: 💡 Hook (variants): "Blogging doesn't have to be a time-suck. Here's my secret…" "Is blogging eating up your spare time? Let's fix that!" "Unlock 10 hours a week AND keep your blog thriving!" 🎬 Script: Hook: "Blogging doesn't have to be a time-suck. Here's my secret…" Subtitle: "Maximize your time with blog automation hacks!" Body: "Picture this: writing, editing, posting, and promoting your blog without breaking a sweat. I was buried under endless tasks until I discovered blog automation. Scheduling posts, auto-publishing, automating social shares—it's a game-changer. 10 hours a week, back in my pocket! More time for creativity or even a break. Imagine what automation could do for your content game." CTA: "Which blog task do you wish was automated? Drop a comment!" 📝 Reel Caption: Blog automation isn't just convenience—it's freedom. What will you create with your extra time? 📸 Visual Idea: Open with a whirlwind of papers and sticky notes symbolizing chaos. Transition to a person seamlessly typing on a laptop, where blog posts are auto-scheduled. Quick cuts show blog shares and responses happening automatically. Conclude with a serene scene: the person outdoors, notebook in hand, jotting ideas peacefully on a sunny day. Setup Instructions Prerequisites: Telegram account OpenAI API account with GPT-4 access Google account (optional, for logging ideas) Step 1: Create Your Telegram Bot Open Telegram and search for @BotFather Send /newbot and follow the instructions to create your bot Save the Bot Token you receive - you'll need this for n8n Send /setprivacy to @BotFather, select your bot, and choose "Disable" to allow the bot to read all messages Step 2: Get Your OpenAI API Key Visit OpenAI's API platform Create an account or log in Navigate to API Keys section Create a new API key and save it securely Ensure you have access to GPT-4 models (required for optimal results) Step 3: Configure the Workflow Import this template into your n8n instance Set up Telegram credentials: Add your Bot Token to all Telegram nodes Test the connection Configure OpenAI credentials: Add your API key to the "OpenAI Chat Model" and "Transcribes audio" nodes Verify GPT-4o model access Optional - Google Sheets setup: Create a new Google Sheet with columns: Status, Date, Description, Script Connect your Google account to the "Google Sheets" node Select your spreadsheet and sheet Step 4: Activate and Test Click "Activate" in the top-right corner of your workflow Open Telegram and find your bot Send a test message like "Create a Reel about morning routines" Verify you receive a complete Reel scenario response Step 5: Start Creating! Send text ideas directly to your bot Record voice notes with your concepts Receive professional Reel scenarios within seconds Use the optional Google Sheets integration to build your content library Pro Tips: Be specific with your ideas for better results The AI remembers your conversation context, so you can refine ideas iteratively Voice messages work great for capturing spontaneous ideas on-the-go Review the generated visual concepts - they're designed to be immediately actionable Troubleshooting: Ensure your OpenAI account has sufficient credits Verify your Telegram bot privacy settings allow message reading Check that all credentials are properly configured and tested For Google Sheets issues, confirm the sheet structure matches the expected columns This template transforms the tedious process of content creation into an instant, AI-powered system that delivers professional-quality Reel scenarios whenever inspiration strikes!

Overview The n8n Telegram Gmail Assistant is an intelligent workflow that lets you search and retrieve specific Gmail emails simply by messaging a Telegram bot. Powered by advanced language models, it turns plain-language requests into precise Gmail searches, delivering results directly to your Telegram chat. This no-code automation is perfect for users who want instant, conversational access to their inbox—no Gmail tab required. Key Features Conversational Email Search: Just message the Telegram bot with requests like “Get me all emails from Amazon” or “Show unread emails after 6 June 2025.” The assistant understands sender names, keywords, and date filters—even if you only provide part of the information. AI-Powered Query Parsing: Uses a language model (LLM) to intelligently extract sender, keywords, and date range from your message, then builds an accurate Gmail search query. Flexible Filtering: Supports sender, keywords, ‘after’ and ‘before’ dates, or any combination. Handles both specific and broad queries. Instant Telegram Delivery: Each matching email is formatted with date, sender, subject, and a snippet, and sent as a separate Telegram message for easy reading. Customizable & Extendable: Swap the AI model (Google Gemini or OpenAI), adjust output formatting, and set email limits or read status as needed. How It Works User Sends a Telegram Message: For example, “Get unread emails from Amazon about invoices after 1 June 2025.” AI Interprets the Request: The workflow’s LLM agent extracts sender, keywords, and date filters, converting them into a Gmail search query using Gmail’s syntax (e.g., from:amazon AND (invoice OR invoices) AND after:2025/06/01). Gmail Search: The workflow fetches all matching emails from your connected Gmail account. Message Formatting: Each email is summarized into a concise, emoji-rich Telegram message (date, sender, subject, snippet). Telegram Delivery: Results are sent to your Telegram chat, one message per email. Setup Instructions Create a Telegram Bot: Use @BotFather on Telegram to create a bot and obtain the API token. Connect Telegram to n8n: Add your bot’s API token as a credential in n8n. Connect Gmail Account: Authorize your Gmail account in n8n, set email limits, and choose read/unread status preferences. Configure AI Model: Use your own Google Gemini or OpenAI API key, or select a preferred LLM node in the workflow. Deploy the Workflow: Activate the workflow and start messaging your Telegram bot to retrieve emails instantly. Value Proposition Save Time:** No need to open Gmail or remember search operators—just ask in plain language. Stay Organized:** Instantly filter and retrieve important emails, even on the go. User-Friendly:** No coding required, with clear setup steps and customizable options. Cost-Effective:** Available simply with an n8n subscription—no extra costs or hidden fees of anything. Enjoy the workflow Free Forever within your n8n plan.

🧠 Analyze and Diagnose n8n Workflow Errors Automatically via OpenAI and Email > ⚠️ This template is available on ☁️ Cloud & 🖥️ self-hosted n8n instances with the OpenAI node enabled. 👤 Who is this for? This workflow is designed for n8n developers, automation engineers, and DevOps teams who want to automatically capture and analyze workflow errors, and receive professional HTML-styled diagnostics directly in their inbox. 💥 What problem does this solve? Manually troubleshooting failed workflows in n8n can be time-consuming. This template streamlines error detection by: Capturing workflow failures using the Error Trigger node Diagnosing root causes with the help of OpenAI Sending a fully-formatted, human-readable HTML error report via email Including practical resolutions and next-step suggestions This helps you or your team resolve issues faster and avoid repeated manual debugging. ⚙️ What this workflow does ⚡ Triggers on any n8n workflow error 📦 Extracts relevant error metadata including node, execution ID, and timestamps 🧠 Sends error content to OpenAI for analysis and recommendations 💌 Generates an HTML email report with inline styles and clear formatting 📥 Emails the result to a system administrator or support email 🛠️ Setup Install the OpenAI node in your self-hosted n8n instance. Add your OpenAI API Key securely in credentials. Configure the SMTP Email node with your email credentials. Adjust the Error Trigger to monitor specific workflows or all workflows. Set your preferred admin or dev email address in the final node. 🔧 How to customize this workflow to your needs 🧩 Use a [Set node] to define your variables, such as: Default admin email Workflow filter (optional) ✍️ Customize the prompt sent to OpenAI if you want deeper or more specific analysis 🎨 Modify the email HTML styles to match your brand or internal format 💾 Add additional logging (e.g., to Airtable, Google Sheets, or Notion) for long-term error tracking 📌 Sticky Note Title: Automated Error Reporter with AI-Powered Diagnosis Description: Captures any n8n error, sends it to OpenAI, and emails a beautiful HTML report to the administrator with steps to resolve the issue. Requires OpenAI credentials and SMTP configured.

This workflow contains community nodes that are only compatible with the self-hosted version of n8n. 🧠 Perplexity-Powered Daily AI News Digest (via Telegram) This ready-to-deploy n8n workflow automates the entire process of collecting, filtering, formatting, and distributing daily AI industry news summaries directly to your Telegram group or channel. Powered by Perplexity and OpenAI, it fetches only high-signal AI updates from trusted sources (e.g. OpenAI, DeepMind, HuggingFace, MIT Tech Review), filters out duplicates based on a Google Sheet archive, and delivers beautifully formatted news directly to your team — every morning at 10AM. For more such build and step-by-step tutorials, check out: https://www.youtube.com/@Automatewithmarc 🚀 Key Features: Perplexity AI Integration: Automatically fetches the most relevant AI developments from the last 24 hours. AI Formatter Agent: Cleans the raw feed, removes duplicates, adds summaries, and ensures human-friendly formatting. Google Sheets Log: Tracks previously reported news items to avoid repetition. Telegram Delivery: Sends a polished daily digest straight to your chat, ready for immediate team consumption. Customizable Scheduling: Preconfigured for daily use, but can be modified to fit your team's preferred cadence. 💼 Ideal For: Anyone who wants to stay ahead of fast-moving AI trends with zero manual effort 🛠️ Tech Stack: Perplexity AI OpenAI (GPT-4 or equivalent) Google Sheets Telegram API ✅ Setup Notes: You’ll need to connect your own OpenAI, Perplexity, Google Sheets, and Telegram credentials. Replace the Google Sheet ID and Telegram channel settings with your own.

Who is this for? This workflow is for small business owners, personal assistants, or project managers who rely on multiple platforms for communication and scheduling. Ideal for users managing customer support, personal scheduling, or group event coordination via LINE, Google Calendar, and Gmail. What problem is this workflow solving? Reduces the manual effort needed to manage conversations, schedule events, and handle email communications. Provides an intelligent system for replying to user messages and fetching relevant calendar or email information in real time. Bridges the gap between messaging platforms and productivity tools, improving efficiency. What this workflow does LINE Chatbot Automation**: Automatically processes and responds to messages received via LINE. Google Calendar Management**: Retrieves upcoming events or schedules new events dynamically based on user queries. Email Retrieval**: Fetches recent emails using Gmail and filters them based on user instructions. AI-Powered Replies**: Uses OpenAI GPT to interpret user queries and provide tailored responses. Setup Prerequisites: LINE Developer account and API access. Google Calendar and Gmail accounts with OAuth credentials. An n8n instance with access to environment variables. Steps: Set up environment variables (LINE_API_TOKEN and DYNAMIC_EMAIL). Configure API credentials for Google Calendar and Gmail in n8n. Test the workflow by sending a sample message via LINE. Enhancements: Use sticky notes to provide inline instructions for each node. Include a video walkthrough or a step-by-step document for first-time users. How to customize this workflow to your needs Localization**: Modify responses in the AI Agent node to match the language and tone of your audience. Integration**: Add more integrations like Slack or Microsoft Teams for additional notifications. Advanced Filters**: Add specific conditions to Gmail or Google Calendar nodes to fetch only relevant data, such as events with specific keywords or emails from certain senders. Advanced Use Cases Customer Support**: Automatically schedule meetings with clients based on their messages in LINE. Event Management**: Handle RSVP confirmations, event reminders, and email follow-ups for planned events. Personalized Assistant**: Use the workflow to act as a personal virtual assistant that syncs your schedule, replies to messages, and summarizes emails. Tips for Optimization Edit Fields Node**: Add a centralized node to configure dynamic inputs (e.g., tokens, emails, or thresholds) for easy updates. Fallback Responses**: Use a switch node to handle unrecognized input gracefully and provide clear feedback to users. Logs and Monitoring**: Add nodes to log interactions and track message flows for debugging or analytics. Let me know if you'd like me to expand on any specific section or add more customization ideas!

Who is this for? This workflow is perfect for digital content creators, marketers, and social media managers who regularly create engaging short-form videos featuring inspirational or motivational quotes. While the workflow is universally applicable, it specifically highlights Thai as an example to demonstrate effective language and font integration. What problem is this workflow solving? Creating consistent and engaging multilingual video content manually, including attractive fonts and proper video formatting, is time-consuming and repetitive. Additionally, managing files, background music, and updating statuses manually can be tedious and prone to errors. What this workflow does Automatically fetches background video and music files stored on Google Drive. Randomly selects a quote (demonstrated with Thai language) and author information from Google Sheets. Dynamically combines the selected quote and author text using appealing fonts, such as the Thai font "Kanit," directly onto the video using FFmpeg on your n8n local environment. Creates visually engaging videos with a 9:16 aspect ratio, optimized for YouTube Shorts and other vertical video platforms. Automatically uploads the finalized video to YouTube. Updates the status and YouTube URL back into your Google Sheet, ensuring you have up-to-date records. Setup Requirements: This workflow requires a self-hosted n8n instance, as the execution of FFmpeg commands is not supported on n8n Cloud. Ensure FFmpeg is installed on your self-hosted environment. Google Sheets Setup: Your Google Sheet must include at least these columns: Index: (Unique identifier for each quote) Quote: (Text of the quote) Author: (Author of the quote) CreateStatus: (Track video creation status; values like 'DONE' or blank for pending) YoutubeURL: (Automatically updated after upload) To help you get started quickly, you can use this template spreadsheet. Next steps: Organize your video and music files in separate folders in Google Drive. Authenticate your Google Sheets, Google Drive, and YouTube accounts in n8n. Ensure fonts compatible with your target languages (such as Kanit for Thai) are available in your FFmpeg installation. How to customize this workflow to your needs Fonts:** Adjust font styles and sizes within the workflow's code node. Ensure the fonts you choose fully support the language you wish to use. Quote Management:** Easily add or remove quotes and authors in your Google Sheets document. Media Files:** Change or update background videos and music by modifying the files in your Google Drive folders. Video Specifications:** Customize video dimensions, text positioning, opacity, and music volume directly in the provided FFmpeg commands. Benefits of Using Localized Fonts and Quotes Utilizing fonts specific to your target language, as demonstrated with Thai, significantly increases audience engagement by making your content more relatable, shareable, and visually appealing. Ensure you select fonts that properly support the language you're targeting.

🧑‍⚖️ AI Legal Assistant Agent — AI-Powered Legal Q&A with Document Retrieval Category: LegalTech / AI Agent / RAG / Chatbot Description: This no-code AI agent acts as a legal assistant chatbot that can answer user queries by retrieving information from a pre-indexed legal document library. It’s powered by OpenAI + Pinecone + Telegram and designed for law firms, compliance teams, or anyone who needs instant answers from contracts, policies, or regulatory documents. For more of such builds and step-by-step video tutorial, check out: https://www.youtube.com/@Automatewithmarc 🔍 How it Works: Telegram Trigger – Starts when a user sends a message via Telegram. AI Agent (Open AI Model) – Uses a retrieval-augmented generation (RAG) setup to understand the question and pull relevant context. Pinecone Vector Store – Searches across a vectorized legal contract library for relevant clauses or documents. OpenAI Embeddings – Converts uploaded documents into vector embeddings for efficient search. Memory Buffer – Maintains conversation flow and context for follow-up questions. Telegram Response – Sends the final AI-generated answer directly to the user. 🎯 Use Cases: In-house legal teams automating internal policy Q&A Law firms building client-facing legal bots Startups offering legal tech services with document-based queries Compliance teams monitoring contract terms and obligations ✅ Key Features: Real-time legal Q&A via Telegram Pinecone + OpenAI-powered vector search Retrieval-Augmented Generation (RAG) setup Factual, memory-aware assistant with fallback if info is unavailable Fully customizable and extendable ⚙️ Setup Instructions: Connect OpenAI, Pinecone, and Telegram credentials Upload your contracts or policy docs into Pinecone Customize the system prompt or expand document sources as needed Activate and test via Telegram This workflow is a solid foundation for any AI-powered legal assistant or chatbot solution—highly relevant for modern LegalOps and knowledge management teams.

For Who? Content Creators Youtube Automation Marketing Team How it works? 1 - Retrieve Base Image, Image Description and Situation from Airtable 2 - Generate Image Prompt 3 - Generate Image via Fal AI 4 - Verify if Image is generated 5 - Upload Image on Airtable 📺 YouTube Video Tutorial: SETUP Setup Input : The first part of the workflow can be replaced with anything else. You need as input a Prompt and the Base Image URL (publicly available). Setup Output : In this Workflow, the output is storing the image on Airtable but you can replace that with anything else but basically you have two options : Store the Generated Image somewhere : Keep everything like this and replace the last Airtable node with the Third Party you want to use. Use the Image directly in n8n : In HTTP Request "Generate Image" switch sync_mode to "true", remove all the following nodes and add "Extract form File" node (convert to Base64 String) APIs : For the following third-party integrations, replace ==[YOUR_API_TOKEN]== with your API Token or connect your account via Client ID / Secret to your n8n instance: Fal AI (FLUX KONTEXT MAX) : https://fal.ai/models/fal-ai/flux-pro/kontext/max/api#schema-input Airtable : https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.airtable/?utm_source=n8n_app&utm_medium=node_settings_modal-credential_link&utm_campaign=n8n-nodes-base.airtable

Deep Multiline Icebreaker System (AI-Powered Cold Email Personalization) Categories: Lead Generation, AI Marketing, Sales Automation This workflow creates an advanced AI-powered cold email personalization system that achieves 5-10% reply rates by generating deeply personalized multi-line icebreakers. The system scrapes comprehensive website data, analyzes multiple pages per prospect, and uses advanced AI prompting to create custom email openers that make recipients believe you've personally researched their entire business. Benefits Superior Response Rates** - Achieves 5-10% reply rates vs. 1-2% for standard cold email campaigns Deep Website Intelligence** - Scrapes and analyzes multiple pages per prospect, not just homepages Advanced AI Personalization** - Uses sophisticated prompting techniques with examples and formatting rules Complete Lead Pipeline** - From Apollo search to personalized icebreakers in Google Sheets Scalable Processing** - Handle hundreds of prospects with intelligent batching and error handling Revenue-Focused Approach** - System designed around proven $72K/month agency methodologies How It Works Apollo Lead Acquisition: Integrates directly with Apollo.io search URLs through Apify scraper Processes 500+ leads per search with comprehensive contact data Filters for prospects with both email addresses and accessible websites Multi-Page Website Scraping: Scrapes homepage to extract all internal website links Processes relative URLs and filters out external/irrelevant links Performs intelligent batching to prevent IP blocking during scraping Comprehensive Content Analysis: Converts HTML to markdown for efficient AI processing Uses GPT-4 to generate detailed abstracts of each webpage Aggregates insights from multiple pages into comprehensive prospect profiles Advanced AI Icebreaker Generation: Employs sophisticated prompting with system messages, examples, and formatting rules Uses proven icebreaker templates that reference non-obvious website details Generates personalized openers that imply deep manual research Smart Data Processing: Removes duplicate URLs and handles scraping errors gracefully Implements token limits to control AI processing costs Organizes final output in structured Google Sheets format Required Google Sheets Setup Create a Google Sheet with these exact tab and column structures: Search URLs Tab: URL - Contains Apollo.io search URLs for your target audiences Leads Tab (Output): first_name - Contact's first name last_name - Contact's last name email - Contact's email address website_url - Company website URL headline - Job title/position location - Geographic location phone_number - Contact phone (if available) multiline_icebreaker - AI-generated personalized opener Setup Instructions: Create Google Sheet with "Search URLs" and "Leads" tabs Add your Apollo search URLs to the first tab (one per row) Connect Google Sheets OAuth credentials in n8n Update the Google Sheets document ID in all sheet nodes The workflow reads from Search URLs and outputs to Leads automatically Apollo Search URL Format: Your search URLs should look like: https://app.apollo.io/#/people?personLocations[]=United%20States&personTitles[]=ceo&qKeywords=marketing%20agency&page=1 Business Use Cases AI Automation Agencies** - Generate high-converting prospect outreach for service-based businesses B2B Sales Teams** - Create personalized cold email campaigns that actually get responses Marketing Agencies** - Offer premium personalization services to clients Consultants** - Build authority through deeply researched prospect outreach SaaS Companies** - Improve demo booking rates through personalized messaging Professional Services** - Stand out from generic sales emails with custom insights Revenue Potential This system transforms cold email economics: 5-10x Higher Response Rates** than standard cold email approaches $72K/month proven methodology** - exact system used to scale successful AI agency Premium Positioning** - prospects assume you've done extensive manual research Scalable Personalization** - process hundreds of prospects daily vs. manual research Difficulty Level: Advanced Estimated Build Time: 3-4 hours Monthly Operating Cost: ~$150 (Apollo + Apify + OpenAI + Email platform APIs) Watch My Complete Live Build Want to see me build this entire deep personalization system from scratch? I walk through every component live - including the AI prompting strategies, website scraping logic, error handling, and the exact techniques that generate 5-10% reply rates. 🎥 See My Live Build Process: "I Deep-Personalized 1000+ Cold Emails Using THIS AI System (FREE TEMPLATE)" This comprehensive tutorial shows the real development process - including advanced AI prompting, multi-page scraping architecture, and the proven icebreaker templates that have generated over $72K/month in agency revenue. Set Up Steps Apollo & Apify Integration: Configure Apify account with Apollo scraper access Set up API credentials and test lead extraction Define target audience parameters and lead qualification criteria Google Sheets Database Setup: Create multi-sheet structure (Search URLs, Leads) Configure proper column mappings for lead data Set up Google Sheets API credentials and permissions Website Scraping Infrastructure: Configure HTTP request nodes with proper redirect handling Set up error handling for websites that can't be scraped Implement intelligent batching with split-in-batches nodes AI Content Processing: Set up OpenAI API credentials with appropriate rate limits Configure dual-AI approach (page summarization + icebreaker generation) Implement token limiting to control processing costs Advanced Icebreaker Generation: Configure sophisticated AI prompting with system messages Set up example-based learning with input/output pairs Implement formatting rules for natural-sounding personalization Quality Control & Testing: Test complete workflow with small prospect batches Validate AI output quality and personalization accuracy Monitor response rates and optimize messaging templates Advanced Optimizations Scale the system with: Industry-Specific Templates:** Customize icebreaker formats for different verticals A/B Testing Framework:** Test different AI prompt variations and templates CRM Integration:** Automatically add qualified responders to sales pipelines Response Tracking:** Monitor which personalization elements drive highest engagement Multi-Touch Sequences:** Create follow-up campaigns based on initial response data Important Considerations AI Token Management:** System includes intelligent token limiting to control OpenAI costs Scraping Ethics:** Built-in delays and error handling prevent website overload Data Quality:** Filtering logic ensures only high-quality prospects with accessible websites Scalability:** Batch processing prevents IP blocking during high-volume scraping Why This System Works The key to 5-10% reply rates lies in making prospects believe you've done extensive manual research: Non-obvious details from deep website analysis Natural language patterns that avoid template detection Company name abbreviation (e.g., "Love AMS" vs "Love AMS Professional Services") Multiple page insights aggregated into compelling narratives Check Out My Channel For more advanced automation systems and proven business-building strategies that generate real revenue, explore my YouTube channel where I share the exact methodologies used to build successful automation agencies.