by David Ashby
Complete MCP server exposing 2 CarbonDoomsDay API operations to AI agents. ⚡ Quick Setup Need help? Want access to more workflows and even live Q&A sessions with a top verified n8n creator.. All 100% free? Join the community Import this workflow into your n8n instance Credentials Add CarbonDoomsDay credentials Activate the workflow to start your MCP server Copy the webhook URL from the MCP trigger node Connect AI agents using the MCP URL 🔧 How it Works This workflow converts the CarbonDoomsDay API into an MCP-compatible interface for AI agents. • MCP Trigger: Serves as your server endpoint for AI agent requests • HTTP Request Nodes: Handle API calls to https://api.carbondoomsday.com/api • AI Expressions: Automatically populate parameters via $fromAI() placeholders • Native Integration: Returns responses directly to the AI agent 📋 Available Operations (2 total) 🔧 Co2 (2 endpoints) • GET /co2/: Get CO2 Measurement by Date • GET /co2/{date}/: CO2 measurements from the Mauna Loa observatory. This data is made available through the good work of the people at the Mauna Loa observatory. Their release notes say: These data are made freely available to the public and the scientific community in the belief that their wide dissemination will lead to greater understanding and new scientific insights. We currently scrape the following sources: [co2_mlo_weekly.csv] [co2_mlo_surface-insitu_1_ccgg_DailyData.txt] [weekly_mlo.csv] We have daily CO2 measurements as far back as 1958. Learn about using pagination via [the 3rd party documentation]. [co2_mlo_weekly.csv]: https://www.esrl.noaa.gov/gmd/webdata/ccgg/trends/co2_mlo_weekly.csv [co2_mlo_surface-insitu_1_ccgg_DailyData.txt]: ftp://aftp.cmdl.noaa.gov/data/trace_gases/co2/in-situ/surface/mlo/co2_mlo_surface-insitu_1_ccgg_DailyData.txt [weekly_mlo.csv]: http://scrippsco2.ucsd.edu/sites/default/files/data/in_situ_co2/weekly_mlo.csv [the 3rd party documentation]: http://www.django-rest-framework.org/api-guide/pagination/#pagenumberpagination 🤖 AI Integration Parameter Handling: AI agents automatically provide values for: • Path parameters and identifiers • Query parameters and filters • Request body data • Headers and authentication Response Format: Native CarbonDoomsDay API responses with full data structure Error Handling: Built-in n8n HTTP request error management 💡 Usage Examples Connect this MCP server to any AI agent or workflow: • Claude Desktop: Add MCP server URL to configuration • Cursor: Add MCP server SSE URL to configuration • Custom AI Apps: Use MCP URL as tool endpoint • API Integration: Direct HTTP calls to MCP endpoints ✨ Benefits • Zero Setup: No parameter mapping or configuration needed • AI-Ready: Built-in $fromAI() expressions for all parameters • Production Ready: Native n8n HTTP request handling and logging • Extensible: Easily modify or add custom logic > 🆓 Free for community use! Ready to deploy in under 2 minutes.
by Ranjan Dailata
Who this is for? The LinkedIn Profile Extract and JSON Resume Builder is a powerful workflow that scrapes professional profile data from LinkedIn using Bright Data's infrastructure, then transforms that data into a clean, structured JSON resume using Google Gemini. The workflow is ideal for automating resume parsing, candidate profiling, or integrating into recruiting platforms. This workflow is tailored for: HR professionals & recruiters automating resume screening Talent acquisition platforms enriching candidate profiles Developers & AI builders creating resume-parsing AI pipelines Data scientists working on labor market analytics Growth hackers profiling prospects via public data What problem is this workflow solving? Parsing resumes or LinkedIn profiles into machine-readable formats is often a manual, error-prone process. Most scraping tools either fail due to anti-bot protections or return unstructured HTML that's hard to work with. This workflow solves that by: Using Bright Data's Web Unlocker for reliable, CAPTCHA-free LinkedIn scraping Extracting clean text and structured profile data via Google Gemini LLM Automatically generating a standards-compliant JSON Resume and Skills Sending the resume to webhooks or storing it for downstream usage What this workflow does Accepts LinkedIn Profile URL and required metadata (Bright Data zone, webhook) Scrapes LinkedIn profile using Bright Data Web Unlocker Extracts clean content and skills using Google Gemini LLM Builds a JSON-formatted resume following the JSON resume schema Sends the JSON resume via Webhook Notification Persists the output by saving the file to disk Setup Sign up at Bright Data. Navigate to Proxies & Scraping and create a new Web Unlocker zone by selecting Web Unlocker API under Scraping Solutions. In n8n, configure the Header Auth account under Credentials (Generic Auth Type: Header Authentication). The Value field should be set with the Bearer XXXXXXXXXXXXXX. The XXXXXXXXXXXXXX should be replaced by the Web Unlocker Token. In n8n, configure the Google Gemini(PaLM) Api account with the Google Gemini API key (or access through Vertex AI or proxy). Update the Set URL and Bright Data Zone node with the LinkedIn profile, Bright Data Zone and the Webhook notification URL. For testing purposes, you can obtain a webhook url using https://webhook.site/ How to customize this workflow to your needs Add Language Translation Insert a translation LLM node to support multilingual profiles. Generate PDF Resumes Convert JSON to formatted PDF resumes using an HTML-to-PDF module. Push to ATS or CRM Add integration nodes to pipe data into applicant tracking systems (ATS), CRMs, or databases. Use Alternative LLMs Swap Gemini with OpenAI or Anthropic Claude if preferred.
by Immanuel
Automated Raw Materials Inventory Management with Google Sheets, Supabase, and Gmail using n8n Webhooks Description What Problem Does This Solve? 🛠️ This workflow automates raw materials inventory management for businesses, eliminating manual stock updates, delayed material issue approvals, and missed low stock alerts. It ensures real-time stock tracking, streamlined approvals, and timely notifications. Target audience: Small to medium-sized businesses, inventory managers, and n8n users familiar with Google Sheets, Supabase, and Gmail integrations. What Does It Do? 🌟 Receives raw material data and issue requests via form submissions. Updates stock levels in Google Sheets and Supabase. Manages approvals for material issue requests with email notifications. Detects low stock levels and sends alerts via Gmail. Maintains data consistency across Google Sheets and Supabase. Key Features Real-time stock updates from form submissions. Automated approval process for material issuance. Low stock detection with Gmail notifications. Dual storage in Google Sheets and Supabase for redundancy. Error handling for robust data validation. Setup Instructions Prerequisites n8n Instance**: Self-hosted or cloud n8n instance. API Credentials**: Google Sheets API: Credentials from Google Cloud Console with Sheets scope, stored in n8n credentials. Supabase API: API key and URL from Supabase project, stored in n8n credentials (do not hardcode in nodes). Gmail API: Credentials from Google Cloud Console with Gmail scope. Forms**: A form (e.g., Google Form) to submit raw material receipts and issue requests, configured to send data to n8n webhooks. Installation Steps Import the Workflow: Copy the workflow JSON from the “Template Code” section (to be provided). Import it into n8n via “Import from File” or “Import from URL”. Configure Credentials: Add API credentials in n8n’s Credentials section for Google Sheets, Supabase, and Gmail. Assign credentials to respective nodes. For example: In the Append Raw Materials node, use Google Sheets credentials: {{ $credentials.GoogleSheets }}. In the Current Stock Update node, use Supabase credentials: {{ $credentials.Supabase }}. In the Send Low Stock Email Alert node, use Gmail credentials. Set Up Nodes: Webhook Nodes (Receive Raw Materials Webhook, Receive Material Issue Webhook): Configure webhook URLs and link them to your form submissions. Approval Email (Send Approval Request): Customize the HTML email template if needed. Low Stock Alerts (Send Low Stock Email Alert, Send Low Stock Email After Issue): Configure recipient email addresses. Test the Workflow: Submit a test form for raw material receipt and verify stock updates in Google Sheets/Supabase. Submit a material issue request, approve/reject it, and confirm stock updates and notifications. How It Works High-Level Steps Receive Raw Materials: Processes form submissions for raw material receipts. Update Stock: Updates stock levels in Google Sheets and Supabase. Handle Issue Requests: Processes material issue requests via forms. Manage Approvals: Sends approval requests and processes decisions. Monitor Stock Levels: Detects low stock and sends Gmail alerts. Detailed Descriptions Detailed node descriptions are available in the sticky notes within the workflow screenshot (to be provided). Below is a summary of key actions. Node Names and Actions Raw Materials Receiving and Stock Update Receive Raw Materials Webhook**: Receives raw material data from a form submission. Standardize Raw Material Data**: Maps form data into a consistent format. Calculate Total Price**: Computes Total Price (Quantity Received * Unit Price). Append Raw Materials**: Records receipt in Google Sheets. Check Quantity Received Validity**: Ensures Quantity Received is valid. Lookup Existing Stock**: Retrieves current stock for the Product ID. Check If Product Exists**: Branches based on Product ID existence. Calculate Updated Current Stock**: Adds Quantity Received to stock (True branch). Update Current Stock**: Updates stock in Google Sheets (True branch). Retrieve Updated Stock for Check**: Retrieves updated stock for low stock check. Detect Low Stock Level**: Flags if stock is below minimum. Trigger Low Stock Alert**: Triggers email if stock is low. Send Low Stock Email Alert**: Sends low stock alert via Gmail. Add New Product to Stock**: Adds new product to stock (False branch). Current Stock Update**: Updates Supabase Current Stock table. New Row Current Stock**: Inserts new product into Supabase. Search Current Stock**: Retrieves Supabase stock records. New Record Raw**: Inserts raw material record into Supabase. Format Response**: Removes duplicates from Supabase response. Combine Stock Update Branches**: Merges branches for existing/new products. Material Issue Request and Approval Receive Material Issue Webhook**: Receives issue request from a form submission. Standardize Data**: Normalizes request data and adds Approval Link. Validate Issue Request Data**: Ensures Quantity Requested is valid. Verify Requested Quantity**: Validates Product ID and Submission ID. Append Material Request**: Records request in Google Sheets. Check Available Stock for Issue**: Retrieves current stock for the request. Prepare Approval**: Checks stock sufficiency for the request. Send Approval Request**: Emails approver with Approve/Reject options. Receive Approval Response**: Captures approver’s decision via webhook. Format Approval Response**: Processes approval data with Approval Date. Verify Approval Data**: Validates the approval response. Retrieve Issue Request Details**: Retrieves original request from Google Sheets. Process Approval Decision**: Branches based on approval action. Get Stock for Issue Update**: Retrieves stock before update (Approved). Deduct Issued Stock**: Reduces stock by Approved Quantity (Approved). Update Stock After Issue**: Updates stock in Google Sheets (Approved). Retrieve Stock After Issue**: Retrieves updated stock for low stock check. Detect Low Stock After Issue**: Flags low stock after issuance. Trigger Low Stock Alert After Issue**: Triggers email if stock is low. Send Low Stock Email After Issue**: Sends low stock alert via Gmail. Update Issue Request Status**: Updates request status (Approved/Rejected). Combine Stock Lookup Results**: Merges stock lookup branches. Create Record Issue**: Inserts issue request into Supabase. Search Stock by Product ID**: Retrieves Supabase stock records. Issues Table Update**: Updates Supabase Materials Issued table. Update Current Stock**: Updates Supabase stock after issuance. Combine Issue Lookup Branches**: Merges issue lookup branches. Search Issue by Submission ID**: Retrieves Supabase issue records. Customization Tips Expand Storage Options **: Add nodes to store data in other databases (e.g., Airtable) alongside Google Sheets and Supabase. Modify Approval Email **: Update the Send Approval Request node to customize the HTML email template (e.g., adjust styling or add branding). Alternative Notifications **: Add nodes to send low stock alerts via other platforms (e.g., Slack or Telegram). Adjust Low Stock Threshold **: Modify the Detect Low Stock Level node to change the Minimum Stock Level (default: 50).!
by David Olusola
Learn Customer Onboarding Automation with n8n ✅ How It Works This smart onboarding automation handles new customer signups by: Receiving signup data via webhook Validating required customer info Creating a contact in HubSpot CRM Sending a personalized welcome email Delivering onboarding documents after 2 hours Sending a personal check-in email after 1 day Sending a Week 1 success guide after 3 days Updating CRM status and notifying the team at each milestone It’s designed for professional onboarding, with built-in timing, CRM integration, and smart notifications to improve engagement and retention. 🛠️ Setup Steps Create Webhook Add a Webhook node in n8n with POST method — this triggers when a new customer signs up. Validate Customer Data Add an IF node to check if email and customerName are present. Create CRM Contact Use a HubSpot node to create a new contact, map fields (e.g., split name into first/last). Send Notifications Add a Telegram or Slack node to alert your team instantly. Send Welcome Email Use an Email Send node for a warm welcome, customized with customer details. Wait 2 Hours Add a Wait node to delay next steps and avoid overwhelming the customer. Send Onboarding Documents Use another Email Send node to deliver helpful PDFs or guides. Wait 1 Day & Send Check-in Another Wait node, followed by a personal check-in email using the customer’s name. Wait 2 More Days & Send Success Guide Deliver Week 1 content via email to reinforce engagement. Update CRM & Notify Team Use HubSpot to update status and Telegram/Slack to notify your team of completion.
by David Ashby
🛠️ Demio Tool MCP Server Complete MCP server exposing all Demio Tool operations to AI agents. Zero configuration needed - all 4 operations pre-built. ⚡ Quick Setup Need help? Want access to more workflows and even live Q&A sessions with a top verified n8n creator.. All 100% free? Join the community Import this workflow into your n8n instance Activate the workflow to start your MCP server Copy the webhook URL from the MCP trigger node Connect AI agents using the MCP URL 🔧 How it Works • MCP Trigger: Serves as your server endpoint for AI agent requests • Tool Nodes: Pre-configured for every Demio Tool operation • AI Expressions: Automatically populate parameters via $fromAI() placeholders • Native Integration: Uses official n8n Demio Tool tool with full error handling 📋 Available Operations (4 total) Every possible Demio Tool operation is included: 📅 Event (3 operations) • Get an event • Get many events • Register an event 🔧 Report (1 operations) • Get a report 🤖 AI Integration Parameter Handling: AI agents automatically provide values for: • Resource IDs and identifiers • Search queries and filters • Content and data payloads • Configuration options Response Format: Native Demio Tool API responses with full data structure Error Handling: Built-in n8n error management and retry logic 💡 Usage Examples Connect this MCP server to any AI agent or workflow: • Claude Desktop: Add MCP server URL to configuration • Custom AI Apps: Use MCP URL as tool endpoint • Other n8n Workflows: Call MCP tools from any workflow • API Integration: Direct HTTP calls to MCP endpoints ✨ Benefits • Complete Coverage: Every Demio Tool operation available • Zero Setup: No parameter mapping or configuration needed • AI-Ready: Built-in $fromAI() expressions for all parameters • Production Ready: Native n8n error handling and logging • Extensible: Easily modify or add custom logic > 🆓 Free for community use! Ready to deploy in under 2 minutes.
by David Ashby
Complete MCP server exposing 3 Compliance API operations to AI agents. ⚡ Quick Setup Need help? Want access to more workflows and even live Q&A sessions with a top verified n8n creator.. All 100% free? Join the community Import this workflow into your n8n instance Credentials Add Compliance API credentials Activate the workflow to start your MCP server Copy the webhook URL from the MCP trigger node Connect AI agents using the MCP URL 🔧 How it Works This workflow converts the Compliance API into an MCP-compatible interface for AI agents. • MCP Trigger: Serves as your server endpoint for AI agent requests • HTTP Request Nodes: Handle API calls to https://api.ebay.com{basePath} • AI Expressions: Automatically populate parameters via $fromAI() placeholders • Native Integration: Returns responses directly to the AI agent 📋 Available Operations (3 total) 🔧 Listing_Violation (1 endpoints) • GET /listing_violation: Get Violation Summary Counts 🔧 Listing_Violation_Summary (1 endpoints) • GET /listing_violation_summary: This call returns listing violation counts for a seller 🔧 Suppress_Listing_Violation (1 endpoints) • POST /suppress_listing_violation: Suppress Listing Violation 🤖 AI Integration Parameter Handling: AI agents automatically provide values for: • Path parameters and identifiers • Query parameters and filters • Request body data • Headers and authentication Response Format: Native Compliance API responses with full data structure Error Handling: Built-in n8n HTTP request error management 💡 Usage Examples Connect this MCP server to any AI agent or workflow: • Claude Desktop: Add MCP server URL to configuration • Cursor: Add MCP server SSE URL to configuration • Custom AI Apps: Use MCP URL as tool endpoint • API Integration: Direct HTTP calls to MCP endpoints ✨ Benefits • Zero Setup: No parameter mapping or configuration needed • AI-Ready: Built-in $fromAI() expressions for all parameters • Production Ready: Native n8n HTTP request handling and logging • Extensible: Easily modify or add custom logic > 🆓 Free for community use! Ready to deploy in under 2 minutes.
by Jitesh Dugar
Transform accounts payable from a manual bottleneck into an intelligent, automated system that reads invoices, detects fraud, and processes payments automatically—saving 20+ hours per week while preventing costly fraudulent payments. 🎯 What This Workflow Does Automates the complete invoice-to-payment cycle with advanced AI: 📧 Check Invoices from Jotform - Monitor Jotform for Invoice Submission 🤖 AI-Powered OCR - Extracts ALL data from PDFs and images (vendor, amounts, line items, dates, tax) 🚨 Fraud Detection Engine - Analyzes 15+ fraud patterns: duplicates, anomalies, suspicious vendors, document quality 🚦 Intelligent Routing - Auto-routes based on AI risk assessment: Critical Fraud (Risk 80-100): Block → Slack alert → CFO investigation Manager Review (>$5K or Medium Risk): Approval workflow with full analysis Auto-Approve (<$5K + Low Risk): Instant → QuickBooks → Vendor notification 📊 Complete Audit Trail - Every decision logged to Google Sheets with AI reasoning ✨ Key Features Advanced AI Capabilities Vision-Based OCR**: Reads any invoice format—PDF, scanned images, smartphone photos 99% Extraction Accuracy**: Vendor details, line items, amounts, dates, tax calculations, payment terms Multi-Dimensional Fraud Detection**: Duplicate invoice identification (same number, similar amounts) Amount anomalies (round numbers, threshold gaming, unusually high) Vendor verification (new vendors, mismatched domains, missing tax IDs) Document quality scoring (OCR confidence, missing fields, calculation errors) Timing anomalies (future dates, expired invoices, weekend submissions) Pattern-based detection (frequent small amounts, vague descriptions, no PO references) Intelligent Processing Risk-Based Scoring**: 0-100 risk score with detailed reasoning Vendor Trust Ratings**: Build vendor reputation over time Category Classification**: Auto-categorizes (software, consulting, office supplies, utilities, etc.) Amount Thresholds**: Configurable auto-approve limits Human-in-the-Loop**: Critical decisions escalated appropriately Fast-Track Low Risk**: Process safe invoices in under 60 seconds Security & Compliance Fraud Prevention**: Catch fraudulent invoices before payment Duplicate Detection**: Prevent double payments automatically Complete Audit Trail**: Every decision logged with timestamp and reasoning Role-Based Approvals**: Route to correct approver based on amount and risk Document Verification**: Quality checks on every invoice 💼 Perfect For Finance Teams**: Processing 50-500 invoices per week CFOs**: Need fraud prevention and spending visibility Controllers**: Want automated AP with audit compliance Growing Companies**: Scaling without adding AP headcount Multi-Location Businesses**: Centralized invoice processing across offices Fraud-Conscious Organizations**: Healthcare, legal, financial services, government contractors 💰 ROI & Business Impact Time Savings 90% reduction** in manual data entry time 20-25 hours saved per week** on invoice processing Same-day turnaround** on all legitimate invoices Zero data entry errors** with AI extraction No more lost invoices** - complete tracking Fraud Prevention 100% duplicate detection** before payment Catch suspicious patterns** automatically Prevent invoice splitting** (gaming approval thresholds) Identify fake vendors** before payment Average savings: $50K-$200K annually** in prevented fraud losses Process Improvements 24-hour vendor response times** (vs 7-10 days manual) 95%+ payment accuracy** with AI validation Better cash flow management** via due date tracking Vendor satisfaction** from transparent, fast processing Audit-ready** with complete decision trail 🔧 Required Integrations Core Services Jotform** - Invoice Submissions Create your form for free on Jotform using this link OpenAI API** - GPT-4o-mini for OCR & fraud detection (~$0.03/invoice) Google Sheets** - Invoice database and analytics (free) Accounting System** - QuickBooks, Xero, NetSuite, or Sage (via API) Optional Add-Ons Slack** - Real-time fraud alerts and approval requests Bill.com** - Payment processing automation Linear/Asana** - Task creation for manual reviews Expensify/Ramp** - Expense management integration 🚀 Quick Setup Guide Step 1: Import Template Copy JSON from artifact In n8n: Workflows → Import from File → Paste JSON Template imports with all nodes and sticky notes Step 2: Configure Email Monitoring Connect Gmail or Outlook account Update filter: invoices@yourcompany.com (or your AP email) Test: Send yourself a sample invoice Step 3: Add OpenAI API Get API key: https://platform.openai.com/api-keys Add to both AI nodes (OCR + Fraud Detection) Cost: ~$0.03 per invoice processed Step 4: Connect Accounting System Get API credentials from QuickBooks/Xero/NetSuite Configure HTTP Request node with your endpoint Map invoice fields to your GL codes Step 5: Setup Approval Workflows Update email addresses (finance-manager@yourcompany.com) Configure Slack webhook (optional) Set approval thresholds ($5K default, customize as needed) Step 6: Create Google Sheet Database Create spreadsheet with columns:
by Growth AI
WhatsApp AI Personal Assistant - n8n Workflow Instructions Who's it for This workflow is designed for business professionals, entrepreneurs, and individuals who want to transform their WhatsApp into a powerful AI-powered personal assistant. Perfect for users who need to manage emails, calendar events, document searches, and various productivity tasks through a single messaging interface. What it does This comprehensive n8n workflow creates an intelligent WhatsApp bot that can process multiple message types (text, voice, images, PDF documents) and execute complex tasks using integrated tools including Gmail, Google Calendar, Google Drive, Airtable, Discord, and internet search capabilities. The assistant maintains conversation context and can handle sophisticated requests through natural language processing. How it works Phase 1: Message Reception and Classification The workflow begins when a message is received through the WhatsApp Trigger. A Switch node automatically classifies the incoming message type (text, audio, image, or document) and routes it to the appropriate processing pathway. Phase 2: Content Processing by Format Text Messages: Direct extraction and formatting for AI processing Voice Messages: Retrieves audio URL from WhatsApp API Downloads audio file with authenticated requests Transcribes speech to text using OpenAI Whisper Formats transcribed content for AI agent Images: Downloads image from WhatsApp API Analyzes visual content using GPT-4O-mini vision model Generates detailed French descriptions covering composition, objects, people, and atmosphere Combines user requests with AI analysis PDF Documents: Validates file format (rejects non-PDF files) Downloads and extracts text content Processes document text for AI analysis Phase 3: AI Assistant Processing The processed content is handled by a Claude Sonnet 4-powered agent with access to: SerpAPI** for internet searches Airtable database** for email contact management Gmail integration** for email operations Google Calendar** for event scheduling and management Google Drive** for document searches Discord messaging** for notifications Calculator** for mathematical operations PostgreSQL chat memory** for conversation context Phase 4: Response Delivery The system intelligently determines response format: For voice inputs: Converts AI response to speech using OpenAI TTS For other inputs: Sends text responses directly Handles technical requirements like MIME type compatibility for WhatsApp Requirements API Credentials Required: WhatsApp Business API** (Trigger and messaging) OpenAI API** (GPT-4O-mini, Whisper, TTS) Anthropic API** (Claude Sonnet 4) Google APIs** (Gmail, Calendar, Drive OAuth2) Airtable API** (Database operations) Discord Bot API** (Messaging) SerpAPI** (Internet search) PostgreSQL Database** (Conversation memory) Self-hosted n8n Instance This workflow requires a self-hosted n8n installation as it uses community nodes and advanced integrations not available in n8n Cloud. How to set up 1. Prerequisites Setup Deploy n8n on a server with public access Obtain WhatsApp Business API credentials Create developer accounts for all required services Set up a PostgreSQL database for conversation memory 2. Credential Configuration Configure the following credentials in n8n: WhatsApp API credentials for both trigger and messaging nodes OpenAI API key with access to GPT-4O-mini, Whisper, and TTS Anthropic API key for Claude Sonnet 4 Google OAuth2 credentials for Gmail, Calendar, and Drive Airtable Personal Access Token Discord Bot token SerpAPI key PostgreSQL database connection 3. WhatsApp Configuration Configure webhook URLs in WhatsApp Business API settings Set up phone number verification Configure message templates if required 4. Tool Configuration Airtable**: Set up email database with 'Nom' and 'Mails' columns Google Calendar**: Configure calendar access permissions Google Drive**: Set up appropriate folder permissions Discord**: Configure bot permissions and channel access 5. Testing and Validation Test each message type (text, audio, image, PDF) Verify all tool integrations work correctly Test conversation memory persistence Validate response delivery in both text and audio formats How to customize the workflow Modify AI Assistant Personality Edit the system message in the "Agent personnel" node to customize the assistant's behavior, tone, and capabilities according to your needs. Add New Tools Integrate additional n8n tool nodes to extend functionality: CRM systems (Salesforce, HubSpot) Project management tools (Notion, Trello) File storage services (Dropbox, OneDrive) Communication platforms (Slack, Microsoft Teams) Customize Content Processing Modify image analysis prompts for specific use cases Add document format support beyond PDF Implement content filtering or moderation Add language detection and multi-language support Enhance Memory and Context Implement user-specific memory sessions Add conversation summaries for long interactions Create user preference storage Implement conversation analytics Response Customization Add multimedia response capabilities Implement response templates for common queries Add typing indicators or read receipts Create custom response formatting Security Enhancements Implement user authentication Add rate limiting for API calls Create audit logs for sensitive operations Implement data encryption for stored conversations Performance Optimization Add caching for frequently accessed data Implement queue management for high-volume usage Add error handling and retry mechanisms Create monitoring and alerting systems Important Notes This workflow processes sensitive data; ensure proper security measures are in place Monitor API usage limits across all integrated services Regularly backup conversation memory data Test thoroughly before deploying to production Consider implementing user access controls for business environments Keep all API credentials secure and rotate them regularly Troubleshooting Audio Issues**: Verify MIME type handling in the "Fix mimeType for Audio" node WhatsApp Delivery**: Check webhook configurations and phone number verification Tool Failures**: Validate all API credentials and permissions Memory Issues**: Monitor PostgreSQL database performance and storage Response Delays**: Optimize tool timeout settings and add proper error handling
by Cheng Siong Chin
Introduction Automate peer review assignment and grading with AI-powered evaluation. Designed for educators managing collaborative assessments efficiently. How It Works Webhook receives assignments, distributes them, AI generates review rubrics, emails reviewers, collects responses, calculates scores, stores results, emails reports, updates dashboards, and posts analytics to Slack. Workflow Template Webhook → Store Assignment → Distribute → Generate Review Rubric → Notify Slack → Email Reviewers → Prepare Response → Calculate Score → Store Results → Check Status → Generate Report → Email Report → Update Dashboard → Analytics → Post to Slack → Respond to Webhook Workflow Steps Receive & Store: Webhook captures assignments, stores data. Distribute & Generate: Assigns peer reviewers, AI creates rubrics. Notify & Email: Alerts via Slack, sends review requests. Collect & Score: Gathers responses, calculates peer scores. Report & Update: Generates reports, emails results, updates dashboard. Analyze & Alert: Posts analytics to Slack, confirms completion. Setup Instructions Webhook & Storage: Configure endpoint, set up database. AI Configuration: Add OpenAI key, customize rubric prompts. Communication: Connect Gmail, Slack credentials. Dashboard: Link analytics platform, configure metrics. Prerequisites OpenAI API key Gmail account Slack workspace Database or storage system Dashboard tool Use Cases University peer review assignments Corporate training evaluations Research paper assessments Customization Multi-round review cycles Custom scoring algorithms Benefits Eliminates manual distribution Ensures consistent evaluation
by Jitesh Dugar
Automated Certificate Generator with Email Validation & Delivery Automatically generate, validate, and deliver professional course completion certificates with zero manual work — from webhook request to PDF delivery in seconds. Overview This workflow transforms certificate generation from a manual design task into a fully automated system. It receives certificate requests via webhook, validates recipient emails using advanced verification, generates beautifully designed HTML certificates, converts them to high-quality PNG images, delivers via professional email templates, and maintains complete audit trails in Google Sheets. Powered by email validation APIs and HTML-to-image conversion, it ensures every certificate meets professional standards while preventing delivery to invalid or fraudulent email addresses. What This Workflow Does Receives certificate requests** via webhook from your LMS, CRM, or custom application Validates recipient emails** using VerifiEmail API with comprehensive checks: RFC compliance verification MX record validation Disposable email detection Spoof and fraud prevention Generates professional certificates** with custom HTML/CSS templates featuring: Purple gradient backgrounds with modern typography Google Fonts integration (Playfair Display + Montserrat) Gold achievement badges Auto-generated unique certificate IDs Formatted completion dates Instructor signatures Converts HTML to PNG** using HTMLcsstoImg API for permanent, shareable images Delivers via email** with branded HTML templates including download links and LinkedIn sharing CTAs Logs everything** to Google Sheets for reporting, analytics, and certificate verification Handles errors** with automatic validation checks and optional Slack notifications Key Features Zero Manual Work**: Fully automated from request to delivery Advanced Email Validation**: Blocks invalid, temporary, and fraudulent email addresses Professional Design**: Print-ready certificates with customizable branding Unique Certificate IDs**: Auto-generated format: CERT-{timestamp}-{random} Instant Delivery**: Certificates sent within seconds of completion Complete Audit Trail**: All certificates logged with 10+ data points Error Prevention**: Validation stops invalid requests before processing Highly Customizable**: Easy to modify colors, fonts, layouts, and email templates Scalable**: Handles hundreds of certificates per day API-Ready**: RESTful webhook endpoint for easy integration Use Cases Educational Institutions Automatically issue certificates for online courses and programs Generate graduation certificates for completed degrees Create participation certificates for workshops and seminars Corporate Training Award compliance training certificates to employees Recognize professional development completions Issue skill certification for internal programs Online Course Platforms Integrate with LMS systems (Teachable, Thinkific, Kajabi) Automate certificate delivery upon course completion Build certificate libraries for student portfolios Event Management Issue attendance certificates for conferences and webinars Generate speaker appreciation certificates Create volunteer recognition certificates Certification Programs Award professional certifications and credentials Generate CPE/CE certificates for continuing education Issue examination completion certificates Prerequisites Required Services & Accounts n8n** (self-hosted or cloud) - Workflow automation platform VerifiEmail Account** - Email validation API HTMLcsstoImg Account** - HTML to PNG conversion Gmail Account** - Email delivery via OAuth2 Google Workspace** - For Sheets logging and tracking Required Credentials VerifiEmail API Key HTMLcsstoImg User ID + API Key Gmail OAuth2 credentials Google Sheets OAuth2 credentials Setup Instructions 1. Import the Workflow Download the certificate-generator.json file In n8n, navigate to Workflows → Import from File Select the JSON file and click Import 2. Configure Credentials VerifiEmail API Sign up at https://verifi.email Navigate to Dashboard → API Keys Copy your API key In n8n: Settings → Credentials → Add Credential Search for "VerifiEmail" Name: VerifiEmail API Paste API key and save Assign to "Verifi Email" node in workflow HTMLcsstoImg API Sign up at https://htmlcsstoimg.com Go to Dashboard → API Copy User ID and API Key In n8n: Credentials → Add Credential → "HTMLcsstoImg" Name: HTMLcsstoImg API Enter User ID and API Key Assign to "HTML/CSS to Image" node Gmail OAuth2 In n8n: Credentials → Add Credential → "Gmail OAuth2" Click Connect my account Follow Google OAuth flow Grant permissions: Send email Name: Gmail OAuth2 Assign to "Send Certificate Email" node Google Sheets OAuth2 Create new Google Sheet: "Certificates Log" Add column headers in Row 1: Certificate ID Recipient Name Course Email Completion Date Generated At Certificate URL Status Instructor Duration In n8n: Credentials → Gmail OAuth2 (same as above works for Sheets) Assign to "Log to Google Sheets" node Select your "Certificates Log" spreadsheet Select "Sheet1" 3. Activate Workflow Click the toggle switch in top-right to activate Copy the Webhook URL from "Certificate Request Webhook" node Format: https://your-n8n-instance.com/webhook/certificate-generator 4. Configure Your Application For LMS Integration: // When course is completed fetch('https://your-n8n-instance.com/webhook/certificate-generator', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ name: student.fullName, course: course.title, date: new Date().toISOString().split('T')[0], email: student.email, instructor: course.instructor, duration: course.duration }) }); For Zapier/Make.com: Trigger: Course completed Action: Webhooks → POST URL: Your webhook URL Body: Map fields to JSON format 5. Test the Workflow Send test request: curl -X POST https://your-n8n-instance.com/webhook/certificate-generator \ -H "Content-Type: application/json" \ -d '{ "name": "Test User", "course": "Test Course", "date": "2025-10-04", "email": "test@gmail.com" }' Verify: Email validation passes Certificate generated successfully Image created at HTMLcsstoImage Email delivered to inbox Entry logged in Google Sheets How It Works Webhook Trigger → Receives POST request with certificate data Email Validation → VerifiEmail checks RFC, MX records, disposable status Field Validation → Ensures name, course, date present and email valid Data Combination → Merges webhook data with validation results HTML Generation → Creates styled certificate with dynamic content Image Conversion → HTMLcsstoImg renders 1200x850px PNG Email Delivery → Gmail sends professional template with download link Database Logging → Google Sheets records all certificate details Error Handling → Catches failures and stops invalid requests Processing Time: 5-10 seconds per certificate API Reference Endpoint POST /webhook/certificate-generator Content-Type: application/json Required Fields { "name": "string", // Full name of recipient "course": "string", // Course or program name "date": "YYYY-MM-DD", // Completion date "email": "string" // Recipient email address } Optional Fields { "instructor": "string", // Instructor name (default: "Program Director") "duration": "string", // Course duration (e.g., "40 hours") "certificateId": "string" // Custom ID (auto-generated if not provided) } Success Response { "success": true, "message": "Certificate generated and sent successfully", "certificateId": "CERT-1728000000-ABC123", "certificateUrl": "https://hcti.io/v1/image/xyz123" } Error Response { "success": false, "error": "Missing required fields: name, course, date, or valid email" } Customization Certificate Design Edit the "Generate HTML Certificate" Code node: Change Brand Colors: // Background gradient background: linear-gradient(135deg, #YOUR_COLOR_1 0%, #YOUR_COLOR_2 100%); // Border color border: 3px solid #YOUR_BRAND_COLOR; Add Company Logo: Modify Fonts: @import url('https://fonts.googleapis.com/css2?family=Your+Font&display=swap'); font-family: 'Your Font', sans-serif; Email Template Edit the "Send Certificate Email" node message: Update Company Info: © 2025 Your Company Name Contact: support@yourcompany.com Change Header Color: .header { background: linear-gradient(135deg, #YOUR_COLOR_1, #YOUR_COLOR_2); } Certificate ID Format In "Generate HTML Certificate" node: // Custom format: COURSE-YEAR-NUMBER const certId = ${data.course.substring(0,3).toUpperCase()}-${new Date().getFullYear()}-${Math.floor(Math.random() * 10000)}; Data Flow Webhook → Email Validation → Field Validation → Combine Data ↓ Generate HTML → Convert to PNG → Send Email ↓ Log to Sheets → Success Response ↓ Error Handling (if failed) Expected Output PNG Certificate Includes: Branded header with logo/company name Recipient name in large display font Course name and duration Formatted completion date Instructor signature section Unique certificate ID Gold achievement badge Professional borders and styling Google Sheets Entry: Certificate ID Recipient details Course information Completion date and time Direct link to certificate image Status: "Sent" Email Notification: Professional HTML template Personalized congratulations message Direct download button Certificate details table LinkedIn sharing encouragement Performance Processing Time:** 5-10 seconds per certificate Daily Capacity:** 250+ certificates (limited by free tier quotas) Image Resolution:** 1200x850px (print-ready) File Size:** ~200-400 KB per PNG Email Delivery:** ~98% success rate Troubleshooting Webhook not receiving data Verify webhook URL is correct Check n8n workflow is activated Ensure POST method is used Validate JSON format Email validation fails Use real email domains (not example.com) Check VerifiEmail API quota Verify API credentials are correct Test with gmail.com addresses first Certificate not generating Check required fields are present Verify date format is YYYY-MM-DD Review "Generate HTML Certificate" node logs Ensure HTMLcsstoImg API key valid Image conversion fails Verify HTMLcsstoImg credits available Check HTML syntax is valid Review API response in execution logs Test HTML locally first Email not delivered Confirm Gmail OAuth2 connected Check recipient email is valid Review spam/junk folders Verify Gmail daily limit not exceeded Google Sheets not updating Re-authenticate Google Sheets OAuth2 Verify spreadsheet permissions Check column names match exactly Ensure sheet exists and is accessible Best Practices Test with small batches before production rollout Monitor API quotas to avoid unexpected failures Use real email addresses during testing (avoid disposable) Archive old certificates periodically from Google Sheets Set up Slack notifications for error monitoring Validate webhook payload before sending Document customizations for team reference Back up Google Sheets regularly Review email deliverability weekly Keep credentials secure and rotate periodically Security Notes All API credentials encrypted in n8n Certificate URLs are publicly accessible via direct link Email validation prevents delivery to fraudulent addresses Webhook uses HTTPS for secure data transmission Google Sheets access controlled via OAuth2 permissions No sensitive data stored in workflow logs Future Enhancements PDF output option for formal certifications Multiple certificate templates (modern, classic, minimalist) QR code verification system Batch certificate generation Multi-language support Certificate revocation capability Analytics dashboard WhatsApp/SMS delivery option Integration with Notion/Confluence knowledge bases Support Resources n8n Documentation n8n Community Forum VerifiEmail Docs HTMLcsstoImage API Gmail API Reference Google Sheets API License This workflow template is provided as-is for free use and modification under the MIT License. Attribution appreciated but not required. Version: 1.0.0 Last Updated: October 2025 Compatibility: n8n v1.0.0+
by Jitesh Dugar
Automated Client Onboarding Workflow This n8n workflow automates the end-to-end client onboarding process: capturing client details, validating emails, assigning tiers, generating welcome packs, creating tasks, notifying teams, archiving records, and sending weekly reports. Who’s It For B2B SaaS companies** onboarding new customers Agencies** handling structured client setups Sales & customer success teams** needing automation Consulting firms** aiming for error-free onboarding ⚙️ How It Works Capture client details through a Webhook (connected to forms). Validate client’s email using Verifi Email. Log onboarding data into Google Sheets. Assign tier logic (Basic/Pro/Enterprise) via Function node. Create a Trello task card with onboarding steps. Generate a personalized Welcome Pack PDF with client details. Send Slack notification to internal team with client details. Download and attach PDF, then send personalized welcome email to the client. Archive structured onboarding data in Airtable. Weekly scheduled report: Collects Airtable onboarding data Processes weekly stats (plans, tiers, counts) Sends onboarding summary via email to the manager 🛠️ How to Set Up Webhook Setup Install & configure credentials: Verifi Email key Google Sheets OAuth2 Airtable OAuth2 Gmail OAuth2 Slack OAuth2 Trello API Optional: Customize the Welcome PDF template (HTML/CSS). Edit tier assignment logic inside the Assign Tier Logic node. Modify Slack & email templates to match your branding. Adjust schedule for weekly reports (default: Monday 9 AM IST). Test with sample payload: { "name": "Jane Doe", "email": "jane@acme.com", "company": "Acme Corp", "plan": "Pro" } 📋 Requirements Self-hosted or Cloud n8n Credentials: Verifi Email, Google Sheets, Airtable, Gmail, Slack, Trello Optional: API for company enrichment ⚠️ Note: The HTML/CSS to PDF node (used for report generation) has a limit of 10 free requests. For production usage, you’ll need an API plan. ⭐ Core Features Email Validation: Blocks fake/spam signups - **Tier Assignment: Auto-classifies clients into Basic/Pro/Enterprise Task Management**: Trello cards for onboarding checklist Welcome PDF Pack**: Branded, client-personalized PDF attachment Slack Notifications**: Real-time internal updates Airtable Archiving**: Permanent record-keeping Weekly Reports**: Automated onboarding summaries for managers 📈 Use Cases & Applications B2B SaaS**: Scale client onboarding without hiring more staff Agencies**: Deliver smooth onboarding experiences Sales Teams**: Reduce delays in CRM entry Customer Success**: Focus on relationship-building instead of admin ✅ Key Benefits Saves 5–6 hours of manual onboarding per client Ensures error-free onboarding with email validation Provides a professional, branded experience Improves collaboration with Slack + Trello integration Scales seamlessly as client volume grows 🔧 Customization Options Modify tier logic (e.g., budget, plan, company size) Customize Slack channel or Trello list for task routing Update PDF branding (logo, theme, styling) Add extra onboarding steps (e.g., Calendly call scheduling) Extend weekly reports (e.g., include ROI or CSM notes) ⚠️ Important Disclaimers For educational & automation purposes Ensure compliance with GDPR/CCPA before storing client data Always test workflow with dummy data before production Workflow Components Webhook Trigger** → Captures client form submissions Verifi Email** → Validates client email Google Sheets** → Logs onboarding entries Code Node** → Assigns tier & priority Trello** → Creates task card for CSM HTML/CSS to PDF** → Generates Welcome Pack PDF Slack** → Notifies team about new client Gmail** → Sends welcome email with PDF Airtable** → Archives full onboarding record Schedule Trigger* + *Report** → Weekly summary to management
by Limbraj More
Automate admin tasks for manufacturing companies by processing emails, extracting key data from invoices & purchase orders, and delivering instant alerts via Gmail and Telegram. 📝 Description This workflow automatically: Fetches incoming emails from Gmail Classifies emails (invoices, purchase orders, payment follow-up, etc.) using AI Sends tailored auto-replies based on content and attachment presence Extracts structured data from attached invoices/POs (PDFs etc.) Delivers alerts and document files to your team via Telegram Logs or routes data for further use in accounting or internal systems ⚙️ Pre-Conditions & Requirements Before using this workflow, you need: Gmail Account with API access (for OAuth2 authentication) Telegram Bot API Token (create a Telegram bot and get your API key) Optional: API credentials for Google Sheets or other data sinks if you want to log extracted data OpenRouter API credentials (for LLM-powered nodes, if used) Access to an n8n instance (cloud or self-hosted) 🛠 Setup Instructions Import the Workflow: Download the JSON file and import it into your n8n instance. Connect Accounts: Configure the Gmail Trigger node with your Gmail OAuth2 credentials Set up the Telegram node with your bot API token Set Required Variables: Adjust AI instructions or prompt text if needed (for your company’s tone/templates) Customize labels, keywords, or filters in code nodes for your use case Set target Telegram chat/group IDs Test the Workflow: Send a sample email with attachments to your Gmail account Confirm that emails are classified, replies are sent, and Telegram notifications/mobile alerts are delivered as expected Review and Connect Optional Modules: For logging or archiving extracted data, connect additional “Google Sheets” or “Webhook” nodes as needed 🧩 Customization Tips Modify Email Categories: Update AI prompt instructions or filters to add/change labels (“Vendor Query,” “Partial Payment,” etc.) Attachment Handling: Edit the code node logic to detect and process additional file types (DWG, XLSX, ZIP, etc.) Notification Logic: Change the Telegram destination or add Slack/Microsoft Teams for broader team alerts Data Logging: Add nodes for CRM, inventory, or ERP integration (push to your accounting or workflow management tool) Example AI Prompt (for categorization) text You are the personal emailing assistant for Zenith Engineering, a manufacturing company... Your tasks: Categorize each email by priority Draft polite, professional replies... Identify and label attachments such as invoices, POs, drawings Response should be a valid JSON object: {"Label":"Important", "Response":"..."} If you have any doubts and questions let me know : smonu2303@gmail.com from Pune. Linkedin: https://www.linkedin.com/in/raj-more-171560bb/