AI-Powered Instagram Content Repurposing and Intelligence Engine - n8n Workflow

Content Marketers: Seeking an automated way to monitor trending topics in their niche. Social Media Managers: Needing unique, pre-written scripts based on successful competitor content. AI Automation Developers: Looking for an advanced, multi-step n8n workflow integrating scraping, transcription, and multiple large language models (LLMs). n8n Users: Interested in sophisticated n8n templates that manage deduplication and large data pipelines.

Generating fresh, engaging content can be a massive time sink. This n8n workflow solves the content discovery problem by creating an intelligent, self-updating content pipeline. It automatically monitors key competitor Instagram accounts for new Reel posts using the Apify n8n node. Crucially, it employs a smart deduplication process using Google Sheets to ensure no content is processed twice. Once a unique piece of content is found, the n8n template downloads the video, uses OpenAI Whisper to generate a transcript, and then feeds the transcript to GPT-4o for deep analysis (identifying tools, creating step-by-step guides, and refining content suggestions). Finally, it uses Perplexity for additional background context before GPT-4o writes a completely new, unique script. This automated n8n solution transforms competitive research into actionable, ready-to-use content ideas, showcasing the true power of an automated n8n system.

The entire process is initiated by the Schedule Trigger n8n trigger, set to run daily.

1. Content Discovery: The n8n workflow starts by executing an Apify actor via an HTTP Request n8n node. This step scrapes the latest Instagram Reels from a defined list of competitor usernames (set to the latest 5 per account).


2. Deduplication & Database Insertion: The flow connects to Google Sheets via the Search for Entries n8n node, checking if the Instagram Reel ID already exists in the database. The Drop Duplicates merge n8n node is configured to only pass forward items where no match was found (new content). The metadata for this new content is then recorded using the Add Entries Google Sheets n8n node.


3. Video Processing: The unique Reels pass to the Download Video HTTP Request n8n node, fetching the actual video file via the scraped videoUrl.


4. Transcription & Analysis: The Transcribe Video n8n node (using OpenAI Whisper) extracts the spoken text. This transcript is then sent to the Filter & Generate Suggestions GPT-4o n8n node, which performs a structured analysis to identify relevant tools and generate content repurposing suggestions.


5. External Research: The AI-generated search prompt is used by the Search Perplexity HTTP Request n8n node to gather three interesting facts about the discovered tool.


6. Script Generation: The Write New Script GPT-4o n8n node compiles all the data (original transcript, AI suggestions, step-by-step guide, and Perplexity facts) to generate a unique, high-quality, short Instagram script.


7. Final Update: The n8n workflow concludes by using the Update Entries Google Sheets n8n node to attach both the raw scraped transcript and the final, generated script back to the original database row, completing the content intelligence cycle within this efficient n8n workflow.

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


2. Set up Credentials: You must configure the following service credentials for the respective n8n node operations:

1. Customize Scraping: In the Run Actor Synchronously n8n node, modify the list of Instagram usernames to match your target competitors.


2. Activate: Save the n8n workflow and activate it to run according to the scheduled n8n trigger.

Schedule Trigger (n8n trigger): Function: Starts the n8n workflow daily at 6 AM. Key Configuration: Set to run once daily (interval). Run Actor Synchronously (HTTP Request n8n node): Function: Executes the Apify Instagram Scraper actor to gather new Reels. Key Configuration: POST request to Apify API. Body contains a list of username targets and resultsLimit: 5. Requires Apify Bearer Token in the headers. Search for Entries (Google Sheets n8n node): Function: Checks the Google Sheet database to see if the current Reel ID ($json.id) has been processed before. Key Configuration: Operation: Search. Filter by id column. Drop Duplicates (Merge n8n node): Function: Ensures the n8n workflow processes only genuinely new content. Key Configuration: Mode: Combine. Join Mode: keepNonMatches. Matches based on the id field. Transcribe Video (OpenAI n8n node): Function: Uses the Whisper API to transcribe the downloaded video file content. Key Configuration: Resource: audio. Operation: transcribe. Filter & Generate Suggestions (OpenAI n8n node - GPT-4o): Function: Analyzes the video transcript to identify tools and create structured content ideas and search prompts. Key Configuration: Model: gpt-4o. Requires structured JSON output format and detailed system/user prompts. Write New Script (OpenAI n8n node - GPT-4o): Function: Synthesizes all gathered information (transcript, analysis, research) to write a new, optimized script for social media.* Key Configuration: Model: gpt-4o. Uses data from previous n8n nodes (Transcribe Video, Filter & Generate Suggestions, Search Perplexity) in the complex input prompt.