Bibliothek / Social-Media-Veröffentlichung
Social-Media-Veröffentlichung
Konkurrenten-Instagram-Reels in KI-Content-Briefings in Google Sheets analysieren
Ruft nach Zeitplan Konkurrenten-Reels über Apify ab, transkribiert die Audiospur und nutzt ein KI-Modell, um strukturierte Content-Briefings in Google Sheets zu speichern. Bereits verarbeitete Reels werden übersprungen.
Was sie bewirkt
### 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.
Die Schritte
- 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
Insgesamt 23 Schritte.
Ähnliche Automatisierungen
Social-Media-VeröffentlichungInstagram Reels mit Apify, OpenAI und Perplexity analysieren12 SchritteSocial-Media-VeröffentlichungInstagram-Reels, die über Telegram gesendet werden, mit Apify und OpenAI analysieren23 SchritteWeb Scraping & RechercheInstagram Reels transkribieren und Ideen in Sheets ergänzen12 SchritteSocial-Media-VeröffentlichungInstagram Reels aus Google Drive und Sheets planen10 Schritte