Automated web scraping: email a CSV, save to Google Sheets & Microsoft Excel
How it works: The workflow starts by sending a request to a website to retrieve its HTML content. It then parses the HTML extracting the relevant information The extracted data is storted and converted into a CSV file. The CSV file is attached to an email and sent to your specified address. The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use. Set-up steps: Change the website to scrape in the "Fetch website content" node Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node) Configure Google Cloud credentials with access to Google Drive, Google Sheets and Gmail APIs (the latter is required for the Send CSV via e-mail node).
By Mihai FarcasChatGPT Automatic Code Review in Gitlab MR
Who this template is for This template is for every engineer who wants to automate their code reviews or just get a 2nd opinion on their PR. How it works This workflow will automatically review your changes in a Gitlab PR using the power of AI. It will trigger whenever you comment with +0 to a Gitlab PR, get the code changes, analyze them with GPT, and reply to the PR discussion. Set up Steps Set up webhook of note_events in Gitlab repository (see here on how to do it) Configure ChatGPT credentials Note "+0" in MergeRequest to trigger automatic review by ChatGPT
By assertTurn YouTube videos into summaries, transcripts, and visual insights
Who is this for? This workflow is built for anyone who works with YouTube content, whether you're: A learner looking to understand a video’s key points A content creator repurposing video material A YouTube manager looking to update titles, descriptions A social media strategist searching for the most shareable clips Don't just ask questions about what's said. Find out what's going on in a video too. Video Overview: https://www.youtube.com/watch?v=Ovg_KfKxnC8 What problem does this solve? YouTube videos hold valuable insights, but watching and processing them manually takes time. This workflow automates: Quick content extraction: Summarize key ideas without watching full videos Visual analysis: Understand what’s happening beyond spoken words Clip discovery: Identify the best moments for social sharing How the workflow works This n8n-powered automation: Uses Google’s Gemini 1.5 Flash AI for intelligent video analysis Provides multiple content analysis templates tailored to different needs What makes this workflow powerful? The easiest place to start is by requesting a summary or transcript. From there, you can refine the prompts to match your specific use case and the type of video content you’re working with. But what's even more amazing? You can ask questions about what’s happening in the video — and get detailed insights about the people, objects, and scenes. It's jaw-dropping. This workflow is versatile — the actions adapt based on the values set. That means you can use a single workflow to: Extract transcripts Generate an extended YouTube description Write a summary blog post You can also modify the trigger based on how you want to run the workflow — use a webhook, connect it to an event in Airtable, or leave it as-is for on-demand use. The output can then be sent anywhere: Notion, Airtable, CMS platforms, or even just stored for reference. How to set it up Connect your Google API key Paste a YouTube video URL Select an analysis method Run the workflow and get structured results Analysis Templates Basic & Timestamped Transcripts: Extract spoken content Summaries: Get concise takeaways Visual Scene Analysis: Detect objects, settings, and people Clip Finder: Locate shareable moments Actionable Insights: Extract practical information Customization Options Modify templates to fit your needs Connect with external platforms Adjust formatting preferences Advanced Configuration This workflow is designed for use with gemini-1.5-flash. In the future, you can update the flow to work with different models or even modify the HTTP request node to define which API endpoint should be used. It's also been designed so you can use this flow on it's own or add to a new / existing worflow. This workflow helps you get the most out of YouTube content — quickly and efficiently.
By Colleen BradyTranslate text from English to German
No description available.
By Harshil AgrawalSend a notification to Slack when a new high-quality lead is added to Hubspot
Use Case When tracking your contacts and leads in Hubspot CRM, every new contact might be a potential customer. To guarantee that you're keeping the overview you'd normally need to look at every new lead that is coming in manually to identify high-quality leads to prioritize their engagement and optimize the sales process. This workflow saves the work and does it for you. What this workflow does The workflow runs every 5 minutes. On every run, it checks the Hubspot CRM for contacts that were added since the last check. It then checks if they meet certain criteria (in this case if they are making +5m annual revenue) and alerts you in Slack for every match. Setup Add Hubspot, and Slack credentials. Click on Test workflow. How to adjust this workflow to your needs Change the schedule interval Adjust the criteria to send alerts
By Ricardo EspinozaasVoice AI chatbot with OpenAI, RAG (Qdrant) & Guardrails for WordPress
This workflow implements a complete Voice AI Chatbot system for Wordress that integrates speech recognition, guardrails for safety, retrieval-augmented generation (RAG), Qdrant vector search, and audio responses. It is designed to be connected to a WordPress Voicebot AI plugin through a webhook endpoint. --- Key Advantages ✅ Complete Voice AI Pipeline* The workflow handles: audio input STT intelligent processing TTS output All within a single automated process. ✅ Safe and Policy-Compliant Thanks to the Guardrails module, the system automatically: detects harmful or disallowed requests blocks them responds safely This protects both the user and the business. ✅ Contextual and Memory-Based Conversations The Window Buffer Memory tied to unique session IDs enables: continuous conversation flow natural dialogue better understanding of context ✅ Company-Specific Knowledge via RAG By integrating Qdrant as a vector store, the system can: retrieve business documentation give accurate and up-to-date answers support personalized content This makes the chatbot far more powerful than a standard LLM. ✅ Modular and Extensible Architecture Because everything is modular inside n8n, you can: swap OpenAI with other models add new tools or knowledge sources change prompts or capabilities without redesigning the entire workflow. ✅ *Easy WordPress Integration The workflow connects directly to a WordPress Voicebot plugin, meaning: no custom backend development simple deployment fast integration for websites ✅ Automatic Indexing of Documents The second workflow section: fetches Google Drive files converts them into embeddings indexes them into Qdrant This lets you maintain your knowledge base with almost no manual work. --- How It Works This workflow creates a Wordpress voice-enabled AI chatbot that processes audio inputs and provides contextual responses using RAG (Retrieval-Augmented Generation) from a Qdrant vector database. The system operates as follows: Audio Processing Pipeline: Receives audio input via webhook and converts speech to text using OpenAI's STT (Speech-to-Text) Applies guardrails to detect inappropriate content or jailbreak attempts using a separate GPT-4.1-mini model Routes safe queries to the AI agent and blocks unsafe content with a default response AI Agent with Contextual Memory: Uses OpenAI Chat Model with window buffer memory to maintain conversation context Equips the agent with two tools: Calculator for computations and RAG tool for business knowledge retrieval The RAG system queries Qdrant vector store containing company documents using OpenAI embeddings Response Generation: Generates appropriate text responses based on query type and available knowledge Converts approved responses to audio using OpenAI's TTS (Text-to-Speech) with "onyx" voice Returns binary audio responses to the webhook caller --- Set Up Steps Vector Database Preparation: Create Qdrant collection via HTTP request with specified vector configuration Clear existing collection data before adding new documents Set up Google Drive integration to source documents from specific folders Document Processing Pipeline: Search and retrieve files from Google Drive folder "Test Negozio" Process documents through recursive text splitting (500 chunk size, 50 overlap) Generate embeddings using OpenAI and store in Qdrant vector store Implement batch processing with 5-second delays between operations System Configuration: Configure webhook endpoint for receiving audio inputs Set up multiple OpenAI accounts for different functions (STT, TTS, guardrails, main agent) Establish Qdrant API connections for vector storage and retrieval Implement session-based memory management using session IDs from webhook headers WordPress Integration: Install the provided Voicebot AI Agent WordPress plugin Configure the plugin with the webhook URL to connect to this n8n workflow The system is now ready to receive audio queries and respond with voice answers The workflow handles both real-time voice queries and background document processing, creating a comprehensive voice assistant solution with business-specific knowledge retrieval capabilities. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.
By DavideCreate AI personalized video & voice outreach with HeyGen, ElevenLabs & Perplexity
Automated Sales Rep Clone Outreach Video and Voice Note for B2B Outbound This workflow automatically transforms new leads from Google Sheets into hyper-personalized outreach videos, voice notes, and emails using AI research, scriptwriting, video cloning, and voice generation. Perfect for SDRs, founders, and agencies who want to scale outreach without sacrificing personalization. 🎥 Watch step by step build: https://www.youtube.com/watch?v=q9AAh9zRou4 What this template does Whenever a new row is added to your Google Sheets CRM, this workflow: Reads the new lead (Name, Email, Phone, Company, Industry, LinkedIn URL) Runs deep research on the person & company using Perplexity Generates a personalized 30-second outreach script Creates a cloned-face, AI-generated HeyGen video with the script Creates an ElevenLabs voice note using the same personalized insights Uploads the audio file to Google Drive Sends an email to yourself containing: Outreach subject line Email body Personalized video link Personalized voice note link (Optional) Sends a WhatsApp/SMS/MMS message via Twilio with the files or links This template builds a complete AI-powered outbound engine—research, video, voice note, and email—fully automated. Why this is useful Turns manual outbound into a hands-free, 360° AI workflow Personalized video outreach dramatically increases reply rates Consistent research quality for every lead SDRs save hours per day on manual prep Perfect for: Influencer agencies SaaS outbound teams Founders doing cold outreach Recruitment agencies Real estate & service businesses Requirements Before running this workflow, connect: Google Sheets OAuth (trigger + CRM sheet) Perplexity API Key OpenAI API Key (GPT-5.1, GPT-4.1-mini) OpenRouter API Key HeyGen API Key (for video avatar) ElevenLabs API Key (for voice note) Google Drive OAuth (for file upload) Twilio credentials (optional SMS/WhatsApp) ⚠️ All credentials must be added manually after importing. This ensures security and complies with n8n Template Guidelines. How it works (Node Breakdown) Google Sheets Trigger Watches your CRM sheet and fires whenever a new lead row is added. Code Node — Extract Latest Row Ensures only the newly added row continues through the workflow. Research Agent Powered by OpenAI + Perplexity Scrapes professional history, company insights, marketing gaps Identifies outreach opportunities & triggers Produces a structured research summary Scripting Agent Writes a natural, human-sounding 30-second outreach script tailored to that exact lead. HeyGen Video Generator Creates a personalized avatar video narrating the script (720×1280). ElevenLabs Voice Generation Generates a custom voice note version of the pitch. Google Drive Upload Saves the voice note file for sharing or sending via WhatsApp. Twilio Message (optional) Sends the voice note or video link via SMS/WhatsApp. Email Output Creates a fully structured JSON email including: Subject line Personalized body HeyGen video link Voice note link Delivered via Gmail node. Setup (Step-by-Step) Import the template into n8n Open Google Sheets Trigger → choose your CRM sheet Add all required credentials: Perplexity OpenAI OpenRouter HeyGen ElevenLabs Google Drive Gmail Twilio (optional) In HeyGen node, choose: Your avatar Your preferred voice ID In ElevenLabs node, set: Your preferred voice model Review the system prompts of: Research Agent Script Agent Email Agent Adjust for your brand tone if needed. Run once manually to test. Turn on the workflow—your AI outbound engine is live. Customization Ideas Swap HeyGen avatar to match your brand identity Add a Slack notification when each video is ready Save research & scripts into a Notion database Create a HubSpot contact for each lead Add duplicate detection logic Auto-post video to social channels for public outreach Troubleshooting Video stuck in “processing”? → Increase the Wait node duration (30–60 sec). Voice note too robotic? → Switch to a premium ElevenLabs voice. Research not specific enough? → Strengthen the system prompt with more constraints. Emails not arriving? → Ensure Gmail OAuth has send permission configured. API authentication errors? → Check credentials in each node (OpenAI, Perplexity, HeyGen, etc.).
By Automate With MarcBilibili video downloader with Google Drive upload & email notification
Bilibili Video Downloader with Google Drive Upload & Email Notification Automate downloading of Bilibili videos via the Bilibili Video Downloader API (RapidAPI), upload them to Google Drive, and notify users by email — all using n8n workflow automation. --- 🧠 Workflow Overview This n8n automation allows users to: Submit a Bilibili video URL. Fetch download info from the Bilibili Video Downloader API (RapidAPI). Automatically download and upload the video to Google Drive. Share the file and send an email notification to the user. --- ⚙️ Node-by-Node Explanation | Node | Function | | ---------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------- | | On form submission | Triggers when a user submits the Bilibili video URL through the form. | | Fetch Bilibili Video Info from API | Sends the video URL to the Bilibili Video Downloader API (RapidAPI) to retrieve download info. | | Check API Response Status | Validates that the API returned a 200 success status before proceeding. | | Download Video File | Downloads the actual video from the provided resource URL. | | Upload Video to Google Drive | Uploads the downloaded video file to the user’s connected Google Drive. | | Google Drive Set Permission | Sets sharing permissions to make the uploaded video publicly accessible. | | Success Notification Email with Drive Link | Sends the Google Drive link to the user via email upon successful upload. | | Processing Delay | Adds a delay before executing error handling if something fails. | | Failure Notification Email | Sends an error notification to the user if download/upload fails. | --- 🧩 How to Configure Google Drive in n8n In n8n, open Credentials → New → Google Drive. Choose OAuth2 authentication. Follow the on-screen instructions to connect your Google account. Use the newly created credential in both Upload Video and Set Permission nodes. Test the connection to ensure access to your Drive. --- 🔑 How to Obtain Your RapidAPI Key To use the Bilibili Video Downloader API (RapidAPI): Visit bilibili videodownloade. Click Subscribe to Test (you can choose free or paid plans). Copy your x-rapidapi-key from the “Endpoints” section. Paste the key into your n8n Fetch Bilibili Video Info from API node header. Example header: json { "x-rapidapi-host": "bilibili-video-downloader.p.rapidapi.com", "x-rapidapi-key": "your-rapidapi-key-here" } --- 💡 Use Case This automation is ideal for: Content creators archiving Bilibili videos. Researchers collecting media resources. Teams that need centralized video storage in Google Drive. Automated content management workflows. --- 🚀 Benefits ✅ No manual downloads – fully automated. ✅ Secure cloud storage via Google Drive. ✅ Instant user notification on success or failure. ✅ Scalable for multiple users or URLs. ✅ Powered by the reliable Bilibili Video Downloader API (RapidAPI). --- 👥 Who Is This For n8n developers wanting to explore advanced workflow automations. Content managers handling large volumes of Bilibili content. Digital archivists storing video data in Google Drive. Educators sharing Bilibili educational videos securely. --- 🏁 Summary With this n8n workflow, you can seamlessly integrate the Bilibili Video Downloader API (RapidAPI) into your automation stack — enabling effortless video downloading, Google Drive uploading, and user notifications in one unified system.
By Sk developer Telegram bot: analyze images with GPT-4o-Mini/NVIDIA Vila & generate images with Stable Diffusion 3
Introduction Transform your Telegram bot into an AI vision system using GPT-4o-Mini and NVIDIA Stable Diffusion 3. Perfect for content moderators, researchers, and developers. Workflow Explanatory At start: Processes Telegram messages: images→analysis, text→image generation At Router: Routes by content type Upper path: Analyzes images using Nvidia Vila + GPT-4o-Mini Lower path: Generates images from text via Stable Diffusion 3 At Merge: Combines AI results At Gmail: Emails processed results How It Works Telegram Trigger listens for messages (images, text, documents) Content Router directs images → AI analysis, text → image generation Image Analysis: Downloads image → GPT-4o-Mini vision analysis → Email results Image Generation: Text prompt → Stable Diffusion 3 → Email generated image Gmail Notifications send formatted reports Prerequisites Telegram Bot token (via @BotFather) OpenAI API key (GPT-4 Vision) NVIDIA API key (free tier available) Gmail OAuth2 credentials Setup Steps Setup Steps Create Telegram Bot - Create Telegram bot and obtain token Configure API Credentials - Configure API credentials in HTTP Request nodes Set Up Gmail OAuth2 - Set up Gmail OAuth2 Import and Activate Workflow - Import workflow, update credentials, and activate Customization Options Add more AI models (Anthropic, Gemini) Route audio/documents to transcription/OCR Replace Gmail with Slack or Discord Connect to databases for storage Benefits Speed: Seconds per analysis vs. hours manually Accuracy: AI-powered visual understanding Intelligence: Historical tracking enables trend analysis
By Cheng Siong Chin