by Oneclick AI Squad
The workflow is triggered manually with user input, searches LinkedIn profiles, processes the results using AI, generates connection recommendations, and delivers them via email. It leverages AI to enhance networking opportunities based on insights from profiles. Good to Know Each email is personalized with the user’s name and recommended connections. Recommendations are based on LinkedIn search results and AI analysis. The system ensures data privacy by processing inputs securely. Email notifications include a curated list of potential connections. How it Works Profile Analysis Workflow Get User Data from Email**: Manually inputs user email and profile information to initiate the workflow. Your Profile Information**: Provides initial user data for LinkedIn search. Search LinkedIn Profiles**: Queries LinkedIn via an API (e.g., SerpAPI) to gather profile data. Process LinkedIn Search Results**: Extracts relevant details from search results. AI Recommendation Workflow AI Profile Analysis**: Uses an AI model (e.g., Ollama Model) to analyze profile data and suggest connections. Create Recommendations**: Generates a curated list of potential connections. Create Final Recommendations**: Refines and formats the recommendation list. Create Email**: Prepares a personalized email with the connection list. Send Email**: Delivers the email to the user. Excel Sheet Structure No persistent Excel sheet is required**; data is processed in-memory and emailed directly. However, optional logging can be set up: Optional Log Sheet (Recommendations): Timestamp: Date and time of recommendation generation. User Email: User’s email address. Profile Name: User’s LinkedIn profile name. Industry: User’s industry. Recommended Connections: List of suggested connections. Sent Status: Whether the email was sent successfully. How to Use Import the Workflow into your n8n instance and configure email integration. Provide User Data: Manually enter the user’s email and profile information in the "Get User Data from Email" node. Configure API Credentials: Set up SerpAPI for LinkedIn searches and email service (e.g., SMTP). Run the Workflow: Execute manually to test the process. Monitor Emails: Check the user’s inbox for the curated connection list. Optional Logging: Set up a Google Sheet to log recommendations if desired. Requirements SerpAPI**: For LinkedIn profile searches. Email Service Integration**: Gmail, SMTP, or similar for email delivery. Ollama Model**: For AI-based profile analysis. n8n Instance**: With SerpAPI, email, and function nodes. Customizing this Workflow Expand Data Sources**: Integrate additional platforms (e.g., Xing) for broader searches. Enhance AI**: Train the Ollama Model for more specific connection criteria (e.g., job role, location). Add Notifications**: Include Slack or SMS alerts for admin tracking. Customize Email**: Adjust the email template for branding or additional details. Automate Trigger**: Replace manual input with a scheduled trigger or webhook.
by WeblineIndia
Auto FAQ Generator for Clients using NewsAPI, OpenAI GPT-4.1 and Google Sheets This workflow automatically generates weekly client-ready investment FAQs by combining market news (NewsAPI) and portfolio data (Google Sheets) using OpenAI GPT-4.1. The final FAQs are structured and saved back into Google Sheets. Quick Implementation Steps Import the workflow into n8n Add your NewsAPI API key in the HTTP Request node Connect your Google Sheets account Ensure your sheet has required columns: Client Name Asset Investment Amount Current Value Last Week Value Risk Level Sector Add your OpenAI API key Create a destination sheet with columns: Q1–A5 Activate the workflow That’s it! Your FAQs will be generated every Monday at 8 AM. What It Does This workflow automates the process of generating weekly investment FAQs for clients by combining real-time market insights with portfolio performance data. It ensures that financial advisors or teams can deliver consistent, relevant and easy-to-understand updates without manual effort. It pulls the latest tech-focused market news using NewsAPI and combines it with structured portfolio data stored in Google Sheets. The workflow then analyzes portfolio trends such as high-risk assets and declining investments to enrich the context. Using OpenAI, the workflow generates 5 practical and client-friendly FAQs, each with a short, one-line answer. These FAQs are then structured and saved into a Google Sheet, making them easy to reuse, share or distribute. Who’s It For Financial advisors and wealth managers Investment firms and portfolio managers Fintech startups Client relationship teams Anyone managing client portfolios and communications Requirements To use this workflow, you will need: n8n account (self-hosted or cloud) NewsAPI account** (https://newsapi.org/) OpenAI API key** Google Sheets account** Required Google Sheets Structure 📥 Input Sheet (Portfolio Data) Must include these exact column headers: Client Name Asset Investment Amount Current Value Last Week Value Risk Level Sector 📤 Output Sheet (FAQs) Create a sheet with the following columns: Q1, A1 ,Q2, A2,Q3, A3, Q4, A4, Q5, A5 How It Works & Set Up 1. Schedule Trigger Node: Weekly Portfolio & News Trigger Runs every Monday at 8:00 AM You can modify timing as needed 2. Fetch Market News Node: Fetch Market News (HTTP Request) Endpoint: https://newsapi.org/v2/top-headlines Query Parameters: sources=techcrunch apiKey=YOUR_API_KEY Action Required: Add your NewsAPI key manually 3. Check News Availability Node: IF Node Checks whether news articles exist If yes → formats top 5 articles If no → uses fallback message 4. Format News Node: Format Top News Extracts top 5 headlines and descriptions Node: Fallback News Message Used when no news is available: "No major market news this week. Focus on portfolio performance" 5. Fetch Portfolio Data Node: Fetch Portfolio Data (Google Sheets) Connect your Google account Select your portfolio sheet 6. Format Portfolio Summary Node: Set Node Combines all rows into readable format: Client Name | Asset | Investment Amount | Current Value | Last Week Value | Risk Level | Sector 7. Analyze Portfolio Node: Code Node Calculates: Number of high-risk assets Number of assets losing value 8. Merge Data Node: Merge Node Combines: News data Portfolio summary & analysis 9. Generate FAQs using AI Node: OpenAI Model: gpt-4.1-nano Action Required: Add your OpenAI API credentials AI generates: Exactly 5 FAQs Focus on trends, risks, opportunities Simple one-line answers 10. Extract Structured Output Node: Set Node Uses regex to extract: Q1–Q5 A1–A5 11. Save FAQs to Google Sheets Node: Google Sheets (Append) Writes structured FAQs into output sheet Ensure your sheet has columns: Q1–A5 How To Customize Nodes Change News Source** Modify sources=techcrunch to another provider Adjust AI Output Style** Edit prompt in OpenAI node Example: longer answers, different tone Change Schedule** Update trigger node (daily, weekly, etc.) Modify Portfolio Analysis** Update Code node logic for deeper insights Add-ons Send FAQs via Email (Gmail/SMTP node) Push data to dashboards (Notion, Airtable) Send alerts via Slack or Microsoft Teams WhatsApp or SMS notifications Add historical comparison (week-over-week trends) Use Case Examples Weekly investor update emails Portfolio performance summaries for clients Internal advisory team insights Automated client reporting systems Fintech app content generation There can be many more use cases depending on how you extend the workflow. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|----------| | No news data fetched | Missing or invalid NewsAPI key | Add valid API key in HTTP node | | Empty FAQs | OpenAI credentials missing | Configure OpenAI API key | | FAQs not structured properly | AI output format changed | Ensure prompt format is unchanged | | Google Sheets not updating | Incorrect sheet or permissions | Reconnect credentials and verify sheet | | Portfolio data not showing | Incorrect column names | Ensure exact headers are used | | Workflow not triggering | Schedule inactive | Activate workflow | Need Help? If you need assistance with: Setting up this workflow Customizing AI prompts Adding advanced automation features Integrating with your business tools We’re here to help! Contact WeblineIndia for expert support in building and scaling automation workflows tailored to your business needs.
by Sana Fatima
From Leads to Smiles – Automated Patient Engagement______Turn every lead into a booked appointment with AI 💡 Why this workflow? Dental clinics lose 50%+ of leads due to slow response. This template ensures instant engagement with AI-powered personalization. Works for dentists, beauty clinics, physiotherapists, or any appointment-based business. Description: When a new patient submits a form (e.g., teeth whitening, Invisalign, implants), the workflow: Captures and stores the lead in Google Sheets. 2.Uses an AI Agent to generate a friendly, personalized welcome message. Instantly sends tailored notifications to both the patient and the dentist. No more generic thank-you emails → engage leads before they go cold! 🚀 Category: Marketing & Sales Customer Engagement Healthcare Automation 📖 Step-by-Step Guide (for beginners) Trigger (Google Sheets): Every time a new patient submits a Google Form, the lead is automatically captured in Google Sheets. AI Agent (OpenAI Chat Model): Generates a personalized welcome message Patient Notification (Email): Sends a warm, engaging welcome message with appointment details instantly. Dentist Notification (Email): Alerts the dentist with lead details so they can follow up quickly. Execution: Just hit Execute Workflow → watch as your clinic never loses another lead. 👉 Perfect for beginners in AI + n8n automation. You can duplicate this template, connect your Google Sheet + Gmail + OpenAI API key, and start converting leads today. Tags: lead generation dentist crm google sheets ai agent chatgpt email automation
by Siddhant
Hourly Email Summary: This agent scans your inbox every 4 hour and summarizes new emails into a clean, actionable Slack message. Powered by GPT-4, it classifies emails by Urgency (High, Medium, Low) and Intent (Awaiting Reply, To Respond, Comment, Notification, Marketing). No more inbox FOMO — just what you need to act fast. Main Use Cases: • Stay on top of important threads without refreshing your inbox constantly • Prioritize tasks and replies based on urgency and context • Catch missed follow-ups by surfacing emails that need a response • Filter out noise like marketing emails or low-priority notifications • Enable async decision-making by keeping the team updated on critical emails via Slack • Reduce cognitive load by letting AI handle sorting and triaging ⸻ ✅ Steps to Use Connect Your Accounts: Add your Gmail, Slack, Google Sheets, and OpenAI credentials inside n8n. Create Gmail Labels (Required): Go to your Gmail settings and create labels matching the following format: AI Agent/To Respond, AI Agent/Awaiting Reply, AI Agent/Notification, AI Agent/Marketing, etc. These are used by the workflow to auto-tag emails based on intent. Create a Google Sheet with 2 Tabs • Name the sheet something like “N8N - Emails”. • Add two sheets/tabs inside: • Sheet1 → stores all processed emails • Sheet2 → stores only the latest batch for digest view • In both sheets, add these columns (first row): From | Summary | Intent | Category | TimeStamp | Urgency Import the Workflow: Upload or paste the .json file into your n8n instance. Make sure each node is linked to your active credentials. Configure Slack Channel: In the Slack node, select the channel where you want urgent alerts and digest summaries to be posted. Adjust Schedule (Optional): Default: runs every hour. You can tweak this to suit your preference (e.g., every 30 min or 2 hours). Run a Test: Execute manually once to check: • Emails are getting processed • Labels are added correctly in Gmail • Slack notifications are triggered • Data is logged in Google Sheets Turn It On • Once everything looks good, activate the workflow. • Your inbox will now be triaged in real-time — sorted, labeled, summarized. Step-by-Step Breakdown: ⏰ Schedule Trigger: Runs every hour to kick off the workflow automatically. 📩 Fetch Emails & Labels • Pulls all Gmail messages received in the last 4 hours. • Also fetches Gmail labels to use for tagging messages based on intent. 🤖 Analyze with GPT-4 • Each email is analyzed using GPT-4. • Output includes: • Summary • Urgency: High, Medium, Low • Intent: To Respond, Awaiting Reply, Marketing, Notification, etc. • Category: Customer, Investor, Spam, etc. Classify and Label • Emails are tagged with the right intent label inside Gmail. 5.🚨 Slack Alerts for High Urgency • If an email is marked High Urgency, it sends an alert to a designated Slack channel with all key details. 📊 Google Sheets Logging • All emails are logged to two Google Sheets: • Sheet1: All messages, for long-term record. • Sheet2: Temporary sheet to collect latest batch for digest. ⏳ Wait + Digest Preparation • After logging, the workflow waits 30 seconds. • It then fetches recent entries from Sheet2, filters out older messages, and groups them by Medium and Low urgency. 📬 Slack Digest Summary • A clean digest is posted on Slack showing only the Medium and Low urgency messages from the past hour — helping you catch up without inbox overload. Uses a System Prompt to define its role as an AI Chief of Staff. Uses a User Prompt that instructs GPT-4 to analyze each email and return a structured JSON with the following: • summary – One-line summary of the email • urgency – High / Medium / Low • category – Investor, Customer, Support, Spam, Other • Intent – One of: • To Respond: Needs your reply • Awaiting Reply: You’re waiting for a response • Notification: Auto-updates from tools or services • Meeting Update: Calendar or schedule changes • Marketing: Promotional or cold emails • FYI: Informational emails that don’t need action The output is clean JSON with built-in guardrails to avoid hallucinations or irrelevant content. Only real message data is used for summaries and classification. Sections with no relevant data are omitted to keep it concise. 🧩 What’s Next This agent already cuts through inbox noise and gives you clarity — but there’s more you can build on top: 💡 Suggestions to Improve: • Train on your past threads to make prioritization even smarter • Allow custom rules per sender or domain (e.g. always mark investor emails as High) • Add emoji tags or reactions in Slack to quickly mark emails as done or follow-up • Support voice summary via Slack audio snippet or Loom integration 🚀 Next Features You Could Add: • Reply-from-Slack: One-click smart reply suggestions that can be sent right from Slack • Cross-inbox support: Add Outlook or multiple Gmail accounts • Weekend Digest: A weekly email or Slack drop with trends (top senders, most flagged categories) • Daily Timeline View: Generate a Notion page that logs the day’s most critical communication
by Robert Breen
This n8n workflow sends a real-time Slack notification when a user submits a contact form on your website. It also optionally sends a confirmation email via either Outlook or Gmail. You can embed the form directly into your website and route all submissions to your preferred Slack channel for quick follow-up. ✅ Key Features 🌐 Website Form Trigger**: A no-code form that can be embedded directly on your website. ⚡ Slack Integration**: Instantly posts lead details to a designated Slack channel. 📧 Email Follow-Up (Optional)**: Sends a thank-you email to the user via either Gmail or Microsoft Outlook. 🔗 Easy to Connect**: Requires minimal setup with OAuth for Slack and email APIs. 🧰 What You'll Need Slack Bot Token & Permissions** Gmail or Outlook account (optional)** n8n instance (cloud or self-hosted)** 🛠️ Step-by-Step Setup 1️⃣ Embed Contact Form on Website Node**: Form Submission on Website What it does**: Captures user inputs — Name, Email, and Phone. How to use**: Grab the public webhook URL from this node. Embed it as a form action on your website (HTML form or no-code builder). API**: None required. Webhook-based. 2️⃣ Send to Slack Node**: Slack What it does**: Posts a message to your Slack #leads channel with submission details. Message format**: You have a form submission with these details. Name: {{ Name }} Email: {{ Email }} Phone: {{ Phone }} API**: Slack Bot Token (OAuth2) 3️⃣ Optional: Send Confirmation Email Node**: Send Email - Gmail Sends email using Gmail API. Node**: Send Email - Outlook Sends email using Microsoft Outlook API. Message**: Hi {{ Name }}, Thank you for reaching out on our website. We'll be in touch soon! API**: Gmail or Microsoft Outlook OAuth2 👤 Created By Robert Breen Automation Consultant | AI Workflow Designer | n8n Expert 📧 rbreen@ynteractive.com 🌐 ynteractive.com 🔗 LinkedIn 🏷️ Tags slack lead alerts website form n8n email automation real-time notification lead generation form trigger webhook
by Rahul Joshi
📘 Description: This workflow automates sales contact follow-ups and engagement tracking by integrating HighLevel CRM, Gmail, Slack, and Google Sheets. It fetches all contacts from HighLevel, filters inactive contacts, sends personalized follow-up emails, checks for responses, and notifies the sales team accordingly. It eliminates manual follow-up tracking, ensures timely outreach, and provides real-time notifications — helping sales teams maintain engagement, respond promptly, and improve lead conversion. ⚙️ What This Workflow Does (Step-by-Step) 🟢 Manual Trigger – Starts the automation manually Action: Initiates the workflow for immediate follow-up execution or testing. 📦 Fetch Contacts from HighLevel CRM Action: Retrieves all contacts from HighLevel, including names, emails, and metadata for full visibility. 🔍 Validate Deal Fetch Success (IF Node) Action: Verifies that fetched contacts contain valid IDs. ✅ True Path: Continues to filter inactive contacts. ❌ False Path: Logs invalid or missing contacts to Google Sheets for auditing and troubleshooting. 🧹 Filter Contacts with No Response Action: Selects contacts who have not replied in the last 24 hours, ensuring follow-ups target only inactive leads. 📊 Get Most Recent Contact Action: Retrieves the latest contact based on last updated time and calculates hours since last interaction. 📧 Send Follow-Up Email to Contact Action: Sends a personalized email to the contact, asking for confirmation or questions and including dynamic details like name and last interaction time. ⏳ Wait for 24 Hours Before Next Action Action: Pauses the workflow for 24 hours to allow contacts sufficient time to respond. 📨 Retrieve Email Thread for Response Action: Fetches the most recent Gmail thread using the thread ID to check if the contact has replied. ✅ Check If Contact Responded with “Yes” (IF Node) Action: Evaluates if the response contains the word “yes”. ✅ True Path: Triggers Slack notification for positive response. ❌ False Path: Triggers Slack notification for no response. 💬 Notify Sales Team in Slack if Response Received Action: Sends a Slack message notifying the team of a positive reply, including contact details and response snippet. ⚠️ Notify Sales Team in Slack if No Response Action: Sends a Slack message notifying the team that the contact hasn’t replied, including contact info, follow-up timestamp, and waiting status. 🚨 Log Fetch or Validation Errors (Error Handling) Action: Records any fetch or validation errors in Google Sheets for easy review and troubleshooting. 🧩 Prerequisites HighLevel CRM API OAuth credentials Gmail OAuth2 credentials for sending and fetching emails Google Sheets document for error logging Slack API credentials for notifications 💡 Key Benefits ✅ Fully automated follow-up workflow for sales contacts ✅ Timely notifications for positive and inactive responses ✅ Personalized emails to contacts ✅ Transparent tracking and logging of errors ✅ Seamless integration across HighLevel, Gmail, Slack, and Google Sheets 👥 Perfect For Sales teams managing multiple leads Marketing teams ensuring lead engagement Startups scaling outreach efforts Organizations using HighLevel CRM + Gmail + Slack for sales follow-ups
by Oneclick AI Squad
This n8n workflow enables an AI-powered symptom checker where users input symptoms via a form or chat, analyzes them using an AI model, matches possible conditions, and suggests relevant doctors with contact details via WhatsApp or email, enhancing healthcare accessibility. Why Use It This workflow improves healthcare outreach by providing quick, AI-driven symptom analysis and doctor recommendations, reducing the burden on medical staff, empowering users with informed choices, and streamlining appointment scheduling. How to Import It Download the Workflow JSON: Obtain the workflow file from the n8n template or create it based on this document. Import into n8n: In your n8n instance, go to "Workflows," click the three dots, select "Import from File," and upload the JSON. Configure Credentials: Set up form/webhook, AI model, WhatsApp, email (e.g., SMTP), and optional doctor database API credentials in n8n. Run the Workflow: Test with a sample symptom input and verify responses. System Architecture Symptom Input Pipeline**: Form/Chat Trigger: Initiates the workflow when a user submits symptoms. Extract Symptom Data: Processes the input from the form or chat. AI Analysis Flow**: Send to AI Model: Analyzes symptoms using an AI model. Match Possible Conditions: Identifies potential health conditions. Doctor Suggestion Flow**: Retrieve Doctor Details: Fetches relevant doctor data from a Google Sheet or API. Prepare Suggestion Message: Formats the suggestion with doctor names and contacts. Send WhatsApp Suggestion: Delivers the suggestion via WhatsApp. Send Email Suggestion: Delivers the suggestion via email. Update Log: Logs the request and response in a Google Sheet. Google Sheet File Structure Columns**: timestamp: Date and time of the symptom submission. user_id: Unique identifier for the user (e.g., form ID or chat handle). symptoms: List of symptoms entered by the user. condition: AI-identified possible condition. doctor_name: Name of the suggested doctor. contact: Doctor’s contact (phone or email). sent_via: Channel used for delivery (e.g., WhatsApp, Email). Customization Ideas Add More Channels**: Integrate SMS or Slack for additional notifications. Enhance AI**: Train the AI model with more medical data for better accuracy. Include Appointment Booking**: Add a node to schedule appointments with suggested doctors. Multilingual Support**: Adapt responses for different languages. Severity Alerts**: Flag critical conditions for immediate medical attention. Requirements to Run This Workflow Google Sheets Account**: For logging symptom data and doctor details. AI Model**: Ollama or similar for symptom analysis (requires API access). Form/Chat Service**: Google Forms, WhatsApp webhook, or similar for user input. WhatsApp Business API**: For sending WhatsApp messages (requires token and phone number). Email Service**: Gmail, SMTP, or similar for email delivery. n8n Instance**: With Google Sheets, AI, WhatsApp, and email connectors configured. Internet Connection**: To access APIs and services. Want a tailored workflow for your business? Our experts can craft it quickly Contact our team
by InfyOm Technologies
✅ What problem does this workflow solve? Garage and auto service businesses handle much more than just vehicle repairs — they manage service schedules, customer reminders, pickups, feedback, and repeat visits. When handled manually, this often leads to missed reminders, delayed pickups, unhappy customers, and lost repeat business. This workflow delivers a fully automated, end-to-end customer communication system for garages using n8n + Airtable + WhatsApp + Email, ensuring timely, professional, and consistent engagement at every stage of the service lifecycle. ⚙️ What does this workflow do? This automation suite consists of four interconnected workflows, each handling a critical touchpoint: WF-01: Scheduled Service Reminders Runs daily at 9 AM Identifies upcoming, due-today, or overdue services Sends branded reminders via WhatsApp + Email Automatically marks reminders as sent to avoid duplicates WF-02: Pickup Notification Triggers when service status changes to “Done” Instantly notifies customers that their vehicle is ready Sends confirmation via WhatsApp + Email Updates Airtable to track pickup notifications WF-03: Feedback Collection Triggers when service status becomes “Delivered” Sends a polite feedback request with a form link Uses WhatsApp + Email for higher response rates Ensures feedback requests are sent only once WF-04: Next Service Reminder Runs daily at 9 AM Tracks upcoming next-service dates Sends reminders for: Overdue services Services due today Upcoming services (next 7 days) Encourages repeat visits and long-term retention 🧠 How it Works – High-Level Flow 1. Central Data Source (Airtable) Airtable acts as the single source of truth for: Customer details Vehicle information Service status Service dates & next service dates Notification tracking flags 2. Smart Triggers & Scheduling Schedule Triggers** run daily reminders automatically Airtable Triggers** react instantly to status changes (Pending → Done → Delivered) 3. Personalized Message Generation Dynamic WhatsApp and Email messages are generated using customer, vehicle, and service data Messages are branded and context-aware (overdue, today, upcoming, completed, feedback) 4. Multi-Channel Notifications WhatsApp** messages are sent via Twilio Email** notifications are sent via Gmail Customers are reached on their preferred channels 5. Automatic Tracking & Deduplication Each step updates Airtable flags: Reminder sent Pickup notification sent Feedback sent Next service reminder sent Prevents duplicate messages and ensures clean automation 🔧 Integrations Used Airtable** – Customer, vehicle, and service management Twilio WhatsApp API** – Instant customer notifications Gmail** – Professional email communication n8n Schedule & Trigger Nodes** – Time-based and event-based automation 👤 Who is this for? Perfect for: 🚘 Auto garages & service centers 🛠 Multi-location workshop chains 🚗 Car detailing & maintenance businesses ⚙️ Agencies building automation solutions for automotive clients 🎯 Business Outcomes ✅ No missed service or follow-up reminders ✅ Faster pickups and smoother operations ✅ Automated feedback collection ✅ Higher repeat visits and customer retention ✅ Zero manual follow-ups for staff 🚀 Result This workflow transforms a garage into a fully automated, customer-centric service operation, ensuring every customer is informed, engaged, and encouraged to return — without adding operational overhead.
by Oneclick AI Squad
Automates real-time market monitoring, technical analysis, AI-powered signal generation for cryptocurrencies (and stocks), filters high-confidence trades, and delivers actionable alerts via multiple channels. Good to Know Runs every 5–30 minutes (configurable trigger) to catch fresh market opportunities Pulls real-time price data from multiple crypto/stock sources in parallel Calculates popular technical indicators (RSI, MACD, Moving Averages, etc.) Uses an AI model (likely Grok/xAI, OpenAI, or similar) to interpret indicators and generate buy/sell signals with confidence scores Applies multi-layer filtering to reduce noise (thresholds, validation rules) Stores signals in a database, logs execution history, and sends notifications Supports email, Telegram, Discord, SMS (via Twilio), or trading execution webhooks Saves significant time compared to manual chart watching How It Works 1. Trigger Schedule Trigger* or *Manual Trigger** (every 5–30 minutes) Optional: Market Hours / Kill-zone filter (e.g. avoid low-volume periods) Can be webhook-based for on-demand runs 2. Fetch & Prepare Data Fetches real-time / recent OHLCV data for a watchlist of cryptocurrencies (and possibly stocks) Sources: CoinGecko, Binance, Alpha Vantage, CoinMarketCap, Bybit, Kraken, etc. (multiple in parallel) Combines data from different APIs Prepares structured dataset (candles, volume, current price) Calculates technical indicators in parallel or via Code node / community nodes (e.g. RSI(14), MACD, EMA/SMA crossovers, Bollinger Bands, etc.) 3. Analysis & Signal Generation Sends prepared market data + calculated indicators to an AI model Prompt instructs the model to: Analyze current market structure Evaluate indicator confluence Generate Buy / Sell / Hold signal Assign confidence score (e.g. 0–100%) Provide short reasoning Optional: Rule-based pre-filter (e.g. only proceed if RSI < 30 or MACD crossover) 4. Validate, Alert & Store Filters** signals: minimum confidence threshold, no-duplicate check, max signals per run, etc. Validates** against additional rules (e.g. volume spike, no recent opposite signal) Stores** signal in database (PostgreSQL, Supabase, Airtable, Google Sheets, etc.) Includes: timestamp, symbol, signal type, confidence, price, indicators snapshot, AI reasoning Logs** full execution trace Sends alerts**: Email notification Telegram / Discord message (with formatting) SMS (Twilio) Webhook to trading bot / execution system Optional: Push to tradingview alert or auto-execute (paper/live) Data Sources Market Data APIs** — CoinGecko, Binance, Alpha Vantage, CoinMarketCap, etc. Technical Indicators** — Calculated via Code node, community nodes (e.g. phoenix indicators), or external libraries AI Model** — Grok (xAI), OpenAI (GPT-4o), Claude, Gemini, or local LLM Notification Channels** — Email (Gmail/SMTP), Telegram, Discord, Twilio, webhook Storage** — Google Sheets, PostgreSQL, Supabase, Notion, Airtable How to Use Import the workflow JSON into your n8n instance Configure credentials: API keys for market data providers (Alpha Vantage, CoinGecko Pro, Binance, etc.) AI provider (Grok API key, OpenAI key, etc.) Notification services (Telegram bot token, email SMTP, Twilio, etc.) Database connection if used Set your watchlist — edit the symbols in the fetch node(s) Tune the schedule — change interval in the trigger node Customize AI prompt — adjust in the AI node for more aggressive/conservative signals Set filters — confidence threshold, max alerts per cycle, etc. Test manually — use Execute Workflow button with sample data Activate & monitor — check Executions tab for logs Requirements n8n (self-hosted or cloud) API keys for at least one market data provider AI API access (Grok, OpenAI, etc.) Notification credentials (Telegram bot, email account, etc.) Optional: Database for persistent signal history Customizing This Workflow Add more exchanges/sources for better data redundancy Include on-chain metrics (whale alerts, funding rates) via additional APIs Switch AI model or fine-tune prompt for your trading style Add risk management rules (position sizing, stop-loss levels) Integrate auto-trading via exchange API (Binance, Bybit, Alpaca, etc.) Create dashboard output (Google Sheets + Looker Studio / Grafana) Add backtesting mode using historical data Implement blackout periods or news filter to avoid high-impact events
by Rahul Joshi
📊 Description Automate employee leave tracking and communication with structured notifications and reminders 📅📣. This workflow checks a centralized Google Sheet daily to detect when leave periods start or end. When leave begins, it notifies your HR Slack channel and reminds the employee to update their availability. When leave ends, it sends a return notification and follow-up reminder. All actions are reflected back in Google Sheets to maintain a single source of truth. Ideal for growing teams that want a simple, reliable way to manage leave visibility without manual follow-ups or status tracking. What This Template Does 🌐 Runs automatically on a daily schedule 📄 Reads employee leave data from Google Sheets 🧮 Validates and evaluates leave start and end dates 🔀 Routes employees into activation or reset flows 📣 Sends Slack notifications to the HR or admin channel 📧 Sends reminder emails to employees at the right time 📊 Updates leave status in Google Sheets to prevent duplicates 🔁 Processes employees sequentially for reliable execution Key Benefits ✅ Eliminates manual leave tracking ✅ Improves visibility for HR and leadership ✅ Ensures employees receive timely reminders ✅ Prevents duplicate notifications using status flags ✅ Keeps Google Sheets updated as the single source of truth ✅ Scales easily as your team grows Features Daily scheduled leave check Google Sheets as centralized leave database Smart activation and reset logic Slack channel notifications Automated employee reminder emails Status tracking with idempotent processing Sequential execution to avoid API rate limits Configurable Slack channel settings Requirements Google Sheets OAuth2 credentials Slack OAuth2 credentials Gmail OAuth2 credentials Google Sheet with the following columns: Employee Email, Name, Start Date, End Date, Status, Last Updated Target Audience 🏢 HR and People Operations teams 🚀 Growing startups managing distributed teams 📊 Operations teams needing structured leave tracking 🤖 Automation builders creating internal workflow systems
by Oneclick AI Squad
This automated n8n workflow fetches stock data from the Twelve Data API after market close, predicts 5-day trends using AI analysis, updates Google Sheets with the results, and sends an email summary report. This process helps users stay informed about stock movements and make data-driven decisions efficiently. Good to Know AI prediction accuracy improves with more historical stock data. Market conditions and external factors can influence prediction outcomes. Google Sheets access must be authorized to ensure smooth data updates. Email notifications ensure timely delivery of summary reports. The system relies on the Twelve Data API as the primary data source. How It Works Daily Market Close Trigger** - Initiates the workflow daily at 9:00 PM (after market close), Monday to Friday. Read Stock Symbols** - Reads stock symbols from a Google Sheet to determine which stocks to analyze. Set Configuration Variables** - Configures API keys and other necessary variables manually. Fetch 5-Day Stock Data** - Retrieves 5-day stock data from the Twelve Data API. Analyze Stock Trends** - Uses AI to predict 5-day stock price movements based on the fetched data. Update Google Sheet** - Appends the analysis results to a Google Sheet for tracking. Format Email Report** - Creates a concise, human-friendly summary of the stock predictions. Send Email Report** - Delivers the summary report via email to designated recipients. Data Sources The workflow utilizes one Google Sheet: Stock Data Sheet** - Contains stock analysis data with columns: Date (date) Stock Symbol (text) Current Price (number) Predicted 5-Day Trend (text) Confidence Level (number) Notes (text) How to Use Import the workflow into n8n. Configure Google Sheets API access and authorize the application. Set up email credentials for report delivery. Create the required Google Sheet with the specified column structure. Configure the Twelve Data API key. Test with sample stock data to verify predictions and email delivery. Adjust analysis parameters based on your specific stock monitoring needs. Monitor and refine the system based on actual vs. predicted trends. Requirements Google Sheets API access. Email service credentials (Gmail, SMTP, etc.). Twelve Data API key. Initial stock data for analysis. Customizing This Workflow Modify the Stock Trend Predictor parameters to focus on specific stock sectors or adjust prediction horizons. Customize the email report format to match your preferences and integrate additional data sources like news feeds or financial indicators if needed.
by Jitesh Dugar
AI-Powered Incident Report Generator with Severity Alerts & PDF Delivery Description Automate incident reporting from detection to delivery with AI-driven analysis and professional documentation. This workflow transforms raw incident details into a clear, structured incident report, performs AI-based root cause and impact analysis, triggers real-time alerts for high-severity issues, and delivers a polished PDF report to your operations team — all with minimal manual effort. What This Workflow Does Turns incident reporting into a fast, reliable, and repeatable process: 🚨 Receive Incident Details – Accepts incident data via webhook (ID, severity, systems affected, description). 🧠 AI Analysis – Uses AI to generate root cause analysis, impact assessment, and recommended actions. ⚠️ Severity Check – Automatically detects high-severity incidents. 💬 Slack Alerts – Sends instant alerts for critical incidents to the ops channel. 📄 Professional Report Generation – Formats incident details into a clean, readable report. 📑 PDF Creation – Converts the report into a downloadable PDF. 📧 Email Delivery – Sends the report to the operations team. ☁️ Secure Storage – Saves a copy to Google Drive for records and compliance. Key Features 🤖 AI-Generated Analysis – Automated root cause, impact, and action recommendations ⚡ Real-Time Severity Alerts – Immediate Slack notifications for high-risk incidents 📄 Professional PDF Reports – Clean, structured, and ready for audits 📧 Automated Delivery – Email reports without manual follow-ups ☁️ Centralized Storage – Securely archive reports in Google Drive Perfect For 🏢 IT & Operations Teams 🔐 Security & Compliance Teams 🧑💼 Internal Ops & Risk Management 🏭 Enterprises handling system or process incidents 📊 Teams needing audit-ready incident documentation What You’ll Need Required Integrations 🤖 OpenAI – Incident analysis and recommendations 📄 HTMLCSS to PDF – Convert reports into PDFs 📧 Gmail – Send incident reports 💬 Slack – Severity-based alerts Optional ☁️ Google Drive – Store incident reports securely Quick Start 1️⃣ Import the workflow into n8n 2️⃣ Connect OpenAI, Slack, Gmail, and HTMLCSS to PDF credentials 3️⃣ Update Slack channel and email recipients 4️⃣ Trigger the webhook with incident data 5️⃣ Activate the workflow Expected Results ⚡ Faster incident response 🤖 Consistent AI-driven analysis 📉 Reduced manual reporting work 📄 Audit-ready incident documentation 🚨 Immediate visibility into critical incidents