Smart lead outreach with Explorium MCP using Google Sheets and Telegram

Name: Smart lead outreach with Explorium MCP using Google Sheets and Telegram
Availability: InStock
Author: David Olusola

Smart lead outreach with Explorium MCP using Google Sheets and Telegram preview

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

🚀 Smart Outreach: Auto-Personalized Lead Sequences

🧠 What It Does

This n8n workflow turns your Telegram bot into an AI-powered B2B lead enrichment and outreach engine.

It uses Explorium MCP's premium business data, combined with GPT-4 intelligence, to deliver:

Enriched lead profiles (person or company) AI-personalized 4-step cold email sequences Real-time interaction via Telegram Google Sheets logging for CRM or follow-up 🖥️ Demo: https://www.loom.com/share/4c2ae62154d74b66b4a59a6926282fab

🔄 How It Works

Telegram Input Users message a company or person’s name to your Telegram bot.
GPT-4 AI Agent Analyzes the Request Determines if input is a person or company Starts the enrichment process
Explorium MCP Client Fetches B2B Data Pulls from enterprise-grade business databases Finds company size, revenue, funding, contact names, tech stack, and more Augments with Tavily search where needed
Smart Data Processor Structures the info Classifies it Adds enrichment and processing timestamps
GPT-4 Generates Email Sequence 4-email cold outreach campaign Personalized based on enriched profile Professional tone with soft CTA and clear value
Google Sheets Logging People Sheet: name, role, LinkedIn, experience, education, skills Companies Sheet: size, HQ, tech stack, funding, lead score, outreach emails
Telegram Responds in Real-Time Sends back structured summary Clean JSON or readable text 🧰 Requirements

To run this workflow, you’ll need:

✅ Telegram Bot (via BotFather) ✅ OpenAI API Key (GPT-4 or GPT-4o) ✅ Explorium MCP credentials (for B2B enrichment) ✅ Tavily API key (for supplemental web results) ✅ Google Sheets account (OAuth2 connected to n8n)

⚙️ Setup Instructions

Import the Template into n8n Use the JSON file to create a new workflow. Configure Telegram Trigger Set up your bot via BotFather Connect your Telegram API credentials in n8n Connect External APIs Set up Explorium MCP credentials (via header auth) Add Tavily and OpenAI credentials in their respective nodes Replace Google Sheets Links Update documentId and sheetName to point to your target Sheets Customize (Optional) Tweak prompt logic, email tone, or data mapping Add Slack alerts or CRM pushes Test the Flow DM a name or company to your Telegram bot Wait a few seconds for a full enriched reply + email sequence

📥 Output Includes:

Full structured profile in JSON format 4 cold outreach emails tailored to the lead Stored copy in Google Sheets for sales or follow-up 💼 Who This Is For:

SDRs & Sales Teams AI/Marketing Agencies Growth Hackers Founders doing outbound manually

David Olusola

92 workflows

Nodes

n8n-nodes-base.telegramtrigger @n8n/n8n-nodes-langchain.agent @n8n/n8n-nodes-langchain.lmchatopenai @n8n/n8n-nodes-langchain.memorypostgreschat @n8n/n8n-nodes-langchain.mcpclienttool n8n-nodes-base.httprequesttool n8n-nodes-base.code n8n-nodes-base.telegram

Complexity

advanced

Published 23 Jun 2025

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/5133/5133.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Automate WhatsApp lead capture and replies with Whapi, Ollama and Sheets

Receive WhatsApp messages via Whapi, generate AI replies with a local Ollama model, log conversations in Google Sheets, and auto-capture leads — all without touching a cloud LLM. This n8n template builds a fully automated WhatsApp AI CRM using Whapi.cloud for messaging and Ollama for 100% local AI inference — no OpenAI costs, no data leaving your server. # How it works A Webhook node receives inbound WhatsApp messages from Whapi.cloud. A Code node extracts the sender's phone, name, message text, and filters out outbound/non-text messages. An IF node ensures only real inbound text messages from customers are processed. Google Sheets is used to fetch that customer's full conversation history, enabling memory across sessions. A Code node builds a full prompt — system instructions + conversation history + new message — passed to the AI model. Ollama (via LangChain LLM Chain node) generates a contextual reply using a local model (default: gemma3:1b). The user message and AI reply are each appended to Google Sheets as conversation history logs. A separate Google Sheets upsert captures or updates the lead record with phone and name. The AI reply is sent back to the customer via Whapi's HTTP API. # How to use Set up a Whapi.cloud account and connect a WhatsApp number. Point the webhook to your n8n webhook URL. Create a Google Sheet with a History tab (columns: Phone, Name, Role, Message, Timestamp) and a Leads tab (columns: Phone, Name, CreatedAt). Add your Google Sheets credentials and replace YOUR_GOOGLE_SHEET_ID in the relevant nodes. Run Ollama locally or on your server. Pull the model: ollama pull gemma3:1b. Update the model name in the Ollama node if using a different model. Customise the system prompt inside the Build AI Prompt node to match your business (real estate, support, bookings, etc.). Activate the workflow and send a WhatsApp message to test. # Requirements Whapi.cloud account (WhatsApp Business API) Ollama running locally or on a self-hosted server Google Sheets (with OAuth2 credentials connected in n8n) # Customising this workflow Switch AI models: Swap gemma3:1b for any Ollama-supported model like llama3, mistral, or phi3 depending on your hardware. Change the industry: Edit the system prompt in Build AI Prompt to serve any business — bookings, customer support, sales qualification, etc. Upgrade the CRM: Replace Google Sheets with Airtable, Notion, or a real CRM (HubSpot, Pipedrive) by swapping out the Sheets nodes. Add handoff logic: Insert a condition to escalate to a human agent if the message contains keywords like "speak to someone" or "human". Multi-language: The system prompt already instructs the AI to reply in the customer's language — no extra setup needed. # Who is this for It's designed for service businesses (real estate, consultants, agencies) that want to respond to inbound WhatsApp leads instantly, log conversations, and build a simple CRM — all from a single workflow.

View

Send multi-stage customer project emails from Google Sheets with Zoho ZeptoMail

Keep your clients informed at every stage of their project without lifting a finger. This workflow runs daily from Google Sheets and automatically sends four timed emails a Day 3 progress update, a Day 5 near-completion nudge, a feedback request on project completion, and a post-delivery upsell all via Zoho ZeptoMail. Each email is logged back to the sheet so no message ever sends twice. ## Who it's for Service businesses (resume writing, LinkedIn optimization, design, freelance agencies) that manage client orders in a Google Sheet and want structured follow-up without a CRM. ## How it works 1. A Schedule Trigger fires daily at 9 AM and reads all rows from your Google Sheet 2. Blank rows are filtered out; date variables are calculated dynamically 3. Four parallel branches check independently whether each email type is due: - **T+3** — progress update sent 3 days after the order date - **T+5** — near-completion update sent at day 5 (only after T+3 is confirmed sent) - **Feedback** — sent once the project status is marked Completed - **Upsell** — sent ~3 days after feedback, offering premium add-ons 4. Each qualifying row is looped one at a time, the email is sent via ZeptoMail, and the sheet is updated to prevent re-sends 5. After the upsell sends, the row status is set to **All Done** — permanently stopping all further checks for that customer ## Setup 1. Connect your **Google Sheets** and **Zoho ZeptoMail** credentials in n8n 2. Replace all `YOUR_RESOURCE_ID_HERE` placeholders in the Google Sheets nodes with your actual spreadsheet and sheet IDs 3. Set your sender address in all four email nodes (`YOUR_EMAIL_HERE`) 4. Update the feedback form link and booking link in the Feedback and Upsell email templates 5. Ensure your sheet has these columns: `Customer Name`, `Email`, `Project Type`, `Date Added`, `Status`, `T3_Email_Sent`, `T5_Email_Sent`, `Feedback_Email_Sent`, `Feedback_Email_Date`, `Upsell_Email_Sent`, `original_subject` ## Requirements - Self-hosted n8n instance (community node required) - Community node: `n8n-nodes-zohozeptomail` - Active Zoho ZeptoMail account with a configured mail agent

View

Send 10-day post-purchase WhatsApp offers with Odoo, OpenAI and Evolution API

What Problem Does It Solve? * Generic, automated retention messages often feel like spam and fail to engage returning customers. * Manually tracking which customers ordered exactly 10 days ago to send them tailored offers is extremely time-consuming. * Sending bulk promotional WhatsApp messages too quickly can result in phone number bans. * This workflow solves these issues by: - Automatically fetching customers from Odoo whose invoices are exactly 10 days old. - Using an AI Agent (OpenAI) to generate a highly personalized, warm Egyptian Arabic message for each customer. - Offering a targeted 10% extra discount to encourage repeat purchases via social media platforms. - Implementing a 1-minute "Wait" mechanism between messages to protect your WhatsApp account from being flagged. How to Configure It * Odoo Setup - Connect your Odoo credentials in n8n. - The workflow fetches invoices starting from April 2026. Adjust the date filter in the "Fetch 10-Day Old Invoices" node if needed. * OpenAI Setup - Add your OpenAI API key to the "Generate AI Message" node. - You can tweak the system prompt to match your specific brand voice or adjust the discount offer. * WhatsApp API Setup - This workflow uses the Evolution API. Update the URL and "apikey" in the "Send WhatsApp Discount" node with your specific instance details. How It Works * Every day at 10:01 AM, the schedule node triggers the workflow automatically. * It queries Odoo for all posted invoices exactly 10 days old and retrieves the corresponding customer contact details (Name and Phone). * It processes the customers one by one through a loop (Split In Batches). * For each customer, OpenAI generates a unique, friendly colloquial Arabic message calling them by their first name and offering a 10% discount. * The message explicitly directs the customer to claim the offer via social media messages, completely avoiding formal "terms & conditions" jargon. * The workflow sends the AI-generated text via WhatsApp and then pauses for 1 minute before processing the next customer. Customization Ideas * Change the AI prompt to offer different discounts based on the total amount the customer spent in their last order. * Add a condition to skip customers who have already made a new purchase within the last 10 days. * Switch the AI model to Claude or Gemini depending on your preference for Arabic copywriting. For more info [Contact Me](https://www.linkedin.com/in/khaledyasser01/)

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

Smart lead outreach with Explorium MCP using Google Sheets and Telegram

Workflow preview

Important notice

Overview

🧠 What It Does

🔄 How It Works

⚙️ Setup Instructions

📥 Output Includes: