Automate Instagram influencer lead collection with Apify, GPT and PostgreSQL
Needs changesWhat this workflow does
This AI workflow has 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model and Postgres. It also calls api.apify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Edit Fields (Edit Fields (Set)): sets 3 fields: site, field_of_interest, target_country
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Code: runs custom JavaScript code
- HTTP Request: calls api.apify.com
- Split Out: splits a list into separate items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Code: runs custom JavaScript code
- HTTP Request: calls api.apify.com
- Information Extractor: extracts structured fields from text with AI, with model: OpenAI Chat Model
- Postgres: create or update
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Postgres
n8n-nodes-base.postgres
From the author
This workflow is built for digital marketers, sales professionals, influencer agencies, and entrepreneurs who want to automate Instagram lead generation. If you’re tired of manually searching for profiles, copying email addresses, and updating spreadsheets,…