AutomationFlowsAI & RAG › Founder Daily Brief Generation

Founder Daily Brief Generation

Founder Daily Brief Generation. Uses httpRequest, anthropic, sendGrid. Scheduled trigger; 9 nodes.

Cron / scheduled trigger★★★☆☆ complexityAI-powered9 nodesHTTP RequestAnthropicSendGrid
AI & RAG Trigger: Cron / scheduled Nodes: 9 Complexity: ★★★☆☆ AI nodes: yes Added:

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 →

Download .json
{
  "name": "Founder Daily Brief Generation",
  "nodes": [
    {
      "parameters": {
        "triggerTimes": [
          "08:00"
        ],
        "timezone": "America/New_York"
      },
      "id": "node_schedule_trigger",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1,
      "position": [
        100,
        100
      ]
    },
    {
      "parameters": {
        "method": "GET",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/task_queue?status=eq.PENDING&limit=50",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "id": "node_read_tasks",
      "name": "Read Pending Tasks",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        300,
        100
      ]
    },
    {
      "parameters": {
        "method": "GET",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/approval_requests?status=eq.PENDING_FOUNDER&limit=50",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "id": "node_read_approvals",
      "name": "Read Pending Approvals",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        500,
        100
      ]
    },
    {
      "parameters": {
        "method": "GET",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/deployment_monitor?order=created_at.desc&limit=20",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "id": "node_read_deployment",
      "name": "Read Deployment Status",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        700,
        100
      ]
    },
    {
      "parameters": {
        "method": "GET",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/lead_intelligence_log?order=received_at.desc&limit=50",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        }
      },
      "id": "node_read_leads",
      "name": "Read Lead Intelligence",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        900,
        100
      ]
    },
    {
      "parameters": {
        "resource": "message",
        "model": "claude-3-5-sonnet-20241022",
        "messages": {
          "values": [
            {
              "content": "Generate a concise executive brief for Prateek Gehlot based on this data:\n\nPending Tasks: {{ JSON.stringify($input.first().body) }}\n\nPending Approvals: {{ JSON.stringify($('node_read_approvals').first().body) }}\n\nDeployment Status: {{ JSON.stringify($('node_read_deployment').first().body) }}\n\nRecent Leads: {{ JSON.stringify($('node_read_leads').first().body) }}\n\nProvide:\n1. Summary of pending decisions (approvals)\n2. Critical tasks needing attention\n3. System health status\n4. Pipeline highlights\n\nKeep it under 500 words. Tone: Strategic, data-driven.",
              "role": "user"
            }
          ]
        }
      },
      "id": "node_claude_brief",
      "name": "Claude - Generate Brief",
      "type": "n8n-nodes-base.anthropic",
      "typeVersion": 1,
      "position": [
        1100,
        100
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/founder_daily_briefs",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        },
        "requestFormat": "json",
        "jsonParameters": {
          "parameters": [
            {
              "name": "brief_date",
              "value": "={{ new Date().toISOString().split('T')[0] }}"
            },
            {
              "name": "brief_content",
              "value": "={{ $input.first().message.content }}"
            },
            {
              "name": "pending_tasks_count",
              "value": "={{ Array.isArray($('node_read_tasks').first().body) ? $('node_read_tasks').first().body.length : 0 }}"
            },
            {
              "name": "pending_approvals_count",
              "value": "={{ Array.isArray($('node_read_approvals').first().body) ? $('node_read_approvals').first().body.length : 0 }}"
            },
            {
              "name": "status",
              "value": "GENERATED"
            }
          ]
        }
      },
      "id": "node_save_brief",
      "name": "Save Brief to Database",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        1300,
        100
      ]
    },
    {
      "parameters": {
        "fromEmail": "noreply@titancrestre.ae",
        "toEmail": "{{ $env.FOUNDER_EMAIL }}",
        "subject": "Daily Brief - {{ new Date().toLocaleDateString() }}",
        "emailType": "html",
        "htmlBody": "<h2>Founder Daily Brief</h2><p>{{ $input.first().message.content }}</p><p>---</p><p>This brief was generated by TITAN OS at {{ new Date().toISOString() }}</p>"
      },
      "id": "node_send_email_disabled",
      "name": "Send Email (DISABLED)",
      "type": "n8n-nodes-base.sendGrid",
      "typeVersion": 1,
      "position": [
        1500,
        100
      ],
      "disabled": true
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://maqqjchekovcgtbzrbrv.supabase.co/rest/v1/execution_logs",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpHeaderAuth",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Authorization",
              "value": "Bearer {{ $env.SUPABASE_SERVICE_ROLE_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        },
        "requestFormat": "json",
        "jsonParameters": {
          "parameters": [
            {
              "name": "workflow_name",
              "value": "Founder Daily Brief Generation"
            },
            {
              "name": "workflow_run_id",
              "value": "={{ $execution.id }}"
            },
            {
              "name": "status",
              "value": "COMPLETED"
            },
            {
              "name": "action_log",
              "value": "Daily brief generated and saved to database. Tasks={{ Array.isArray($('node_read_tasks').first().body) ? $('node_read_tasks').first().body.length : 0 }}, Approvals={{ Array.isArray($('node_read_approvals').first().body) ? $('node_read_approvals').first().body.length : 0 }}"
            },
            {
              "name": "execution_timestamp",
              "value": "={{ new Date().toISOString() }}"
            }
          ]
        }
      },
      "id": "node_audit_log",
      "name": "Write Audit Log",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4,
      "position": [
        1700,
        100
      ]
    }
  ],
  "connections": {
    "node_schedule_trigger": {
      "main": [
        [
          {
            "node": "node_read_tasks",
            "branch": 0
          }
        ]
      ]
    },
    "node_read_tasks": {
      "main": [
        [
          {
            "node": "node_read_approvals",
            "branch": 0
          }
        ]
      ]
    },
    "node_read_approvals": {
      "main": [
        [
          {
            "node": "node_read_deployment",
            "branch": 0
          }
        ]
      ]
    },
    "node_read_deployment": {
      "main": [
        [
          {
            "node": "node_read_leads",
            "branch": 0
          }
        ]
      ]
    },
    "node_read_leads": {
      "main": [
        [
          {
            "node": "node_claude_brief",
            "branch": 0
          }
        ]
      ]
    },
    "node_claude_brief": {
      "main": [
        [
          {
            "node": "node_save_brief",
            "branch": 0
          }
        ]
      ]
    },
    "node_save_brief": {
      "main": [
        [
          {
            "node": "node_send_email_disabled",
            "branch": 0
          }
        ]
      ]
    },
    "node_send_email_disabled": {
      "main": [
        [
          {
            "node": "node_audit_log",
            "branch": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Founder Daily Brief Generation. Uses httpRequest, anthropic, sendGrid. Scheduled trigger; 9 nodes.

Source: https://gist.github.com/prateekgehlot09/37341cecd133286bbbc84ec6be171b90 — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

Automatically publish Lightroom photos to Instagram with short, human-sounding AI captions. This workflow pulls the next item from your Data Table queue, generates an on-brand caption from alt text +

Data Table, Anthropic, HTTP Request
AI & RAG

Slack Channel Daily Digest (Multi-Provider LLM). Uses stickyNote, scheduleTrigger, httpRequest, openAi. Scheduled trigger; 14 nodes.

HTTP Request, OpenAI, Anthropic
AI & RAG

Create a reusable “photos to post” queue from your Lightroom Cloud album—ideal for Lightroom-to-Instagram automation with n8n. It discovers new photos, stores clean metadata in a Data Table, and gener

HTTP Request, Anthropic, Data Table
AI & RAG

06 - AEO Citation Monitor (4 LLMs). Uses googleSheets, anthropic, httpRequest, slack. Scheduled trigger; 11 nodes.

Google Sheets, Anthropic, HTTP Request +1
AI & RAG

资讯转视频自动化. Uses anthropic, httpRequest, executeCommand. Scheduled trigger; 10 nodes.

Anthropic, HTTP Request, Execute Command