This workflow automates deep content and strategy analysis for competitor Instagram accounts. It combines data scraping with a powerful multi-modal AI pipeline (Gemini) to not only tell you what your competitors are posting, but why it's working (or not working), and what you should do next.
The process is broken down into four logical stages:
- Scrape & Collect: Downloads recent posts, including media and captions, from specified competitor profiles.
- Deduplicate & Filter: Checks the Google Sheet database to ensure only genuinely new content that hasn't been analyzed before is processed.
- AI Analysis: Runs the new content through an advanced AI model (Gemini) to analyze images, videos, and text captions for themes, tone, and visual elements.
- Strategy Generation: Synthesizes all gathered metrics and AI insights to generate final, actionable content recommendations.
This workflow relies on the following services for data collection and intelligence:
| Service | Purpose | Requirement |
|---|---|---|
| Google Sheets | Database for storing all post data and AI analysis results. | A Google Project having Sheets & Docs APIs enabled |
| Apify | Web scraping tool for extracting high-volume Instagram data. | Apify API Key |
| Gemini / Google AI | Multi-modal analysis of content (images, video, text) and strategy generation. | Access to Gemini API |
Set up should take less than 5 minutes. You only need to configure the core inputs:
- Install Apify Node: Ensure you have the community node
@apify/n8n-nodes-apifyinstalled in your workflow environment to connect to the scraping tool. - Target Accounts: Provide the list of competitor Instagram usernames you wish to monitor in the initial scraping configuration.
- Post Limit: Set the max_posts value to specify how many of the latest posts should be pulled per account during each run.
This step downloads recent content (posts, videos, and images) from the Instagram competitor accounts you have defined.
To save resources and maintain data quality, this step ensures that the system only processes genuinely new content. It checks the post IDs against the content already logged in your Google Sheet and filters out any duplicates before the next stage.
New content is processed by the Gemini model, which uses multi-modal intelligence to extract meaning from every part of the post:
- Visual Analysis: Extracts key elements like persons, objects, themes, and emotional tone from images and video thumbnails.
- Text Analysis: Analyzes the caption and comments for meaning, tone, and sentiment.
- Data Storage: The comprehensive analysis results are saved into the Google Sheet, associated with the unique post ID.
The final stage acts as a "Strategy Specialist AI," synthesizing all the gathered data—performance metrics (likes, comments, etc.) and the deep AI analysis—to provide a final report:
- Key Insights: Identifies trends, such as the most engaged content themes, the best-performing media types (Reels vs. Images), and viral hashtags.
- Actionable Strategy: Provides specific, personalized recommendations for content experiments based on what is currently succeeding and failing in the competitor landscape.
While this workflow is built and optimized for the Gemini / Google AI model for multi-modal analysis, the core logic is flexible. You can easily:
- replace the AI nodes in STEP 3 and STEP 4 with a connector for any other AI provider (e.g., OpenAI, Claude) that meets your requirements.
- Fine tune the prompt messages to the format you want.
- Further pass the final insights to other AI workflows that generates content automatically based on the recommendations, & more..