by Nima Salimi
✉️ Automate MailerSend Email (Google Sheets) 🌐 Overview This workflow converts Google Sheets into a full Email CRM — no HubSpot or Customer.io needed! It automates segmentation, sending, validation, and delivery tracking using: ✅ Google Sheets → CDP + Email Performance DB ✅ MailerSend → Email Template Delivery ✅ n8n → Automation + Logic + Scheduling It automatically: • Reads subscribers from a selected segment sheet • Validates email + checks for disposable domains • Sends a MailerSend email template • Updates send status + delivery result in Sheets Perfect for onboarding emails, promo campaigns, retention flows, newsletters & more! ✅ Key Features • 🎯 Unlimited audience segments • 🚫 Deduplication system per execution • 🛡️ Disposable email filtering • 🔄 Automatic recurring runs (every 30 minutes) • 🧩 Template-based personalization (name, codes, journey) • 📊 Real-time delivery tracking + analytics-ready data • 🔐 Zero CRM vendor lock-in 📊 Database Sheets (Google Sheets Required) Use this database template: 🔗 https://docs.google.com/spreadsheets/d/17KqltP-NqchPhZV7gk6QToqCZX6IiA5EBkDCBNsIX_0/edit?usp=sharing | Sheet Name | Purpose | Required Fields | |-----------|---------|----------------| | template | Campaign configuration | Id, template_name, journey, type, type_template_id, discount_code | | segment1 / segment2 | Audience lists | user_id, email, first_name, number | | transaction | Status + results history | user_id, status, sent_result, sent_at, template_name | transaction | CreatedAt | UpdatedAt | user_id | email | number | first_name | status | database_id | type | template_id | type_template_id | template_name | journey | discount_code | gift_code | |----------------------------------|----------------------------------|-----------------|------------------------|-------------|------------|------------|-------------|------|-------------|-------------------|-----------------|---------|---------------|-----------| | 2025-10-25T13:11:41.567-04:00 | 2025-10-25T13:11:41.567-04:00 | uid_0000000001 | nimasalimi42@gmail.com | 9362000000 | Liam | 1-sending | segment1 | email | 1 | v28xxl2sq8dg785k | SMS-TEST | Test | disxxx | | | 2025-10-25T13:11:41.567-04:00 | 2025-10-25T13:11:41.567-04:00 | uid_0000000002 | user2@gmail.com | 9362000001 | Noah | 1-sending | segment1 | email | 1 | v28xxl2sq8dg785k | SMS-TEST | Test | disxxx | | | 2025-10-25T13:11:41.567-04:00 | 2025-10-25T13:11:41.567-04:00 | uid_0000000003 | user3@gmail.com | 9362000002 | Oliver | 1-sending | segment1 | email | 1 | v28xxl2sq8dg785k | SMS-TEST | Test | disxxx | | template | Id | template_name | journey | database_id | type | type_template_id | discount_code | gift_code | |----|---------------------------|----------------|-------------|------|-------------------|---------------|-----------| | 3 | Order-Confirmation | Order | segment3 | email | v28xxl2sq8dg785k | discount2 | | | 4 | Shipping-Notification | Notification | segment4 | email | v28xxl2sq8dg785c | discount3 | | | 5 | Add-to-Cart-day1 | Add-to-Car | segment5 | email | v28xxl2sq8dg785d | discount4 | | | 6 | Welcome-New-Customer | Welcome | segment6 | email | v28xxl2sq8dg785s | discount5 | | | 7 | Churn-Pro-Plan | Churn | segment7 | email | v28xxl2sq8dg785g | proxc | | | 8 | Churn-Pro-Plan-1day-ago | Churn | segment8 | email | v28xxl2sq8dg785h | | shipx | segment1 | user_id | email | number | first_name | database_id | |-----------------|-------------------------|--------------|------------|-------------| | uid_0000000001 | nimasalimi42@gmail.com | 09362000000 | Liam | segment1 | | uid_0000000002 | user2@gmail.com | 09362000001 | Noah | segment1 | | uid_0000000003 | user3@gmail.com | 09362000002 | Oliver | segment1 | | uid_0000000004 | user4@gmail.com | 09362000003 | Elijah | segment1 | | uid_0000000005 | user5@gmail.com | 09362000004 | James | segment1 | 📌 Add more segments simply by creating new sheets (segment3, segment4...) 📌 Change campaign by updating template_id in Setup Flow node 👤 Who’s it for? • Ecommerce email retention teams • SaaS CRM automation operators • Digital marketing & lifecycle pros • Agencies running multi-brand campaigns • No-code builders who want scalable CRM logic ⚙️ Automations Included Flow 1 — Insert Users (Triggered on schedule) • Pull users from selected segment tab • Insert into transaction sheet • Status: 0-processing → 1-sending • Prevent duplicate sending ✅ Flow 2 — Send Emails (Runs every 30 min) • Selects “ready” users (1-sending) • Checks: Missing email → 3-no-email Disposable → 4-disposal-email • Sends via MailerSend template ID in sheet • Updates status → 2-sent + message result 🎯 Your entire CRM sending logic runs automatically every day 🧠 Personalization Support Available merge-fields: • first_name • discount_code • gift_code (Modify jsonBody to add more!) 🔐 MailerSend Setup Required Inside MailerSend node: Replace “info@example.com” with your verified sender email ✅ You must: ✔ Verify domain ✔ Approve sender email ✔ Copy correct template ID → Google Sheet 💡 Optional Enhancements • Slack alerts for failed sends • Connect Looker Studio for dashboards • Add SMS / WhatsApp parallel flows • A/B test templates by duplicating rows • Add AI for subject optimization or copy rewrite 📺 Connect With Me More workflows, CRM strategy & AI marketing automation 👇 LinkedIn: https://linkedin.com/in/nima-salimi-a655a6231 Follow & ⭐️ this template if it helped you 🚀
by Jitesh Dugar
University Admission Confirmation & Welcome Kit A robust n8n workflow template that automates the university admission process for colleges, universities, and educational programs. This workflow validates student emails, generates professional PDF admission letters, sends personalized welcome emails, and handles errors efficiently — all in under 15 seconds per submission. Perfect for streamlining student onboarding with professional communication. Overview This workflow automates the process of handling new admission submissions by: Verifying student emails in real-time Generating university-branded admission confirmation PDFs Sending personalized welcome emails Logging invalid entries and preventing spam Key Features Email Verification & Fraud Prevention Real-time email validation using VerifiEmail API Checks RFC compliance, MX records, disposable emails, and spoofed addresses Rejects invalid emails before processing Prevents fake registrations and ensures deliverability Automated PDF Generation Creates branded, print-ready admission letters using PDFMunk Includes student details, program information, and verification badge Professional design with gradient headers and university branding Dynamic data integration for personalized documents Smart Email Notifications Student Welcome Email:** Personalized confirmation with PDF attachment Invalid Email Alerts:** Notifies admissions team of failed validations Responsive Design:** Mobile-friendly, clear next steps Intelligent Routing Conditional logic based on validation results Valid emails → generate PDF + send email Invalid emails → log and stop workflow Saves API usage and execution time Error Handling Comprehensive error detection for validation and API failures Detailed logging for invalid addresses Stops on failure to avoid unnecessary processing Sends admin alerts with actionable info Perfect For Universities & Colleges (Undergraduate & Postgraduate Admissions) Online Education Platforms (MOOCs, Certifications) Training & Vocational Programs Study Abroad Agencies Scholarship & Fellowship Applications Continuing Education Departments Workflow Statistics | Metric | Detail | |---------|--------| | Total Nodes | 15 | | Complexity | ⭐⭐ Medium | | Processing Time | 8–15 seconds per submission | | Setup Time | 10–15 minutes | | Code Required | ❌ No code (No-code solution) | | Maintenance | Minimal (Set & forget) | Requirements Required Services & APIs | Service | Purpose | Signup | |----------|----------|--------| | VerifiEmail API | Email validation | verifi.email | | PDFMunk API | PDF generation | pdfmunk.com | | Gmail | Email notifications | Google Cloud Console | Optional Integrations Google Forms or Typeform (data source) Google Sheets (admission tracking) Slack (team notifications) CRM (Salesforce, HubSpot, etc.) What Gets Created PDF Admission Letter Generated using PDFMunk API Includes: University-branded header & gradient design Email verification badge Student details (Name, Course, Application ID) Admission date & program info Professional footer & signature Email Notifications 1. Student Welcome Email Personalized greeting + attached PDF Next steps checklist (enrollment, orientation, etc.) Mobile-responsive design 2. Invalid Email Alert (Admin) Sent to admissions@youruniversity.edu Includes failure reasons, student name, and application ID Actionable follow-up steps Quick Start Guide 1️⃣ Import Template Copy workflow JSON In n8n → Workflows → Import from Clipboard Paste and import 2️⃣ Configure Credentials (10 minutes) A. VerifiEmail API Sign up → get API key → add under VerifiEmail account B. PDFMunk API Sign up → get API key → add under HtmlcsstopdfApi account C. Gmail OAuth2 Create project in Google Cloud Console Enable Gmail API → OAuth 2.0 credentials Add under Gmail account in n8n 3️⃣ Update Email Addresses Welcome Email Node:** admissions@youruniversity.edu Invalid Alert Node:** admissions team email Update branding details in email + PDF templates 4️⃣ Test the Workflow curl -X POST https://your-n8n.com/webhook/admission-form \ -H "Content-Type: application/json" \ -d '{ "name": "John Doe", "email": "john.doe@example.com", "course": "B.Tech Computer Science", "college_name": "TechNova University", "application_id": "TN-2025-0451", "admission_date": "2025-10-12" }' 5️⃣ Activate Workflow Toggle ON in n8n (top-right corner). 🧠 Detailed Setup Instructions Step 1: VerifiEmail Configuration Sign up → get API key Add in VerifiEmail Node credentials Test with sample email Step 2: PDFMunk Setup Sign up → get API key Add in HTML to PDF Node Test with sample execution Step 3: Gmail Configuration Enable Gmail API Add OAuth 2.0 credentials Authenticate with Gmail account Test sending an email Step 4: Webhook Setup Copy webhook URL from “Webhook - Admission Form” node Connect your form platform (Google Form, Typeform, etc.) Ensure JSON payload includes: name, email, course, college_name, application_id, admission_date Step 5: Test & Validate ✅ Valid email: Check PDF generation + welcome email ❌ Invalid email: Confirm admin alert sent ⚠️ Missing data: Review error logs 🔄 Workflow Diagram Start ↓ Webhook Trigger ↓ Email Verification (VerifiEmail API) ↓ Conditional Check (Valid?) ↙️ ↘️ TRUE FALSE ↓ ↓ Generate PDF Log Error ↓ ↓ Send Welcome Email End ↓ Done ✅ Processing Flow Details | Stage | Time | | ----------------------- | ----------- | | Webhook → Data capture | ~0s | | Email Verification | ~2–3s | | PDF Generation | ~4–6s | | Email Delivery | ~2–3s | | Total (Valid Email) | 8–15s ⚡ | | Invalid Email Path | 3–5s 🚀 | Customization Options Easy Customizations Email Templates:** Update HTML & university branding PDF Template:** Modify HTML (colors, fonts, fields) Error Messages:** Customize admin alerts Advanced Customizations Add Tracking:** Google Sheets or CRM Multi-Language Support:** Generate localized PDFs Extra Notifications:** Slack or SMS for staff CRM Integration:** Auto-push student data to Salesforce Troubleshooting | Issue | Cause | Solution | | -------------------- | ----------------------------- | ----------------------------- | | Email marked invalid | API key or quota issue | Check VerifiEmail dashboard | | PDF not generated | HTML error or expired API key | Validate HTML + check PDFMunk | | Email not sent | OAuth expired | Re-auth Gmail credential | | Webhook inactive | URL incorrect or workflow off | Activate + test via curl | Performance & Scalability | Metric | Current Capacity | | ---------------------- | --------------------------------- | | Concurrent Submissions | 10–20 | | Daily Volume | 500–1000 | | PDF Size | 100–500 KB | | Storage | Temporary (email attachment only) | Scaling Up Upgrade API tiers for high-volume admissions Add queue system or DB logging Validate large payloads & compress data Security & Privacy All API calls via HTTPS OAuth2 for Gmail authentication No student data stored post-execution Encrypted verification process Compliance GDPR compliant (minimal retention) Secure credential storage in n8n Full audit via execution logs License This template is provided as-is for commercial and personal use under the MIT License.
by Yassin Zehar
Description Receive one clean Gmail recap each day with all Google Forms submissions. The workflow reads your Form-linked Google Sheets, compiles every request submitted today, and sends a single, structured email at your chosen time—keeping your inbox tidy. Context Instead of receiving dozens of individual notifications, consolidate all daily form submissions into one organized email recap. Who is this for? Teams managing multiple incoming requests per day. Managers who want a daily summary instead of real-time alerts. Anyone who prefers to avoid notification spam. Requirements Google account with Forms & Sheets access Google Forms linked to Google Sheets Gmail account with n8n OAuth configured Steps 🗒️ Use the sticky notes in the n8n canvas to: Credentials : Add/verify Google (Sheets) and Gmail credentials in n8n. Schedule : Add a Cron/Schedule Trigger (default: 17:00/ 5PM, your local time). Add Google Sheets node → Read mode. Spreadsheet: select your Form-linked sheet. Build the Recap Body Use a Code (Function) node to assemble a simple HTML list or table from the filtered rows. Send Gmail : Add Gmail node and setup your team inbox / distribution list. For the body, paste the HTML body from step 5 and enable HTML. Test & Activate : Submit a few sample responses, run once, confirm the email looks right. Turn the workflow ON. You’ll get this: A structured Gmail message listing all daily submissions with: submitter name, timestamp, request details, and any custom fields from your form. Tutorial video Watch the Youtube Tutorial video How it works ⏰ Trigger: workflow runs once a day at your chosen time (default 5 PM). 📑 Collects all requests from that day in the Google Sheet. 📝 Compile: Generates a recap list/table. 📝 Generates a recap list with all submissions. 📨 Sends one Gmail email summarizing all requests of the day. About me : I'm Yassin, IT Project Manager, Agile & Data specialist. Scaling tech products with data-driven project management. 📬 Feel free to connect with me on Linkedin
by Yassin Zehar
Description Get a single Gmail notification immediately whenever someone submits your Google Forms. The workflow watches the Form-linked Google Sheets for new rows and sends a clean, readable email within about a minute—perfect for time-sensitive workflows. Context Stay responsive to urgent requests without inbox overload. Get notified immediately when new submissions arrive, with all key details in one clean email. Who is this for? Teams collecting support requests, project inputs, or approvals. Anyone who needs to respond quickly to new form submissions. Perfect for time-sensitive workflows. Requirements Google account A Google Forms linked to a Google Sheets (Responses → “Link to Sheet”) Gmail account connected to n8n (OAuth) Steps 🗒️ Use the sticky notes in the n8n canvas to: Create a Google Forms and link it to a Google Sheets. Credentials**: Add/verify Google (Sheets) and Gmail credentials in n8n. Add Google Sheets Trigger node. Spreadsheet: your Form-linked sheet. Polling interval**: every 1 minute (or adjust as needed). Send Gmail**: Add Gmail node and set up recipient team inbox or on-call email. Test & Activate**: Submit a sample form, wait 1 minute, confirm the email. Make sure the workflow is always activated** You’ll get this: A Gmail message with key details (requester, summary, priority, link to the sheet), easy to scan and act on. Tutorial video Watch the Youtube Tutorial video How it works ⏰ Trigger: workflow runs every time you get a request from the form (trigger checks every minute) 📝 Prepare: Format the submission into a concise message. 📨 Notify: Sends one Gmail email per submission About me : I'm Yassin, IT Project Manager, Agile & Data specialist. Scaling tech products with data-driven project management. 📬 Feel free to connect with me on Linkedin
by Emir Belkahia
E-commerce Weekly Bestseller Video Generator (Algolia + Google VEO 3) This workflow automatically identifies your weekly bestselling product from your Algolia-powered e-commerce store and generates a cinematic product video using Google VEO 3.0 AI, helping marketing teams create engaging video content without manual editing or expensive production tools. Who's it for E-commerce stores using Algolia for search. Ideal for marketing teams who want to automate video content creation for top-performing products and maximize conversion potential with engaging visual content. What it does (and doesn't do) ✅ It DOES: Identify your weekly bestseller automatically via Algolia custom ranking Validate product images before video generation Generate 6-second cinematic product videos using Google VEO 3.0 Store videos in Supabase for easy frontend integration Update Algolia records with video URLs automatically Send email alerts if products lack images ❌ It DOESN'T: Generate videos for all products at once Edit or customize videos after generation Create multi-product compilation videos Replace manual video editing for complex productions Work without Google Cloud Storage (VEO 3.0 requirement) Think of it as: An automated video production assistant that doubles down on your bestsellers with engaging content, not a full video editing suite. How it works Weekly trigger - Runs every Monday at 9:00 PM (or manually for testing) Bestseller fetch - Queries Algolia index with empty search to get top-ranked product Video check - Skips products that already have videos Image validation - Ensures product has a valid, accessible image URL Video generation - Converts image to base64 and sends to Google VEO 3.0 with cinematic prompt Polling loop - Waits and checks generation status until video is ready Storage transfer - Downloads MP4 from Google Cloud Storage and uploads to Supabase Index update - Marks product as having video and adds public URL to Algolia Set up steps Setup time: ~20 minutes Connect your Algolia credentials (Search API key + Application ID) Replace placeholders: ALGOLIA_APP_ID with your Algolia Application ID YOUR_INDEX_NAME with your product index name PROJECT-ID-GOOGLE-CLOUD with your Google Cloud Project ID GOOGLE_STORAGE_BUCKET_NAME with your GCS bucket name YOUR_SUPABASE_PROJECT with your Supabase project ID YOUR_BUCKET_NAME with your Supabase bucket name admin@example.com with your email address Configure Algolia custom ranking (inStock + popularity recommended) Ensure your products have hasVideo, images[], name, description attributes Set up Google Vertex AI with VEO 3.0 API access Create Google Cloud Storage bucket for VEO 3.0 outputs Create Supabase storage bucket for final video hosting Requirements Algolia account with product index (free tier works) Algolia index with products containing image URLs Google Vertex AI account with VEO 3.0 API access Google Cloud Storage bucket (mandatory for VEO 3.0) Supabase account with storage bucket (free tier works) Gmail account for error notifications Products with attributes: hasVideo, images[], name, description, objectID Why both Google Cloud Storage AND Supabase? VEO 3.0 can only output videos as base64 strings or MP4 files in Google Cloud Storage. Base64 strings are too large for n8n to process (even with code nodes), making Google Cloud Storage mandatory. The workflow then downloads the MP4 and uploads it to Supabase because: Supabase is where your other product assets already live Supabase offers generous free tier and simpler pricing Easier to serve videos to your frontend from a single storage provider Think of Google Cloud Storage as a temporary staging area required by VEO 3.0's limitations, and Supabase as your actual production storage. Cost breakdown For a typical 6-second product video: Google VEO 3.0 generation: ~$0.15-0.30 per video Google Cloud Storage: ~$0.002 (temporary staging) Supabase storage: Free tier covers hundreds of videos 💰 Bottom line: About $0.15-0.30 per video. Running weekly for a year = $8-16 in video generation costs. 💡 Pro tips Customize the video prompt: The default prompt creates a cinematic studio dolly shot. Edit the jsonBody in "Generate video with Google VEO 3" to match your brand style (fast-paced, minimalist, lifestyle, etc.). Adjust bestseller logic: Modify the Algolia query to add filters like category:electronics or brand:Nike to focus on specific product segments. Use manual execution during setup: Don't wait until Monday! Run the workflow manually to catch configuration issues like broken image URLs or missing credentials immediately. Monitor your email alerts: If you frequently get "no image" or "broken image" alerts, audit your product data quality in Algolia. Missing images = lost video opportunities. Start with test products: Before going live, manually trigger the workflow on a product you know has good images. Verify the video appears correctly in your Supabase bucket and Algolia record. Check your GCS bucket occasionally: Videos accumulate in Google Cloud Storage after each run. Set up a lifecycle policy to auto-delete files older than 7 days to avoid unnecessary storage costs. Adjust the schedule: If Monday 9PM doesn't work for your team's workflow, change the trigger to run on a different day or time that aligns with your content calendar. How it identifies the bestseller This workflow leverages Algolia's custom ranking feature. When you send an empty search query to Algolia, the first result returned follows your custom ranking criteria. This is an Algolia best practice that ensures your most relevant products appear first even without search terms. In the example configuration, custom ranking uses: inStock attribute - Prioritizes available products popularity attribute - A computed metric based on sales volume, views, and other signals You'll need to configure your own custom ranking in your Algolia index settings to match your business criteria. The workflow assumes your index is already configured to return your bestselling product first when queried with no search terms.
by Matthieu
🔒 N8N Security Audit Report - Automated Weekly Email 🎯 What does this workflow do? This workflow automatically generates and emails a comprehensive security audit report for your N8N instance every week. It identifies potential security risks related to: Credentials** 🔑 : Exposed or insecure credentials Nodes** 🧩 : Sensitive nodes (Code, HTTP Request, SSH, FTP, etc.) Instance settings** 🏢 : Global security configuration Community nodes** 📦 : Third-party nodes that may pose risks The report includes direct links to affected workflows, execution statuses, and actionable recommendations. ✨ Key Features 📊 Smart Risk Assessment Calculates overall risk level: 🟩 Low / 🟧 Moderate / 🟥 High Tracks unique credentials (not just total occurrences) Provides detailed breakdown by node type 🔗 Direct Workflow Links Clickable links to each workflow mentioned Shows last execution status (🟢 success / 🔴 failed) Displays execution timestamps 🌍 Bilingual Support Full support for French and English Switch language with a single variable 📧 Beautiful HTML Email Clean, professional formatting Color-coded risk levels Emoji icons for easy scanning 🚀 Quick Setup (5 minutes) 1️⃣ Configure Credentials N8N API**: Generate an API key in your N8N settings Gmail OAuth2**: Set up OAuth2 for Gmail sending 2️⃣ Set Your Variables Edit the "Set Config Variables" node: { "email_to": "your.email@domain.com", "project_name": "My-N8N-Project", "server_url": "https://n8n.yourdomain.com", // NO trailing slash! "Language": "EN" // or "FR" } 3️⃣ Test & Activate Click "Execute Workflow" to test Check your email inbox Activate for weekly automation 📧 Example Report Output Subject: 🔒 Audit Report My-Project – Risk 🟧 Moderate Content: 📊 Summary • Credentials involved: 8 (5 unique) • Nodes involved: 12 💻 code: 4 🌐 httpRequest: 3 🔐 ssh: 2 • Community nodes: 1 • Overall risk level: 🟧 Moderate 🔐 Credentials Risk Report 🔹 Credentials with full access 🔑 My AWS Credentials 🔑 Database Admin 📋 Workflow: Data Processing Pipeline 🟢 (25-10-2024 06:15 → 06:16) 💻 Process Data 🌐 API Call 🧩 Nodes Risk Report [...detailed node analysis...] 🎨 Customization Options Change Schedule Modify the "Schedule Trigger" node to run: Daily at 8 AM Monthly on the 1st Custom cron expression Add Recipients Add multiple emails in the Gmail node's toList parameter Adjust Risk Thresholds Edit the JavaScript in "Format Audit Report" nodes to customize when risk levels change Use Different Email Service Replace Gmail node with: SMTP Microsoft Outlook SendGrid Any email service N8N supports 💡 Use Cases ✅ Compliance Monitoring: Track security posture for audits ✅ Team Awareness: Keep your team informed of security status ✅ Change Detection: Notice when new risky nodes are added ✅ Best Practices: Get recommendations to improve security ✅ Multi-Environment: Run separate instances for dev/staging/prod 🔧 Technical Details Nodes Used: 8 Credentials Required: 2 (N8N API + Gmail OAuth2) External Dependencies: None N8N Version: Compatible with latest N8N versions Execution Time: ~10-20 seconds 📋 Requirements N8N instance with API access Gmail account (or other email service) N8N API key with audit permissions Valid SSL certificate for workflow links (recommended) 🐛 Troubleshooting Empty report? → Check your N8N API key has audit permissions Workflow links don't work? → Verify server_url is correct and has no trailing slash No execution status shown? → Workflows must have been executed at least once Wrong language displayed? → Set Language to exactly "FR" or "EN" (uppercase) 🌟 Why This Template? Unlike basic monitoring tools, this workflow: ✅ Provides context-aware security analysis ✅ Links directly to affected workflows ✅ Shows real execution data (not just theoretical risks) ✅ Calculates unique credential exposure (not just counts) ✅ Supports bilingual reports ✅ Delivers actionable recommendations 🤝 Feedback & Support Found this helpful? Please rate the template! Have suggestions? Drop a comment below. Pro tip: Combine this with N8N's native alerting for real-time incident response! Tags: #security #audit #monitoring #compliance #automation #email #reporting #credentials #governance 📜 License MIT - Feel free to modify and share!
by Olivier
This template sends you a daily email notification with all prospects that visited your website in the past 24 hours. It uses ProspectPro data to collect, filter, and format prospects into a clear summary, delivered straight to your inbox each morning. Qualified leads are highlighted first, ensuring you don’t miss important activity. ✨ Features Automatically collect new website visitors from ProspectPro every day Highlight qualified (label 1) prospects first in your notification Customizable prospect list: name, location, domain, tags, and visit data Smart filtering: excludes disqualified prospects and old activity Clean daily email with direct link to ProspectPro for more details Extendable with logging, CRM sync, or Slack alerts ⚙ Requirements n8n instance or cloud workspace Install the ProspectPro Verified Community Node ProspectPro account & API credentials (14-day free trial available) Gmail OAuth2 credentials (or replace with your preferred email provider) 🔧 Setup Instructions Import the template into your n8n workspace Configure your ProspectPro API credentials Configure Gmail (or swap for your own email node) Adjust notification content in the "Create a Prospect List" and "Send Notification" nodes (Optional) Add extra error logging, Slack alerts, or CRM sync steps 🔐 Security Notes Workflow includes error branches for ProspectPro and Gmail nodes Prevents sending empty emails if no new prospects are found Code filters out disqualified prospects automatically 🧪 Testing Trigger the workflow manually or wait for the daily schedule Check your Gmail inbox for the notification email Verify the total count and details against ProspectPro dashboard 📌 About ProspectPro ProspectPro is a B2B Prospecting Platform for Dutch SMEs. It helps sales teams identify prospects, track website visitors, and streamline sales without requiring a full CRM. Website: https://www.prospectpro.nl Platform: https://mijn.prospectpro.nl API docs: https://docs.prospectpro.nl Support: https://www.prospectpro.nl/klantenservice Support hours: Monday–Friday, 09:00–17:00 CET
by Jitesh Dugar
Personalized Promo Code Cards for Verified Users Overview This workflow automatically generates beautiful, personalized promotional cards with QR codes and sends them via email to verified users. Perfect for e-commerce stores, marketing campaigns, and customer engagement initiatives. Key Features Email Verification**: Validates email addresses using Verifi Email API to prevent fraud and ensure deliverability Dynamic Promo Cards**: Generates stunning, personalized promotional cards with custom discount codes and QR codes Automated Email Delivery**: Sends professionally designed HTML emails with embedded promo card images Real-time Logging**: Tracks all promo distributions in Google Sheets for monitoring and analytics Error Handling**: Includes error path for invalid emails with admin notifications Fully Customizable**: Easy to customize card design, email template, and discount values Workflow Process Webhook Trigger: Receives user data (name, email, promo_code, discount_value, discount_type) Data Processing: Formats and validates incoming data with default values Email Verification: Checks email validity using Verifi Email API Validation Gateway: Routes valid emails to generation or invalid to error path Card Generation: Creates personalized promo card image using HTML/CSS to Image API Email Delivery: Sends beautifully designed email with promo card via Gmail Logging: Records successful distributions in Google Sheets Error Notification: Sends admin alerts for failed attempts What's Included Beautiful Promo Card Design Gradient purple background (#667eea to #764ba2) Personalized greeting with customer name Prominent discount display in circular badge QR code for easy checkout redemption Validity date clearly shown Professional, mobile-responsive design Professional Email Template Engaging gradient header matching promo card Highlighted promo code section with dashed border Three feature icons (Easy to Use, Exclusive Deal, Limited Time) Call-to-action button Embedded promo card image Clean footer with expiry and contact info Required Integrations & APIs 1. Verifi Email API Purpose**: Email verification and validation Get API Key**: https://verifi.email Setup**: Sign up → Generate API key → Add to workflow credentials 2. HTML/CSS to Image API Purpose**: Convert HTML promo card to PNG image Get API Key**: https://htmlcsstoimg.com Setup**: Create account → Copy API key → Configure in workflow 3. Gmail API (OAuth2) Purpose**: Send personalized promo emails Get Credentials**: https://console.cloud.google.com/ Setup Steps**: Create new project Enable Gmail API Create OAuth 2.0 Client ID Add credentials to n8n 4. Google Sheets API Purpose**: Log promo distributions for tracking Get Credentials**: https://console.cloud.google.com/ Setup Steps**: Enable Google Sheets API Create Service Account (or use OAuth2) Share your Google Sheet with the service account email Add credentials to n8n Quick Start Guide Step 1: Import the Workflow Copy the workflow JSON Go to n8n dashboard Click "Import from File" or "Import from URL" Paste the workflow Step 2: Configure Credentials Set up the following credentials in n8n: Verifi Email API credentials HTML/CSS to Image API credentials Gmail OAuth2 credentials Google Sheets credentials Step 3: Create Google Sheet Create a new Google Sheet Add headers: Timestamp, Name, Email, Promo Code, Discount Value, Status Share with your service account (if using service account auth) Copy the Sheet ID and update in the workflow Step 4: Customize Settings QR Code URL**: Update the checkout URL in the promo card HTML (line with YOURSTORE.com) Admin Email**: Change admin notification email in the "Error Path" node Validity Date**: Update expiry date in both promo card and email template Colors/Design**: Customize gradient colors and styling as needed Step 5: Test the Workflow Activate the workflow Copy the webhook URL Send a POST request with test data: { "name": "John Doe", "email": "john@example.com", "promo_code": "SAVE20", "discount_value": "20%", "discount_type": "percentage" } Input Parameters Send a POST request to the webhook with the following JSON body: { "name": "Customer Name", // Optional: defaults to "Valued Customer" "email": "customer@example.com", // Required: customer email address "promo_code": "SUMMER25", // Optional: defaults to "WELCOME10" "discount_value": "25%", // Optional: defaults to "10%" "discount_type": "percentage" // Optional: defaults to "percentage" } Use Cases E-commerce Welcome offers for new customers Abandoned cart recovery with discount codes Birthday/anniversary promotions Loyalty rewards for repeat customers Marketing Campaigns Seasonal sale promotions Referral program rewards Social media contest prizes Email list incentives Customer Engagement Re-engagement campaigns VIP member benefits Event registration perks Survey completion rewards Customization Options Promo Card Design Modify colors and gradients in the HTML/CSS Change logo/emoji in the header Adjust card dimensions and layout Customize QR code size and styling Update validity date format Email Template Change email subject line Modify header text and styling Add company branding/logo Customize CTA button text and link Update footer information Business Logic Add conditional discounts based on user tier Implement time-based validity Add product-specific promo codes Include multiple discount tiers Add custom validation rules Monitoring & Analytics The workflow automatically logs: Timestamp of each promo distribution Customer name and email Promo code assigned Discount value Distribution status (Success/Failed) Use this data to: Track campaign performance Monitor redemption rates Identify popular discount amounts Analyze email delivery success Debug failed attempts Troubleshooting Common Issues Email not sending: Verify Gmail API credentials are correct Check OAuth2 token hasn't expired Ensure Gmail account has proper permissions Image not generating: Confirm HTML/CSS to Image API key is valid Check API usage limits haven't been exceeded Verify HTML syntax is correct Email validation failing: Ensure Verifi Email API credentials are active Check API rate limits Verify email format in incoming data Google Sheets not updating: Confirm Sheet ID is correct Check service account has edit permissions Verify sheet name matches configuration Pro Tips Test with Invalid Emails: Try sending to invalid emails to verify error handling works Monitor API Limits: Keep track of API usage to avoid hitting rate limits A/B Test Designs: Create multiple card variations to see which performs better Personalize Further: Add more custom fields like user tier, purchase history, etc. Schedule Reports: Create a companion workflow to send daily/weekly promo distribution reports Performance Metrics Processing Time**: 30-60 seconds per request Success Rate**: 95%+ for valid email addresses Scalability**: Handles hundreds of requests per hour Error Recovery**: Automatic admin notifications for failures Security & Privacy Email validation prevents spam and fraud No sensitive data stored in workflow All API credentials encrypted in n8n Google Sheets logging can be disabled if needed Compliant with email marketing best practices Best Practices Email Deliverability: Always validate emails before sending Rate Limiting: Implement delays for bulk sends to avoid spam filters Personalization: Use customer names and relevant discount amounts Clear CTAs: Make it easy for customers to redeem their codes Tracking: Monitor distribution and redemption metrics Testing: Always test with real emails before launching campaigns 📄 License This workflow template is provided as-is for use in your n8n instance. Feel free to customize and adapt to your specific needs. Why Use This Workflow? ✅ Saves Time: Automates entire promo distribution process ✅ Reduces Errors: Email validation prevents bounce rates ✅ Professional Output: Beautiful, branded promo cards ✅ Easy Tracking: Real-time logging in Google Sheets ✅ Scalable: Handles high volume campaigns ✅ Customizable: Easy to adapt to your brand ✅ Cost-Effective: Uses affordable or free tier APIs Perfect for marketers, e-commerce managers, and anyone looking to automate personalized promotional campaigns!
by SIENNA
Automated FTP/SFTP to MinIO Object Backup with Scheduling $\mapsto$ Can work with FTP/SFTP Servers like your Wordpress Website ! What this workflow does ? This workflow performs automated, periodic backups of files from a FTP or SFTP server directory to a MinIO S3 bucket running locally or on a dedicated container/VM/server. It can also work if the MinIO bucket is running on a remote cloud provider's infrastructure; you just need to change the URL and keys. Who's this intended for ? Storage administrators, cloud architects, or DevOps who need a simple and scalable solution for retrieving data from a remote FTP or SFTP Server. This can also be practical for Wordpress Devs that need to backup data from a server hosting a Wordpress Website. In that case, you'll just need to specify the folder that you want to backup (could be one from wordpress/uploads or even the root one) How it works This workflow uses commands to list and download files from a specific directory on a FTP-SFTP Server, then send them to MinIO using their version of the S3 API. The source directory can be a specific one or the entire server (the root directory) Requirements None, just a source folder/directory on a FTP/SFTP Server and a destination bucket on MinIO. You'll also need to get MinIO running. You're using Proxmox VE ? Create a MinIO LXC Container : https://community-scripts.github.io/ProxmoxVE/scripts?id=minio Need a Backup from another Cloud Storage Provider ? Need automated backup from another Cloud Storage Provider ? $\mapsto$ Check out our templates, we've done it with AWS, Azure, and GCP, and we even have a version for FTP/SFTP servers! $\odot$ These workflow can be integrated to bigger ones and modified to best suit your needs ! You can, for example, replace the MinIO node to another S3 Bucket from another Cloud Storage Provider (Backblaze, Wasabi, Scaleway, OVH, ...)
by Jitesh Dugar
🎁 Verified Referral Reward Notification Workflow Overview Transform your referral program into a fully automated, fraud-resistant system that delivers professional rewards to verified referrers. This workflow combines email validation, dynamic coupon generation with visual design, automated email delivery, and comprehensive tracking—all without manual intervention. What This Workflow Does 1. Receives Referral Submissions Accepts form submissions via webhook (compatible with Jotform, Typeform, Google Forms, or any webhook-enabled form) Captures referrer details, email, referred friend, and campaign information 2. Validates Email Addresses Prevents fraud and abuse by verifying email authenticity using VerifiEmail API Checks for disposable emails, invalid formats, and non-existent addresses Ensures high deliverability rates for reward emails 3. Generates Personalized Coupon Cards Creates unique coupon codes with smart formatting (e.g., REF-JOHN1234) Designs beautiful HTML/CSS coupon cards with gradient backgrounds and professional styling Converts HTML to high-quality PNG images using HTMLCSStoImage API 4. Sends Professional Reward Emails Delivers branded thank-you emails with embedded coupon images Includes both visual coupon card and text-based coupon code Personalized with referrer's name and campaign details 5. Tracks Everything in Google Sheets Logs successful rewards with timestamps, coupon codes, and image URLs Records failed verifications for analysis and optimization Provides audit trail and performance metrics 6. Handles Invalid Submissions Gracefully Sends polite notification emails for failed verifications Explains possible reasons (typos, disposable emails, invalid formats) Encourages users to correct and resubmit Perfect For E-commerce stores running referral programs SaaS companies with customer referral incentives Marketing agencies managing client referral campaigns Any business wanting to automate reward distribution Companies needing fraud prevention in their referral systems Key Benefits ✅ Fraud Prevention - Email verification stops fake submissions ✅ Professional Branding - Beautiful, customizable coupon designs ✅ Full Automation - Zero manual work after setup ✅ Complete Tracking - Every submission logged with full details ✅ High Deliverability - Only sends to verified, valid emails ✅ Scalable - Handles unlimited submissions automatically ✅ Analytics Ready - Google Sheets data ready for reporting and dashboards Technical Highlights Conditional logic for valid/invalid email paths Dynamic HTML generation with inline CSS Image rendering for visual coupons Error handling and graceful degradation Comprehensive logging for both success and failure paths Use Cases Referral Marketing Programs - Reward customers for bringing friends Ambassador Programs - Incentivize brand advocates Holiday Campaigns - Run seasonal referral promotions Growth Marketing - Scale word-of-mouth acquisition Partner Programs - Automate partner referral rewards Required Services & APIs Free Tier Available: VerifiEmail** - Email verification (https://verifi.email) HTMLCSStoImage** - HTML to image conversion (https://htmlcsstoimg.com) Google Services (Free): Gmail** - Email sending via OAuth Google Sheets** - Data tracking and logging Form Options (Any webhook-enabled service): Jotform Typeform Google Forms (via extensions) Tally Any custom form with webhook support Setup Time ⏱️ 15-20 minutes (including credential setup and testing) Skill Level 🎯 Beginner-Friendly - Detailed documentation and sticky notes guide you through every step What You'll Need Before Starting Gmail account with 2FA enabled Google Sheet for tracking (template provided in documentation) VerifiEmail API key (free signup) HTMLCSStoImage API key (free signup) Form platform with webhook capability Customization Options Modify coupon discount percentage Change HTML/CSS design and branding Customize email templates Adjust coupon code format Add additional data fields Integrate with CRM or marketing tools A/B test different coupon designs Set validity periods dynamically Featured Community Workflows Submission Notes Why This Workflow Deserves to be Featured: Solves Real Business Problem - Referral fraud is a genuine issue costing businesses money. This workflow provides an elegant solution. Production Ready - Not a demo or proof-of-concept. This is battle-tested code ready for real-world use. Comprehensive Documentation - Every node has detailed sticky notes explaining purpose, configuration, and data flow. Beginner Accessible - Despite sophistication, clear documentation makes it approachable for n8n newcomers. Scalable Architecture - Handles both success and failure paths gracefully with proper error handling. Multi-Service Integration - Demonstrates best practices for connecting multiple APIs and Google services. Visual Excellence - Generates beautiful, professional coupon cards that enhance brand perception. Analytics Built-In - Google Sheets integration enables immediate tracking and reporting. Customizable Template - Easy to adapt for different industries, brands, and use cases. Community Value - Provides a foundation others can build upon and learn from. Business Impact: Reduces manual work by 100% Cuts fraudulent referrals by ~70-80% Improves customer experience with instant rewards Provides actionable data for marketing optimization Scales to handle thousands of referrals automatically Version History v1.0 - Initial release with full automation and dual-path logic Tested and validated in production environment Includes comprehensive documentation and setup guides Support & Documentation Full implementation guide included with: Step-by-step setup instructions Credential configuration details Testing procedures Troubleshooting tips Customization examples Google Sheets template structure License MIT License - Free to use, modify, and distribute Perfect for businesses looking to automate their referral programs without sacrificing quality or control.
by Rahul Joshi
Description: Discover which marketing channels actually convert with this n8n automation template. The workflow fetches all opportunities from HighLevel (GHL), filters for “Closed Won” deals, computes lead-to-sale conversion metrics per source, and sends a summary report to Slack while logging raw data into Google Sheets for ongoing analysis. Perfect for marketing teams, growth analysts, and sales managers who want to reduce wasted ad spend and double down on sources that deliver real ROI. ✅ What This Template Does (Step-by-Step) ⚡ Manual or Scheduled Trigger Run the workflow manually for instant analysis or automate it daily/weekly with a schedule trigger. 📥 Fetch All Opportunities from HighLevel Pulls every deal record from your GHL CRM, including status, amount, and lead source fields. 🔍 Filter for Closed-Won Deals Separates deals by outcome — only “Won” deals are used for conversion tracking, while others trigger Slack alerts for team review. 📊 Log Won Deals to Google Sheets Saves every successful deal’s details into a structured Google Sheet for long-term performance tracking. 🧮 Calculate Lead Source Metrics Aggregates results by lead source, calculating total deals, conversion rate, and total revenue per source automatically. 📢 Send Slack Summary Report Posts a neat summary of conversion metrics to a dedicated Slack channel like #lead-source-report, ensuring visibility for the marketing and sales teams. 🔔 Alert for Lost/Pending Deals Non-won opportunities are flagged and shared with the team via Slack for timely follow-ups. ##🧠 Key Features 📊 Automated lead source performance tracking 💬 Slack alerts for both success and loss updates 📈 Real-time conversion and ROI visibility ⚙️ Seamless GHL + Google Sheets + Slack integration 🔁 Ready to run on-demand or on schedule 💼 Use Cases 💡 Measure campaign ROI across channels 🎯 Identify top-performing ad platforms 📢 Send weekly sales source reports to marketing 💰 Optimize budget allocation using data-driven insights 📦 Required Integrations HighLevel (GHL) – for opportunity data retrieval Google Sheets – for storing and visualizing deal data Slack – for team notifications and reports 🎯 Why Use This Template? ✅ Saves hours of manual reporting work ✅ Ensures consistent performance tracking ✅ Highlights winning and underperforming sources ✅ Helps marketing teams focus on what truly converts
by Mohammad Abubakar
This n8n template helps in making informed decisions for Crypto and Stocks Trading by helping you keep track of breaking changes in the market. How it works Collects crypto and/or stock market headlines from multiple sources: CoinDesk, CoinTelegraph, Google News, and X (via an RSS proxy). Normalizes all items into a consistent structure with fields like source, kind, title, url, publishedAt, matchedKeywords, media[], and topic. Uses topic-specific keyword lists to keep relevant items and a small spam blacklist to drop giveaways / airdrops / obvious noise. Deduplicates items across runs by tracking previously seen links. Bundles everything into a compact { topic, items[] } JSON payload and sends it to your own backend or UI via HTTP. Set up steps Import the template JSON into a new n8n workflow. In the Init RunConfig code node, choose a default topic (crypto or stocks), which platforms to use (CoinDesk / CoinTelegraph / Google News / X), and optionally adjust tickers and keywords. Open the final HTTP Request - Send to your backend node and: Replace the example URL with your own API endpoint. Either set a x-webhook-secret header that your backend validates, or remove this header entirely if you don’t use it. Create any required credentials (for the webhook header auth and for HTTP requests, if needed) – the template does not contain real API keys. Enable either the Schedule Trigger for periodic runs or the Webhook trigger for on-demand runs from your app. Expect roughly 10–20 minutes to import, configure, and test the first run; detailed per-node notes are available as sticky notes inside the workflow canvas.