Workflow Templates

Extract & Organize Academic Publications with GPT-4 Mini, Google Sheets & Gmail Author: CSChin Example Source: https://www.ncl.ac.uk/singapore/staff/profile/chengchin.html#publications Overview This automated workflow extracts, processes, and organizes academic publications from university staff profile pages using AI-powered extraction. Publications are automatically categorized by type and stored in organized Google Sheets while sending email notifications. Key Features: AI extraction • Auto-categorization • Dual output (Sheets + Email) • Year-based sorting Target Audience Academic Researchers** - Track publications across teams University Administrators** - Manage faculty publication records Research Librarians** - Maintain institutional repositories Department Heads** - Monitor research output PhD Students** - Organize literature reviews Use Cases Automated Publication Tracking - Monitor faculty research output Research Portfolio Management - Maintain publication databases Citation Database Building - Populate citation systems Department Reporting - Generate organized reports by category/year Research Impact Analysis - Track publication trends

Overview This workflow is an AI-powered Salon Booking Assistant that automates hair, beauty, and spa appointment scheduling through a Webhook trigger. It interacts with the user in natural conversation, collects booking details (service type, stylist preference, date/time, and any special requests), finalizes the draft, and confirms the appointment by storing it in Google Calendar and sending an email confirmation — fully automated end-to-end. How It Works 1. User Interaction The workflow starts when a user submits a request via the Webhook. The AI agent asks step-by-step questions: Type of service (haircut, facial, manicure, etc.) Preferred stylist (optional) Preferred date & time Any additional notes (special treatments, products, etc.) Once details are gathered, it generates a draft appointment summary. 2. Confirmation & Personal Details The user reviews the draft and confirms. The assistant then asks for personal details (name, email, phone number). 3. Booking & Notifications After confirmation, the details are sent to Google Calendar to create an appointment. A confirmation email is sent to the user with all booking information. A final webhook response confirms that the appointment is successfully booked. How to Use Triggered directly via a Webhook URL (can be embedded in your salon website or mobile app). Simply fill in the details, and the assistant will guide the user step by step until the booking is finalized. Once completed, the user receives both an email confirmation and an on-screen success message. Requirements To use this workflow, you’ll need: n8n account** (self-hosted or cloud) Webhook node** (for booking trigger) OpenAI or OpenRouter API Key** (for AI-driven conversation) Google Calendar API access** (to create appointments) Gmail / SMTP credentials** (to send confirmation emails)

Elevate Your Website’s Ranking: Automated Daily SEO Audits Boost your online visibility and stay ahead of the curve with this Automated SEO Audit Workflow Template. This solution streamlines the crucial task of monitoring your website’s health, proactively identifying issues, and ensuring peak performance without the manual grind. It’s your personal, tireless SEO assistant, designed to save you time and provide actionable insights for driving organic traffic and enhancing your search engine optimization (SEO). Benefits & Target Audience Proactive Issue Detection** Catch SEO errors and performance bottlenecks as they emerge before they impact your rankings. Time & Resource Savings** Automate daily checks so your team can focus on strategy, not manual audits. Comprehensive Insights** Receive on-page, technical, performance, accessibility, and security checks in a single, styled HTML report. Ideal for: Website owners, bloggers, digital marketing agencies, SEO specialists, web developers, and e-commerce businesses are committed to maintaining a strong online presence and improving organic search performance. Detailed Workflow Daily Trigger A Schedule Trigger node fires the audit at your chosen time each day. Configuration Use the Set Variables node to define the target URL, the recipient, and the sender's email addresses. Content Fetch An HTTP Request node retrieves your site’s raw HTML. On-Page Analysis The HTML node parses critical elements (titles, meta descriptions, H1/H2 headings, image alt tags). Audit Logic A Code node runs your custom SEO audit script covering on-page, technical, performance (Core Web Vitals), accessibility, and basic security checks—to generate actionable findings. Report Delivery A Gmail node formats those findings into a clean HTML report and emails it to your specified recipients. Required APIs & Customization APIs Needed:** Gmail (or Slack) credentials for report delivery. Easy Customization:** Target URLs & Recipients: Update in “Configure Target & Recipients.” Audit Frequency: Adjust the Schedule Trigger (e.g., hourly, weekly). Report Branding: Customize the HTML/CSS in the Gmail/Slack node. Delivery Channels: Swap Gmail for Slack, Teams, or your preferred notification service.

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.

Description This automation manages Stripe disputes by fetching dispute data, formatting it, logging it into Google Sheets, updating related payment records, and notifying the customer via email. It ensures finance and support teams always have up-to-date dispute information while keeping customers informed automatically. What This Template Does (Step-by-Step) 📋 Manual Trigger → Start the workflow manually. 🔗 Fetch Latest Disputes from Stripe → Retrieves the 5 most recent disputes via the Stripe API. 🛠 Format Stripe Dispute Data → Cleans and restructures the raw Stripe response (dispute_id, charge_id, amount, currency, reason, status, respond_by, etc.). 📊 Log Dispute in Disputes Sheet → Appends a new row in the Disputes sheet for historical record-keeping. 📧 Send Customer Dispute Notification Email → Notifies the customer about the dispute with all relevant details (amount, status, respond-by date). 📑 Find Payment in Ledger → Searches the Payments Sheet for a matching charge_id. ✅ Check if Payment Exists → Confirms whether the disputed payment already exists in the ledger. ✏️ Update Payment Record with Dispute Info → If found, updates the existing payment row with dispute details (status, dispute amount, respond_by date, etc.). Prerequisites Stripe account + API key Google Sheets with: Disputes Sheet (for logging disputes) Payments Sheet (for updating transactions) Gmail account with OAuth2 credentials Key Benefits ✅ Keeps a historical log of all disputes in one sheet ✅ Updates existing payment records with dispute status ✅ Sends automatic customer notifications to reduce confusion ✅ Helps finance and support teams track disputes in real time Perfect For Finance teams handling payment disputes Support teams needing automatic customer updates Businesses that want clear visibility into disputes alongside payment records

Automated Legal & Accessibility Website Compliance Checker Description Automate website compliance checks in minutes using AI-powered analysis. This workflow scans any website for essential legal and accessibility requirements, generates a professional compliance report, delivers it as a PDF, and stores it securely — helping teams identify risks early and stay audit-ready with zero manual effort. What This Workflow Does Transforms manual website compliance reviews into a single automated flow: 🌐 Capture Website Details – Accepts website URL, company name, and email via webhook. 📥 Fetch Website Content – Securely downloads and cleans website HTML for analysis. 🧠 AI Compliance Analysis – Uses AI to audit the site against key compliance standards. 📊 Scoring & Insights – Calculates an overall compliance score and highlights gaps. 📄 Generate Visual Report – Builds a detailed, easy-to-read HTML compliance report. 🖨️ Convert to PDF – Converts the report into a downloadable, shareable PDF. 📧 Email Delivery – Sends the compliance report directly to the provided email. ☁️ Secure Storage – Saves the PDF report to Google Drive for records and audits. Key Features 🤖 AI-Powered Compliance Audits – Automatically checks privacy, cookies, accessibility, SSL, and more. 📊 Compliance Scoring – Clear numerical scores and status indicators for each section. 📄 Professional PDF Reports – Branded, structured reports suitable for clients or audits. ⚙️ End-to-End Automation – From URL submission to email delivery without manual steps. 📧 Instant Email Notifications – Reports delivered automatically to stakeholders. ☁️ Google Drive Backup – Centralized storage for compliance history and documentation. Compliance Checks Included ✔️ Privacy Policy presence & indicators ✔️ Cookie consent mechanisms ✔️ Terms of Service availability ✔️ Accessibility (WCAG-related indicators) ✔️ Contact information visibility ✔️ SSL / HTTPS verification ✔️ Critical issues & improvement recommendations Perfect For 🏢 Startups & SaaS Companies – Quickly assess website compliance before launch. 🧾 Agencies & Consultants – Deliver automated compliance audits to clients. ⚖️ Legal & Compliance Teams – Speed up preliminary compliance checks. 💻 Freelancers & Web Developers – Validate client websites post-deployment. 📈 Operations Teams – Maintain ongoing compliance documentation effortlessly. What You’ll Need Required Integrations 🌐 Webhook – Receive website URL and user details. 🤖 OpenAI – Analyze website HTML for compliance indicators. 📄 HTMLCSS to PDF – Convert compliance report into a PDF. 📧 Gmail – Send compliance report via email. ☁️ Google Drive – Store generated compliance reports. 🌍 HTTP Request – Fetch website HTML content (no authentication required). Optional Enhancements 📊 Compliance Dashboard – Connect Google Drive or logs to Looker Studio. 🌍 Multi-Website Scans – Extend webhook to accept bulk URLs. 🕒 Scheduled Scans – Run periodic compliance checks automatically. 📨 Slack Alerts – Send compliance summaries to internal channels. 📝 Custom Branding – Adjust HTML styling, logos, and colors. Quick Start 1️⃣ Import the workflow JSON into your n8n workspace. 2️⃣ Activate the webhook and copy the endpoint URL. 3️⃣ Connect OpenAI, Gmail, Google Drive, and HTMLCSS to PDF credentials. 4️⃣ Send a POST request with website URL, company name, and email. 5️⃣ Review the emailed PDF compliance report. 6️⃣ Check Google Drive for stored audit copies. 7️⃣ Activate the workflow for production use. Expected Results ⚡ Minutes Instead of Hours – Instant compliance assessments. 🤖 AI Accuracy – Consistent, structured compliance analysis. 📈 Risk Visibility – Early detection of legal and accessibility gaps. 📄 Audit-Ready Reports – Clean, shareable documentation. ☁️ Centralized Storage – Every scan archived automatically. Workflow Structure 🌐 Webhook Trigger ↓ 📥 Fetch Website HTML ↓ 🧹 Clean & Prepare Content ↓ 🧠 AI Compliance Analysis ↓ 📊 Parse Results ↓ 📄 Generate HTML Report ↓ 🖨️ Convert to PDF ↓ 📧 Email Report ↓ ☁️ Save to Google Drive Ready to Automate Website Compliance? Import this template and turn any website URL into a complete compliance report — automatically, consistently, and professionally. Perfect for audits, clients, and peace of mind. ✅

1. Who's It For HR teams managing multiple new hires monthly. Small-to-medium businesses automating onboarding processes. Companies wanting consistent onboarding experiences. Remote-first teams needing streamlined provisioning. Growing startups scaling their hiring operations. Organizations seeking data-driven onboarding insights. 2. How It Works Captures new hire data via Jotform (name, email, position, department, start date). Extracts employee information including IT requirements and preferences. Analyzes role with AI Agent (GPT-4o-mini) for intelligent profiling. Determines priority level: standard, high, or executive. Generates personalized onboarding goals and training recommendations. Routes executive hires to HR alert path for VIP treatment. Sends welcome email to new employee with personalized plan. Notifies manager with prep checklist and onboarding goals. Creates IT setup request with hardware and software requirements. Logs all data to Google Sheets for tracking and analytics. Offers: AI-powered planning, smart routing, automated notifications, centralized tracking. 3. How to Set Up 1. Create Jotform with required fields (employee name, email, position, department, start date, manager, laptop type, experience level). 2. Import workflow JSON to n8n via Workflows → Import from File. 3. Add credentials: Jotform API, OpenAI API, Gmail OAuth2, Google Sheets. 4. Update Jotform Trigger node with your form ID. 5. Configure Extract Onboarding Data node field mappings to match your form. 6. Add OpenAI API key to OpenAI Chat Model node. 7. Update email addresses in Gmail nodes (welcome email, manager notification, IT request, HR alert). 8. Create Google Sheet with columns matching the Log to Database node. 9. Connect Google Sheets node to your spreadsheet. 10. Customize AI Agent system prompt for your company culture. 11. Test workflow with sample Jotform submission. 12. Activate workflow and monitor executions. Requirements n8n instance (cloud or self-hosted with LangChain support). Credentials: Jotform API key, OpenAI API key, Gmail OAuth2, Google Sheets access. Jotform account for employee onboarding forms. Google Workspace for email and spreadsheet integration. OpenAI API credits (~$0.01-0.03 per employee with gpt-4o-mini). Core Features AI-Powered Analysis: Intelligent role assessment and priority classification. Smart Routing: Executive hires get VIP treatment with HR alerts. Personalized Welcome Emails: Customized onboarding plans with goals and training. Manager Preparation: Automated prep checklist with employee details and expectations. IT Provisioning: Detailed setup requests with hardware and software needs. Database Logging: Complete audit trail in Google Sheets for analytics. Flexible Configuration: Easy customization for different company needs. Scalable Processing: Handles unlimited onboarding submissions automatically. Use Cases & Applications HR Departments: Automate repetitive onboarding tasks for all new hires. Remote Companies: Streamline equipment shipping and virtual onboarding. Fast-Growing Startups: Scale hiring without increasing HR headcount. IT Teams: Reduce equipment provisioning turnaround time. Managers: Get standardized prep instructions for every new team member. Executive Hiring: VIP onboarding path for leadership positions. Key Benefits Time Savings: 15+ hours saved per hire on manual coordination. Consistency: Every employee gets the same high-quality onboarding experience. Personalization: AI tailors plans based on role, department, and experience. Visibility: Real-time tracking of all onboarding activities in one place. Scalability: Handle 1 or 100 hires per month with zero additional effort. Compliance: Ensure all required steps are completed and documented. Employee Experience: New hires feel welcomed and prepared from day one. Data Insights: Track onboarding metrics and identify improvement areas. Customization Options Adjust AI priority classification logic for your org structure. Add custom fields to Jotform (team size, remote/office, security clearance). Modify email templates with company branding and messaging. Create department-specific onboarding workflows. Add Slack notifications for real-time alerts. Integrate with HRIS systems via HTTP Request nodes. Build custom reporting dashboards from Google Sheets data. Add follow-up sequences (day 7, day 30, day 90 check-ins). Include document signing workflows (offer letters, NDAs). Schedule calendar events automatically for first day and orientations. Important Disclaimers Requires n8n with LangChain support for AI Agent functionality. Test thoroughly before deploying to production onboarding. Ensure GDPR/CCPA compliance when collecting employee data. Monitor OpenAI API costs based on monthly hiring volume. Verify email deliverability and avoid spam filters. Keep employee data secure with proper access controls. Review AI-generated content for accuracy and appropriateness. Customize for your specific company policies and culture. Backup Google Sheets data regularly for compliance. Update manager and IT team email addresses before activation.

Solar Energy Production Monitoring Alert Workflow This workflow automatically monitors solar energy production every 2 hours by fetching data from the Energidataservice API. If the energy output falls below a predefined threshold, it instantly notifies users via email. Otherwise, it logs the data into a Google Sheet and posts a daily summary to Slack. Who’s It For Renewable energy teams monitoring solar output. Facility managers and power plant supervisors. ESG compliance officers tracking sustainability metrics. Developers or analysts automating solar energy reporting. How It Works Trigger: The workflow starts every 2 hours using a Schedule Trigger. Data Fetch: An HTTP Request node fetches solar energy production data from the Energidataservice API. Processing: A Code node filters out entries with production below the minimum threshold. Decision Making: An If node checks whether any low-production entries are present. Alerts: If low-production is detected, an email is sent via the Gmail node. Logging: If all entries are valid, they are logged into a Google Sheet. Slack Summary: A Slack node posts the summary sheet data for end-of-day visibility. How to Set Up Schedule Trigger: Configure to run every 2 hours. HTTP Request Node: Method: GET URL: https://api.energidataservice.dk/dataset/YourDatasetHere Add necessary headers and params as required by the API. Code Node: Define logic to filter entries where solar_energy_production < required_threshold. If Node: Use items.length > 0 to check for low-production entries. Gmail Node: Auth with Gmail credentials. Customize recipient and message template. Google Sheets Node: Connect to a spreadsheet. Map appropriate columns. Slack Node: Use Slack OAuth2 credentials. Specify channel and message content. Requirements n8n Cloud or Self-hosted instance. Access to Energidataservice API. Gmail account (with n8n OAuth2 integration). Google Sheets account & sheet ID. Slack workspace and app with appropriate permissions. How to Customize Change Frequency:** Adjust the Schedule Trigger interval (e.g., every hour or 4x per day). Threshold Tuning:** Modify the value in the Code node to change the minimum acceptable solar production. Alert Routing:** Update Gmail recipients or replace Gmail with Microsoft Outlook/SendGrid. Sheet Format:** Add or remove columns in the Google Sheet based on extra metrics (e.g., wind or nuclear data). Slack Posting:** Customize Slack messages using Markdown for improved readability. Add‑ons Telegram Node:** Send alerts to a Telegram group instead of email. Discord Webhook:** Push updates to a Discord channel. n8n Webhook Trigger:** Extend it to receive external production update notifications. Integromat/Make or Zapier:** For multi-platform integration with CRMs or ticketing tools. Use Case Examples Utility Companies:** Automatically detect and act on solar underperformance to maintain grid stability. Solar Farm Operators:** Log clean production data for auditing and compliance reports. Sustainability Teams:** Track daily performance and anomalies without manual checks. Home Solar System Owners:** Get notified if solar generation drops below expected. Common Troubleshooting | Issue | Possible Cause | Solution | | -------------------------------------- | -------------------------------------- | ------------------------------------------------------------------- | | HTTP Request fails | API key missing or URL is incorrect | Check API endpoint, parameters, and authentication headers | | Gmail not sending alerts | Missing or invalid Gmail credentials | Re-authenticate Gmail OAuth2 in n8n credentials | | No data getting logged in Google Sheet | Incorrect mapping or sheet permissions | Ensure the sheet exists, columns match, and credentials are correct | | Slack node fails | Invalid token or missing channel ID | Reconnect Slack credentials and check permissions | | Code node returns empty | Filter logic may be too strict | Validate data format and relax the threshold condition | Need Help? Need help setting this up or customizing it for your own solar or energy monitoring use case? ✅ Set it up on your n8n Cloud or self-hosted instance ✅ Customize it for your own API or data source ✅ Modify alerts to suit your internal tools (Teams, Discord, SMS, etc.) 👉 Just reach out to our n8n automation team at WeblineIndia, we'll be happy to help.

Generate AI newsletters from form inputs and send via SendGrid Streamline your email marketing process with this AI-powered "Human-in-the-Loop" workflow. It allows you to generate high-quality, targeted newsletters from a simple form input, review them via email, and automatically distribute them to your subscribers upon approval. ## Who is this for? Digital marketers, content creators, community managers, and small business owners who want to maintain consistent communication with their audience but need to reduce the time spent on drafting and formatting emails. ## What does this workflow do? Input Collection: Starts with a user-friendly n8n Form where you input the newsletter topic, target audience, and sender details. Data Logging: Automatically saves the form responses to a Google Sheet for your records. AI Generation: Uses OpenAI (GPT-4o) to draft a catchy subject line and valuable body content formatted in Markdown based on your inputs. Approval Process: Sends a "Review Request" email to your inbox (via Gmail). This email contains a preview of the newsletter and a special link to approve it. Execution Wait: The workflow pauses and waits for you to click the approval link. Distribution: Once approved, it converts the Markdown to HTML and sends the final newsletter to your subscriber list using SendGrid. ## Requirements OpenAI API Key:** To utilize GPT-4o for content generation. Google Cloud Account:** Required for the Google Sheets (logging) and Gmail (approval notifications) nodes. SendGrid Account:** Required for sending the final newsletter to your subscribers. n8n version:** Ensure you are using a version that supports the LangChain nodes. ## How to set up Configure Credentials: Set up your credentials for OpenAI, Google (Sheets & Gmail), and SendGrid within n8n. Subscriber List: Open the Workflow Configuration node (Set node). Replace the placeholder with your comma-separated list of subscriber emails. Google Sheets: Create a Google Sheet with columns for topic, target, sender, and admin_email. Update the Store Form Responses node with your Document ID and Sheet Name. Sender Verification: In the SendGrid node, ensure the "From Email" matches a verified sender identity in your SendGrid account. Test: Click "Test Workflow," fill out the Form Trigger URL, and check your email for the approval draft. Click the link in the email to finish the process. ## How to customize Change the AI Model:** You can swap the OpenAI model node for Anthropic (Claude) or a local LLM if preferred. Adjust the Prompt:* Edit the system message in the *Generate Newsletter Content** agent node to change the tone or structure of the newsletter. Swap Email Providers:** If you don't use SendGrid or Gmail, simply replace these nodes with the email service of your choice (e.g., Mailchimp, Outlook, AWS SES).

Filter incoming emails via IMAP, extract & clean the body into plain text, normalize (title/slug/snippet/date/from/url), check for duplicates in Postgres, store as a row in a Notion database, then send a Telegram notification. Perfect for building a knowledge base or inbox triage automation without duplicate noise. Key Features IMAP polling (Only UNSEEN). Extract & clean HTML → plain text. Normalization: title, snippet, bodyText, slug, messageId, sentAt, fromAddress, sourceUrl. Deduplication via Postgres (SELECT EXISTS). Create page in Notion database (property mapping). Telegram success notification. Tags: email, imap, notion, postgres, deduplication, telegram, automation, knowledge-base Prerequisites IMAP access (Gmail/Outlook/Custom). Gmail: enable IMAP + App Password if using 2FA. Notion Integration Token & Database ID (database must be shared with the integration). PostgreSQL accessible from n8n. (Optional) Telegram Bot Token & Chat ID.

🎯 Automated B2B Cold Email Sequence with AI Personalization Stop manually sending follow-ups. This workflow automates your entire cold email outreach with AI-powered personalization, smart scheduling, and automatic reply detection. ✨ What It Does This workflow sends a perfectly-timed 3-email sequence to B2B prospects with: AI-generated personalized emails** adapted to each prospect's sector, company size, and role Smart scheduling**: Only sends Tuesday/Wednesday/Thursday at optimal times (~9AM with randomization) Bilingual support**: Auto-detects French or English prospects Reply detection**: Automatically stops the sequence when someone replies Spam prevention**: Randomized sending times, professional intervals Full tracking**: Updates Google Sheets with send status and reply detection Slack notifications**: Get alerted immediately when a hot lead responds 📊 Expected Results Based on real usage: 10-15% reply rate** (vs 3-8% for generic cold emails) 2-5 hot leads** per 30 prospects contacted 90% time saved** vs manual outreach Professional delivery** that preserves sender reputation 🎬 How It Works Add prospect to Google Sheet (Email, Name, Company, etc.) Workflow triggers automatically on new row Time planning calculates optimal send dates (Tue/Wed/Thu only) Email 1 (J0): AI generates introduction with value prop (80-120 words) Wait 3 days Email 2 (J+3): Follow-up with new angle or case study (70-90 words) Wait 4 days Email 3 (J+7): Final soft close, respectful exit (60-100 words) Reply detection: Monitors Gmail → marks prospect "hot" → Slack alert → stops sequence 🚀 Perfect For Sales teams doing B2B cold outreach Agencies prospecting new clients SaaS founders building their pipeline Consultants/freelancers doing business development Anyone tired of manual follow-ups and low response rates ⚙️ Requirements Required: Google Sheets (free) Gmail account (free) OpenAI API key (~$0.50 per 100 emails) Optional: Slack (for notifications) n8n version: Compatible with n8n 1.0+

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