by Jitesh Dugar
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 YOUR_GOOGLE_SHEET_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 Mohamed Abubakkar
How it Works. The workflow runs automatically every day and collects analytics data for both today and yesterday. It cleans and standardizes both datasets in the same way so they are easy to compare. After that, it measures how performance has changed from one day to the next and interprets those changes to understand trends and context. Once all calculations are finished, the AI creates a clear, easy-to-read summary of what happened. This summary is then formatted and sent through the required communication channels, while the final data is saved for tracking over time and for creating follow-up tasks if needed. Key Features: Trigger runs once per day recommended (11: 57 PM). Fetch seperate data for today and yesterday in node. Compare the two days data and highlight if traffic is less Add the trend lowTraffic for low traffic identification. Using GPT-4 Mini for human readable summary to suit different communication channels. Sending report to WhatsApp / Email Stored the final structure data to Google Sheet for future analytics and historical record Setup Steps 1. Connect Required Credentials You must connect the following credentials: Google Analytics API Google Sheets OpenAi API Email SMTP WhatsApp API ClickUp API 2. Replace Defalut Values Update the workflow with: Your Google Analytics Id's Your Google Sheet Tabs Replace SMTP Credentials, sender and recipients Change with your OpenAi API key Create your WhatApi API Credentials ClickUp API Key's 3. Customize Email Template Modify subject, message body, or formatting style based on your reporting standards. 4. Adjust Trigger You may choose: Manual Trigger Cron Trigger for daily/weekly report Webhook Trigger integrated with your system Detailed Process Flow Schedule Trigger Node Type: Trigger Node Purpose: Automates the start of the workflow. Details: Runs every day (or every hour if real-time monitoring is needed). Eliminates manual data collection and ensures consistent reporting. Analytics Reports Node Type :- Google Analytics Node Purpose: Fetch website performance data Metrics includes: users, sessions, page views Combine the Data Node Type: Merge Node (Append) Purpose: Combines today’s and yesterday’s datasets into a single item for comparison. Details: Prepares data for calculating percentage changes. Maintains proper structure for further nodes. Calculate Percent Changes Node Type: Function Node Purpose: Computes day-over-day percentage changes for users, sessions, and page views. Details: Formula: ((today - yesterday) / yesterday) * 100 Handles increases and decreases correctly. Outputs values used for trend indicators and alerts. Generate AI Summary Node Type: OpenAI Node Purpose: Produces human-readable, professional insights about the daily analytics. Details: Summarizes key changes, trends, and recommendations. Provides context such as low-traffic warnings. Text output is used in emails, WhatsApp, and ClickUp tasks. Send Email or Whatsapp to Dedicated Person / Marketing Team Node Type: Email Node / Whatspp Purpose: Sends daily alert or report emails or whatsapp. Details: Includes formatted metrics and AI summary. Email subject and body clearly indicate trends and recommendations. Workflow Benefits Fully automated daily GA reporting AI-generated summaries for clear insights Alerts only triggered when necessary Historical logging for trends and dashboards Actionable tasks automatically created in ClickUp Multi-channel delivery via Email and WhatsApp Handles low-traffic scenarios gracefully
by siyad
This n8n workflow automates the process of monitoring inventory levels for Shopify products, ensuring timely updates and efficient stock management. It is designed to alert users when inventory levels are low or out of stock, integrating with Shopify's webhook system and providing notifications through Discord (can be changed to any messaging platform) with product images and details. Workflow Overview Webhook Node (Shopify Listener): This node is set up to listen for Shopify's inventory level webhook. It triggers the workflow whenever there is an update in the inventory levels. The webhook is configured in Shopify settings, where the n8n URL is specified to receive inventory level updates. Function Node (Inventory Check): This node processes the data received from the Shopify webhook. It extracts the available inventory and the inventory item ID, and determines whether the inventory is low (less than 4 items) or out of stock. Condition Nodes (Inventory Level Check): Two condition nodes follow the function node. One checks if the inventory is low (low_inventory equals true), and the other checks if the inventory is out of stock (out_of_stock equals true). GraphQL Node (Product Details Retrieval): Connected to the condition nodes, this node fetches detailed information about the product using Shopify's GraphQL API. It retrieves the product variant, title, current inventory quantity, and the first product image. HTTP Node (Discord Notification): The final node in the workflow sends a notification to Discord. It includes an embed with the product title, a warning message ("This product is running out of stock!"), the remaining inventory quantity, product variant details, and the product image. The notification ensures that relevant stakeholders are immediately informed about critical inventory levels.
by WeblineIndia
Quick overview This workflow runs daily to compare department budgets and actual spend from Google Sheets, calculates variance, uses Google Gemini to generate root-cause insights, sends Slack alerts when variance breaches a threshold, logs results back to Google Sheets, and emails a daily report via Gmail. How it works Runs every day at 9:00 AM on a schedule. Reads budget and actual spend data from two Google Sheets tabs and matches records by Department. Calculates spend variance and variance percentage, then assigns a status label (Healthy/Warning/Critical) and run context like date and summary. Sends the variance details to Google Gemini to generate a JSON response with root cause, risk level, and recommendations. Checks whether the variance percentage is greater than 10% and sends a Slack alert with the AI insights when the threshold is exceeded. Appends the final analysis (including whether an alert was sent) to a Google Sheets log and sends the same report via Gmail. Setup Connect Google Sheets OAuth credentials and set the correct spreadsheet and sheet tabs for Budget Data, Actual spend, and the Final report log. Add a Google Gemini (PaLM) API credential for the Gemini model used in the analysis step. Add Slack OAuth2 credentials and choose the channel where budget variance alerts should be posted. Add Gmail OAuth2 credentials and set the recipient(s) for the daily budget monitoring email. Update the variance alert threshold (currently >10% variance) and status thresholds (10%/20%) to match your policy. Requirements n8n instance (self-hosted or cloud) Google Sheets OAuth2 credentials Google Gemini (PaLM) API credentials Slack OAuth2 credentials Gmail OAuth2 credentials Properly structured Google Sheets: Budget Sheet → Department, Budget Spend Sheet → Department, Spend Report Sheet → Predefined columns for logging Customization Variance Threshold**: Modify IF node condition (> 10) to any value Update logic in Add Status & Context Details node: Critical: > 20% or Warning: > 10% Gemini Prompt*: Customize prompt inside *AI-Based Budget Analysis node to get different insights Slack Message Format**: Modify message body to include/exclude fields Email Template**: Customize HTML in Gmail node for branding or formatting Schedule Time**: Change trigger time as per business needs Additional info Who’s It For Finance and accounting teams Procurement departments Operations managers Business analysts Startups and enterprises managing departmental budgets Add-ons (Enhancements) Add monthly or weekly summary reports Integrate Power BI / dashboards for visualization Add multi-level approvals for high-risk alerts Store data in a database (MySQL/PostgreSQL) instead of Sheets Add SMS or WhatsApp alerts for critical cases Include historical trend analysis using AI Use Case Examples Corporate Budget Monitoring Track departmental spending daily and prevent overspending Procurement Cost Control Identify supplier-related cost deviations early Startup Financial Discipline Maintain strict control over limited budgets Project-Based Budget Tracking Monitor cost overruns across multiple projects Audit & Compliance Reporting Maintain a clear log of financial decisions and anomalies These are just a few examples—this workflow can be adapted for many other financial monitoring scenarios. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|---------| | No data fetched | Incorrect Google Sheets configuration | Verify sheet IDs and column names | | Merge not working | Department names mismatch | Ensure consistent naming across sheets | | Wrong variance values | Non-numeric data | Ensure Budget and Spend fields are numbers | | No Slack alerts | Condition not met or Slack not configured | Check IF condition and Slack credentials | | AI output missing | Gemini API issue | Verify API credentials and prompt | | Email not sent | Gmail credentials issue | Reconnect Gmail OAuth | | Data not logged | Sheet mapping issue | Check column mapping in final node | | Workflow not running | Trigger inactive | Activate workflow | Need Help? If you need help setting up this workflow, customizing it for your business, or adding advanced features like dashboards, AI enhancements or integrations, our n8n workflow development team at WeblineIndia is here to assist you. We specialize in building scalable automation workflows tailored to your business needs. Reach out to us for: Workflow setup & deployment Custom automation solutions AI-powered business workflows Integration with enterprise systems Let us help you turn automation into a competitive advantage.
by kreonovo
What this does This automation will create tables in your Airtable base and send Webflow form submissions as records in those tables. It keeps track of your Webflow forms with a Form Index table to ensure that form content does not get sent to the wrong table if you have Webflow forms with identical names. This is useful for Enhancing your Webflow form submission management. By sending structured data to your Airtable base you can do more with your Webflow forms. Usage guide Full written and video guide This automation is made to be as low effort as possible to start enhancing your Webflow forms. Simply create credentials for Webflow and a Personal Access Token for your Airtable base and connect them to the relevant nodes. The guide demonstrates a realworld example using a Webflow template and breaksdown the flow and logic for all the nodes.
by n8n Team
This n8n workflow, which runs every Monday at 5:00 AM, initiates a comprehensive process to monitor and analyze network security by scrutinizing IP addresses and their associated ports. It begins by fetching a list of watched IP addresses and expected ports through an HTTP request. Each IP address is then processed in a sequential loop. For every IP, the workflow sends a GET request to Shodan, a renowned search engine for internet-connected devices, to gather detailed information about the IP. It then extracts the data field from Shodan's response, converting it into an array. This array contains information on all ports Shodan has data for regarding the IP. A filter node compares the ports returned from Shodan with the expected list obtained initially. If a port doesn't match the expected list, it is retained for further processing; otherwise, it's filtered out. For each such unexpected port, the workflow assembles data including the IP, hostnames from Shodan, the unexpected port number, service description, and detailed data from Shodan like HTTP status code, date, time, and headers. This collected data is then formatted into an HTML table, which is subsequently converted into Markdown format. Finally, the workflow generates an alert in TheHive, a popular security incident response platform. This alert contains details like the title indicating unexpected ports for the specific IP, a description comprising the Markdown table with Shodan data, medium severity, current date and time, tags, Traffic Light Protocol (TLP) set to Amber, a new status, type as 'Unexpected open port', the source as n8n, a unique source reference combining the IP with the current Unix time, and enabling follow and JSON parameters options. This comprehensive workflow thus aids in the proactive monitoring and management of network security.
by Cheng Siong Chin
How It Works Scheduled runs collect data from oil markets, global shipping movements, news sources, and official reports. The system performs statistical checks to detect anomalies and volatility shifts. An AI-driven geopolitical model evaluates emerging risks and assigns a crisis score. Based on severity thresholds, results are routed to the appropriate alert channels for rapid response. Setup Steps Data Sources: Connect the oil price API, OPEC report feeds, shipping databases, and news sources. AI Model: Configure the OpenRouter ChatGPT model for geopolitical and risk analysis. Alerts: Define severity rules and route alerts to Email, Slack, or Dashboard APIs. Storage: Configure a database for historical records, audit logging, and trend tracking. Prerequisites Oil market API credentials; news feed access; OPEC data source; OpenRouter API key; Slack/email/dashboard integrations Use Cases Supply chain risk monitoring; energy market crisis detection; geopolitical threat assessment; trader decision support; operational risk management Customization Adjust risk thresholds; add market data sources; modify alert routing rules Benefits Reduces crisis detection lag 90%; consolidates fragmented data; enables proactive response
by Cheng Siong Chin
How It Works This workflow automates student progress monitoring and academic intervention orchestration through intelligent AI-driven analysis. Designed for educational institutions, learning management systems, and academic advisors, it solves the critical challenge of identifying at-risk students while coordinating timely interventions across faculty and support services. The system receives student data via webhook, fetches historical learning records, and merges these sources for comprehensive progress analysis. It employs a dual-agent AI framework for student progress validation and academic orchestration, detecting performance gaps, engagement issues, and intervention opportunities. The workflow intelligently routes findings based on validation status, triggering orchestration actions for students requiring support while logging compliant progress for successful learners. By executing multi-channel interventions through HTTP APIs and email notifications, it ensures educators and students receive timely guidance while maintaining complete audit trails for academic accountability and accreditation compliance. Setup Steps Configure Student Data Webhook trigger endpoint Connect Workflow Configuration node with academic performance parameters Set up Fetch Student Learning History node with LMS API credentials Configure Merge Student Data node for data consolidation Connect Student Progress Validation Agent with Claude/OpenAI API credentials Set up AI processing nodes Configure Route by Validation Status node with performance thresholds Connect Academic Orchestration Agent with AI API credentials for intervention planning Set up orchestration processing Prerequisites Claude/OpenAI API credentials for AI agents, learning management system API access Use Cases Universities identifying students requiring academic support, online learning platforms detecting engagement drops Customization Adjust validation thresholds for institutional academic standards Benefits Reduces student identification lag by 75%, eliminates manual progress tracking
by Roshan Ramani
Who's it for This workflow is ideal for: Content creators who want to replicate successful LinkedIn strategies Social media managers monitoring competitor content performance Marketing teams analyzing trending topics in their industry Personal brands looking to create data-driven content Agencies managing multiple LinkedIn accounts What it does This comprehensive workflow automates the entire LinkedIn content lifecycle: it scrapes viral posts from target accounts, analyzes engagement patterns, identifies trending topics, generates original AI-powered content based on those trends, creates accompanying images, and automatically publishes to your LinkedIn profile or company page. How it works Phase 1: Data Collection (Runs every 12 hours) Scheduler triggers the workflow twice daily Fetches LinkedIn profile URLs from Google Sheets Processes profiles in batches of 3 to respect API limits Uses Apify API to scrape recent posts from each profile Adds 3-second delays between requests to avoid rate limiting Filters for high-engagement posts (20+ likes, comments, or reposts) Saves viral posts to Google Sheets with full metadata Phase 2: Content Generation (Triggered by new data) Monitors Google Sheets for new viral posts every minute Filters posts published within the last 3 days that haven't been analyzed Aggregates trending content into a single dataset Analyzes patterns using Google Gemini AI to identify: Common themes and topics Engagement triggers and hooks Successful content structures Trending hashtags and formats Generates original LinkedIn post with proper formatting Creates AI image prompt optimized for minimal text Generates professional image using Google Imagen Publishes complete post to your LinkedIn account Marks analyzed posts as complete to prevent duplication Setup steps 1. Configure Google Sheets Create a new Google Sheet with two tabs: Tab 1: "usernames & links" - Add LinkedIn profile URLs you want to monitor Tab 2: "scrape data" - Leave empty (auto-populated by workflow) Connect your Google Sheets credentials in both nodes Replace all instances of YOUR_GOOGLE_SHEET_ID with your actual sheet ID Replace SHEET_GID values with your actual sheet GIDs 2. Set up Apify API Sign up for Apify account and get API token Replace YOUR_APIFY_API_TOKEN in "Scrape LinkedIn Posts API" node Note: Apify has free tier with limited requests 3. Configure Google Gemini credentials Obtain Google PaLM API credentials Add credentials to both "Google Gemini Chat Model" and "Generate an image" nodes 4. Set up LinkedIn publishing Connect your LinkedIn credentials in "Publish to LinkedIn" node If posting as organization, replace YOUR_LINKEDIN_ORGANIZATION_ID with your company page ID If posting as individual, change "postAs" parameter to "person" 5. Configure scheduling Default schedule: every 12 hours Adjust "LinkedIn Content Automation Scheduler" trigger if needed Consider your API rate limits when changing frequency 6. Test the workflow Manually trigger Phase 1 to scrape posts Verify data appears in Google Sheets "scrape data" tab Wait for Phase 2 trigger or manually activate it Check that content is generated and published correctly Verify posts are marked as analyzed in Google Sheets Requirements Google Sheets API access (free) Google Sheets Trigger OAuth2 (free) Apify API token (free tier available, $49/month for more) Google PaLM/Gemini API key (pay-per-use pricing) LinkedIn OAuth credentials (free) How to customize Adjust scraping targets: Add more LinkedIn profile URLs to your Google Sheets Change batch size in "Process Profiles in Batches" (default: 3) Modify post limit per profile in Apify API call (default: 1 post) Modify engagement filters: Edit "Filter High-Engagement Posts" node thresholds Default: 20+ likes OR 20+ comments OR 20+ reposts Adjust based on your niche's typical engagement rates Add additional criteria like views or impressions Customize content analysis window: Change "Filter Recent Posts (3 Days)" to analyze different timeframes Options: 24 hours for fast-moving trends, 7 days for broader patterns Balance between recency and data volume Refine AI content generation: Edit system prompt in "LinkedIn Content Strategy AI" node Adjust content length, tone, or style preferences Add industry-specific guidelines Include brand voice requirements Modify hashtag strategy Customize image generation: Edit image prompt structure in AI prompt Change visual style, colors, or composition Adjust for brand guidelines Modify dimensions or aspect ratios Change posting schedule: Adjust "LinkedIn Content Automation Scheduler" frequency Consider optimal posting times for your audience Balance between content quality and posting frequency Coordinate with other marketing activities Enhance data collection: Increase posts per profile in Apify settings Add more profile URLs to monitor Implement competitor tracking Track additional metrics like impressions or click-through rates Add notifications: Connect Slack/Email nodes after successful posts Set up alerts for high-performing content Create reports of analyzed trends Monitor API usage and errors
by Oneclick AI Squad
Automate your post-event networking with this intelligent n8n workflow. Triggered instantly after an event, it collects attendee and interaction data, enriches profiles with LinkedIn insights, and uses GPT-4 to analyze engagement and generate tailored follow-up messages. High-value leads are prioritized, messages are sent via email, LinkedIn, or Slack, and all activity is logged in your CRM and database. Save hours of manual follow-up while boosting relationship-building and ROI. 🤝✨ Advanced Features Webhook automation** – Starts instantly on event completion Multi-Source Enrichment** – Combines event data, interactions, and LinkedIn profiles AI-Powered Insights** – GPT-4 analyzes behavior and suggests personalized talking points Smart Priority Filtering** – Routes leads into High, Medium, and Low priority paths Personalized Content Generation** – AI crafts custom emails and LinkedIn messages Multi-Channel Outreach** – Sends via Email, LinkedIn DM, and Slack CRM Integration** – Automatically updates HubSpot with contact notes and engagement PostgreSQL Logging** – Stores full interaction history and analytics ROI Dashboard** – Tracks response rates, meetings booked, and pipeline impact What It Does Collects attendee data from your event platform Enriches with LinkedIn profiles & real-time interaction logs Scores networking potential using engagement algorithms Uses AI to analyze conversations, roles, and mutual interests Generates hyper-personalized follow-up emails and LinkedIn messages Sends messages through preferred channels (email, LinkedIn, Slack) Updates HubSpot CRM with follow-up status and next steps Logs all actions and tracks analytics for performance reporting Workflow Process The Webhook Trigger initiates the workflow via POST request with event and attendee data. Get Attendees** fetches participant list from the event platform. Get Interactions** pulls Q&A, chat, poll, and networking activity logs. Enrich LinkedIn Data** retrieves professional profiles, job titles, and company details via LinkedIn API. Merge & Enrich Data** combines all sources into a unified lead profile. AI Analyze Profile** uses GPT-4 to evaluate interaction depth, role relevance, and conversation context. Filter High Priority** routes top-tier leads (e.g., decision-makers with strong engagement). Filter Medium Priority** handles warm prospects for lighter follow-up. AI Agent1** generates personalized email content using chat model and memory. Generate Email** creates a professional, context-aware follow-up email. Send Email** delivers the message to the lead’s inbox. AI Agent2** crafts a concise, friendly LinkedIn connection message. Generate LinkedIn Msg** produces a tailored outreach note. Send LinkedIn** posts the message via LinkedIn API. Slack Notification** alerts your team in real-time about high-priority outreach. Update CRM (HubSpot)** adds contact, tags, and follow-up tasks automatically. Save to Database (Insert)** logs full lead journey and message content in PostgreSQL. Generate Analytics** compiles engagement metrics and success rates. Send Response** confirms completion back to the event system. Setup Instructions Import the workflow JSON into n8n Configure credentials: Event Platform API (for attendees & interactions) LinkedIn API (OAuth2) OpenAI (GPT-4) SMTP (for email) or Email Service (SendGrid, etc.) HubSpot API Key PostgreSQL Database Slack Webhook URL Trigger with a webhook POST containing event ID and settings Watch personalized outreach happen automatically! Prerequisites Event platform with webhook + attendee/interaction API LinkedIn Developer App with API access OpenAI API key with GPT-4 access HubSpot account with API enabled PostgreSQL database (table for leads & logs) Slack workspace (optional, for team alerts) Example Webhook Payload { "eventId": "evt_spring2025", "eventName": "Annual Growth Summit", "triggerFollowUp": true, "priorityThreshold": { "high": 75, "medium": 50 } } Modification Options Adjust scoring logic in AI Analyze Profile (e.g., weight Q&A participation higher) Add custom email templates in Generate Email with your brand voice Include meeting booking links (Calendly) in high-priority messages Route VIP leads to Send SMS via Twilio Export analytics to Google Sheets or BI tools (Looker, Tableau) Add approval step before sending LinkedIn messages Ready to 10x your event ROI? Get in touch with us for custom n8n automation!
by Rahul Joshi
Description Turn incoming Gmail messages into structured Zendesk tickets, enriched by Azure OpenAI, and log key details to Google Sheets for tracking. Ideal for IT Support teams needing fast, consistent intake and documentation. ⚡ What This Template Does Fetches new emails via Gmail Trigger. ✉️ Normalizes Gmail data and formats it for downstream steps. Enriches and structures content with Azure OpenAI Chat Model and Output Parsers. Creates Zendesk tickets from the processed data. 🎫 Appends or updates logs in Google Sheets for auditing and reporting. 📊 Key Benefits Saves time by automating ticket creation and logging. ⏱️ Improves ticket quality with AI-driven normalization and structure. Ensures consistent records in Google Sheets for easy reporting. Reduces manual errors in IT Support intake. ✅ Features Gmail-triggered intake flow for new messages. AI enrichment using Azure OpenAI Chat Model with parsing and memory tooling. Zendesk ticket creation (create: ticket) with structured fields. Google Sheets logging (appendOrUpdate: sheet). Modular design with Execute Workflow nodes for reuse and scaling. Requirements n8n instance (Cloud or self-hosted). Gmail credentials configured in n8n for the Gmail Trigger. Zendesk credentials with permission to create tickets. Google Sheets credentials with access to the target spreadsheet (append/update enabled). Azure OpenAI credentials configured for the Azure OpenAI Chat Model and associated parsing. Target Audience IT Support and Helpdesk teams handling email-based requests. 🛠️ Operations teams standardizing inbound email workflows. Agencies and MSPs offering managed support intake. Internal automation teams centralizing ticket capture and logging. Step-by-Step Setup Instructions Connect Gmail credentials in n8n and select the inbox/label for the Gmail Trigger. Add Zendesk credentials and confirm ticket creation permissions. Configure Google Sheets credentials and select the target sheet for logs. Add Azure OpenAI credentials to the Azure OpenAI Chat Model node and verify parsing steps. Import the workflow, assign credentials to each node, update any placeholders, and run a test. Rename the final email/logging nodes descriptively (e.g., “Log to Support Sheet”) and schedule if needed.
by Daniel Shashko
How it Works This workflow accepts meeting transcripts via webhook (Zoom, Google Meet, Teams, Otter.ai, or manual notes), immediately processing them through an intelligent pipeline that eliminates post-meeting admin work. The system parses multiple input formats (JSON, form data, transcription outputs), extracting meeting metadata including title, date, attendees, transcript content, duration, and recording URLs. OpenAI analyzes the transcript to extract eight critical dimensions: executive summary, key decisions with ownership, action items with assigned owners and due dates, discussion topics, open questions, next steps, risks/blockers, and follow-up meeting requirements—all returned as structured JSON. The intelligence engine enriches each action item with unique IDs, priority scores (weighing urgency + owner assignment + due date), status initialization, and meeting context links, then calculates a completeness score (0-100) that penalizes missing owners and undefined deadlines. Multi-channel distribution ensures visibility: Slack receives formatted summaries with emoji categorization for decisions (✅), action items (🎯) with priority badges and owner assignments, and completeness scores (📊). Notion gets dual-database updates—meeting notes with formatted decisions and individual task cards in your action item database with full filtering and kanban capabilities. Task owners receive personalized HTML emails with priority color-coding and meeting context, while Google Calendar creates due-date reminders as calendar events. Every meeting logs to Google Sheets for analytics tracking: attendee count, duration, action items created, priority distribution, decision count, completeness score, and follow-up indicators. The workflow returns a JSON response confirming successful processing with meeting ID, action item count, and executive summary. The entire pipeline executes in 8-12 seconds from submission to full distribution. Who is this for? Product and engineering teams drowning in scattered action items across tools Remote-first companies where verbal commitments vanish after calls Executive teams needing auditable decision records without dedicated note-takers Startups juggling 10+ meetings daily without time for manual follow-up Operations teams tracking cross-functional initiatives requiring accountability Setup Steps Setup time:** 25-35 minutes Requirements:** OpenAI API key, Slack workspace, Notion account, Google Workspace (Calendar/Gmail/Sheets), optional transcription service Webhook Trigger: Automatically generates URL, configure as POST endpoint accepting JSON with title, date, attendees, transcript, duration, recording_url, organizer Transcription Integration: Connect Otter.ai/Fireflies.ai/Zoom webhooks, or create manual submission form OpenAI Analysis: Add API credentials, configure GPT-4 or GPT-3.5-turbo, temperature 0.3, max tokens 1500 Intelligence Synthesis: JavaScript calculates priority scores (0-40 range) and completeness metrics (0-100), customize thresholds Slack Integration: Create app with chat:write scope, get bot token, replace channel ID placeholder with your #meeting-summaries channel Notion Databases: Create "Meeting Notes" database (title, date, attendees, summary, action items, completeness, recording URL) and "Action Items" database (title, assigned to, due date, priority, status, meeting relation), share both with integration, add token Email Notifications: Configure Gmail OAuth2 or SMTP, customize HTML template with company branding Calendar Reminders: Enable Calendar API, creates events on due dates at 9 AM (adjustable), adds task owner as attendee Analytics Tracking: Create Google Sheet with columns for Meeting_ID, Title, Date, Attendees, Duration, Action_Items, High_Priority, Decisions, Completeness, Unassigned_Tasks, Follow_Up_Needed Test: POST sample transcript, verify Slack message, Notion entries, emails, calendar events, and Sheets logging Customization Guidance Meeting Types:** Daily standups (reduce tokens to 500, Slack-only), sprint planning (add Jira integration), client calls (add CRM logging), executive reviews (stricter completeness thresholds) Priority Scoring:** Add urgency multiplier for <48hr due dates, owner seniority weights, customer impact flags AI Prompt:** Customize to emphasize deadlines, blockers, or technical decisions; add date parsing for phrases like "by end of week" Notification Routing:** Critical priority (score >30) → Slack DM + email, High (20-30) → channel + email, Medium/Low → email only Tool Integrations:** Add Jira/Linear for ticket creation, Asana/Monday for project management, Salesforce/HubSpot for CRM logging, GitHub for issue creation Analytics:** Build dashboards for meeting effectiveness scores, action item velocity, recurring topic clustering, team productivity metrics Cost Optimization:** ~1,200 tokens/meeting × $0.002/1K (GPT-3.5) = $0.0024/meeting, use batch API for 50% discount, cache common patterns Once configured, this workflow becomes your team's institutional memory—capturing every commitment and decision while eliminating hours of weekly admin work, ensuring accountability is automatic and follow-through is guaranteed. Built by Daniel Shashko Connect on LinkedIn