Workflow Templates

Tags*: Supply Chain, Logistics, Route Planning, Transportation, GPS API Context Hi! I’m Samir — a Supply Chain Engineer and Data Scientist based in Paris, and founder of LogiGreen Consulting. I help companies improve their logistics operations using data, AI, and automation to reduce costs and minimize environmental footprint. > Let’s use n8n to build smarter and greener transport operations! 📬 For business inquiries, you can add find me on LinkedIn Who is this template for? This workflow is designed for logistics and transport teams who want to automate distance and travel time calculations for truck shipments. Ideal for: Control tower dashboards Transport cost simulations Route optimization studies How does it work? This n8n workflow connects to a Google Sheet where you store city-to-city shipment lanes, and uses the OpenRouteService API to calculate: 📏 Distance (in meters) ⏱️ Travel time (in seconds) 🪪 Number of route steps Steps: ✅ Load departure/destination city coordinates from a Google Sheet 🔁 Loop through each record 🚚 Query OpenRouteService using the truck (driving-hgv) profile 🧾 Extract and store results: distance, duration, number of steps 📤 Update the Google Sheet with new values What do I need to get started? This workflow is beginner-friendly and requires: A Google Sheet with route pairs (departure and destination coordinates) A free OpenRouteService API key 👉 Get one here Next Steps 🗒️ Follow the sticky notes inside the workflow to: Select your sheet Plug in your API key Launch the flow! 🎥 Check the Tutorial 🚀 You can customize the workflow to: Add CO2 emission estimates for Sustainability Reporting Connect to your TMS via API or EDI This template was built using n8n v1.93.0 Submitted: June 1, 2025

This automated n8n workflow converts any technical documentation or blog post URL into a professional, step-by-step developer tutorial video complete with AI-generated narration, code syntax highlighting, terminal command animations, and visual diagrams. The system intelligently analyzes documentation structure, extracts code examples, generates natural voiceover narration, creates synchronized visual scenes, and automatically publishes the finished video to YouTube with SEO-optimized descriptions. Fundamental Aspects Webhook-Based Trigger**: Accepts HTTP POST requests containing a documentation URL to initiate the automated video creation pipeline on-demand. Intelligent Content Extraction**: Fetches HTML content, parses documentation structure, extracts code blocks with language detection, identifies headings for organization, and cleans irrelevant elements like navigation and scripts. AI-Powered Tutorial Planning**: Uses Claude AI to analyze documentation content and generate a comprehensive tutorial outline including section titles, duration estimates, narration scripts, visual types (code/terminal/diagram), and learning outcomes. Professional Audio Generation**: Converts narration scripts into high-quality audio using Google Cloud Text-to-Speech with natural-sounding neural voices, proper pacing, and timing synchronization. Dynamic Visual Scene Creation**: Generates code editor scenes with syntax highlighting and typewriter effects, terminal animations with command execution sequences, flowchart diagrams with progressive reveals, and text overlays with key points. Automated Video Rendering**: Combines audio narration with visual scenes using Remotion API to render publication-ready videos in 1080p resolution at 30fps with smooth transitions. Multi-Platform Distribution**: Automatically uploads completed videos to YouTube with AI-generated titles and descriptions, backs up to Google Drive for archival, and returns comprehensive metadata via webhook response. Setup Instructions Import the Workflow into n8n**: Download the workflow JSON file and import via n8n interface under "Workflows" → "Import from File" option. Configure Claude AI (Anthropic) Credentials**: Navigate to the "Analyze with Claude AI" node and click the credentials dropdown. Create new Anthropic credentials using your API key from console.anthropic.com. Ensure you have access to Claude Sonnet 4 model (claude-sonnet-4-20250514). Save and test the connection to verify API access. Set Up Google Cloud Text-to-Speech**: Go to Google Cloud Console and enable the Text-to-Speech API. Create a service account with "Cloud Text-to-Speech User" role. Generate and download a JSON key file for the service account. In n8n, navigate to "Generate Audio with Google TTS" node and add service account credentials. Upload the JSON key file when prompted. Configure Remotion API for Video Rendering**: Sign up for a Remotion account at remotion.dev and obtain API credentials. In the "Render Video with Remotion" node, add HTTP Header Auth credentials. Set authorization header with your Remotion API key. Ensure you have a Remotion composition named "TutorialVideo" deployed. Note: You may need to create a custom Remotion project for code highlighting and terminal animations. Add YouTube OAuth2 Credentials**: Navigate to "Upload to YouTube" node and create YouTube OAuth2 credentials. Follow Google's OAuth flow to authorize n8n to upload videos on your behalf. Ensure your YouTube account has upload permissions and is verified for videos longer than 15 minutes. Configure default privacy settings (public, unlisted, or private) in node parameters. Configure Google Drive Backup**: Go to "Backup to Google Drive" node and add Google Drive OAuth2 credentials. Authorize n8n to access your Google Drive. Optionally specify a folder ID in node options to organize video backups. Activate Webhook Endpoint**: Activate the workflow using the toggle switch in the top-right corner. Copy the webhook URL from the "Webhook Trigger" node (appears after activation). The URL will be in format: https://your-n8n-instance.com/webhook/create-video. Test the Workflow**: Send a test POST request to the webhook URL using curl, Postman, or HTTPie: curl -X POST https://your-n8n-instance.com/webhook/create-video \ -H "Content-Type: application/json" \ -d '{"documentationUrl": "https://docs.example.com/getting-started"}' Monitor the execution in n8n's "Executions" tab to track progress through each node. Check YouTube and Google Drive for the generated video (processing may take 5-15 minutes depending on content length). Verify Output Quality**: Review the generated video for audio quality, code highlighting accuracy, and pacing. Check YouTube description for proper formatting of prerequisites and learning outcomes. Ensure code snippets are readable and terminal animations are properly synchronized. Technical Dependencies Claude AI (Anthropic)**: For intelligent content analysis, tutorial outline generation, section structuring, and narration script writing with natural language processing. Google Cloud Text-to-Speech**: For converting narration scripts into professional-quality audio with neural voice models (en-US-Neural2-J recommended for technical content). Remotion API**: For programmatic video rendering, scene composition, code syntax highlighting, terminal animations, and transition effects (requires custom React components). YouTube Data API v3**: For automated video uploads, metadata management, thumbnail generation, and playlist organization. Google Drive API**: For backup storage, file sharing, and archival of raw video files with organized folder structures. n8n Platform**: For workflow orchestration, webhook handling, conditional logic, error handling, and execution monitoring. JavaScript Runtime**: For custom content parsing, JSON manipulation, code language detection, timing calculations, and data transformation in Code nodes. Customization Possibilities Voice Customization**: Change narrator voice in "Generate Narration Script" node by modifying the voice parameter. Google TTS offers multiple voices (male, female, different accents). Adjust speed (0.25-4.0) and pitch (-20 to +20) for different pacing styles. Use different voices for intro/outro vs main content. Video Branding**: Add custom intro/outro animations by modifying Remotion composition. Include your logo, channel name, and subscribe animations. Customize color schemes in code editor themes (Dracula, Monokai, Solarized, One Dark). Add watermarks or corner branding throughout video. Code Editor Themes**: Change syntax highlighting themes in "Create Visual Scenes" node. Popular options include Dracula (default), VS Code Dark+, GitHub Light, Monokai Pro, Nord. Adjust font sizes, line spacing, and highlighting animation speeds for readability. Content Filtering**: Add pre-processing logic to filter specific documentation sections. Skip changelog entries, API reference tables, or installation instructions if not needed. Focus on tutorial-style content only. Add minimum/maximum content length thresholds. Multi-Language Support**: Extend the workflow to detect documentation language and use appropriate TTS voices. Support Spanish (es-ES), French (fr-FR), German (de-DE), Japanese (ja-JP), and other languages. Generate localized titles and descriptions. Advanced Visual Types**: Add screen recording capabilities for live demonstrations. Include animated flowcharts using Mermaid or D3.js. Generate architecture diagrams from code structure. Add picture-in-picture video of an instructor or animated avatar. Tutorial Complexity Detection**: Use Claude AI to assess documentation difficulty level and adjust pacing accordingly. Beginner content gets slower narration and more detailed explanations. Advanced content can move faster with less repetition. Interactive Elements**: Generate timestamp chapters for YouTube with clickable sections. Create accompanying blog post or GitHub repository with code examples. Generate quiz questions based on content for learning validation. Quality Assurance**: Add validation nodes to check video quality before upload. Verify audio levels are balanced, code is readable at 1080p, and total duration matches expectations. Implement retry logic for failed renders. Batch Processing**: Extend webhook to accept multiple URLs for bulk video generation. Create playlists automatically for related documentation pages. Schedule sequential uploads to avoid flooding your channel. Analytics Integration**: Track video performance by connecting to YouTube Analytics API. Monitor view counts, engagement rates, and audience retention. Use insights to improve future video generation parameters. Cost Optimization**: Implement caching for previously processed documentation URLs to avoid redundant API calls. Use cheaper TTS voices for internal testing. Compress videos before upload while maintaining quality. Set API rate limits to control costs. Custom Remotion Components**: Build specialized React components for your tech stack (e.g., database schema visualizers, API request/response animations, deployment pipeline diagrams). Create reusable templates for common tutorial patterns. Notification System**: Add email or Slack notifications when videos complete processing. Include video URLs, processing time, and any errors encountered. Send daily summaries of generated videos. SEO Enhancement**: Use Claude AI to generate SEO-optimized titles, descriptions, and tags. Research trending keywords in your niche. Auto-generate closed captions and subtitles for accessibility and searchability. Explore More AI Video Automation: Contact us to design custom video automation workflows for product demos, educational content, marketing videos, or AI-powered content creation pipelines tailored to your business needs.

This workflow automates the creation of audiobooks from structured text data using AI-powered text-to-speech and audio processing services. Click here to listen the result of my example. Key Advantages 1. ✅ Fully Automated Audiobook Production The entire pipeline—from text retrieval to final audio upload—is automated. This removes manual steps, reduces human error, and enables repeatable audiobook generation at scale. 2. ✅ Advanced Voice Customization By using voice design prompts (voice description + style instruction), the workflow produces highly expressive and context-aware narration, ideal for audiobooks, storytelling, and branded audio content. 3. ✅ Scalable and API-Safe Architecture The batch processing and looping logic respects external API limits. This makes the workflow robust even for large audiobooks with dozens or hundreds of segments. 4. ✅ Centralized Content Management Google Sheets acts as a lightweight CMS: Easy to edit scripts and voice parameters Clear tracking of processed items Temporary URLs and merge flags ensure full visibility into the workflow state 5. ✅ Asynchronous and Fault-Tolerant The use of wait nodes and status checks allows the workflow to handle long-running audio operations without blocking or failing prematurely. 6. ✅ Seamless Cloud Storage Integration Final audiobooks are automatically stored in Google Drive, making them immediately accessible for distribution, review, or further processing. 7. ✅ Modular and Extensible Design Each step (TTS generation, batching, merging, storage) is modular. This makes it easy to: Swap TTS providers Change storage destinations Add post-processing steps (e.g. metadata, chapter markers) How it Works This workflow automates the creation of audiobooks using AI-generated voice synthesis with custom voice design. The process begins by retrieving script data from a Google Sheets document containing text, speaker information, voice descriptions, and style instructions. The workflow then processes each row in batches, sending the text to the Qwen3-TTS model on Replicate with specified voice parameters to generate individual audio segments. Each generated audio URL is stored back in the spreadsheet. Concurrently, once multiple audio segments are ready, they are merged into a single audio file using an external FFmpeg API service. The system polls for merge completion, retrieves the final merged audio file, and uploads it to Google Drive as a complete audiobook with a timestamped filename. Set up Steps Data Source Configuration: Set up the Google Sheets node to connect to your spreadsheet containing the audiobook script with required columns: Text, Speaker, Voice Description, Style Instruction, Temp URL, and To Merge API Credentials Setup: Configure Replicate API credentials for Qwen3-TTS voice synthesis Set up Fal.run API credentials for FFmpeg audio merging operations Configure Google Drive OAuth2 credentials for uploading the final audiobook Voice Design Parameters: Ensure your spreadsheet contains appropriate voice descriptions and style instructions compatible with the Qwen3-TTS model's requirements Destination Settings: Verify the Google Drive folder ID in the upload node points to your desired storage location for the final audiobook Execution: Trigger the workflow manually to begin processing your script rows and generating the complete audiobook with custom voice design 👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n. Need help customizing? Contact me for consulting and support or add me on Linkedin.

Automating LinkedIn Company Page Discovery Use Case Finding the official LinkedIn page of a company is crucial for tasks like outreach, research, or enrichment. This automation streamlines the process by intelligently searching the company’s website and LinkedIn to locate the correct profile. What This Automation Does This automation identifies a company's LinkedIn page using the following input parameters: Company domain**: The official website domain of the company (e.g., company.com). Airtop Profile (connected to LinkedIn)**: The name of your Airtop Profile authenticated on LinkedIn. How It Works Launches an Airtop session using the provided authenticated profile. Attempts to extract a LinkedIn link directly from the company's website. If not found, performs a LinkedIn search for the company. If still unsuccessful, falls back to a Google search. Validates the most likely result to confirm it’s a LinkedIn company page. Outputs the verified LinkedIn URL. Setup Requirements Airtop API Key — free to generate. An Airtop Profile logged in to LinkedIn (requires one-time login). Next Steps Combine with People Enrichment**: Use this with LinkedIn profile discovery for full contact + company data workflows. CRM Integration**: Automatically enrich company records with LinkedIn links. Build Custom Outreach Workflows**: Connect company pages to SDR tooling for deeper research and engagement. Read more about how to find Linkedin Company page

Automating LinkedIn Connection Requests Use Case Automatically sending LinkedIn connection requests to prospects can significantly streamline your outreach process. This automation ensures you only send requests to users you're not already connected with, and can optionally include a personalized message. What This Automation Does This automation sends a LinkedIn connection request using the following input parameters: linked_url**: The LinkedIn profile URL of the person you want to connect with. airtop_profile**: The name of your Airtop Profile authenticated on LinkedIn. message* *(optional): The note you want to include with your connection request. How It Works Starts an Airtop browser session using your authenticated profile. Opens the target LinkedIn profile in a new browser window. Detects if you're already connected or if a connection request is pending. If the "Connect" button is available: If no message is provided, clicks "Connect" and sends the request without a note. If a message is provided, clicks "Add a note", types the message, and sends the request. Terminates the browser session. Setup Requirements Airtop API Key — free to generate. An Airtop Profile logged in to LinkedIn (requires one-time authentication). Next Steps Pair with People Enrichment**: Use with the LinkedIn Profile Finder to generate URLs before sending requests. CRM Integration**: Log connection attempts and responses in your CRM. Campaign Sequencing**: Combine with message follow-up automations for a complete outreach flow. Read more about automating Linkedin Connection Requests

Complete AI Graphic Design Suite with OpenAI, Replicate & Google Drive Categories: AI Agents, Design Automation, Business Tools This workflow creates a complete AI-powered graphic design system that replaces expensive designers with intelligent automation. Featuring a conversational AI agent that orchestrates 5 specialized design tools, this suite can generate logos, style guides, gradients, and revisions on demand. Built by someone who's scaled automation agencies to $72K/month, this system demonstrates how AI agents can deliver real business value beyond simple chatbots. Benefits Complete Design Automation** - Generate logos, style guides, gradients, and revisions through natural conversation Conversational AI Interface** - Chat-based interaction makes design accessible to non-designers Professional Quality Output** - Uses advanced AI models and proven templates for consistent results Instant Delivery** - Generate designs in seconds vs. days of traditional design processes Scalable Business Tool** - Deploy for clients, embed on websites, or use internally Cost-Effective Solution** - Replace $82K/year designers with $30/month automation How It Works AI Agent Orchestration: Central conversational AI that understands design requests in natural language Automatically selects the right tool based on user needs and context Maintains conversation memory for iterative design improvements Provides professional, helpful responses with design expertise Logo Generation System: Creates professional logos using OpenAI's advanced image generation Supports various styles: minimalistic, corporate, creative, and industry-specific Automatically uploads to Google Drive with shareable links Perfect for startups, rebranding projects, and client work Style Guide Creation: Generates comprehensive brand guidelines using template-based approach Includes color palettes, typography, logo usage, and brand elements Uses AI to customize templates with client-specific information Delivers presentation-ready style guides for professional use Gradient Background Generator: Creates beautiful background gradients for websites and marketing materials Uses proven design templates with AI-powered customization Generates multiple variations and color combinations Perfect for landing pages, social media, and brand materials Design Editor & Revision System: Intelligently revises existing designs based on feedback Handles both Google Drive files and external image URLs Maintains design consistency while implementing requested changes Supports iterative improvements and client feedback cycles Advanced Upscaling Integration: Uses Replicate API to enhance image quality up to 4x resolution Professional print-quality output for all generated designs Seamlessly integrates with all design generation tools Perfect for high-resolution marketing materials and presentations Required Setup Configuration OpenAI API Setup: Connect your OpenAI API for: GPT-4 conversation handling and design guidance DALL-E (4o) image generation for all design tools Intelligent prompt processing and tool selection Google Drive Integration: Create template files for style guides and examples Set up OAuth credentials for file management Configure sharing permissions for client access Organize folders for different design categories Replicate API Configuration: Set up account for image upscaling capabilities Replace <your-replicate-api-key-here> with actual API key Configure upscaling factors (2x or 4x options) AI Agent System Message: Configure the agent with business context: You are a helpful, intelligent design assistant. You generate high-quality designs using the provided tools (generate logo, generate style guide, and generate gradient background). Then you can also upscale them, and finally, you can revise them. When you receive an image from a tool, wrap it in nice looking Markdown (atx) format and present it to the user. The only things you can generate are logos, style guides, and gradient backgrounds. Make sure to clarify which (as well as any additional information needed) so the prompt you send to the image model is optimal. If you are asked to adjust or revise an image, ask the user to define their changes as explicitly as possible. Chat Integration Options: Embedded website chat widget for client-facing design services Direct chat interface for internal team use Hosted chat endpoint for external integrations Business Use Cases Design Agencies** - Offer automated design services with instant delivery and unlimited revisions Marketing Teams** - Generate brand assets, social media graphics, and campaign materials on demand Startups** - Create professional branding without expensive design budgets Consultants** - Provide design services as value-added offerings to clients Web Developers** - Offer integrated design services alongside development projects E-commerce Businesses** - Generate product graphics, banners, and promotional materials Revenue Potential This system transforms design service economics: Replace $82K/year designers** with $30/month automation costs Instant delivery advantage** - complete designs in minutes vs. days Unlimited revisions** without additional designer time costs Premium service offering** - charge $1,500-5,000 per client implementation Scalable white-label solution** for agencies and consultants 24/7 availability** for time-sensitive client requests Difficulty Level: Intermediate Estimated Build Time: 2-3 hours Monthly Operating Cost: ~$30 (OpenAI + Replicate APIs) Watch My Complete Build Process Want to see exactly how I built this entire AI design system from scratch? I walk through the complete development process, including AI agent setup, tool integration, and the business strategy behind replacing expensive designers with intelligent automation. 🎥 Watch My Live Build: "This AI Agent Replaces an $82k/yr Graphic Designer (N8N)" This comprehensive tutorial shows the real development approach - including agent design patterns, tool orchestration, and the exact prompting strategies that deliver professional-quality results. Set Up Steps Core AI Agent Configuration: Set up chat trigger with embedded and hosted options Configure OpenAI chat model with design-focused system prompts Add memory buffer for conversation context and design iterations Design Tool Integration: Configure all 5 specialized design workflows as callable tools Set up proper data flow between agent and design generators Test tool selection logic with various design requests Template and Asset Management: Upload design templates to Google Drive for style guide generation Configure file sharing permissions for client access Set up organized folder structure for different design types Quality Control Setup: Test complete design workflows from request to delivery Validate AI output quality across all design categories Optimize prompts and templates based on actual usage patterns Client Integration Options: Embed chat widget on client websites for design services Set up hosted endpoints for external system integration Configure branding and messaging for client-facing interactions Advanced Extensions Scale the system with additional capabilities: Industry-Specific Templates** - Customize design styles for different verticals Brand Consistency Engine** - Maintain design standards across all generated assets Client Portal Integration** - Automated design delivery with approval workflows Multi-Language Support** - Generate designs with international text and cultural considerations Advanced Analytics** - Track design performance and client satisfaction metrics Print Production Tools** - Generate print-ready files with proper color profiles and dimensions Why This System Works The competitive advantage lies in intelligent automation combined with professional quality: Natural conversation interface** eliminates design tool complexity Template-based generation** ensures consistent, professional results Instant iteration capability** allows real-time design improvements Cost advantage** enables competitive pricing while maintaining margins 24/7 availability** provides service levels impossible with human designers Scalable delivery** handles multiple clients simultaneously without quality degradation Check Out My Channel For more advanced AI automation systems that generate real business results, explore my YouTube channel where I share the exact strategies used to build successful automation agencies and scale to $72K+ monthly revenue.

This workflow facilitates seamless synchronization between Entra (Microsoft Azure AD) and Zammad. It automates the following processes: Fetch Entra Group Members: Retrieves users from a designated Entra group. These users are candidates for synchronization. Create Universal User Object: Extracts key user information, such as email, phone, and name, and formats it for Zammad compatibility. Synchronize with Zammad: Identifies users in Zammad who need updates based on Entra data. Adds new users from Entra to Zammad. Deactivates users in Zammad if they are no longer in the Entra group. Key Features Dynamic Matching**: Compares users from Entra with existing Zammad users based on email and updates records accordingly. Efficient Management**: Automatically creates, updates, or deactivates Zammad users based on their status in Entra. Custom Fields**: Supports custom field mapping, ensuring enriched user profiles in Zammad. Setup Instructions Microsoft Entra Integration: Ensure proper API permissions for accessing Entra groups and members. Configure Microsoft OAuth2 credentials in n8n. Zammad Integration: Set up Zammad API credentials with appropriate access rights. Customize the workflow to include additional fields or map existing fields as needed. Run Workflow: Trigger the workflow manually or set up an automation schedule (e.g., daily sync). Review created/updated/deactivated users in Zammad. Use Cases IT Administration**: Keep your support system in sync with the organization’s Entra data. User Onboarding**: Automatically onboard new hires into Zammad based on Entra groups. Access Management**: Ensure accurate and up-to-date user records in Zammad. Prerequisites Access to an Entra (Azure AD) environment with group data. A Zammad instance with API credentials for user management. A custom field in Zammad User Object (entra_key) of type String. A custom field in Zammad User Object (entra_object_type) of type `Single selection field with two key value pairs user = User contact = Contact` This workflow is fully customizable and can be adapted to your organization’s specific needs. Save time and reduce manual errors by automating your user sync process with this template! If you have found an error or have any suggestions, please report them here on Github.

🧠 AI Blog Generator for Shopify Products using GPT-4o The AI Blog Generator is an advanced automation workflow powered by n8n, integrating GPT-4o and Google Sheets to generate SEO-rich blog articles for Shopify products. It automates the entire process — from pulling product data, analyzing images for nutritional information, to producing structured HTML content ready for publishing — with zero manual writing. 💡 Key Advantages 🔗 Shopify Product Sync** Automatically pulls product data (title, description, images, etc.) via Shopify API. 🤖 AI-Powered Nutrition Extraction** Uses GPT-4o to intelligently analyze product images and extract nutritional information. ✍️ SEO Blog Generation** GPT-4o generates blog titles, meta descriptions, and complete articles using both product metadata and extracted nutritional info. 🗂️ Structured Content Output** Produces well-formatted HTML with headers, bullet points, and nutrition tables for seamless Shopify blog integration. 📄 Google Sheets Integration** Tracks blog creation, manages retries, and prevents duplicate publishing using a centralized Google Sheet. 📤 Shopify Blog API Integration** Publishes the generated blog to Shopify using a two-step blog + article API call. ⚙️ How It Works Manual Trigger Initiate the process using a test trigger or a scheduler. Fetch Products from Shopify Retrieves all product details including descriptions and images. Extract Product Images Splits and processes each image individually. OCR + Nutrition AI GPT-4o reads nutrition facts from product images. Skips items without valid info. Check Existing Logs References a Google Sheet to avoid duplicates and determine retry status. AI Blog Generation Creates a blog with headings, bullet points, intro, and a nutrition table. Shopify Blog + Article Posting Uses the Shopify API to publish the blog and its content. Update Google Sheet Logs the blog URL, HTML content, errors, and status for future reference. 🛠️ Setup Steps Shopify Node**: Connects to your Shopify store and fetches product data. Split Out Node**: Divides product images for individual OCR processing. OpenAI Node**: Uses GPT-4o to extract nutrition data from images. If Node**: Filters for entries with valid nutrition information. Edit Fields Node**: Formats the product data for AI processing. AI Agent Node**: Generates SEO blog content. Google Sheets Nodes**: Reads and updates blog creation status. HTTP Request Nodes**: Posts the blog and article via Shopify’s API. 🔐 Credentials Required Shopify Access Token** – For retrieving product data and posting blogs OpenAI API Key** – For GPT-4o-based AI generation and image processing Google Sheets OAuth** – For accessing the log sheet 👤 Ideal For Ecommerce teams looking to automate content for hundreds of products Shopify store owners aiming to boost organic traffic through blogging Marketing teams building scalable, AI-driven content workflows 💬 Bonus Tip The workflow is modular. You can easily extend it with internal linking, language translation, or even social media sharing — all within the same n8n flow.

A complete, ready-to-deploy Telegram chatbot template for food delivery businesses. This intelligent assistant handles orders, payments, customer service, and order tracking with human-in-the-loop payment verification. ✨ Key Features 🤖 AI-Powered Conversations - Natural language order processing using Google Gemini 📱 Telegram Integration - Seamless customer interaction via Telegram 💳 Payment Verification - Screenshot-based payment confirmation with admin approval 📊 Order Tracking - Automatic Google Sheets logging of all orders 🧠 Memory Management - Contextual conversation memory for better customer experience 🌍 Multi-Currency Support - Easily customizable for any currency (USD, EUR, GBP, etc.) 📍 Location Flexible - Adaptable to any city/country 🔄 Human Oversight - Manual payment approval workflow for security 🛠️ What This Template Includes Core Workflow Customer Interaction - AI assistant takes orders via Telegram Order Confirmation - Summarizes order with total and payment details Information Collection - Gathers customer name, phone, and delivery address Payment Processing - Handles payment screenshots and verification Admin Approval - Human verification of payments before order confirmation Order Tracking - Automatic logging to Google Sheets with delivery estimates Technical Components AI Agent Node - Google Gemini-powered conversation handler Memory System - Maintains conversation context per customer Google Sheets Integration - Automatic order logging and tracking Telegram Nodes - Customer and admin communication Payment Verification - Screenshot detection and approval workflow Conditional Logic - Smart routing based on message types 🚀 Quick Setup Guide Prerequisites n8n instance (cloud or self-hosted) Telegram Bot Token Google Sheets API access Google Gemini API key Step 1: Replace Placeholders Search and replace the following placeholders throughout the template: Business Information [YOUR_BUSINESS_NAME] → Your restaurant/food business name [ASSISTANT_NAME] → Your bot's name (e.g., "Alex", "Bella", "Chef Bot") [YOUR_CITY] → Your city [YOUR_COUNTRY] → Your country [YOUR_ADDRESS] → Your business address [YOUR_PHONE] → Your business phone number [YOUR_EMAIL] → Your business email [YOUR_HOURS] → Your operating hours (e.g., "9AM - 11PM daily") Currency & Localization [YOUR_CURRENCY] → Your currency name (e.g., "USD", "EUR", "GBP") [CURRENCY_SYMBOL] → Your currency symbol (e.g., "$", "€", "£") [YOUR_TIMEZONE] → Your timezone (e.g., "EST", "PST", "GMT") [PREFIX] → Order ID prefix (e.g., "FB" for "Food Business") Menu Items (Customize Completely) [CATEGORY_1] → Food category (e.g., "Burgers", "Pizza", "Sandwiches") [ITEM_1] through [ITEM_8] → Your menu items [PRICE_1] through [DELIVERY_FEE] → Your prices Add or remove categories and items as needed Payment & Support [YOUR_PAYMENT_DETAILS] → Your payment information [YOUR_PAYMENT_PROVIDER] → Your payment method (e.g., "Venmo", "PayPal", "Bank Transfer") [YOUR_SUPPORT_HANDLE] → Your Telegram support username Step 2: Configure Credentials Telegram Bot - Add your bot token to Telegram credentials Google Sheets - Connect your Google account and create/select your orders spreadsheet Google Gemini - Add your Gemini API key Sheet ID - Replace [YOUR_GOOGLE_SHEET_ID] with your actual Google Sheet ID Step 3: Customize Menu Update the menu section in the AI Agent system message with your actual: Food categories Item names and prices Delivery fees Any special offerings or combos Step 4: Test & Deploy Import the template into your n8n instance Test the conversation flow with a test Telegram account Verify Google Sheets logging works correctly Test the payment approval workflow Activate the workflow 💰 Currency Examples USD Version 🍔 MENU & PRICES (USD) Burgers Classic Burger – $12.99 Cheese Burger – $14.99 Deluxe Burger – $18.99 Delivery Fee – $3.99 EUR Version 🍔 MENU & PRICES (EUR) Burgers Classic Burger – €11.50 Cheese Burger – €13.50 Deluxe Burger – €17.50 Delivery Fee – €3.50 📊 Google Sheets Structure The template automatically logs orders with these columns: Order ID Customer Name Chat ID Phone Number Delivery Address Order Info Total Price Payment Status Order Status Timestamp 🔧 Customization Options Easy Customizations Menu Items - Add/remove/modify any food items Pricing - Update to your local pricing structure Currency - Change to any currency worldwide Business Hours - Modify operating hours Delivery Areas - Add location restrictions Payment Methods - Update payment information# Header 1

🔍 Yelp Business Finder: Scraping Local Businesses by Keyword, Category & Location Using Bright Data and Google Sheets Description: Automate local business data collection from Yelp using AI-powered input validation, Bright Data scraping, and automatic Google Sheets integration. Perfect for market research, lead generation, and competitive analysis. 🛠️ How It Works Form Submission: Users submit a simple form with country, location, and business category parameters. AI Validation: Google Gemini AI validates and cleans input data, ensuring proper formatting and Yelp category alignment. Data Scraping: Bright Data's Yelp dataset API scrapes business information based on the cleaned parameters. Status Monitoring: The workflow monitors scraping progress and waits for data completion. Data Export: Final business data is automatically appended to your Google Sheets for easy analysis. 📋 Setup Steps ⏱️ Estimated Setup Time: 10-15 minutes Prerequisites ✅ Active n8n instance (cloud or self-hosted) ✅ Google account with Sheets access ✅ Bright Data account with Yelp scraping dataset ✅ Google Gemini API access Configuration Steps Import Workflow: Copy the provided JSON workflow In n8n: Go to Workflows → + Add workflow → Import from JSON Paste the JSON and click Import Configure Google Sheets: Create a new Google Sheet or use an existing one Set up OAuth2 credentials in n8n Update the Google Sheets node with your document ID Configure column mappings for business data Setup Bright Data: Add your Bright Data API credentials to n8n Replace BRIGHT_DATA_API_KEY with your actual API key Verify your Yelp dataset ID in the HTTP request nodes Test the connection Configure Google Gemini: Add your Google Gemini API credentials Test the AI Agent connection Verify the model configuration Test & Activate: Activate the workflow using the toggle switch Test with sample data: country="US", location="New York", category="restaurants" Verify data appears correctly in your Google Sheet 📊 Data Output 📍 Business Name Official business name from Yelp ⭐ Overall Rating Average customer rating (1-5 stars) 📝 Reviews Count Total number of customer reviews 🏷️ Categories Business categories and tags 🌐 Website URL Official business website 📞 Phone Number Contact phone number 📍 Address Full business address 🔗 Yelp URL Direct link to Yelp listing 🎯 Use Cases 🔍 Market Research Analyze local business landscapes and competition 📈 Lead Generation Build prospect lists for B2B outreach 🏪 Location Analysis Research business density by area and category 📊 Competitive Intelligence Monitor competitor ratings and customer feedback ⚠️ Important Notes: Ensure you comply with Yelp's terms of service and rate limits Bright Data usage may incur costs based on your plan AI validation helps improve data quality and reduce errors Monitor your Google Sheets for data accuracy 🔧 Troubleshooting Common Issues: API Rate Limits:** Implement delays between requests if needed Invalid Categories:** AI agent helps standardize category names Empty Results:** Verify location spelling and category alignment Authentication Errors:** Check all API credentials and permissions 🚀 Ready to start scraping Yelp business data efficiently!

📌 AI Agent Template with Bright Data MCP Tool Integration This template obtains all the possible tools from Bright Data MCP, process this through chatbot, then run any tool based on the user's query ❓ Problem It Solves The problem that the MCP solves is the complexity and difficulty of traditional automation, where users need to have specific knowledge of APIs or interfaces to trigger backend processes. By allowing interaction through natural language, automatically classifying and routing queries, and managing context and memory effectively, MCP simplifies complex data operations, customer support, and workflow orchestration scenarios where inputs and responses change dynamically. 🧰 Pre-requisites Before deploying this template, ensure you have: An active n8n instance (self-hosted or cloud). A valid OpenAI API key (or any AI models) Access to Bright Data MCP API with credentials. Basic familiarity with n8n workflows and nodes. ⚙️ Setup Instructions **Install the MCP Community Node in N8N In your N8N self-hosted instance, go to Settings → Community Nodes. Search and install n8n-nodes-mcp. Configure Credentials: Add your OpenAI API key or any AI mdeols to the relevant nodes. If you want other AI model, please replace all associated nodes of OpenAI in the workflow Set up Bright Data MCP client credentials in the installed community node (STDIO) Obtain your API in Bright Data and put it in Environment field in the credentials window. It should be written as API_Key=<your api key from Bright Data> 🔄 Workflow Functionality (Summary) User message** triggers the workflow. AI Classifier** (OpenAI) interprets the intent and maps it to a tool from Bright Data MCP. If no match is found, the user is notified. If more information is needed, the AI requests it. Memory** preserves context for follow-up actions. The tool is executed, and results are returned contextually to the user. > 🧠 Optional memory buffer and chat memory manager nodes keep conversations context-aware across multiple messages. 🧩 Use Cases Data Scraping Automation**: Trigger scraping tasks via chat. Lead Generation Bots**: Use MCP tools to fetch, enrich, or validate data. Customer Support Agents**: Automatically classify and respond to queries with tool-backed answers. Internal Workflow Agents**: Let team members trigger backend jobs (e.g., reports, lookups) by chatting naturally. 🛠️ Customization Tool Matching Logic**: Modify the AI classifier prompt and schema to suit different APIs or services. Memory Size and Retention**: Adjust memory buffer size and filtering to fit your app’s complexity. Tool Execution**: Extend the "Execute the tool" sub-workflow to handle additional actions, fallback strategies, or logging. Frontend Integration**: Connect this with various platforms (e.g., WhatsApp, Slack, web chatbots) using the webhook. ✅ Summary This template delivers a powerful no-code/low-code agent that turns chat into automation, combining AI intelligence with real-world tool execution. With minimal setup, you can build contextual, dynamic assistants that drive backend operations using natural language.

The Chinese Translator workflow automates the translation of text into Chinese characters, pinyin, and English translations via Line Messaging API. This workflow leverages OpenRouter.ai to call advanced language models such as Qwen for accurate translations and ensures smooth user interaction by providing loading animations and timely replies. Purpose This workflow aims to Provide users with real-time translations of input text into Chinese characters, pinyin, and English Deliver seamless user experience through interactive features like loading animations and quick reply messages Enable easy integration with Line Messaging API for scalable deployment Key Features Real-Time Translation : Translates user-inputted text instantly using OpenRouter.ai's standardized API. Comprehensive Output : Delivers Chinese characters, pinyin, and English translations for each word or phrase. Interactive User Experience : Incorporates loading animations to inform users that the workflow is processing their request. Line Integration : Utilizes Line Webhooks and Reply APIs to facilitate communication between users and the translation service. Data Flow Receiving Input Node: Line Webhook Captures incoming messages from Line users. Extracts the text content and reply token from the webhook payload. Loading Animation Node: Line Loading Animation Sends a loading animation back to the user, indicating that the workflow is processing the request. Enhances user experience by providing immediate feedback. Translation Processing Node: Use OpenRouter Sends the extracted text to OpenRouter.ai's API, utilizing the Qwen model for translation. Requests Chinese characters, pinyin, and English translations for the input text. Sending Response Node: Line Reply Formats the translation results into a readable text message. Sends the translated text back to the user via Line's Reply API. Setup Instructions Prerequisites Line Developer Account : Create a Line channel to obtain necessary credentials for webhooks and messaging. OpenRouter.ai Account : Set up an account and configure access to utilize their language models. Steps to Configure Set Up Line Webhook : Navigate to the Line Developers Console and create a new webhook URL. Copy the generated webhook URL and paste it into the Line Webhook node in n8n. Configure OpenRouter.ai : Obtain API credentials from OpenRouter.ai and integrate them into the Use OpenRouter node within the workflow. Adjust Workflow Settings : Ensure the timezone is set to Asia/Bangkok . Verify that all nodes are correctly connected and configured with appropriate credentials. Intended Audience This workflow is ideal for: Language Learners : Seeking quick translations and pronunciation guides for Chinese language studies. Travelers : Looking to communicate effectively while traveling in Chinese-speaking regions. Businesses : Aiming to provide multilingual support to customers and clients. Benefits Enhanced Learning : Provides comprehensive translations, including pinyin, aiding in language acquisition. User-Friendly Interface : Real-time loading animations and prompt replies ensure a smooth user experience. Scalable Deployment : Easily integrates with Line's extensive user base for widespread accessibility.