by Hichul
This workflow is an autonomous AI research assistant that transforms a single topic into a comprehensive, multi-chapter report. Designed for researchers, students, and content creators, it automates the entire process from planning and online research to writing, formatting, and delivering a final PDF report directly to your email. How it works Trigger: The workflow begins when a user submits a research topic and an email address through a form. AI Planning: An AI agent breaks the main topic into five focused subtopics. It then generates an engaging report title, a detailed introduction, and chapter headings, saving this initial structure to a Google Sheet. Parallel Research and Writing: The workflow then splits into five parallel paths, one for each subtopic. In each path, it uses the Tavily Search API to gather real-time information from the web. A dedicated AI writer then synthesizes this research into a complete, well-formatted HTML chapter with inline citations. Content Aggregation: As each chapter is completed, its content, sources, and section titles are saved to the central Google Sheet. Final Assembly and Delivery: Once all chapters are written, the workflow compiles the title, introduction, a newly generated table of contents, all chapters, and a complete list of sources into a single HTML document. This document is sent to APITemplate.io to be converted into a professionally formatted PDF, which is then emailed as an attachment to the address provided in the form. Set up steps Google Sheets: Make a copy of the provided Google Sheet Template. Connect your Google account in the credentials menu. Update all Google Sheets nodes to use your copied sheet by selecting it from the list. AI Language Model (Google Gemini): Sign up for an API key from the Google AI Platform. Connect your account in the Google Gemini Chat Model nodes. This template is pre-configured for the affordable gemini-pro-flash-lite model. Tavily Search API: Sign up for a free account at Tavily and get an API key. In the Tavily HTTP Request nodes, create a new Header Auth credential. For the Name, enter X-Tavily-API-Key and for the Value, paste your Tavily API key. APITemplate.io: Sign up for a free account at APITemplate.io and get an API key. Connect your account in the Generate PDF node's credentials. Gmail: Connect the Gmail account you want to send the final report from in the Send Report node's credentials.
by Mahmoud Shrouf
Overview Automate your personal productivity with this intelligent n8n workflow that integrates Telegram, Google Sheets, and OpenAI (GPT-4o). This system uses multiple AI agents to manage work hours, tasks, finances, and emails—all through natural language commands sent via Telegram. Every action is synced to Google Sheets for persistent, structured data storage. What This Template Does This automation system deploys several specialized AI agents: 📊 Work Hours Analyzer**: Analyzes work logs from Google Sheets, calculates total hours by workplace, and generates detailed monthly reports in Arabic. 🛠️ Work Tracking Agent**: Handles start/end work commands, calculates total hours, and updates Google Sheets. 📋 Task Manager Agent**: Manages to-do lists—adding, listing, updating, completing, and deleting tasks—with real-time sync to Google Sheets. 💰 Finance Agent**: Tracks income and expenses in multiple currencies, summarizes daily financial activity, and maintains a full transaction history. 📧 Email Analysis Agent**: Processes incoming Gmail messages, generates AI-powered summaries in Arabic with priority, sentiment, and recommended actions. 📅 Monthly Report Generator**: Automatically triggers at the start of each month to compile a professional PDF report of work hours and sends it to a Telegram topic. Prerequisites & Setup Required Accounts & API Keys Before setup, ensure you have: Telegram Bot Token – from @BotFather OpenAI API Key – with access to gpt-4o-mini or gpt-3.5-turbo Google Sheets API – OAuth2 credentials enabled Gmail Account (Optional) – for email analysis n8n Instance – self-hosted or cloud Google Sheets Structure Create a Google Sheet with the following sheets and columns: Sheet: work Date start at end at place note Total hours Sheet: task Task Status Created At Due Date Notes Sheet: Expenses id Amount Currency Note Type (debit/credit) Date Time Sheet: email name email Step-by-Step Setup Step 1: Import the Workflow In n8n, go to Workflows > Import from file Upload the JSON template Open the canvas and verify all nodes are connected Step 2: Configure Credentials Telegram: Add your bot token under "Telegram account" OpenAI: Enter your API key in "OpenAi account" Google Sheets: Connect using OAuth2 under "Google Sheets account" Gmail (Optional): Set up if using email analysis Step 3: Link Google Sheets Share your Google Sheet with the service account email (if using service account) Copy the Document ID from the sheet URL Update all Google Sheets nodes with the correct sheet names and IDs Ensure column names match exactly Step 4: Set Up Telegram Start a chat with your bot Use /start to initialize Ensure chatId and message_thread_id in Telegram nodes match your group/topic Test sending a message like "Start work at the factory" Step 5: Test the Agents Try these sample commands via Telegram: "Start work at the factory" → Logs start time "Finished work" → Logs end time and calculates hours "Add task: pay the bill" → Adds a new task "How much did I spend today?" → Shows today’s expenses "Send last month's report" → Triggers monthly PDF report (on the first of the month) Key Features Smart Work Tracking Automatic time calculation Query by date, place, or period Real-time Google Sheets sync Task Management Add, list, update, complete, delete tasks Friendly, conversational responses Daily summaries of completed and upcoming tasks Financial Tracking Supports multiple currencies (JOD, USD, ILS, etc.) Daily income/expense summaries Full transaction history Arabic-language responses Email Intelligence AI-powered email summaries Priority, sentiment, and action recommendations Plain-text output in Arabic No JSON or code blocks Automated Monthly Reports Triggered on the 1st of each month Generates detailed work hour reports by workplace Outputs clean, formatted PDF Sends directly to Telegram topic Customization Options Modify AI Prompts Edit the systemMessage in any AI agent node to: Change tone (formal, friendly, concise) Add new response formats Support additional commands or languages Extend Functionality Add daily reminders using Schedule Trigger Implement budget alerts when expenses exceed a threshold Add weekly summaries for tasks or work hours Support multi-currency conversion Enhance Telegram Interaction Add inline buttons for quick actions Create shortcuts like /work, /tasks, /finance Use message_thread_id to organize topics Troubleshooting | Issue | Solution | |------|----------| | Bot not responding | Check webhook URL, bot token, and chatId | | Google Sheets not updating | Verify OAuth2 permissions and sheet sharing | | AI not understanding commands | Review prompt clarity and test input phrasing | | Monthly report not sending | Confirm Schedule Trigger timezone and execution time | Benefits ✅ Full automation with minimal user input 📱 Control everything from Telegram 📊 Data stored securely in Google Sheets 📄 Professional PDF reports generated automatically 💬 Natural, friendly Arabic responses 🔁 Seamless sync across all components This template transforms personal productivity by combining AI intelligence with powerful automation—turning simple Telegram messages into structured data, actionable insights, and professional reports.
by Cristina
Automated Weekly Newsletter with AI Research, Editorial Drafting, and Approval Flow This n8n template demonstrates how to automate the full production cycle of a professional weekly newsletter. It combines AI-powered market research, editorial drafting, compliance validation, and an approval loop — all before creating a final Gmail draft ready for distribution. Use cases are many: Wealth managers sending weekly market updates to clients Startups producing recurring research digests Teams creating automated newsletters for marketing or content distribution Good to know At time of writing, each AI call (research, editorial, QC) consumes API tokens from Perplexity and OpenAI. See provider pricing for updated info. Gmail integration requires OAuth setup with your account. You can adapt the prompts to any domain — from finance to tech to education. How it works Schedule Trigger runs every week and sets the date window. Research LLM fetches structured JSON market data using Perplexity. Editorial LLM transforms research into a polished ~2,000 word client-ready newsletter. QC LLM validates factual accuracy and compliance risks before approval. Preview Email is sent with Approve/Revise buttons. Clicking opens a secure n8n-hosted approval form. Final Draft Creation: Once approved, the workflow generates a clean Gmail draft, ready to send. How to use Replace the demo schedule trigger with your own (weekly, daily, or event-based). Set up Gmail OAuth credentials to enable email previews and final drafts. Update branding (logo, disclaimer, signature) in the HTML builder node. Adjust prompts to your audience — e.g., simplify tone for marketing, or keep institutional tone for financial clients. Requirements Perplexity account for research API (or your LLM of choice) OpenAI for editorial and QC steps (or your LLM of choice) Gmail account with OAuth credentials Optional: your own domain to host the approval webhook Customising this workflow This workflow can be extended beyond financial newsletters. Try: Content marketing: Automate weekly digests or trend reports Education: Generate curriculum summaries with approval loops for teachers Internal comms: Automate compliance-checked company updates
by inderjeet Bhambra
Who's it for Content creators, trainers, and educators who need to convert lengthy documents into digestible micro-learning experiences. How it works This workflow takes your source content (PDFs, articles, handbooks) and uses GPT-4 to intelligently break it into 2-3 minute learning modules. Each module includes a key concept, explanation, practical example, and knowledge check question. How to set up Configure OpenAI credentials with GPT-4 access Connect Slack workspace (optional) Set up Google Docs integration Optionally, Send content via webhook or paste directly Requirements OpenAI API key with GPT-4 access Google Docs account (for document creation) Slack workspace (optional, for notifications) How to customize the workflow Adjust module count and length in AI prompts Modify output formats (email, mobile, Slack) Change document structure and styling Add custom delivery channels Perfect for converting employee handbooks, training materials, and documentation into engaging micro-learning courses that people actually complete.
by Sankar Battula
This workflow turns a simple Telegram message into a full stock research report inspired by Warren Buffett’s value investing approach. A user sends a ticker symbol such as AAPL, MSFT, or AMZN, and the workflow validates the input, runs AI-powered research, performs discounted cash flow calculations, and sends a polished HTML report to Gmail with a final verdict. It is designed as a reusable finance analysis template for creators, developers, and automation builders who want to combine Telegram, AI agents, live research, and email delivery in one workflow. Templates in n8n are intended to help users learn, reuse best practices, and quickly adapt a workflow to their own setup, so this version is structured to be easy to follow and reconfigure after import. What this workflow does Receives a stock ticker from Telegram and cleans the input before processing. Validates the ticker format and stops invalid requests early with a helpful reply. Uses an AI agent to generate a Buffett-style investment analysis. Uses SerpAPI for live company and market research. Uses a calculator tool for DCF and margin-of-safety math. Sends the final HTML report to Gmail and confirms completion in Telegram. Setup instructions Import the workflow into n8n and reconnect your credentials for Telegram, OpenAI, SerpAPI, and Gmail. n8n templates are designed to be imported and then configured in the user’s own environment. Open the Extract Ticker, Chat ID & Email node and replace YOUR_EMAIL@gmail.com with your destination email address. Create or connect your Telegram bot credentials, then test by sending a stock ticker like AAPL or MSFT. Connect your Gmail OAuth2 account so the workflow can send the HTML report email. Activate the workflow and run a live test from Telegram. Requirements Telegram Bot API credentials OpenAI API credentials SerpAPI credentials Gmail OAuth2 credentials Best for Finance research demos AI agent workflow examples Telegram-to-email automations Value investing and stock analysis use cases
by Jitesh Dugar
Verified Beta Tester Access Kit - Automated Onboarding System Transform Your Beta Testing Program Automate your entire beta tester onboarding process from signup to tracking with this comprehensive, production-ready n8n workflow. 📚 CATEGORY TAGS Primary Category: ✅ Marketing & Sales Additional Tags: Automation Email Marketing User Management Onboarding SaaS Product Launch Beta Testing Access Control What This Workflow Does When a beta tester signs up through your form or API, this workflow automatically: ✅ Verifies Email Authenticity - Uses VerifiEmail API to validate addresses and block disposable emails ✅ Generates Unique Access Codes - Creates secure BETA-XXXXXX codes with timestamps ✅ Creates QR Codes - Generates scannable codes for quick mobile activation ✅ Builds Branded Access Cards - Produces professional HTML/CSS cards with tester details ✅ Converts to Images - Transforms cards into shareable PNGs ✅ Sends Welcome Emails - Delivers beautifully formatted emails via Gmail ✅ Logs in Trello - Creates organized tracking cards automatically ✅ Returns API Responses - Sends success/error responses with complete data Complete execution time: 5-10 seconds per signup Perfect For 🚀 SaaS startups launching beta programs 📱 Mobile app developers managing beta testers 🎮 Game studios running closed beta tests 🏢 Enterprise teams controlling early access 💼 Product managers organizing user testing 🔬 Research projects managing participants Key Features Security First Real-time email validation Blocks disposable email addresses Unique, non-guessable access codes Webhook authentication ready Professional Branding Customizable HTML/CSS templates Embedded QR codes Responsive email design High-quality PNG generation Team Collaboration Automatic Trello card creation Organized tracking boards Checklist items for follow-ups Easy team assignments Production Ready Comprehensive error handling Detailed logging Scalable architecture Easy integration What You'll Need Required API Keys (All Have Free Tiers): VerifiEmail - Email verification at https://verifi.email HTMLCSSToImage - Image generation at https://htmlcsstoimg.com Gmail Account - Email delivery Trello Account - Project tracking at https://trello.com/app-key Workflow Steps Webhook receives POST request with tester data VerifiEmail validates email authenticity Conditional logic routes valid/invalid emails Function generates unique BETA-XXXXXX access codes HTTP Request creates QR code image Set node stores QR code URL HTMLCSSToImage converts access card to PNG Gmail sends branded welcome email with kit Trello creates tracking card in board Webhook responds with success/error status Sample Request POST to webhook: { "tester_name": "Aarav Mehta", "tester_email": "aarav@example.com", "product_name": "YourApp v1.0", "signup_date": "2025-11-05" } Success Response (200): { "status": "success", "message": "Beta tester verified and access kit delivered", "data": { "tester_name": "Aarav Mehta", "access_code": "BETA-A7K9M2", "trello_card_created": true, "email_sent": true, "qr_code_generated": true } } Error Response (400): { "status": "error", "message": "Invalid or disposable email address detected", "reason": "Disposable email" } Customization Options Email Template Modify HTML in Gmail node Add company logo Change colors and fonts Access Card Design Edit CSS in HTMLCSSToImage node Adjust QR code size Match your brand Access Code Format Change prefix from "BETA-" to your choice Modify length and characters Trello Integration Add custom fields Include labels Set due dates Assign team members Use Cases Mobile App Beta Launch User fills form → Email verified → Code sent → App activated → Team tracks in Trello SaaS Early Access User signs up → Email validated → Access kit received → Product team manages Game Testing Campaign Player requests access → Email verified → Unique key generated → Community team tracks What Makes This Special Unlike simple email workflows, this is a complete system that handles: Security (email verification) Branding (custom access cards) Communication (professional emails) Tracking (team collaboration) Integration (webhook API) All in one cohesive, production-ready workflow! Troubleshooting Common Issues & Solutions: Webhook not receiving data → Check URL and POST method Email verification fails → Verify API key and rate limits Gmail not sending → Reconnect OAuth2 Trello card fails → Confirm List ID is correct Image not generating → Check HTMLCSSToImage credentials 🏷️ ADDITIONAL METADATA Difficulty Level: ⭐⭐⭐ Intermediate (requires API key setup) Time to Setup: 🕐 10-15 minutes
by Msaid Mohamed el hadi
🤖 Instagram Automation Suite: AI Chatbot & Content Powerhouse Workflow Overview This cutting-edge n8n workflow is a comprehensive automation solution designed to streamline various Instagram operations. It combines an intelligent AI chatbot for direct message management, automated user following, and an advanced content generation system, all integrated to enhance your Instagram presence and efficiency. This workflow automatically: Manages Instagram Direct Messages via Telegram Chatbot: Listens for new messages on Telegram. Routes messages from a specific Instagram user (Wolf23000) for processing. Utilizes an AI agent (powered by OpenRouter's cutting-edge models) to determine the intent of the message (e.g., chat back, run an Instagram-related action like getting profile info, posting, or following). Sends AI-generated responses back to the user via Telegram. Automates Instagram User Following: Scheduled to run at regular intervals (hourly). Processes a list of usernames (likely from a Google Sheet, though not explicitly shown in the provided JSON, it's a common pattern for "Auto Follow users from sheet" sticky note). Initiates following actions on Instagram for the specified users. Generates & Schedules Instagram Posts: Scheduled to run monthly. Leverages an AI agent (powered by OpenRouter) to generate 30 or 31 Instagram post ideas for the current month, based on a predefined "Instagram personality profile." Each post idea includes an imagePrompt (for AI image generation), a caption with emojis and hashtags, and a scheduledDate. Refines these post ideas by enhancing the imagePrompt to be more vivid and detailed for AI image generation, and polishing the caption for optimal engagement. Updates a Google Sheet ("posts generation plan") with the generated content, including the enhanced image prompts and the resulting image URLs (presumably from a separate image generation step not fully detailed in the provided JSON, but implied by image_url updates). Key Benefits Intelligent DM Management: Automate responses and actions for Instagram direct messages, ensuring timely and relevant interactions without manual effort. Effortless Audience Growth: Automatically follow target users, expanding your reach and potential engagement on Instagram. AI-Powered Content Creation: Generate a full month's worth of diverse, engaging Instagram post ideas tailored to a specific personality, complete with image prompts and captions. Content Optimization: Automatically enhance image prompts for better AI image generation and refine captions for maximum impact. Time-Saving: Significantly reduce the manual workload associated with Instagram management, from direct messages to content planning and execution. Consistent Brand Voice: Maintain a consistent and engaging presence on Instagram with AI-generated content aligned with your defined personality. Setup Requirements To set up and run this workflow, you'll need the following: n8n Installation: Install n8n (cloud or self-hosted). The latest stable version, as of July 2025, is v1.101.1. Import the workflow configuration. Configure API credentials for all integrated services. Set up scheduling preferences for continuous operation. System Requirements for Self-Hosting: A modern multi-core processor (2 cores minimum, 4 recommended), 2 GB RAM (4 GB or more recommended), and 20 GB of free SSD storage. Node.js version 16 or later (18.x LTS recommended) is required. PostgreSQL is the recommended database for production. Telegram API Access: Create a Telegram bot via BotFather and obtain your API token. Configure the Telegram Trigger node with your bot's API credentials to receive messages. Pricing: Telegram's API is free to use. OpenRouter API Access: Create an OpenRouter account and generate an API key. This key ({{your open router api key }} as seen in the code) is used to access their chat models (e.g., google/gemini-2.5-flash-preview) for AI agent operations. Pricing: OpenRouter offers a variety of models with different pricing structures, including some free models like DeepSeek R1. Most models operate on a pay-per-usage basis, with costs clearly displayed for each model and prompt. Instagram Session ID: You'll need a valid Instagram session ID ({{ your instagram session ID }} as seen in the code) for the workflow to interact with Instagram. This usually involves extracting it from your browser's cookies after logging into Instagram. Caution: Instagram's terms of service generally prohibit automated interactions, and using session IDs for scraping or automation can lead to account suspension. Use with extreme caution and at your own risk. Apify token setup: *You'll need to replace {{ your apify token }} with you apify token in https requests Google Sheets Credentials: A Google Cloud API key with access to Google Sheets. Set up OAuth2 authentication in n8n for read/write access to your "posts generation plan" spreadsheet (Document ID: 1XHNwAXR4USThaAzX1Y6M5PF2P8WqCBU8mi34FBLkV6M). This sheet is used to store and manage generated post ideas. Pricing: The Google Sheets API is generally free for most common use cases, with generous per-minute quotas (300 read and 300 write requests per minute per project, 60 per user per project). No additional charges are incurred for exceeding these limits. https://docs.google.com/spreadsheets/d/1Ze5SC1g6Q5VzMAKYx0zmqlT00Db1HOchUth1jrPyM2Y/edit?usp=sharing https://docs.google.com/spreadsheets/d/1XHNwAXR4USThaAzX1Y6M5PF2P8WqCBU8mi34FBLkV6M/edit?usp=sharing Predefined Instagram Personality JSON: The workflow relies on a detailed JSON object defining an "Instagram personality" (e.g., user_id, username, full_name, bio, content_preferences, personality_traits, unfulancer_attributes). This JSON needs to be correctly set within the Code nodes (Variables, Variables1, Variables2) to guide the AI content generation. Workflow Architecture [Telegram New Message Trigger] ⬇️ [Variables (Set OpenRouter API Key, Instagram Personality, Session ID)] ⬇️ [Switch (Filter messages from 'Wolf23000' and ensure message text exists)] ⬇️ [Edit Fields (Extract message text)] ⬇️ [AI Agent (Determine action based on message intent)] ⬇️ [Structured Output Parser (Parse AI agent's JSON output)] ⬇️ [Switch1 (Route based on AI agent's determined action: chat_back, run_agent, get_instagram_profile)] ⬇️ ┌─────────────┬─────────────┬─────────────┐ │ │ │ │ ▼ ▼ ▼ ▼ [Send a text message1 (Chat back)] [Send a text message (Run agent confirmation)] [Send a text message2 (Get profile confirmation)] ▲ │ [Schedule Trigger (Hourly for Instagram follow)] ⬇️ [Variables (Set OpenRouter API Key, Instagram Personality, Session ID)] ⬇️ [Code (Prepare usernames for following)] ⬇️ [Code1 (Process followed usernames)] ⬇️ [Schedule Trigger2 (Monthly for Instagram post generation)] ⬇️ [AI Agent1 (Generate monthly Instagram post ideas)] ⬇️ [OpenRouter Chat Model (AI Model for content generation)] ⬇️ [Code2 (Parse AI agent's JSON output)] ⬇️ [Schedule Trigger3 (Daily for post generation refinement and auto-posting)] ⬇️ [AI Agent2 (Enhance image prompts and captions)] ⬇️ [OpenRouter Chat Model2 (AI Model for prompt refinement)] ⬇️ [Update row in sheet1 (Update Google Sheet with enhanced content)] ⬇️ [Get row(s) in sheet2 (Retrieve data from Google Sheet)] Connect With Me Exploring AI-Powered Social Media Automation? 📧 Email: mohamedgb00714@gmail.com 💼 LinkedIn: Mohamed el Hadi Msaid Supercharge your Instagram presence with intelligent automation and AI-driven content\! 🚀
by Jitesh Dugar
Verified Gym Trial Pass with Photo ID Overview Automate gym trial pass generation with email verification, photo ID integration, QR codes, and professional PDF passes. This workflow handles the complete member onboarding process - from signup to verified pass delivery - in under 10 seconds. What This Workflow Does Receives signup data via webhook (name, email, photo URL, validity dates) Verifies email authenticity using VerifiEmail API (blocks disposable emails) Generates unique Pass ID in format GYM-{timestamp} Creates QR code for quick check-in at gym entrance Builds branded pass design with gradient styling, member photo, and validity dates Exports to PDF format for mobile-friendly viewing Sends email with PDF attachment and welcome message Logs all registrations in Google Sheets for record-keeping Returns API response with complete pass details Key Features ✅ Email Verification - Blocks fake and disposable email addresses ✅ Photo ID Integration - Displays member photo on digital pass ✅ QR Code Generation - Instant check-in scanning capability ✅ Professional Design - Gradient purple design with modern styling ✅ PDF Export - Mobile-friendly format that members can save ✅ Automated Emails - Welcome message with pass attachment ✅ Spreadsheet Logging - Automatic record-keeping in Google Sheets ✅ Error Handling - Proper 400 responses for invalid signups ✅ Success Responses - Detailed JSON with all pass information Use Cases Gyms & Fitness Centers** - Trial pass management for new members Yoga Studios** - Week-long trial class passes Sports Clubs** - Guest pass generation with photo verification Wellness Centers** - Temporary access cards for trial periods Co-working Spaces** - Day pass generation with member photos Swimming Pools** - Verified trial memberships with photo IDs What You Need Required Credentials VerifiEmail API - Email verification service Get API key: https://verifi.email HTMLCSSToImage API - PNG image generation Get credentials: https://htmlcsstoimg.com HTMLCSSToPDF API - PDF conversion Get credentials: https://pdfmunk.com Gmail OAuth2 - Email delivery Connect your Google account Enable Gmail API in Google Cloud Console Google Sheets API - Data logging Connect your Google account Same OAuth2 as Gmail Setup Instructions Step 1: Create Google Sheet Create a new Google Sheet named "Gym Trial Passes 2025" Add these column headers in Row 1: Pass ID Name Email Start Date Valid Till Issued At Email Verified Status Step 2: Configure Credentials Add VerifiEmail API credentials Add HTMLCSSToImage credentials Add HTMLCSSToPDF credentials Connect Gmail OAuth2 Connect Google Sheets OAuth2 Step 3: Update Google Sheets Node Open "Log to Google Sheets" node Select your "Gym Trial Passes 2025" sheet Confirm column mappings match your headers Step 4: Test the Workflow Copy the webhook URL from the Webhook node Open Postman and create a POST request Use this test payload: { "name": "Rahul Sharma", "email": "your-email@gmail.com", "photo_url": "https://images.unsplash.com/photo-1633332755192-727a05c4013d?w=400", "start_date": "2025-11-15", "valid_till": "2025-11-22" } Send the request and check: ✅ Email received with PDF pass ✅ Google Sheet updated with new row ✅ Success JSON response returned Step 5: Activate & Use Click "Active" toggle to enable the workflow Integrate webhook URL with your gym's website form Members receive instant verified passes upon signup Expected Responses ✅ Success Response (200 OK) { "status": "success", "message": "Gym trial pass verified and sent successfully! 🎉", "data": { "pass_id": "GYM-1731398400123", "email": "member@example.com", "name": "Rahul Sharma", "valid_from": "November 15, 2025", "valid_till": "November 22, 2025", "email_verified": true, "recorded_in_sheets": true, "pass_sent_to_email": true }, "timestamp": "2025-11-12T10:30:45.123Z" } ❌ Error Response (400 Bad Request) { "status": "error", "message": "Invalid or disposable email address. Please use a valid email to register.", "email_verified": false, "email_provided": "test@tempmail.com" } Customization Options Modify Pass Design Edit the Build HTML Pass node to customize: Colors and gradient (currently purple gradient) Layout and spacing Fonts and typography Logo placement (add your gym logo) Additional branding elements Change Email Template Edit the Send Email with Pass node to modify: Subject line Welcome message Instructions Branding elements Footer content Adjust Validity Period Workflow accepts custom start_date and valid_till from webhook payload. You can also hardcode validity periods in the Generate Pass Details node. Add Additional Fields Extend the workflow to capture: Phone number Emergency contact Medical conditions Membership preferences Referral source Performance Average execution time**: 8-12 seconds Handles**: 100+ passes per hour PDF size**: ~150-250 KB Email delivery**: Instant (Gmail API) Success rate**: 99%+ with valid emails Security & Privacy ✅ Email verification prevents fake signups ✅ Unique Pass IDs prevent duplication ✅ All data logged in your private Google Sheet ✅ No data stored in n8n (passes through only) ✅ HTTPS webhook for secure data transmission ✅ OAuth2 authentication for Google services Tags gym fitness trial-pass email-verification qr-code pdf-generation member-onboarding automation verification photo-id
by Weavely AI
Stop forgetting to send follow-up surveys. This workflow automatically generates a tailored post-meeting survey from your Google Meet notes the moment a meeting ends, and sends it to all attendees with one Slack approval. Who is it for Teams and individuals who run recurring meetings and want structured feedback without manually writing and sending surveys after every call. How it works Google Calendar detects when a meeting ends Waits 10 minutes for Gemini to attach notes to the event Reads the meeting notes from Google Docs An AI agent generates 5 to 7 tailored survey questions based on what was discussed Weavely MCP builds and publishes the form automatically A Slack message is sent to the organiser to review and approve On approval, all attendees receive a branded email with the survey link How to set up Update the Configuration node with your calendar email and Slack user ID Connect Google Calendar, Google Docs, Gmail, OpenAI, and Slack credentials Enable Interactivity in your Slack app settings Requirements Google Workspace Business Standard or higher (required for Gemini meeting notes) OpenAI API key Weavely account, free at weavely.ai Slack workspace and Gmail account How to customise Swap Google Calendar for Calendly or any other calendar trigger Replace Gmail with a Slack message to the meeting channel Swap OpenAI for Claude or any other LLM supported by n8n Adjust the AI prompt to change the number or style of questions
by Rahul Joshi
Description Gain real-time audience intelligence with this cross-platform AI Sentiment Analyzer for Twitter (X) and Facebook. 📊🧠 This workflow consolidates mentions and comments, performs GPT-4o-powered sentiment and keyword analysis, summarizes audience mood, highlights dominant trends, and sends a polished HTML report via email — all automatically. Ideal for marketing and insights teams tracking brand conversations across social platforms. 🚀💬 What This Template Does 1️⃣ Starts manually to fetch the latest Twitter mentions and Facebook post comments. 🕹️ 2️⃣ Merges both datasets into a unified JSON structure for seamless cross-platform analysis. 🧩 3️⃣ Validates incoming API data to ensure completeness before processing. ✅ 4️⃣ Runs a custom JavaScript transformation to normalize all messages and add sentiment placeholders. 🧠 5️⃣ Uses GPT-4o to perform sentiment and keyword trend analysis, returning structured JSON insights. 📈 6️⃣ Parses AI output to extract overall sentiment ratios and detailed post-level analysis. 🔍 7️⃣ Generates a human-readable HTML summary using GPT-4o — featuring emojis, bullet insights, and trend sections. 🎨 8️⃣ Emails the formatted sentiment report directly to the marketing team. ✉️ 9️⃣ Logs API or runtime errors automatically into Google Sheets for transparent monitoring. 🧾 Key Benefits ✅ Provides an automated end-to-end pipeline for sentiment intelligence. ✅ Centralizes Twitter and Facebook audience data in one workflow. ✅ Delivers structured insights ready for dashboards or client reporting. ✅ Generates branded HTML summaries that are ready for emailing. ✅ Improves reliability with built-in error tracking and validation layers. Features Dual-platform integration (Twitter X API + Facebook Graph API). JavaScript logic for merging and normalizing social datasets. GPT-4o-based sentiment classification and keyword extraction. Structured JSON parsing and visualization pipeline. AI-generated HTML summary reports for presentation and sharing. Automated email dispatch via Gmail. Google Sheets logging for audit and debugging. Modular configuration — easily extendable to other social networks. #3 Requirements Twitter OAuth2 credentials for fetching mentions. Facebook Graph API credentials for reading posts and comments. Azure OpenAI (GPT-4o) credentials for sentiment and summary generation. Gmail OAuth2 credentials for automated email delivery. Google Sheets OAuth2 credentials for error logging and tracking. Environment Variables TWITTER_API_KEY FACEBOOK_GRAPH_TOKEN AZURE_OPENAI_API_KEY GMAIL_REPORT_RECIPIENTS GOOGLE_SHEET_ERROR_LOG_ID Target Audience 📈 Marketing and insights teams monitoring audience engagement. 💬 Social media managers analyzing public sentiment. 🧠 Data analysts exploring brand perception trends. 💡 PR and communications teams managing online reputation. 🧾 Operations or automation teams integrating AI analytics into dashboards. Step-by-Step Setup Instructions 1️⃣ Connect all API credentials — Twitter, Facebook Graph, Azure OpenAI, Gmail, and Google Sheets. 2️⃣ Update your Twitter user ID and Facebook Page ID in the respective nodes. 3️⃣ Confirm the merge and validation logic in the Merge Platform Datasets and Validate API Response nodes. 4️⃣ Check that your Azure OpenAI account has GPT-4o access enabled. 5️⃣ Verify the Gmail recipient and test the “Send Email Summary” node for delivery. 6️⃣ Link your Google Sheet with a tab named error log sheet to capture workflow exceptions. 7️⃣ Run the workflow once manually to validate each layer — data, AI response, email delivery. 8️⃣ Optionally, schedule it to run daily or weekly for automated sentiment insights. ✅
by Jitesh Dugar
Transform chaotic training requests into strategic skill development - achieving 100% completion tracking, 30% cost reduction through intelligent planning, and data-driven L&D decisions. What This Workflow Does Revolutionizes corporate training management with AI-driven course recommendations and automated approval workflows: 📝 Training Request Capture - Jotform collects skill gaps, business justification, and training needs 💰 Budget Intelligence - Real-time department budget checking and utilization tracking 🤖 AI Course Recommendations - Matches requests to training catalog with 0-100% scoring 📊 ROI Analysis - AI assesses business impact, urgency, and return on investment ✅ Smart Approval Routing - Auto-approves within budget or routes to manager with AI insights 🎯 Skill Development Paths - Creates personalized learning journeys from current to desired levels 👥 Team Impact Assessment - Identifies knowledge sharing opportunities and additional attendees ⚠️ Risk Analysis - Evaluates delays risks and over-investment concerns 📧 Automated Notifications - Sends detailed approvals to managers and confirmations to employees 📈 Complete Tracking - Logs all requests with AI insights for L&D analytics Key Features AI Training Advisor: GPT-4 analyzes requests across 10+ dimensions including needs assessment, ROI, and implementation planning Course Catalog Matching: AI scores courses 0-100% based on skill level, topic relevance, and outcomes alignment Budget Management: Real-time tracking of department budgets with utilization percentages Preventability Scoring: Identifies skill gaps that could have been addressed earlier Alternative Options: AI suggests cost-effective alternatives (online courses, mentoring, job shadowing) Skill Development Pathways: Maps progression from current to desired skill level with timeframes Team Multiplier Effect: Identifies how training one person benefits entire team Manager Guidance: Provides key considerations, questions to ask, and approval criteria Implementation Planning: Suggests timeline, preparation needed, and post-training actions Success Metrics: Defines measurable outcomes for training effectiveness Risk Assessment: Flags delay risks and over-investment concerns Cost Optimization: Recommends ways to reduce costs while maintaining quality Perfect For Growing Tech Companies: 50-500 employees with high skill development needs Enterprise Organizations: Large corporations managing 1000+ training requests annually Professional Services: Consulting, legal, accounting firms requiring continuous upskilling Healthcare Systems: Medical organizations with compliance and clinical training requirements Manufacturing Companies: Technical skills training for operations and quality teams Sales Organizations: Sales enablement and product training at scale Financial Services: Compliance training and professional certification tracking What You'll Need Required Integrations Jotform - Training request form (free tier works) Create your form for free on Jotform using this link OpenAI API - GPT-4 for AI training analysis (~$0.30-0.60 per request) Gmail - Automated notifications to employees, managers, and HR Google Sheets - Training request database and L&D analytics Quick Start Import Template - Copy JSON and import into n8n Add OpenAI Credentials - Set up OpenAI API key (GPT-4 recommended) Create Jotform Training Request Configure Gmail - Add Gmail OAuth2 credentials Setup Google Sheets: Create spreadsheet with "Training_Requests" sheet Replace YOUR_GOOGLE_SHEET_ID in workflow Columns auto-populate on first submission Customize Training Catalog: Edit "Check Training Budget" node Update training catalog with your actual courses, providers, and costs Add your company's preferred vendors Customization Options Custom Training Catalog: Replace sample catalog with your company's actual training offerings Budget Rules: Adjust approval thresholds (e.g., auto-approve under $500) AI Prompt Tuning: Customize analysis criteria for your industry and culture Multi-Level Approvals: Add VP or director approval for high-cost training Compliance Training: Flag required certifications and regulatory training Vendor Management: Track preferred training vendors and volume discounts Learning Paths: Create role-specific career development tracks Certification Tracking: Monitor professional certifications and renewal dates Training Calendar: Integrate with company calendar for session visibility Waitlist Management: Queue employees when sessions are full Pre/Post Assessments: Add skill testing before and after training Knowledge Sharing: Schedule lunch-and-learns for employees to share learnings Expected Results 100% completion tracking - Digital trail from request to certificate 30% cost reduction - Strategic planning prevents redundant/unnecessary training 95% manager response rate - Automated reminders and clear AI guidance 50% faster approvals - AI pre-analysis speeds manager decisions 40% better course matching - AI recommendations vs manual course selection 60% reduction in budget overruns - Real-time budget visibility 3x increase in skill development velocity - Streamlined process removes friction 85% employee satisfaction - Clear process and fast responses Data-driven L&D strategy - Analytics identify trending skill gaps 25% increase in training ROI - Better targeting and follow-through Use Cases Tech Startup (150 Engineers) Engineer requests "Advanced Kubernetes" training. AI identifies skill gap as "high severity" due to upcoming cloud migration project. Checks department budget ($22K remaining of $50K), recommends $1,800 4-day course with 92% match score. Auto-routes to engineering manager with business impact analysis. Manager approves in 2 hours. Training scheduled for next month. Post-training, engineer leads internal workshop, multiplying impact across 10-person team. Migration completes 3 weeks early, saving $50K. Enterprise Sales Org (500 Reps) Sales rep requests "Negotiation Mastery" after losing 3 deals. AI assesses urgency as "justified" based on revenue impact. Recommends $1,100 2-day course but also suggests lower-cost alternative: internal mentoring from top performer ($0). Manager sees both options, chooses mentoring first. Rep closes next deal with new techniques. Training budget preserved for broader team enablement. ROI: $200K deal closed with $0 training spend. Healthcare System (2,000 Nurses) Nurse requests ACLS recertification. AI flags as "compliance-critical" with "immediate" urgency (expiring in 30 days). Checks budget, finds sufficient funds. Auto-approves and schedules next available session. Sends pre-training materials 1 week before. Tracks attendance, generates certificate upon completion. Updates nurse's credential profile in HRIS. Compliance maintained, no manual intervention needed. Financial Services Firm Analyst requests CFA Level 1 prep course ($2,500). AI assesses as "high ROI" but identifies budget constraint (department at 95% utilization). Recommends deferring to next quarter when new budget allocated. Suggests free Khan Academy courses as interim solution. Manager sees complete analysis, approves deferral, adds analyst to Q2 priority list. Transparent communication maintains morale despite delay. Manufacturing Company Maintenance tech requests PLC programming training. AI identifies 5 other techs with same skill gap. Recommends group training session ($1,200 per person vs $2,000 individual). Calculates team multiplier effect: 6 techs trained = reduced downtime across 3 shifts. Manager approves group session, saving $4,800. All 6 techs complete training together, creating peer support network. Equipment downtime reduced 40%. Pro Tips Quarterly Planning: Use Google Sheets data to identify trending skill gaps and plan group training Budget Forecasting: Track monthly utilization to predict Q4 budget needs Course Ratings: Add post-training feedback to improve AI recommendations over time Internal Experts: Build database of employees who can provide mentoring (free alternative) Learning Paths: Create role-based tracks (e.g., "Junior Dev → Senior Dev" pathway) Compliance Flagging: Auto-identify regulatory/certification requirements Vendor Relationships: Track volume with vendors to negotiate discounts Knowledge Retention: Require post-training presentations to reinforce learning Manager Training: Educate managers on how to evaluate AI recommendations Budget Reallocation: Monthly reviews to move unused budget between departments Early Bird Discounts: AI can suggest booking 60+ days out for savings Continuous Learning: Supplement formal training with Udemy/LinkedIn Learning subscriptions Learning Resources This workflow demonstrates advanced automation: AI Agents with complex analysis across multiple decision dimensions Budget management algorithms with real-time calculations Course recommendation engines with scoring and matching Multi-criteria approval routing based on AI confidence Skill progression modeling from current to desired states ROI analysis balancing cost, impact, and urgency Alternative suggestion algorithms for cost optimization Team impact modeling for knowledge multiplication Risk assessment frameworks for training decisions Real-Time Budget Tracking: Live department budget visibility prevents overspending Audit Trail: Complete history for finance audits and compliance reviews Approval Documentation: Timestamped manager approvals for governance Cost Allocation: Track training costs by department, employee, category ROI Measurement: Compare training investment to business outcomes Compliance Monitoring: Flag required certifications and regulatory training Vendor Management: Track spending with training providers Ready to transform your corporate training? Import this template and turn training chaos into strategic skill development with AI-powered insights and automation! 📚✨ Questions or customization? The workflow includes detailed sticky notes explaining each AI analysis component.
by Ayaka Sato
Who's it for Small teams, solo operators, and security-conscious individuals who receive email attachments from external senders. Useful for freelancers, agencies, HR teams, and anyone handling CVs, invoices, or documents from unknown sources. How it works Every minute, the workflow polls Gmail for new unread emails with attachments. For each attachment, it calculates the SHA256 hash and queries VirusTotal for known-malware matches. In parallel, an AI model analyzes the email subject and body for phishing patterns. A rule-based scorer combines both signals into three threat levels: Danger (VirusTotal malicious count >= 3 OR AI detects phishing) triggers a Gmail quarantine label plus a Slack alert. Suspicious (partial hits) logs to a human review queue in Google Sheets. Safe saves the attachment to Google Drive. AI is used only for text classification — the final quarantine decision is always rule-based. Set up steps Get a free VirusTotal API key at virustotal.com Create a Google Sheet named suspicious_queue with columns: timestamp, email_from, email_subject, attachment, malicious_count, ai_verdict Create a Gmail label called QUARANTINE and a Google Drive folder for safe attachments Open Set Configuration and fill in the Sheet ID, Drive folder ID, Slack channel, and label name Connect Gmail, Sheets, Drive, Slack, OpenAI, and VirusTotal (Header Auth with x-apikey) credentials Activate the workflow How to customize Adjust thresholds in the Code node, swap Slack for Discord or Teams, or add SPF and DKIM header checks before scanning.