Engage with relevant Instagram posts using OpenAI and Postgres
Ready for 3.0What this workflow does
This AI workflow has 23 nodes and runs on a schedule (every day at 15:00). Along the way it connects Postgres and OpenAI. It also calls api30.unipile.com:16038 over HTTP.
How it runs
Trigger: On a schedule (every day at 15:00).
- Get Influencer Data (Postgres): select
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Fetch_Influencer_Post (HTTP Request): calls an HTTP API
- formatPost (Code): runs custom JavaScript code
- hasTodayPost (If): checks a condition and branches into true / false
- checkPostRelevancyText (OpenAI): uses OpenAI
- GetImage (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- CheckImageRelevancy (OpenAI): analyze (image)
- format_Relevancy (Code): runs custom JavaScript code
…plus 12 more steps. See the full node list below.
Services it uses
HTTP calls to: api30.unipile.com:16038
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 (9)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Wait
n8n-nodes-base.wait - Postgres
n8n-nodes-base.postgres - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick overview This scheduled workflow pulls Instagram influencers from Postgres, fetches each creator’s latest post via Unipile, evaluates caption and image relevance with OpenAI, and—when qualified—generates and publishes a like and comment through Unipile…