AI LinkedIn Content Performance Analyzer using Bright Data and NocoDB - n8n Workflow

Social Media Strategists: Individuals managing LinkedIn content who need data-driven insights. n8n Users: Developers or automators looking for advanced examples integrating web scraping, databases, and AI Agents in a single n8n workflow. Content Creators: Those seeking an automated system to analyze which posts perform best using real engagement data. Technical Users of NocoDB/Bright Data: Users needing an efficient n8n node implementation for these services.

Managing high-performing LinkedIn content requires analyzing engagement metrics, but manually tracking hundreds of posts is inefficient. This sophisticated n8n workflow solves this by automating the entire lifecycle: scraping, storage, and intelligent analysis.

It consists of two primary flows. First, a scraping flow uses the Bright Data n8n node to pull detailed metrics (likes, comments, content text) for your LinkedIn posts and updates the records in NocoDB, turning it into a real-time performance database. Second, an n8n AI Agent, powered by the OpenAI Chat Model, uses these stored NocoDB metrics as a knowledge base. You can use the When chat message received n8n trigger to ask complex questions like, 'Which content themes received the most engagement last month?' and receive insightful, data-backed answers. This is a powerful n8n template for data-driven content optimization.

The entire process is orchestrated within this comprehensive n8n workflow, which contains two main branches:

1. Data Synchronization Flow (Manual Trigger): The workflow starts with the When clicking ‘Execute workflow’ n8n trigger. It fetches existing post links from NocoDB using the Get posts nocoDb n8n node. These links are aggregated and passed to the Scrape LinkedIn Posts Bright Data n8n node, initiating a scraping job.

To set up this advanced n8n workflow, follow these steps:

1. Import: Copy the provided JSON and import it directly into your n8n instance using the 'New' -> 'Import from JSON' feature.


2. Credentials: You must configure credentials for the following services:

1. Configuration Node: Edit the Config n8n node (a Set node) to define your specific NocoDB setup, including nocodbBaseUrl and nocodbPostsTableId.


2. Database Setup: Ensure your NocoDB instance has a table populated with your LinkedIn post links before running the scraping workflow.


3. Activation: Manually execute the scraping flow (starting from the When clicking ‘Execute workflow’ n8n trigger) once to populate the initial data. Then, activate the entire n8n workflow to enable the chat assistant.

This n8n workflow utilizes a complex array of nodes for data synchronization and AI orchestration:

When clicking ‘Execute workflow’ (n8n trigger): Initiates the data scraping and update process manually.
When chat message received (n8n trigger): Starts the AI Agent conversation, serving as the user interface.
Config (Set): Defines environment variables like the NocoDB base URL and table ID, which are used throughout the n8n workflow.
Get posts (NocoDB): Queries NocoDB to retrieve the list of post links previously stored.
Scrape LinkedIn Posts (Bright Data): A Bright Data n8n node configured to initiate a scraping job for LinkedIn posts metrics. It uses the LinkedIn posts dataset.
Get Snapshot Status / Download Snapshot (Bright Data): Handles the asynchronous job execution of the web scraping task, polling until the data is ready.
Update Post (HTTP Request): Performs a PATCH request to NocoDB using dynamic data to update existing post records with fresh Likes, Comments, and Content metrics.
OpenAI Chat Model (Langchain): The core LLM provider used by the agent for reasoning and generating content insights.
AI Agent (Langchain): The orchestrator n8n node. It manages the tools and memory, using a specialized system message to act as an expert content assistant.
Get Top LinkedIn Posts (NocoDB Tool): Exposes the NocoDB performance data as a tool to the AI Agent, allowing the agent to fetch post statistics dynamically during the chat.