Monitor Competitor LinkedIn Posts with Bright Data and OpenAI

## 🚀 LinkedIn Company Post Analyzer Workflow This automation lets you input a LinkedIn company URL, scrape its latest 5 posts using Bright Data MCP, calculate engagement averages, and store everything neatly in Google Sheets. Whether you're a digital marketer, analyst, or business owner—this saves time and effort! --- ### 🔹 SECTION 1: Start & Input #### 🧩 Nodes: * 🔘 Trigger: Manual Start * 🔗 Set LinkedIn Company URL #### 💡 What Happens: This section is your starting point. You manually execute the workflow by clicking the play button, and then you enter the LinkedIn company profile URL in a form field. #### ✅ Beginner Tip: You don’t need coding skills. Just copy the company’s LinkedIn URL (e.g., https://www.linkedin.com/company/openai) and paste it here. This kicks off the whole automation! --- ### 🤖 SECTION 2: Smart Scraper Agent #### 🧩 Node: * 🤖 Agent: Fetch LinkedIn Posts (via MCP Tool) ##### 🧠 Sub-Nodes Inside the Agent: * 🧠 Chat Model: Understands your scraping request in natural language. * 🌐 Bright Data MCP Client: Actually visits LinkedIn via mobile proxies and scrapes the data. * 🧾 Parse AI Response: Converts raw results into structured post data. #### 💡 What Happens: This smart AI agent (powered by OpenAI + Bright Data) goes to the LinkedIn company page, scrapes the latest 5 posts, and organizes them. Bright Data MCP lets it bypass anti-bot systems by using mobile IPs, so it's reliable even on protected sites like LinkedIn. #### ✅ Beginner Tip: You don’t write any scraping code! The AI understands what to do and fetches posts like a human browser would. This is completely no-code for you. --- ### 📊 SECTION 3: Analyze & Save Metrics #### 🧩 Nodes: * 📈 Analyze Engagement Metrics * 📥 Save Averages to Google Sheets #### 💡 What Happens: Here, the automation calculates the average values (like likes, comments, etc.) from the 5 scraped posts using simple JavaScript logic. Then, it saves these average values into your first Google Sheet so you can track performance over time. #### ✅ Beginner Tip: This helps you measure content engagement across different companies. You can reuse this for competitive research, content benchmarking, or client reporting. --- ### 📄 SECTION 4: Format & Store Full Posts #### 🧩 Nodes: * 🧾 Format Post Content * 📥 Save Posts to Google Sheets #### 💡 What Happens: Now that averages are stored, this section