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 →
{
"name": "04 - Creator Analytics Daily Digest",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 8 * * *"
}
]
}
},
"name": "Cron: Daily 8am",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
250,
300
],
"id": "node-cron"
},
{
"parameters": {
"operation": "executeQuery",
"query": "SELECT creator_id, COUNT(*) as track_count, SUM(play_count) as total_plays, SUM(like_count) as total_likes FROM tracks WHERE created_at > NOW() - INTERVAL '24 hours' GROUP BY creator_id"
},
"name": "Neon: Yesterday's Stats",
"type": "n8n-nodes-base.postgres",
"position": [
500,
300
],
"id": "node-stats"
},
{
"parameters": {
"batchSize": 1
},
"name": "Split by Creator",
"type": "n8n-nodes-base.splitInBatches",
"position": [
750,
300
],
"id": "node-split"
},
{
"parameters": {
"url": "={{ $env.THINKZONE_API_URL }}/v1/analyze",
"method": "POST",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "prompt",
"value": "You are an AI music analytics advisor. Generate a concise, insightful daily digest for this creator. Data: {{ JSON.stringify($json) }}. Include: top performing track, growth trend, 1 actionable recommendation, and a motivating observation. Keep it under 200 words."
},
{
"name": "data",
"value": "={{ $json }}"
}
]
}
},
"name": "ThinkZone API: AI Insights",
"type": "n8n-nodes-base.httpRequest",
"position": [
1000,
300
],
"id": "node-ai-insights"
},
{
"parameters": {
"operation": "executeQuery",
"query": "SELECT email FROM creator_profiles WHERE id = '{{ $json.creator_id }}'"
},
"name": "Neon: Get Creator Email",
"type": "n8n-nodes-base.postgres",
"position": [
1250,
300
],
"id": "node-get-email"
},
{
"parameters": {
"url": "={{ $env.BRAIN_URL }}/events/core",
"method": "POST",
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "event",
"value": "creator.daily_digest"
},
{
"name": "payload",
"value": "={{ { creator_id: $json.creator_id, email: $json.email, stats: $json.stats, ai_insight: $json.ai_insight } }}"
}
]
}
},
"name": "Brain: Emit Digest",
"type": "n8n-nodes-base.httpRequest",
"position": [
1500,
300
],
"id": "node-emit"
}
],
"connections": {
"Cron: Daily 8am": {
"main": [
[
{
"node": "Neon: Yesterday's Stats",
"type": "main",
"index": 0
}
]
]
},
"Neon: Yesterday's Stats": {
"main": [
[
{
"node": "Split by Creator",
"type": "main",
"index": 0
}
]
]
},
"Split by Creator": {
"main": [
[
{
"node": "ThinkZone API: AI Insights",
"type": "main",
"index": 0
}
]
]
},
"ThinkZone API: AI Insights": {
"main": [
[
{
"node": "Neon: Get Creator Email",
"type": "main",
"index": 0
}
]
]
},
"Neon: Get Creator Email": {
"main": [
[
{
"node": "Brain: Emit Digest",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
},
"tags": [
"disco-bass",
"analytics",
"creator"
]
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
04 - Creator Analytics Daily Digest. Uses postgres, httpRequest. Scheduled trigger; 6 nodes.
Source: https://github.com/think-zone/creator-os/blob/main/n8n-workflows/04-creator-analytics-digest.json — 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.
Disparador 1.8. Uses itemLists, postgres, emailSend, httpRequest. Scheduled trigger; 85 nodes.
공유회_알림톡_크론. Uses postgres, httpRequest, n8n-nodes-solapi. Scheduled trigger; 39 nodes.
QuepasaAutomatic. Uses postgres, postgresTrigger, httpRequest. Scheduled trigger; 39 nodes.
QuepasaAutomatic. Uses postgres, postgresTrigger, httpRequest. Scheduled trigger; 39 nodes.
QuepasaAutomatic. Uses postgres, postgresTrigger, httpRequest. Scheduled trigger; 39 nodes.