This workflow follows the HTTP Request → Postgres recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"parameters": {
"triggerTimes": {
"item": [
{
"hour": "*/1",
"minute": "0"
}
]
}
},
"name": "Cron",
"type": "n8n-nodes-base.cron",
"typeVersion": 1,
"position": [
200,
250
]
},
{
"parameters": {
"resource": "searchPosts",
"operation": "get",
"query": "looking for a marketing agency OR looking for performance marketing agency OR looking for social media manager OR growth manager OR branding expert OR agency OR founders marketing agency OR agencies OR marketing agency OR meta ads OR video production agencies OR advertising agencies OR jobs on linkedin OR performance marketing OR graphic designer OR website developer OR web designer OR meta ads expert"
},
"name": "LinkedIn Scrape",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
450,
150
]
},
{
"parameters": {
"subreddit": "marketing,jobs,Entrepreneur",
"filter": "new",
"limit": 50,
"options": {}
},
"name": "Reddit Search",
"type": "n8n-nodes-base.reddit",
"typeVersion": 1,
"position": [
450,
350
]
},
{
"parameters": {
"resource": "tweet",
"operation": "search",
"rules": [
{
"key": "query",
"value": "looking for a marketing agency OR looking for performance marketing agency OR looking for social media manager OR growth manager OR branding expert OR agency OR founders marketing agency OR agencies OR marketing agency OR meta ads OR video production agencies OR advertising agencies OR jobs on linkedin OR performance marketing OR graphic designer OR website developer OR web designer OR meta ads expert"
},
{
"key": "maxResults",
"value": 50
}
]
},
"name": "Twitter Search",
"type": "n8n-nodes-base.twitter",
"typeVersion": 1,
"position": [
700,
150
]
},
{
"parameters": {
"httpMethod": "GET",
"url": "https://www.instagram.com/explore/tags/marketing/?__a=1",
"jsonParameters": true
},
"name": "Instagram Scrape",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
700,
350
]
},
{
"parameters": {
"mode": "mergeByIndex"
},
"name": "Merge",
"type": "n8n-nodes-base.merge",
"typeVersion": 1,
"position": [
950,
250
]
},
{
"parameters": {
"values": {
"string": [
{
"name": "source",
"value": "={{$node[\"Merge\"].json[\"source\"]||'unknown'}}"
},
{
"name": "external_id",
"value": "={{$json[\"data\"]?.id||$json[\"id_str\"]||$json[\"id\"]}}"
},
{
"name": "title",
"value": "={{($json[\"data\"]?.text||$json[\"text\"]||$json[\"caption\"]).slice(0,50)}}"
},
{
"name": "description",
"value": "={{$json[\"data\"]?.text||$json[\"text\"]||$json[\"caption\"]}}"
},
{
"name": "link",
"value": "={{$json[\"data\"]?.permalink||$json[\"link\"]||`https://twitter.com/${$json[\"user\"]?.screen_name}/status/${$json[\"id_str\"]}`}}"
}
],
"json": [
{
"name": "keywords",
"value": "=[\"looking for a marketing agency\",\"looking for performance marketing agency\",\"looking for social media manager\",\"growth manager\",\"branding expert\",\"agency\",\"founders marketing agency\",\"agencies\",\"marketing agency\",\"meta ads\",\"video production agencies\",\"advertising agencies\",\"jobs on linkedin\",\"performance marketing\",\"graphic designer\",\"website developer\",\"web designer\",\"meta ads expert\"].filter(k => ($json[\"data\"]?.text||$json[\"text\"]||$json[\"caption\"]).toLowerCase().includes(k))"
}
]
}
},
"name": "Set",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1200,
250
]
},
{
"parameters": {
"operation": "upsert",
"table": "opportunities",
"schema": "public",
"columns": "source,external_id,title,description,link,keywords",
"keyColumn": "external_id"
},
"name": "Supabase Insert",
"type": "n8n-nodes-base.postgres",
"typeVersion": 1,
"position": [
1450,
250
]
}
],
"connections": {
"Cron": {
"main": [
[
{
"node": "LinkedIn Scrape",
"type": "main",
"index": 0
}
],
[
{
"node": "Reddit Search",
"type": "main",
"index": 0
}
],
[
{
"node": "Twitter Search",
"type": "main",
"index": 0
}
],
[
{
"node": "Instagram Scrape",
"type": "main",
"index": 0
}
]
]
},
"LinkedIn Scrape": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Reddit Search": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Twitter Search": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Instagram Scrape": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 3
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Set",
"type": "main",
"index": 0
}
]
]
},
"Set": {
"main": [
[
{
"node": "Supabase Insert",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Opportunity Grab Workflow. Uses httpRequest, reddit, twitter, postgres. Scheduled trigger; 8 nodes.
Source: https://gist.github.com/aureliusdeus/93ab02b58fccd3dffc26a5f35ef0c372 — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow monitors brand mentions across multiple platforms (Twitter/X, Reddit, News) and automatically detects reputation crises based on sentiment analysis and trend detection. Multi-platform mo
Turn your blog into a set-and-forget content engine: every new article is instantly repurposed into channel-specific social posts with visuals, keeping your brand visible on LinkedIn, X, and Reddit wi
Automatically discovers trending topics in your niche and generates ready-to-use content ideas with AI. Twitter/X trending topics and hashtags Reddit hot posts from niche subreddits Google Trends dail
Social media managers, creators, and brand accounts that rely on retweets for reach but want an automated, hands-off cleanup after campaigns to keep profiles tidy and on-brand.
Creator: Summer Chang