🛻 AI agent for logistics order processing with GPT-4o, Gmail and Google Sheet
Tags: Supply Chain, Logistics, AI Agents Context Hey! I’m Samir, a Supply Chain Data Scientist from Paris, and the founder of LogiGreen Consulting. We design tools to help companies improve their logistics processes using data analytics, AI, and automation—to reduce costs and minimize environmental impacts. >Let’s use N8N to improve logistics operations! 📬 For business inquiries, you can add me on LinkedIn Who is this template for? This workflow template is designed for logistics or manufacturing operations that receive orders by email. [](https://www.youtube.com/watch?v=kQ8dO_30SB0) The example above illustrate the challenge we want to tackle using an AI Agent to parse the information and load them in a Google sheet. If you want to understand how I built this workflow, check my detailed tutorial: [](https://www.youtube.com/watch?v=kQ8dO_30SB0) 🎥 Step-by-Step Tutorial How does it work? The workflow is connected to a Gmail Trigger to open all the emails that include Inbound Order in their subject. The email is parsed by an AI Agent equipped with OpenAI's GPT to collect all the information. The results are pulled in a Google Sheet. [](https://www.youtube.com/watch?v=kQ8dO_30SB0) These orderlines can then be transferred to warehouse teams to prepare *order receiving. What do I need to get started? You’ll need: Gmail and Google Drive Accounts with the API credentials to access it via n8n An OpenAI API key (GPT-4o) for the chat model. A Google Sheet with these columns: PONUMBER, EXPECTEDDELIVERY DATE, SKU_ID, QUANTITY Next Steps Follow the sticky notes in the workflow to configure each node and start using AI to support your logistic operations. 🚀 Curious how N8N can transform your logistics operations? 📬 Let’s connect on LinkedIn Notes An example of email is included in the template so you can try it with your mailbox. This workflow was built using N8N version 1.82.1 Submitted: March 28, 2025
By Samir SaciExport CSV file to JSON
This workflow exports a local CSV file to a JSON file.
By LorenaPost latest Twitter mentions to Slack
This workflow will allow you to get the latest twitter mentions and send those mentions to Rocket.Chat. To ensure that we don't resend the same tweets as before, we use the Function Node and getWorkflowStaticData() to persist the ids of the tweets which have already been sent and filter those out. This leaves us with only the newest tweets.
By NisaragGenerate SEO-optimized titles & meta descriptions with Bright Data & Gemini AI
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. What does this workflow do? This workflow helps speed up the analysis process of the top ranking titles and meta descriptions to identify paterns and styles that will help us rank on Google for a given keyword How does it work? We provide a keyword we are interested in on our Google sheet. When executed, We scrap the top 10 pages using Bright Data serp API and analyse the style and patterns of the top ranking pages and generate a new title and meta description Techncial setup Make a copy of this Google sheet Update your desired keywords on the cell/row Set your Bright data credentials on the Fetch Google Search Results JSON node Update the zone to your preset zone We are getting the results as a JSON. You can update this setting on the url https://www.google.com/search?q={{ $json.searchterm .replaceAll(" ", "+")}}&start=0&brdjson=1 by removing the brd_json=1 query Store the generated results on the Duplicated sheet Run the workflow Setting up the Serp Scraper in Bright Data On Bright Data, go to the Proxies & Scraping tab Under SERP API, create a new zone Give it a suitable name and description. The default is serp_api Add this to your account Add your credentials as a header credential and rename to Bright data API
By Zacharia KimothoProcess documents with OCR, analytics & Google Drive using PDF Vector
Overview Organizations dealing with high-volume document processing face challenges in efficiently handling diverse document types while maintaining quality and tracking performance metrics. This enterprise-grade workflow provides a scalable solution for batch processing documents including PDFs, scanned documents, and images (JPG, PNG) with comprehensive analytics, error handling, and quality assurance. What You Can Do Process thousands of documents in parallel batches efficiently Monitor performance metrics and success rates in real-time Handle diverse document formats with automatic format detection Generate comprehensive analytics dashboards and reports Implement automated quality assurance and error handling Who It's For Large organizations, document processing centers, digital transformation teams, enterprise IT departments, and businesses that need to process thousands of documents reliably with detailed performance tracking and analytics. The Problem It Solves High-volume document processing without proper monitoring leads to bottlenecks, quality issues, and inefficient resource usage. Organizations struggle to track processing success rates, identify problematic document types, and optimize their workflows. This template provides enterprise-grade batch processing with comprehensive analytics and automated quality assurance. Setup Instructions: Configure Google Drive credentials for document folder access Install the PDF Vector community node from the n8n marketplace Configure PDF Vector API credentials with appropriate rate limits Set up batch processing parameters (batch size, retry logic) Configure quality thresholds and validation rules Set up analytics dashboard and reporting preferences Configure error handling and notification systems Key Features: Parallel batch processing for maximum throughput Support for mixed document formats (PDFs, Word docs, images) OCR processing for handwritten and scanned documents Comprehensive analytics dashboard with success rates and performance metrics Automatic document prioritization based on size and complexity Intelligent error handling with automatic retry logic Quality assurance checks and validation Real-time processing monitoring and alerts Customization Options: Configure custom document categories and processing rules Set up specific extraction templates for different document types Implement automated workflows for documents that fail quality checks Configure credit usage optimization to minimize costs Set up custom analytics and reporting dashboards Add integration with existing document management systems Configure automated notifications for processing completion or errors Implementation Details: The workflow uses intelligent batching to process documents efficiently while monitoring performance metrics in real-time. It automatically handles different document formats, applies OCR when needed, and provides detailed analytics to help organizations optimize their document processing operations. The system includes sophisticated error recovery and quality assurance mechanisms. Note: This workflow uses the PDF Vector community node. Make sure to install it from the n8n community nodes collection before using this template.
By PDF VectorVeo 3 ad script builder (GPT-4 + Google Docs integration)
🚀 Overview This n8n automation workflow streamlines the creation of professional video ad scripts tailored for Veo 3 by turning basic user inputs into cinematic, consistent, and highly structured prompts. Whether you're a marketing agency, content creator, or small business, this workflow ensures high-quality AI video generation at scale—without needing a professional copywriter or creative director. 🛠️ How It Works 📝 Form Trigger Captures initial inputs via a web form: Ad Category: Dropdown (Before & After, Brand Awareness, UGC Style, Educational) Environment: Text (short description of setting/location) Script: Raw ad copy Spokesperson: Basic character idea (e.g., “young woman, confident, skincare expert”) 🧠 Build Persona Node Uses GPT-4o-Mini to expand spokesperson input into a full character description. Output includes: Age Race Clothing Hairstyle Tone/Demeanor Ensures visual consistency in AI-generated video scenes. 🌆 Build Environment Node Transforms environment text into a detailed, cinematic setting. Adds descriptive elements like: Lighting style Architecture or background Atmosphere (e.g., soft morning glow, modern interiors) ✂️ Generate Copy Node Breaks the full script into 10-second readable segments for smooth pacing. Helps tools like Veo 3 maintain flow, coherence, and readability. Outputs concise, camera-ready lines for each section. 📄 Google Docs Integration Auto-updates a ready-to-use script template in Google Docs. Replaces placeholders with content from the 3 AI nodes: Cinematic shot: (Build Persona) in (Build Environment). They confidently address the camera: (Generate Copy). Professional lighting emphasizes credibility throughout. Final result: a polished video ad prompt, ready for Veo 3 or any AI video tool. 💸 Cost Efficiency Advantage Using the Veo 3 API directly costs $0.50 per second — meaning a simple 5-second video costs $3.75, and a 6-clip project could run up to $24. However, this workflow is optimized for Veo 3's Fast on Flow mode, which costs just $0.20 per clip. 🔍 Real Example: 6 clips = $1.20 Savings = Over 90% More room for testing, iteration, and scaling This isn’t just smart automation — it’s financially strategic. 🔧 Setup Instructions ✅ Prerequisites Active n8n instance (Cloud or Self-Hosted) OpenAI API Key (for GPT-4) Google Docs API credentials ⚙️ Configuration Steps Import the workflow into your n8n instance Add OpenAI credentials to the AI nodes Set up Google Docs integration in n8n Copy this template: 👉 Veo 3 Script Template Update the Google Docs node with your copy’s URL Test the flow by submitting the form 💼 Use Cases Marketing Agencies: Quickly generate ad scripts for multiple campaigns Content Creators: Scale up content production without creative burnout AI Video Producers: Maintain detailed, consistent inputs for each render Small Business Owners: Create pro-grade ads without outsourcing 🎯 Benefits ✨ Consistency: AI ensures visual + narrative alignment ⚡ Speed: Go from rough idea to finished ad script in seconds 📈 Scalability: Handle multiple clients and campaigns simultaneously 🎥 Quality Output: Templates and pacing are optimized for real-world video use 💰 Cost Savings: Save up to 90% vs API-only generation..
By David OlusolaBuild an AI-powered employee recognition system with GPT-4, Jotform and Google Sheets
Jotform Employee Recognition & Rewards Submission System Transform manual peer recognition into a transparent, engaging, and automated reward system - achieving 300% increase in recognition submissions, 85% employee satisfaction improvement, and building a culture where great work is celebrated instantly. What This Workflow Does Revolutionizes employee recognition with AI-powered categorization and instant acknowledgment: 📝 Peer-to-Peer Recognition - Jotform captures nominations from any employee recognizing colleagues 🤖 AI Categorization - GPT-4 automatically classifies into Innovation, Teamwork, Leadership, Customer Service, Excellence, Problem Solving, or Mentorship 📊 Automated Tracking - Every recognition logged to Google Sheets with full AI analysis 📧 Triple Notifications - Nominator receives thank you, nominee gets congratulations, HR gets summary 🏆 Monthly Award Automation - AI analyzes eligible nominations and recommends Employee of the Month 💰 Reward Recommendations - AI suggests appropriate reward values ($50-$500) based on impact 🎯 Recognition Strength Scoring - 1-10 scale for nomination quality and impact assessment 📈 Analytics Dashboard - Track trends by department, category, and employee 🌟 Public Recognition - Automated announcements and newsletter features 💪 Culture Building - Reinforces positive behaviors through immediate acknowledgment Key Features AI Recognition Analyst: GPT-4 analyzes each nomination across 15+ dimensions including category classification, impact assessment, and award eligibility Smart Categorization: Automatically sorts recognitions into 7 primary categories plus secondary tags for comprehensive tracking Recognition Strength Scoring: 1-10 scale evaluates nomination quality, detail, and genuine impact demonstration Impact Level Assessment: Classifies impact as individual, team, department, or company-wide for appropriate rewards Core Values Mapping: AI identifies which company values the behavior exemplifies (innovation, collaboration, excellence, etc.) Award Eligibility Detection: Automatically flags high-quality nominations for Employee of the Month consideration Reward Value Suggestions: AI recommends appropriate monetary rewards ($50/$100/$250/$500) based on impact and effort Monthly Award Reports: Automated analysis of all eligible nominations with winner recommendations and justification Public Recognition Generation: AI creates shareable recognition text suitable for company-wide announcements Behavioral Examples Extraction: Identifies specific behaviors that can be used for training and culture reinforcement Department Analytics: Track which departments are most active in giving and receiving recognition Trend Identification: Spot patterns in recognition types, peak times, and cultural shifts Perfect For Growing Tech Companies: 50-500 employees building positive culture during rapid scaling Remote-First Organizations: Distributed teams needing virtual recognition and connection Enterprise HR Teams: Large organizations (1000+ employees) managing formal recognition programs Professional Services: Consulting, legal, accounting firms emphasizing teamwork and client service Healthcare Organizations: Hospitals and medical practices recognizing patient care excellence Retail & Hospitality: Frontline teams celebrating customer service and operational excellence Manufacturing Companies: Recognizing safety, quality, innovation, and continuous improvement Educational Institutions: Schools and universities celebrating teaching excellence and student support What You'll Need Required Integrations Jotform - Recognition submission form (free tier works) Create your form for free on Jotform using this link OpenAI API - GPT-4 for AI recognition analysis (~$0.15-0.30 per submission) Gmail - Automated notifications to nominators, nominees, HR, and leadership Google Sheets - Recognition database and analytics dashboard Optional Integrations Slack - Real-time recognition announcements to company channel Microsoft Teams - Recognition notifications and celebrations HRIS Integration - Link recognitions to employee profiles (Workday, BambooHR, etc.) Quick Start Import Template - Copy JSON and import into n8n Add OpenAI Credentials - Set up OpenAI API key (GPT-4 recommended) Create Jotform Recognition Form: Nominator Name (q3_nominatorName) Nominator Email (q4_nominatorEmail) Nominee Name (q5_nomineeName) - dropdown or autocomplete Nominee Email (q6_nomineeEmail) Department (q7_department) - dropdown Recognition Title (q8_recognitionTitle) - short text Detailed Description (q9_description) - paragraph text Specific Example/Story (q10_example) - paragraph text Impact on Team/Company (q11_impact) - paragraph text Configure Gmail - Add Gmail OAuth2 credentials (same for all 4 Gmail nodes) Setup Google Sheets: Create spreadsheet with "Recognition_Log" sheet Replace YOURGOOGLESHEET_ID in workflow (2 places) Columns auto-populate on first submission Customize Email Templates: Update company name, branding, colors Add company logo URLs if desired Update recognition form link Configure Monthly Awards: Review cron schedule (default: 1st of month at 9 AM) Update leadership email addresses Set Company Values (Optional): Edit AI prompt to include your specific company values Customize category names if needed Test Workflow - Submit test recognition through Jotform Launch Program: Announce to company with form link Share recognition examples to inspire participation Consider initial incentives (e.g., "Submit 3 recognitions this month, get $25 gift card") Customization Options Recognition Categories: Add/modify categories to match your company values (Safety, Quality, Diversity & Inclusion, etc.) Reward Tiers: Adjust suggested reward values to match your budget and culture Approval Workflow: Add manager approval step before rewards are issued Point System: Implement recognition points that accumulate toward bigger rewards Nomination Limits: Set monthly caps per nominator to prevent gaming the system Department Weighting: Balance recognition across departments with quotas or goals Anniversary Bonuses: Higher reward values for work anniversaries or milestones Team Recognition: Add option to recognize entire teams, not just individuals Anonymous Nominations: Allow anonymous recognition for sensitive feedback Peer Voting: Let team vote on monthly award winner from nominated candidates Multi-Language Support: Translate forms and emails for international teams Custom Triggers: Add recognition triggers from project completions, customer feedback, etc. Integration with Performance Reviews: Link recognitions to annual review cycles Gamification: Leaderboards, badges, and recognition streaks Charity Donations: Let employees donate rewards to causes they care about Expected Results 300% increase in recognition submissions - Easy process encourages frequent recognition 85% employee satisfaction improvement - Feeling valued boosts morale and engagement 60% reduction in manual HR work - Automated tracking and categorization 95% program participation - Simple form drives company-wide adoption 40% improvement in retention - Recognized employees stay longer 2.5x boost in employee engagement scores - Regular recognition increases commitment 100% recognition tracking - No lost nominations or forgotten acknowledgments 50% faster award decisions - AI analysis speeds monthly selection process 75% reduction in "favoritism" complaints - Transparent, data-driven awards 90% positive cultural impact - Builds appreciation and psychological safety Use Cases Tech Startup (120 Employees, Rapid Growth) Scenario: Software engineer Sarah stays late 3 nights to fix critical production bug affecting 1,000+ customers. Teammate Jake submits recognition at 11 PM from home. AI Analysis: Primary Category: Problem Solving Secondary: Teamwork, Customer Service Recognition Strength: 9/10 (detailed, specific impact) Impact Level: Company-wide (customer retention, revenue protection) Impact Score: 10/10 Core Values: Excellence, Customer First, Ownership Award Recommendation: Employee of the Month + Spot Award Suggested Reward: $500 Eligible for Monthly Award: YES Automated Response: 11:02 PM: Jake receives thank you email with AI analysis 11:02 PM: Sarah receives congratulations notification 11:02 PM: HR receives summary with $500 reward recommendation Next Day 9 AM: CTO reviews, approves $500 gift card + public announcement Weekly Newsletter: Sarah's achievement featured with customer impact data End of Month: Sarah wins Employee of the Month ($1,000 bonus + trophy + parking spot) Result: Sarah feels valued and appreciated. Customer sees bug fixed overnight and becomes case study client. 3 other engineers submit recognitions that week, inspired by Sarah's example. Company culture of "customer heroes" strengthens. Remote-First Marketing Agency (85 Employees, 12 Countries) Scenario: Junior designer Maria creates innovative template that speeds up client deliverables by 40%. Senior creative director in different timezone recognizes her contribution. AI Analysis: Primary Category: Innovation Secondary: Efficiency, Problem Solving Recognition Strength: 8/10 Impact Level: Department-wide (affects all designers) Impact Score: 9/10 Core Values: Innovation, Efficiency, Initiative Award Recommendation: Innovation Award + Spot Recognition Suggested Reward: $250 Eligible for Monthly Award: YES Automated Response: Recognition received during nominee's off-hours (sleeping) Wake up to congratulations email from company Nominator receives thank you acknowledging time zone difference HR schedules all-hands recognition for upcoming Monday Template added to company resource library with Maria's credit Recognition appears in wins Slack channel with reactions from 47 colleagues Result: Maria gains confidence, becomes advocate for innovation program. Template saves company 160 hours quarterly ($16K+ value). 5 other team members submit process improvement ideas that month. Remote employees feel connected despite time zones. Healthcare System (2,400 Nurses & Staff) Scenario: ER nurse catches medication error that could have harmed patient. Colleague recognizes life-saving attention to detail during chaotic shift. AI Analysis: Primary Category: Excellence Secondary: Patient Safety, Attention to Detail Recognition Strength: 10/10 (life-or-death impact) Impact Level: Individual patient, but systemic importance Impact Score: 10/10 Core Values: Patient First, Safety, Excellence Award Recommendation: Safety Excellence Award Suggested Reward: $500 + Public Recognition Eligible for Monthly Award: YES Flag for Quarterly Safety Review: YES Automated Response: Nurse receives recognition during shift break Nursing manager immediately notified Safety committee auto-tagged for review Recognition logged in employee safety profile Story used (with permission) in next safety training Featured in hospital newsletter with photo Result: Nurse's vigilance prevents sentinel event. Recognition reinforces safety culture. 12 other near-miss reports submitted that month (normally 3). Hospital passes safety audit with "exemplary culture" rating. Employee retention improves 15% in high-stress ER department. Manufacturing Company (450 Production Workers) Scenario: Maintenance technician develops preventive maintenance checklist that reduces equipment downtime 30%. Plant manager recognizes proactive problem-solving. AI Analysis: Primary Category: Innovation Secondary: Problem Solving, Operational Excellence Recognition Strength: 9/10 Impact Level: Department-wide (affects entire production line) Impact Score: 9/10 Core Values: Continuous Improvement, Ownership, Excellence Award Recommendation: Operational Excellence Award Suggested Reward: $250 Measurable ROI: $75K saved annually in downtime costs Automated Response: Technician receives recognition at shift change Operations director sees summary with ROI calculation Recognition posted in break room (digital display) Checklist becomes standard operating procedure Technician invited to present at quarterly meeting Featured in company safety/quality newsletter Result: Simple checklist saves company $75K annually. Technician becomes "continuous improvement champion," mentors 8 other workers in process optimization. Recognition program drives 23 process improvements that quarter. Production efficiency increases 12% year-over-year. Professional Services Firm (280 Consultants) Scenario: Junior consultant stays weekend to help colleague prepare critical client presentation. Senior partner recognizes teamwork and sacrifice. AI Analysis: Primary Category: Teamwork Secondary: Client Service, Going Above & Beyond Recognition Strength: 8/10 Impact Level: Team (supported 1 consultant, helped 1 client) Impact Score: 7/10 Core Values: Collaboration, Client First, Team Player Award Recommendation: Teamwork Award + Spot Recognition Suggested Reward: $100 + Comp Day Automated Response: Junior consultant receives congratulations Monday morning Partner's thank you delivered immediately HR flags for performance review documentation Recognition counted toward "team player" bonus criteria Story shared in weekly team meeting Comp day automatically added to time-off balance Result: Junior consultant feels valued despite weekend work. Colleague's presentation wins $500K project extension. Recognition drives "help each other" culture. Voluntary weekend support increases 40% without burnout concerns. Firm wins "Best Places to Work" award citing culture of appreciation. Pro Tips Launch with Leaders First: Have executives submit first recognitions to model behavior and set tone Make it Mobile-Friendly: 70% of recognitions happen on phones during breaks or commutes Weekly Recognition Roundups: Share top 5-10 recognitions in Friday email to inspire others Recognition Training: 15-minute workshop on "what makes a good recognition" increases quality 3x Nominator Leaderboards: Celebrate people who recognize others (not just recipients) Milestone Celebrations: Auto-recognize work anniversaries, project completions, certifications Real-Time Announcements: Post new recognitions to Slack/Teams channel as they arrive Photo Opportunities: Encourage nominators to include photos of the recognized moment/achievement Manager Dashboards: Give managers view of their team's recognition activity to spot engagement issues Budget Tracking: Monitor monthly reward spending vs budget to avoid year-end shortfalls Quarterly Trends Reports: Analyze recognition patterns to identify cultural strengths and gaps Anonymous Option for Sensitive Topics: Some achievements (whistleblowing, standing up to bias) need privacy Celebrate the Nominators: "Recognition Champion of the Month" for most thoughtful nominations Link to Performance Reviews: Include recognition count/quality in annual review criteria Seasonal Campaigns: "Gratitude November" or "Thanks-giving Week" to spike participation Learning Resources This workflow demonstrates advanced automation: AI Agents with Multi-Dimensional Analysis: Recognition categorization, strength scoring, impact assessment, and value determination Dynamic Email Personalization: Different email templates with conditional content based on AI analysis results Scheduled Automation: Monthly award selection runs automatically without manual intervention Complex Data Filtering: JavaScript code filters eligible nominations based on multiple criteria Parallel Execution: Simultaneous notifications to multiple stakeholders without delays Aggregate Reporting: AI synthesizes multiple nominations into executive-ready reports Cultural Pattern Recognition: AI identifies trends in recognition types and department dynamics Behavioral Reinforcement: Immediate positive feedback loops strengthen desired behaviors Data-Driven Decision Support: Objective metrics reduce bias in award selections Scalable Recognition: Handles 10 or 10,000 recognitions per month with same efficiency Business Impact Metrics Employee Engagement Scores: Track quarterly engagement surveys before/after program launch (expect 25-40% increase) Voluntary Turnover Rate: Measure retention improvement (recognized employees 50% more likely to stay) Recognition Participation Rate: Target 80%+ employees submitting at least one recognition annually Recognition Received Distribution: Ensure fair spread across departments and levels (detect favoritism) Manager Effectiveness: Correlate manager recognition activity with team engagement and performance Time-to-Recognition: Track lag between achievement and recognition (target <24 hours) Program ROI: Calculate cost per recognition vs engagement/retention value (typical 10:1 ROI) Recognition Quality Scores: AI strength scores improve over time as employees learn what makes good recognition Award Selection Speed: Reduce Employee of the Month selection from 2 weeks to 2 hours Cultural Value Alignment: Track which core values are most/least recognized to identify gaps --- Ready to Build a Culture of Appreciation? Import this template and turn recognition chaos into systematic celebration of excellence with AI-powered automation! 🏆✨ Questions or customization? The workflow includes detailed sticky notes explaining each AI analysis component and recognition logic. Template Compatibility ✅ n8n version 1.0+ ✅ Works with n8n Cloud and Self-Hosted ✅ No coding required for basic setup ✅ Fully customizable for company-specific values
By Jitesh DugarRandom Process Scheduler
Random Process Scheduler Turn predictable automations into human-like activity with random scheduling across easily customisable time slots. Perfect for content publishing with organic scheduling patterns, social media automation, API systems that need to avoid rate limiting, or any automation requiring randomised timing control across multiple periods. All times are configured in local timezone with automatic UTC conversion for technical operations. Features easy slot management with chronological ordering, gap support, and 24-hour window scheduling. How to use Set schedulerExecutionTime in Init node (match it to Schedule Trigger cron) Define time slots with start/end hours and probability values (see below) Configure Execute sub-process with your own workflow ID Configure SMTP credentials, local time zone and optionally project paths Step by Step Configuration Two variables to set in the Init node's "Custom Configuration" section: When the scheduler runs daily: javascript const schedulerExecutionTime = 1; // 1am (24h clock; must match Schedule Trigger node) Your execution slots: javascript const subprocessTimeSlots = { morning: { start: 6, end: 12, probability: 0.85 }, afternoon: { start: 12, end: 18, probability: 0.85 }, evening: { start: 18, end: 24, probability: 0.5 } }; That's it. Three slots, three probabilities. Add or remove slots, adjust times - it just works. Real-world example with gaps: javascript const subprocessTimeSlots = { night: { start: 0, end: 2, probability: 0.1 }, // Optional late activity morning: { start: 6, end: 10, probability: 0.85 }, // Gap from 2-6am (no execution) noon: { start: 12, end: 14, probability: 0.85 }, // Gap from 10am-12pm afternoon: { start: 16, end: 18, probability: 0.85 }, // Gap from 2-4pm evening: { start: 20, end: 24, probability: 0.5 } // Gap from 6-8pm }; Configure Execute sub-process with your workflow ID Your sub-workflow MUST start with a Wait node and be configured with {{ $json.executions.relativeDelaySeconds }} as “Wait Amount”. Additional Configuration SMTP credential Time zone (Init node): const LOCALTIMEZONE = $env.GENERICTIMEZONE || 'Europe/Paris'; by default Project paths (Init node): // ⚠️ Your email here • const N8NADMINEMAIL = $env.N8NADMINEMAIL || 'yourmail@world.com'; // ⚠️ Your projects’ ROOT folder on your mapped server here • const N8NPROJECTSDIR = $env.N8NPROJECTSDIR || '/files/n8n-projects-data'; // ⚠️ Your project’s folder name here for logging • const PROJECTFOLDERNAME = "RPS"; Requirements n8n instance running in Docker with file system access Volume mapping for persistent storage (e.g., /local-files:/files) De-activate Read/Write nodes & Email sends if you do not want to use logging features (file system access optional) SMTP server for notifications n8n API credentials for error handling Target sub-workflow with Wait node to handle relativeDelaySeconds IMPORTANT: Your sub-workflow MUST start with a Wait node and be configured with {{ $json.executions.relativeDelaySeconds }} as “Wait Amount”. How it works 24-Hour Window Algorithm: Schedules executions from current time until next scheduler run, handling timezone conversions and cross-midnight scenarios Automatic Validation: Checks for overlaps, invalid time ranges, and probability values on every run Chronological Processing: Processes slots in order regardless of how you define them Inclusive/Exclusive Boundaries: 6-12 slot runs from 6:00:00 to 11:59:59 (start inclusive, end exclusive) Chained Execution: Each subprocess receives a relativeDelaySeconds value for sequential execution with calculated intervals Comprehensive Monitoring: Tracks planned vs actual execution times with delay calculations and detailed logging Configuration Rules No Overlap: Slots cannot overlap (6-10 and 9-12 is invalid) Valid Ranges: Start 0-23, end 0-24, start < end Valid Probability: 0 to 1 (0.85 = 85% chance) Gaps Allowed: Skip hours completely (e.g., no execution 2-6am) Emoji Support: Use "night", "morning", "noon", "evening" keywords in slot names for visual logs Use Cases: Content publishing with organic scheduling patterns Social media automation with human-like posting intervals API systems avoiding rate limits through unpredictable timing Business hours automation with precise timing control
By Florent