Monitor Sales Pipeline Health with an OpenAI CRM Agent

# 🚀 Smart CRM Scraper & Pipeline Health Analyzer (n8n + Bright Data + Google Sheets) This automation workflow is perfect for sales ops, marketers, analysts, or even founders who want to: * 📥 Scrape sales pipeline data from CRM dashboards * 📊 Get insights into reps, leads, and statuses * 📁 Store it all in Google Sheets automatically — no copy/paste, no coding Let’s break this into 3 simple sections 👇 --- 🔷 SECTION 1: Start & Set Target 🧩 Combines these nodes: * ⚡ Trigger: Start CRM Scraper * 🔗 Set Source URL (CRM/JSONPlaceholder) 📌 What Happens Here? This section is where your automation begins. You: 1. Manually run the workflow by clicking ▶️ “Execute Workflow” 2. Define the website or CRM source you want to scrape Example: * You paste a mock CRM URL (e.g. https://jsonplaceholder.typicode.com) — but in a real scenario, it could be a Bright Data-accessible CRM dashboard. ✨ Benefits for Beginners: ✅ No coding — just click + paste a URL ✅ Easily swap out URLs for different CRM dashboards ✅ Full control over when scraping starts 🎯 Icons Summary: ⚡ Manual Start | 🔗 Source URL Setup 💡 Real-World Use: Replace the URL with a live CRM performance dashboard hosted inside Bright Data’s mobile proxy network. --- 🤖 SECTION 2: AI Agent — Scrape + Analyze 🧩 Combines: * 🤖 Monitor Sales Pipeline (CRM AI Agent) * 🧠 AI Brain (CRM Query Generator) * 🌐 Bright Data MCP (scrape\_as\_markdown) * 🧾 Clean JSON Parser (Pipeline Metrics) 📌 What Happens Here? This is the “thinking” part of the workflow. 1. 🧠 AI Brain: OpenAI understands the task. It generates instructions like: “Scrape rep names, stages, leads, health from this CRM dashboard as markdown.” 2. 🌐 Bright Data Tool: The MCP tool accesses the page invisibly (like a phone browser) and extracts pipeline data using its scrape\_as\_markdown tool. 3. 🧾 Structured Output Parser: Converts the scraped messy text into a structured JSON format like this: json [ { "rep": "Alice", "leads": 22, "stage": "Proposal", "status": "At Risk" }, ... ] ✨ Benefits for Beginners: ✅ Zero scraping code ✅ Handles login-blocked or bot-protected CRMs via mobile proxies ✅ Clean data format — easy to use in Sheets or dashboards 🎯 Icons Summary: 🧠 OpenAI Logic | 🌐 Bright Data Scraper | 🧾 JSON Cleaner 💡 Real-World Use: Scrape weekly CRM dashboards from tools like HubSpot, Pipedrive, Salesforce (if routed via Bright Data), and turn them into structured perfor