32 Track Sales Rep Performance

# 🚀 Sales Rep Performance Scraper & Analyzer (n8n + Bright Data + AI)

This smart automation lets you scrape performance data about your sales reps from a source (like Bright Data’s MCP), extract meaningful insights (like rankings, completed tasks, coaching suggestions), and save them beautifully into Google Sheets — no coding required!

Let’s break it down section-by-section:

---

## 🔹 SECTION 1: Input & Trigger

🧩 Combines:

* ⚡ Start Scraping (Manual Trigger)
* 🔗 Set MCP Source URL

🧠 What Happens:
This section lets you kick off the workflow and define where the data should come from.

📝 How It Works:

1. You manually run the workflow (great for testing or scheduled automation).
2. In the Set node, you paste the URL to scrape. In this example, it's a placeholder:
   → [https://jsonplaceholder.typicode.com](https://jsonplaceholder.typicode.com)

📈 Real-World Example:
You can change this to the MCP URL that fetches your sales performance dashboard from Bright Data.

🌟 Benefits:
✅ Beginner-friendly – no technical steps
✅ Fully customizable – just replace the placeholder with your real URL
✅ Works instantly – click + paste = done

🎯 Icons Summary:
⚡ = Start
🔗 = Define Target Source

---

## 🤖 SECTION 2: AI Scraper & Analyzer (Bright Data MCP + AI Agent)

🧩 Combines:

* 🤖 Analyze Sales Rep Performance (AI Agent)

  * 🧠 AI Brain (OpenAI)
  * 🌐 Bright Data MCP Tool: scrape\_as\_markdown
  * 🧾 Structured Response Parser

🧠 What Happens:
This section is the heart of the workflow. It uses AI to read and scrape the webpage, process performance results, and return clean, structured JSON data.

📝 How It Works:

1. 🧠 OpenAI receives instructions like:
   → “Scrape latest sales rep performance. Include repId, completedTasks, ranking, coaching suggestions, return as JSON.”

2. 🌐 Bright Data’s MCP executes this by visiting the URL using mobile proxies and scraping the page as markdown (bypassing anti-bot protections).

3. 🧾 The Structured Output Parser turns the result into a usable JSON array of sales reps with performance metrics.

🧪 Output Example:

```json
[
  {
    "repId": 12,
    "completedTasks": 18,
    "coachingRecommended": false
  },
  ...
]
```

🌟 Benefits:
✅ Uses real-time AI scraping — no code, no manual labor
✅ 100% structured output for automation
✅ Scalable — works for 5 reps or 5,000!

🎯 Icons Summary:
🤖 = AI Agent
🧠 = AI Brain
🌐 = Scrape using Bright Data MCP
🧾 = Convert to JSON

---

## 📊 SECTION 3: Process & Store in Google Sheets

🧩 Combines:

* 🧩 Split JSON to Individual Records (Function Node)
* 📊 Store Rep Performance (Google Sheets)

🧠 What Happens:
Now that we have structured performance data, we break it into clean individual rows and save them in a Google Sheet.

📝 How It Works:

1. 🧩 The function node splits the array of reps into individual entries.
   → Converts one big object with 10 reps → into 10 separate rows.

2. 📊 The Google Sheets node appends each row:
   → Columns like repId, completedTasks, ranking, coachingRecommended

📈 Real-World Use:
Perfect for tracking KPIs, building dashboards, or creating team reports without spreadsheets manual work!

🌟 Benefits:
✅ Automatically stores structured data
✅ Compatible with dashboards and analytics tools
✅ Hands-free performance reporting!

🎯 Icons Summary:
🧩 = Split records
📊 = Store in Google Sheets

---

# 🎁 Full Workflow Summary (Emoji Snapshot)

| Step | Icon | Name                 | Description                        |
| ---- | ---- | -------------------- | ---------------------------------- |
| 1️⃣  | ⚡    | Start Scraping       | Manually start the workflow        |
| 2️⃣  | 🔗   | Set MCP Source URL   | Define where the data comes from   |
| 3️⃣  | 🤖   | AI Agent             | Smart scraper that thinks for you  |
|      | 🧠   | OpenAI Model         | Understands scraping instructions  |
|      | 🌐   | Bright Data Tool     | Actually scrapes the source        |
|      | 🧾   | Output Parser        | Formats everything into clean JSON |
| 4️⃣  | 🧩   | Split JSON           | Breaks array into rows             |
| 5️⃣  | 📊   | Save to Google Sheet | Appends results into spreadsheet   |