This n8n workflow automates the process of scraping sales representatives’ performance data, analyzing it with AI, and storing the insights in Google Sheets. The process begins with a manual trigger where the user defines a target URL from which to scrape data, such as a sales performance dashboard. The workflow then utilizes Bright Data’s MCP tool combined with OpenAI’s language model to scrape, interpret, and structure data about each sales rep’s tasks, completion rates, and coaching needs. The structured data is processed by a function node to split it into individual records, which are then appended to a Google Sheets document for ongoing performance tracking. This automation is ideal for sales teams and managers who want to monitor reps’ KPIs without manual data entry, enabling real-time insights and streamlined reporting.

Node Count	11 – 20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.outputParserAutofixing, @n8n/n8n-nodes-langchain.outputParserStructured, code, googleSheets, manualTrigger, n8n-nodes-mcp.mcpClientTool, set, stickyNote