Analyze Competitor Visual Content Across Instagram and TikTok with GPT-4o Vision

This n8n workflow automates the process of collecting and analyzing competitor visual content from social media platforms (specifically Instagram and TikTok, although the current implementation focuses on a generic "Social Media" input) using GPT-4o Vision. It allows you to input social media post URLs, analyze their visual content, and store the insights in a Google Sheet.

What it does

This workflow simplifies the process of competitor visual content analysis by:

1. Triggering on Form Submission: It starts when a user submits a form containing social media post URLs.
2. Editing Fields: It prepares the input data for further processing, likely extracting and standardizing the URLs.
3. Conditional Processing: It uses a Switch node to route items based on a condition, though the specific condition is not defined in the provided JSON. This could be used to differentiate between Instagram and TikTok URLs, or other criteria.
4. Code Execution (Placeholder): It includes a Code node, which is currently empty. This node is intended to contain custom JavaScript logic, likely for making API calls to GPT-4o Vision to analyze the images from the provided URLs and extract visual insights.
5. Filtering Results: It filters the processed items based on a condition, ensuring only relevant data proceeds. The specific filter condition is not defined.
6. Aggregating Data: It combines multiple items into a single collection, useful for batch processing or preparing data for a single output.
7. Storing Data in Google Sheets: Finally, it writes the analyzed visual content data into a specified Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Sheets Account: A Google Sheets account and a configured n8n credential for Google Sheets to store the analysis results.
• OpenAI API Key (Implied): Although not explicitly configured in the provided JSON, the workflow's purpose of "analyzing competitor visual content with GPT-4o Vision" implies the need for an OpenAI API key and a corresponding n8n credential for OpenAI. This would be used within the Code node.
• Social Media Access (Implied): Access to the social media platforms (Instagram, TikTok) to obtain the post URLs.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure Google Sheets Credential:
   • Locate the "Google Sheets" node.
   • Configure your Google Sheets credential, ensuring it has write access to the target spreadsheet.
   • Specify the "Spreadsheet ID" and "Sheet Name" where the analyzed data will be stored.
3. Configure Form Trigger:
   • Locate the "On form submission" node.
   • Activate the workflow and copy the webhook URL. This URL will be used to submit your social media post URLs.
4. Implement GPT-4o Vision Logic:
   • Locate the "Code" node.
   • Add custom JavaScript code to:
     • Extract image URLs from the social media post URLs provided in the input.
     • Make API calls to GPT-4o Vision (e.g., using n8n.require('openai') or a direct HTTP request) to analyze the images.
     • Parse the GPT-4o Vision response and extract relevant visual insights (e.g., objects detected, themes, colors, sentiment).
     • Format the extracted insights into a structure suitable for the subsequent Google Sheets node.
   • Ensure you have an OpenAI credential configured in n8n for this node to use.
5. Define Switch and Filter Logic:
   • Locate the "Switch" node and define the condition(s) for routing items.
   • Locate the "Filter" node and define the condition(s) for filtering items.
6. Test the Workflow:
   • Manually send a form submission to the "On form submission" webhook URL with sample social media post URLs.
   • Verify that the data is processed correctly and written to your Google Sheet.