Cross-Platform Visual Competitive Intelligence using GPT-4o Vision - n8n Workflow

Marketing and Content Strategists needing deep visual competitive intelligence.
Agencies performing detailed social media audits for clients.
n8n users looking for advanced examples combining scraping (Apify) and OpenAI Vision.
Anyone interested in leveraging GPT-4o for sophisticated image analysis tasks within an n8n workflow.

Traditional competitive analysis often overlooks the nuances of visual content. This specialized n8n workflow solves this by automating the scraping and deep analysis of visual assets (images and covers) from platforms like Instagram and TikTok.

By leveraging the GPT-4o Vision model, the n8n node can dissect complex visual elements—such as color palettes (hex codes), composition styles, mood, and text design—that are critical for effective branding. This eliminates manual review, providing structured data and culminating in a comprehensive, AI-generated competitive strategy report. This is one of the most powerful n8n templates available for visual data analysis.

This n8n workflow operates in a sequential, highly automated fashion:

1. Initiation: The process starts with the Form Trigger1 n8n trigger, where the user inputs their account handle, up to three competitors, desired platforms (Instagram/TikTok), and the number of posts to analyze.


2. Configuration: The input is cleaned and standardized by the Workflow Configuration1 n8n node, which also retrieves the crucial OpenAI API key.


3. Platform Routing: The Platform Router1 n8n node directs the flow to the correct Apify scraping modules based on the platforms selected by the user.


4. Content Scraping: Dedicated Apify nodes (Scrape Instagram Posts, Scrape TikTok Posts) run specific actors to retrieve the recent posts and associated image/cover URLs for all specified accounts.


5. Data Filtering: The Filter Images Only1 n8n node ensures that only valid visual content (posts with accessible images/covers) proceeds to the expensive AI analysis stage.


6. AI Vision Analysis: The Analyze Images with GPT-4o Vision code n8n node iterates through every image. It passes the image URL to the GPT-4o Vision API, requesting a structured JSON output detailing visual attributes. This is the core data generation step of the n8n workflow.


7. Reporting: The Aggregate All Results n8n node collects all individual image analyses. The subsequent Generate Competitive Analysis Report code n8n node uses GPT-4 (standard) to ingest the vast amount of collected data and synthesize a detailed, structured competitive analysis report.


8. Logging: Finally, the Log Results to Google Sheets n8n node records the key inputs (accounts, platforms) and the generated summary report for long-term tracking and logging.

To deploy this powerful n8n workflow, follow these steps:

1. Import: Copy the provided n8n workflow JSON and import it directly into your n8n instance.


2. Apify Credentials: You must configure Apify API credentials. Navigate to the Scrape Instagram Posts or Scrape TikTok Posts n8n node and set up or select your Apify OAuth2 API credentials.


3. OpenAI API Key: Open the Workflow Configuration1 n8n node and replace the placeholder YOUROPENAIAPIKEY with your actual OpenAI API key. Ensure this key has access to gpt-4o and gpt-4 models.


4. Google Sheets Setup: Create a new Google Sheet. Ensure it has columns for timestamp, ownaccount, competitors, platforms, posts_analyzed, and summary.


5. Link Google Sheets: In the Log Results to Google Sheets n8n node, connect your Google Sheets account and update the Document ID and Sheet Name (or Sheet ID) to match your newly created spreadsheet.


6. Activation: Save the n8n workflow and run the Form Trigger1 to begin analysis.

Form Trigger1 (n8n trigger): Initiates the workflow via a web form. Collects required inputs: Your account handle, up to three competitor handles, selected platforms (Instagram/TikTok), and Number of Posts to Analyze.
Workflow Configuration1 (Set n8n node): Essential for setup. This n8n node standardizes input variables and requires mandatory configuration of the openaiApiKey variable.
Platform Router1 (Switch n8n node): A core logic n8n node that intelligently routes the execution path only to the Apify scrapers corresponding to the platforms selected in the initial form.
Scrape Instagram Posts / Scrape TikTok Posts (Apify n8n nodes): These nodes execute specialized Apify actors to harvest content metadata, dynamically configuring the input based on the accounts and post count set in the n8n workflow configuration.
Analyze Images with GPT-4o Vision (Code n8n node): Performs the visual intelligence task. This custom n8n node uses an HTTP request to interface with the GPT-4o Vision model, requesting detailed, JSON-formatted attributes (like colorpalette, compositionstyle) for each scraped image.
Generate Competitive Analysis Report (Code n8n node): Aggregates the results from all preceding steps. It calls the GPT-4 model with a detailed system prompt, instructing it to synthesize the data into a structured report covering competitive matrices, platform patterns, and recommended actions.

• Log Results to Google Sheets (Google Sheets n8n node): Serves as the database for the n8n workflow, appending a record of the analysis summary and configuration details upon completion.