Workflow Templates

📘 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

✅ What problem does this workflow solve? Real estate leads move fast. Manually matching buyer requirements with available properties, sending details, updating CRM records, and notifying sales teams often causes delays and missed opportunities. This workflow automates property discovery, lead management, and team notifications, ensuring buyers get instant results and sales teams can follow up immediately. ⚙️ What does this workflow do? Captures buyer property requirements from a website form. Cleans and standardizes search data automatically. Matches buyer criteria with relevant properties from Airtable. Emails matched properties to the buyer instantly. Stores lead details in Airtable for CRM tracking. Notifies the sales team on Slack in real time. 💡 Main Use Cases Automatically match buyer requirements with properties in Airtable. Send personalised property listings to buyers via email. Store and track every lead centrally for sales follow-up. Notify agents instantly to improve response speed. Increase conversions with faster, automated engagement. 🧠 How It Works – Step by Step 1. Website Form Submission A buyer submits a property inquiry form with: Location / City Property type (Apartment, Villa, Commercial, etc.) Budget Contact details The workflow is triggered instantly via webhook. 2. Data Cleaning & Standardization Submitted inputs are cleaned and structured: Budget is normalised City and property type are standardised Data is prepared for property matching 3. Property Matching (Airtable) A dynamic matching formula is generated. Airtable is searched for relevant properties. Matching includes a ±5% budget tolerance for flexibility. 4. Send Matched Properties to Buyer A rich, formatted email is generated automatically. Includes property images, price, location, features, and a “View More Details” link. Email is sent instantly to the buyer. 5. Lead Storage in Airtable Buyer details and preferences are stored in the Buyers table. Lead status is set to New for CRM tracking and follow-up. 6. Sales Team Notification A Slack message is sent to the sales channel with: Buyer details Contact information City and preferred property type Agents can respond immediately to maximize conversion. 🗂 Integrations Used Webhook** – Capture property inquiry submissions Airtable** – Property database and lead CRM Gmail** – Email delivery to buyers Slack** – Real-time sales team alerts n8n Code Nodes** – Dynamic matching logic and email generation 👤 Who can use this? This workflow is ideal for: 🏢 Real estate agencies 🏘 Property brokers 📈 Sales-driven real estate teams 🚀 PropTech startups If your team wants faster lead response and smarter property matching, this automation delivers both. 🚀 Benefits ✅ No manual property searching ✅ Faster response times ✅ Centralised lead tracking ✅ Real-time sales alerts ✅ Better buyer experience

Complete AI-powered sales system Automates lead capture, qualification, and follow-up from multiple channels. AI INTELLIGENCE: Automatic GPT-4 analysis Detects: sentiment, urgency, intent, budget signals Identifies pain points and interests Generates personalized responses LEAD SCORING ENGINE: Score 0-100 based on 10+ variables: Channel (Referral +30, LinkedIn +25, WhatsApp +20, Web Form +15, Email +10) Positive sentiment (+15) High urgency (+25) Purchase intent (+30) High budget (+20) Decision maker (+20) Engagement (+5 per interaction, max 25) MULTI-CHANNEL INPUT: Gmail (incoming emails) Webhook for web forms Webhook for WhatsApp/Telegram All normalized to unified format SMART ROUTER - 5 FLOWS: Schedule Demo: Hot lead with Calendly CTA Send Info: Informative response Create Task: Slack notification for call Nurturing: Cold lead, value-driven email Disqualify: Invalid lead AUTO CRM: Detects new vs existing leads Stores last 10 interactions history Updates score and stage automatically Complete interaction log HOT LEAD ALERTS (Score 70+): Instant Slack notification with lead data, company, score, stage, intent, urgency, pain points, and AI summary. AUTO-NURTURING (Daily 10AM): Filters leads with score 20-60 No contact in 3+ days AI personalized follow-up emails Max 10 per day WEEKLY REPORT (Monday 9AM): Total and new leads Active hot leads count Average score Distribution by stage and channel SETUP: Google Sheets with 3 tabs: Leads, Interactions, Tasks OpenAI API Key Gmail connected Slack channels: #sales, #errors IDEAL FOR: B2B Startups Digital agencies Consulting firms SaaS companies Any business with multi-channel leads Replaces HubSpot, Pipedrive, Close.io - 100% customizable, no monthly fees.

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.

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.

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+