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 (11 AM)",
"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\nconst peopleType = Math.random() < 0.5 ? 'solo' : (Math.random() < 0.75 ? 'couple' : 'group');\n\nreturn {product: selectedProduct, peopleType: peopleType};"
},
"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": {
"tableId": "newsletters"
},
"id": "saveNews",
"name": "Save Newsletter",
"type": "n8n-nodes-base.supabase",
"typeVersion": 1,
"position": [
1250,
300
]
},
{
"parameters": {
"tableId": "daily_quotes"
},
"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 (11 AM)": {
"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. Event-driven trigger; 4 nodes.
Source: https://github.com/SandMan-SM/imperium/blob/200983380033d8a9e209ca41b61105425979e950/automations/n8n-newsletter-fixed.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.
Imperium - Daily Newsletter. Uses n8n-nodes-base manualTrigger, supabase, httpRequest, telegram. Event-driven trigger; 4 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
[HUB] Жора Action. Uses executeWorkflowTrigger, supabase, telegram, httpRequest. Event-driven trigger; 19 nodes.
Telegram-auth. Uses telegramTrigger, telegram, supabase, httpRequest. Event-driven trigger; 18 nodes.
Http Telegram. Uses telegramTrigger, httpRequest, supabase, telegram. Event-driven trigger; 17 nodes.