Automate Instagram content discovery & repurposing w/ Apify, GPT-4o & Perplexity
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every day at 06:00). Along the way it connects OpenAI and Google Sheets. It also calls api.apify.com and api.perplexity.ai over HTTP.
How it runs
Trigger: On a schedule (every day at 06:00).
- Run Actor Synchronously (HTTP Request): calls api.apify.com (POST)
- Limit: keeps the first few items
- Search for Entries (Google Sheets): uses Google Sheets
- Drop Duplicates (Merge): merges the data from its input branches
- Add Entries (Google Sheets): append
- Download Video (HTTP Request): calls an HTTP API
- Transcribe Video (OpenAI): transcribe (audio)
- Filter & Generate Suggestions (OpenAI): uses OpenAI
- Search Perplexity (HTTP Request): calls api.perplexity.ai (POST)
- Write New Script (OpenAI): uses OpenAI
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.apify.com, api.perplexity.ai
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- HTTP Request
n8n-nodes-base.httpRequest - Limit
n8n-nodes-base.limit - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
This workflow creates an end-to-end Instagram content pipeline that automatically discovers trending content from competitor channels, extracts valuable insights, and generates new high-quality scripts for your own content creation. The system helped scale an…