Brevo and HTTP Request integration

How it works This workflow runs on a daily schedule and automatically sends follow-up reminders to candidates who have received an application link but have not yet applied. It checks Airtable for eligible records, calculates how much time has passed since outreach was sent, and decides whether to send a first reminder, second reminder, or no message. All decision logic is handled in a single Code node, which outputs a simple routing value. This makes the workflow easy to understand and prevents fragile conditional logic. Each reminder is sent only once. After a reminder is sent, the workflow updates Airtable with a corresponding “sent” flag so the same reminder cannot be sent again on future runs. Setup steps Connect your Airtable account and select the table containing candidate records. Ensure Airtable includes a timestamp field indicating when outreach was sent. Ensure checkbox fields exist for each reminder (for example, “Reminder 1 Sent” and “Reminder 2 Sent”). Connect your email provider (Brevo) and SMS provider. Set the Cron node to run once per day at your preferred time. Initial setup typically takes 10–15 minutes. When to use this template You want automated follow-ups without manual chasing You need to avoid sending duplicate reminders You want Airtable to remain the source of truth

🤖 AI Sales Agent — Fully Automated Email Handling & Lead Scoring System Automate lead outreach, analyze replies with AI, and keep your CRM always in sync — hands-free. This workflow acts as a 24/7 intelligent sales assistant that not only sends personalized cold emails but also reads and interprets replies, updates your CRM, and even writes contextual responses — just like a real sales rep would. Ideal for founders, growth teams, and agencies who want to automate outreach and follow-ups without losing the human touch. 🧩 What This Workflow Does 🔹 1. Smart AI Email Analysis Every incoming email is parsed and sent to GPT-4o for structured classification: Detects unsubscribe requests, automated replies, or manual responses Extracts intent, sentiment, urgency, and key points Determines the next best action — follow-up, escalate, or close 🔹 2. Personalized AI Replies When appropriate, the workflow automatically drafts replies that: Match the sender’s tone and intent Address objections using feel-felt-found logic Suggest the most relevant product or resource Sign off naturally (e.g. “Sofia from Tech Powered Growth”) 🔹 3. Lead Scoring & CRM Sync (NocoDB) Leads are continuously enriched and scored based on activity: +5 points for interested replies, +2 for clicks, –10 for unsubscribes Status automatically transitions between cold → warm → hot Daily maintenance updates decay inactive leads and schedule re-engagement 🔹 4. Engagement Tracking & Insights The workflow tracks opens, clicks, bounces, spam, and unsubscribes from Brevo (Sendinblue), updating CRM records instantly. Each day, it generates a performance report with lead distribution, score changes, and actionable recommendations. ⚙️ Integrations Used OpenAI GPT-4o-mini** — intent classification & reply generation Brevo (Sendinblue)** — email sending & webhook event tracking Gmail** — real-time incoming replies & outbound responses NocoDB** — lead management, scoring, and analytics n8n Code Nodes** — smart logic for scoring, decay, and decision flow 🚀 Key Benefits ✅ Save hours of manual email triage and follow-ups 💬 Maintain human-sounding conversations with prospects 📊 Keep lead data accurate and always up-to-date ⚡ Automatically nurture, score, and re-engage leads 📈 Get daily actionable analytics for your sales pipeline 🛠️ Setup Instructions Connect your NocoDB, Brevo, Gmail, and OpenAI credentials Adjust your NocoDB table structure or use the sample schema provided Set your sender details in the “Send Initial Outreach Email” node Customize the AI response prompt with your brand tone or offer Turn on the triggers — and watch your AI sales assistant go to work 💡 Ideal For Solo founders automating outreach B2B agencies handling multiple clients Growth engineers and sales ops teams SaaS companies with inbound or outbound funnels 🧠 Pro Tip Pair this workflow with your lead scraping or enrichment flow to create a fully autonomous sales system — from discovery to closed deal.

AI Scoring, Personalized Email Creation and Outreach Overview This comprehensive automation flow helps you scale your outreach to potential customers through intelligent personalized email campaigns. The system combines web scraping, AI-powered lead scoring, and automated email sequences to maximize your conversion rates. Key Features Intelligent Website Analysis** with automated scraping AI-Powered Lead Scoring** for prioritization Personalized Email Generation** using AI Automated Email Outreach** with tracking Real-time Event Monitoring** via Brevo webhooks Centralized Data Management** with NocoDB System Architecture The workflow integrates multiple platforms to create a seamless lead generation pipeline: NocoDB** - Central database and CRM Crawl4AI** - Website content analysis OpenAI** - Lead scoring and email personalization Brevo** - Email delivery and tracking Setup Requirements Prerequisites Before starting, ensure you have accounts for the following services: NocoDB (Database & CRM) Apify (Web scraping platform) OpenAI (AI processing) Brevo (Email delivery service) > 💡 Pro Tip: For advanced users, consider self-hosting NocoDB and Crawl4AI to significantly reduce operational costs. Step-by-Step Setup NocoDB Database Configuration Create Your NocoDB Account Sign up at nocodb.com Create a new workspace Set up your first base (database) Database Schema Setup Create a new table with the following field structure: | Field Name | Field Type | Configuration | |------------|------------|---------------| | first_name | Single Line Text | - | | last_name | Single Line Text | - | | email | Email | - | | headline | Single Line Text | - | | linkedin_url | URL | - | | industry | Single Line Text | - | | organization_name | Single Line Text | - | | organization_website | URL | - | | organization_size | Number | - | | organization_linkedin_url | URL | - | | organization_facebook_url | URL | - | | market_cap | Single Line Text | - | | job_title | Single Line Text | - | | country | Single Line Text | - | | city | Single Line Text | - | | lead_status | Single Select | Options: entered(make it default!), processed, email_created, contacted, trash, failed_to_process, opened_email, warm | Default Value: entered | website_summary | Long Text | - | | score | Number | Default: 0 | | organization_description | Long Text | - | | primary_phone | Phone Number | - | | keywords | Single Line Text | - | | email_subject | Single Line Text | - | | email_body | Long Text | - | | email_opened_times | Number | Default: 0 | | personal_email | Single Line Text | - | External Service Setup Apify Configuration Create account at apify.com Navigate to Settings → API tokens Generate new API token Save token securely for automation setup OpenAI API Setup Visit platform.openai.com Go to API Keys section Create new secret key Store API key securely Ensure billing is configured for API usage Brevo Email Service Sign up at brevo.com Complete account verification Navigate to SMTP & API settings Generate API key for integration Configure sender authentication (SPF/DKIM) Workflow Process Phase 1: Lead Discovery & Data Collection Data Import - Populate NocoDB with lead information Status Update - Mark leads as entered Phase 2: Website Analysis & Lead Scoring Website Scraping - Analyze company websites using Crawl4AI Content Processing - Extract key business information AI Scoring - Evaluate lead quality using OpenAI Database Update - Store analysis results and scores Phase 3: Email Personalization & Outreach Content Generation - Create personalized email content Email Preparation - Format messages for delivery Automated Sending - Deploy via Brevo Status Tracking - Monitor delivery and engagement Phase 4: Performance Monitoring Webhook Processing - Capture Brevo email events Engagement Tracking - Update open/click metrics Lead Qualification - Adjust lead status based on engagement Pipeline Management - Maintain lead progression Lead Status Workflow entered → processed → email_created → contacted → opened_email → warm ↓ failed_to_process / trash (for low-quality leads) Status Definitions entered**: Initial lead data captured processed**: Website analyzed and scored email_created**: Personalized email generated contacted**: Email successfully sent opened_email**: Recipient opened the email warm**: High engagement, ready for follow-up failed_to_process**: Technical issues during processing trash**: Low-quality lead, removed from active pipeline Best Practices Data Quality Regularly clean and deduplicate your lead database Monitor lead scores to refine your targeting criteria Archive or remove inactive leads to maintain performance Email Deliverability Warm up your sending domain before high-volume campaigns Monitor bounce rates and adjust list quality Implement proper SPF, DKIM, and DMARC records Compliance Ensure GDPR/CAN-SPAM compliance in all communications Provide clear unsubscribe mechanisms Respect recipient preferences and opt-outs Performance Optimization A/B test email subject lines and content Analyze open rates and adjust sending times Segment leads based on engagement levels for targeted follow-up Next Steps Once your setup is complete, you'll have a powerful, automated lead generation system that can: Process hundreds of leads simultaneously Provide intelligent lead prioritization Generate personalized outreach at scale Track and optimize campaign performance Ready to transform your lead generation process? Start with the NocoDB setup and work through each integration step by step.

How it works This workflow automates post-event and post-course communications for candidates, while also notifying referring partners at the correct milestones. The workflow is triggered when Airtable updates timestamp fields related to Info Event Outcome or Course Outcome. Airtable controls when the workflow runs, and n8n controls what happens next. This separation avoids race conditions and keeps the system reliable. After triggering, the workflow normalizes record data and determines exactly one action path using a centralized Code node. Based on the outcome, it sends the correct candidate email and SMS, and optionally notifies the referring person. Each message is sent only once using checkbox “sent” flags stored in Airtable. Setup steps Connect Airtable and select the table containing candidate records. Ensure Airtable includes timestamp fields for Info Event Outcome and Course Outcome updates. Ensure checkbox fields exist to track which messages have already been sent. Connect your email provider (Brevo) and SMS provider. Customize message content inside the Email and SMS nodes if needed. Initial setup typically takes 15–20 minutes. When to use this template You need reliable post-event and post-course messaging You want to notify referring partners automatically You must prevent duplicate emails or SMS

Who is this template for? This workflow template is designed for Marketing and pre-Sales to get prospects from a form like Tally, decline data in the famous opensource CRM (SuiteCRM), synchronize contact in Brevo with linking the id from CRM, and then notify in NextCloud. Bonus : validate email with ++CaptainVerify++ and notify in NextCloud depending on response How it works For each submission in the form, a webhook is triggered. A check of the email is done with CaptainVerify. Depending on the response, and if it is ok, then a Lead is created in SuiteCRM. Else, a message in your selected discussion is sent. As the lead has been created, we can create a contact in Brevo (for future campain), ank link this contact with the lead_id from the CRM in a dedicated field. Finaly, a message in your selected discussion in NextCloud informs you about the lead. Set up instructions Complete the Set up credentials step when you first open the workflow. You'll need a CaptainVerify account (Api Key), a dedicated SuiteCRM user with Oauth, a Brevo account (Api Key) and a Nextcloud account. Set up the Webhook in the form's tool of your choice (why not Tally ?). Set each node with the explanations in sticky Notes. Enjoy ! Template was created in n8n v1.44.1