Analyze sales territory performance with Bright Data MCP & GPT-4o

This workflow automatically analyzes sales territory performance, comparing revenue, win rates, and activity across regions. Remove the guesswork from territory planning and drive balanced growth.

Overview

On a weekly schedule, the workflow pulls CRM data for each territory, merges it with demographic and market size info scraped via Bright Data, and feeds everything into OpenAI for performance benchmarking. Outliers—both high and low performers—are highlighted in a Google Data Studio dashboard and summarized in a Slack message.

Tools Used

- n8n – Orchestrates data collection and analysis - CRM API – Source of sales metrics by territory - Bright Data – Scrapes external market indicators (population, GDP, etc.) - OpenAI – Normalizes and benchmarks territories - Google Sheets / Data Studio – Stores and visualizes results - Slack – Sends the weekly summary

How to Install

1. Import the Workflow into n8n. 2. Connect Your CRM API credentials. 3. Configure Bright Data credentials. 4. Set Up OpenAI API key. 5. Authorize Google services & Slack. 6. Customize Territory Definitions in the Set node.

Use Cases