Library / Social Media Publishing
Social Media Publishing
Analyze competitor Instagram Reels into AI content briefs in Google Sheets
On a schedule, pulls competitor Reels via Apify, transcribes audio, and uses an AI model to save structured content briefs to Google Sheets, skipping Reels already processed.
What it does
### Turn competitor Instagram Reels into an AI content brief in Google Sheets This workflow watches a list of competitor Instagram accounts, picks up the Reels they publish, transcribes the audio, and asks an AI model to turn each Reel into a structured content brief saved to a Google Sheet. Every Reel is analysed once — anything already processed in an earlier run is skipped. Who it's for Social media managers, creators and growth teams who want to learn from competitors' Reels without scrolling and taking notes by hand. How it works 1. A schedule trigger starts the run (default: daily at 09:00). 2. Competitor handles are read from the "Competitors" sheet and filtered on the active flag. 3. The Apify Instagram Reels Downloader runs in Reels-only mode, so each competitor's latest Reels are fetched directly — no photo or carousel posts mixed in. 4. Reels already seen are skipped through a deduplication registry kept in an n8n Data Table, so no extra database is needed. 5. The Apify Instagram Video AI Transcript actor turns each new Reel's audio into text. 6. An AI model returns one brief per Reel: summary, hook, hook type, topic, angle, audience, pain point, key message, CTA, emotion, format, plus three rewritten hooks and three adjacent content ideas. 7. Briefs are appended to the "Reel Intelligence" sheet. A failed Reel is recorded and retried on the next run instead of blocking the batch. How to set up 1. Install the Apify community node (self-hosted: Settings → Community nodes). 2. Create the two sheet tabs with the exact headers listed in the setup sticky note. 3. Attach credentials to the Apify, Google Sheets and AI model nodes, then add the competitor accounts you want to track. 4. Run the workflow once manually to confirm rows land in the output sheet, then activate it. Requirements * An Apify account — the two Actors used here are paid per event. A typical run of 8 short Reels costs roughly $0.04. * A Google account with Google Sheets access. * An OpenAI-compatible API key for the analysis step (DeepSeek by default). * The Apify community node (@apify/n8n-nodes-apify) installed on your instance. How to customise * Swap the Actor IDs in the two Apify nodes to run any other Apify Actor. * Point the model node at any OpenAI-compatible endpoint. The Telegram digest node is disabled by default.
The steps
- 01 — When Competitors Should Be Checked
- 01b — Create Registry Table
- 02 — Load Competitors
- 02b — Filter Active Competitors
- 03 — Loop Over Competitors
- 04 — Fetch Recent Reels
- 05 — Normalize Reel Data
- 06 — Prepare Reel Queue
- 07 — Loop Over Reels
- 08 — Already Processed?
- 09 — Is New Or Retryable?
- 09b — Should Process?
- 10 — Run Instagram Transcript Actor
- 11 — Validate Transcript
23 steps in total.
Similar automations
Social Media PublishingAnalyze Instagram Reels with Apify, OpenAI and Perplexity12 stepsSocial Media PublishingAnalyze Instagram Reels sent via Telegram with Apify and OpenAI23 stepsWeb Scraping & ResearchTranscribe Instagram Reels and Add Ideas to Sheets12 stepsWeb Scraping & ResearchRank Whop clipping campaigns and send briefs via Apify, OpenAI and Telegram14 steps