Analyze Competitor LinkedIn Posts with Bright Data & Google Gemini to Google Sheets

This n8n workflow automates the process of analyzing competitor LinkedIn posts by leveraging Bright Data for data extraction, Google Gemini for AI-powered analysis, and Google Sheets for storing the results. It simplifies competitive intelligence gathering, allowing you to quickly understand key themes, sentiment, and engagement strategies from your competitors' content.

What it does

1. Triggers Manually: The workflow is initiated manually, allowing you to control when the analysis is performed.
2. Analyzes with AI Agent: An AI Agent (likely configured with specific instructions not visible in the JSON but implied by the node type) processes the input data.
3. Uses Google Gemini Chat Model: The AI Agent utilizes the Google Gemini Chat Model for its language understanding and generation capabilities, performing the core analysis of the LinkedIn posts.
4. Parses AI Output: The AI Agent's output is processed by an "Auto-fixing Output Parser" and a "Structured Output Parser" to ensure the results are in a clean, usable format.
5. Edits Fields: The extracted and analyzed data is then transformed and refined using an "Edit Fields (Set)" node, likely to map the AI output to the desired structure for Google Sheets.
6. Writes to Google Sheets: Finally, the processed data is written to a Google Sheet, providing a structured repository for your competitor analysis.

Prerequisites/Requirements

• n8n Instance: A running n8n instance.
• Google Account: A Google account with access to Google Sheets and Google Gemini.
• Google Sheets Credential: An n8n credential configured for Google Sheets.
• Google Gemini Credential: An n8n credential configured for Google Gemini.
• Bright Data (Implied): While not explicitly present as a node in the provided JSON, the directory name "6619-analyze-competitor-linkedin-posts-with-bright-data--google-gemini-to-google-sheets" strongly suggests that Bright Data is used upstream to collect the LinkedIn post data that this workflow then processes. You would need a Bright Data account and potentially a separate workflow or script to feed the LinkedIn post data into this workflow.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets credential.
   • Set up your Google Gemini Chat Model credential.
3. Review AI Agent Configuration: The "AI Agent" node will need to be configured with specific instructions (prompts) on how to analyze the LinkedIn posts (e.g., identify themes, sentiment, engagement metrics). This configuration is not part of the base JSON and will need to be set up within the node's settings.
4. Configure Google Sheets Node:
   • Specify the Spreadsheet ID and Sheet Name where the analyzed data should be written.
   • Ensure the column headers in your Google Sheet match the output structure defined in the "Edit Fields (Set)" node.
5. Prepare Input Data (from Bright Data): Ensure you have a mechanism (likely a preceding workflow or manual input) to feed the raw LinkedIn post data (presumably scraped using Bright Data) into the "AI Agent" node. The "Manual Trigger" suggests this workflow is designed to be run on demand with pre-collected data.
6. Execute the Workflow: Click "Execute Workflow" on the "When clicking ‘Execute workflow’" node to run the analysis.