This workflow follows the HTTP Request → Supabase 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": "Imperium - Daily Newsletter",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 24,
"triggerAtHour": 11
}
]
}
},
"id": "schedule",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1,
"position": [
250,
300
]
},
{
"parameters": {
"operation": "getAll",
"table": "products",
"filters": {
"where": [
{
"column": "in_stock",
"condition": "eq",
"value": true
}
]
},
"returnAll": true
},
"id": "getProducts",
"name": "Get Products",
"type": "n8n-nodes-base.supabase",
"typeVersion": 1,
"position": [
450,
300
]
},
{
"parameters": {
"functionCode": "const products = $input.first().json || [];\n\nlet selectedProduct = {name: \"Imperium Classic Tee\", category: \"shirts\", description: \"Premium cotton t-shirt\", price: 29.99};\n\nif (products.length > 0) {\n const randomIndex = Math.floor(Math.random() * products.length);\n selectedProduct = products[randomIndex];\n}\n\nreturn {product: selectedProduct};"
},
"id": "select",
"name": "Select Product",
"type": "n8n-nodes-base.function",
"typeVersion": 1,
"position": [
650,
300
]
},
{
"parameters": {
"url": "http://localhost:11434/api/generate",
"method": "POST",
"sendBody": true,
"body": "{\"model\": \"llama3.2\", \"prompt\": \"Write a short marketing post (2-3 sentences) about the Imperium product: {{$json.product.name}}. Make it sound premium and exclusive.\", \"stream\": false}",
"options": {}
},
"id": "newsletter",
"name": "Generate Newsletter",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4,
"position": [
850,
300
]
},
{
"parameters": {
"url": "http://localhost:11434/api/generate",
"method": "POST",
"sendBody": true,
"body": "{\"model\": \"llama3.2\", \"prompt\": \"Write a short motivational quote (max 15 words) about fashion and confidence.\", \"stream\": false}",
"options": {}
},
"id": "quote",
"name": "Generate Quote",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4,
"position": [
1050,
300
]
},
{
"parameters": {
"operation": "insert",
"table": "newsletters",
"columns": [
"title",
"content",
"published",
"created_at"
],
"schema": "public",
"returnAll": false
},
"id": "saveNews",
"name": "Save Newsletter",
"type": "n8n-nodes-base.supabase",
"typeVersion": 1,
"position": [
1250,
300
]
},
{
"parameters": {
"operation": "insert",
"table": "daily_quotes",
"columns": [
"quote",
"created_at"
],
"schema": "public",
"returnAll": false
},
"id": "saveQuote",
"name": "Save Quote",
"type": "n8n-nodes-base.supabase",
"typeVersion": 1,
"position": [
1450,
300
]
},
{
"parameters": {
"chat_id": "8459911167",
"text": "\ud83d\udcf8 *Imperium Daily Drop*\n\n{{$json.response}}\n\n\"{{$json.response}}\"\n\n\ud83e\udde0 [28 Principles](https://mywebsite.com/28principles) \u2022 \ud83d\udcf0 [Daily Post](https://mywebsite.com/newsletter)",
"reply_markup": {
"inline_keyboard": [
[
{
"text": "\ud83e\udde0 28 Principles",
"url": "https://mywebsite.com/28principles"
},
{
"text": "\ud83d\udcf0 Daily Post",
"url": "https://mywebsite.com/newsletter"
}
]
]
}
},
"id": "telegram",
"name": "Send Telegram",
"type": "n8n-nodes-base.telegram",
"typeVersion": 1.2,
"position": [
1650,
300
]
}
],
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "Get Products",
"type": "main",
"index": 0
}
]
]
},
"Get Products": {
"main": [
[
{
"node": "Select Product",
"type": "main",
"index": 0
}
]
]
},
"Select Product": {
"main": [
[
{
"node": "Generate Newsletter",
"type": "main",
"index": 0
}
]
]
},
"Generate Newsletter": {
"main": [
[
{
"node": "Generate Quote",
"type": "main",
"index": 0
}
]
]
},
"Generate Quote": {
"main": [
[
{
"node": "Save Newsletter",
"type": "main",
"index": 0
}
]
]
},
"Save Newsletter": {
"main": [
[
{
"node": "Save Quote",
"type": "main",
"index": 0
}
]
]
},
"Save Quote": {
"main": [
[
{
"node": "Send Telegram",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Imperium - Daily Newsletter. Uses supabase, httpRequest, telegram. Scheduled trigger; 8 nodes.
Source: https://github.com/SandMan-SM/imperium/blob/200983380033d8a9e209ca41b61105425979e950/automations/n8n-newsletter.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.
This n8n workflow monitors Donald Trump’s Truth Social posts and sends alerts to Telegram & Discord on auto-pilot. Stay instantly updated with every new post, repost, or reply without delays.
Imperium - Daily Newsletter (11 AM). Uses supabase, httpRequest, telegram. Scheduled trigger; 8 nodes.
Imperium - Daily Newsletter. Uses supabase, httpRequest, telegram. Scheduled trigger; 8 nodes.
This n8n workflow automates task management by integrating Trello, Supabase, and Telegram to streamline card creation, user assignment, and due date notifications. It ensures seamless synchronization
GNCA AI News Pipeline. Uses rssFeedRead, httpRequest, telegram, errorTrigger. Scheduled trigger; 29 nodes.