Flownine - Auto Blog Post

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": "Flownine - Auto Blog Post",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "hours",
              "hoursInterval": 24,
              "triggerAtHour": 8
            }
          ]
        }
      },
      "id": "schedule-trigger",
      "name": "Executar Diariamente",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.2,
      "position": [
        250,
        300
      ]
    },
    {
      "parameters": {
        "url": "https://newsapi.org/v2/top-headlines",
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "category",
              "value": "technology"
            },
            {
              "name": "language",
              "value": "pt"
            },
            {
              "name": "pageSize",
              "value": "5"
            },
            {
              "name": "apiKey",
              "value": "={{$credentials.newsApiKey}}"
            }
          ]
        },
        "options": {}
      },
      "id": "fetch-news",
      "name": "Buscar Not\u00edcias",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        450,
        300
      ],
      "notesInFlow": true,
      "notes": "Configure sua API key do NewsAPI ou substitua por outra fonte de dados"
    },
    {
      "parameters": {
        "resource": "chat",
        "model": "gpt-4o-mini",
        "messages": {
          "values": [
            {
              "content": "Voc\u00ea \u00e9 um redator especializado em tecnologia e intelig\u00eancia artificial. Crie um artigo de blog completo em portugu\u00eas brasileiro baseado nas not\u00edcias fornecidas.\n\nRetorne um JSON v\u00e1lido com exatamente esta estrutura:\n{\n  \"title\": \"T\u00edtulo atrativo do artigo (m\u00e1x 60 caracteres)\",\n  \"excerpt\": \"Resumo do artigo em 1-2 frases (m\u00e1x 160 caracteres)\",\n  \"content\": \"Conte\u00fado completo em Markdown com # para t\u00edtulos, ## para subt\u00edtulos, - para listas, **negrito**, etc.\",\n  \"category\": \"IA\",\n  \"tags\": [\"tag1\", \"tag2\", \"tag3\"],\n  \"cover_image\": \"URL de imagem do Unsplash relacionada ao tema\"\n}\n\nNot\u00edcias para basear o artigo:\n{{ $json.articles }}"
            }
          ]
        },
        "options": {
          "responseFormat": "json_object"
        }
      },
      "id": "openai-generate",
      "name": "Gerar Artigo com IA",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "typeVersion": 1.8,
      "position": [
        650,
        300
      ],
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "notesInFlow": true,
      "notes": "Configure suas credenciais da OpenAI"
    },
    {
      "parameters": {
        "method": "POST",
        "url": "https://gjgfevzzonppzxftaxgh.supabase.co/functions/v1/create-blog-post",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "Content-Type",
              "value": "application/json"
            },
            {
              "name": "Authorization",
              "value": "<redacted-credential>"
            }
          ]
        },
        "sendBody": true,
        "specifyBody": "json",
        "jsonBody": "={\n  \"title\": {{ $json.message.content.title }},\n  \"excerpt\": {{ $json.message.content.excerpt }},\n  \"content\": {{ $json.message.content.content }},\n  \"category\": {{ $json.message.content.category || \"IA\" }},\n  \"tags\": {{ $json.message.content.tags || [] }},\n  \"cover_image\": {{ $json.message.content.cover_image || null }},\n  \"published\": true\n}",
        "options": {}
      },
      "id": "create-blog-post",
      "name": "Criar Post no Blog",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.2,
      "position": [
        850,
        300
      ],
      "notesInFlow": true,
      "notes": "Envia o artigo gerado para a Edge Function do Supabase"
    }
  ],
  "connections": {
    "Executar Diariamente": {
      "main": [
        [
          {
            "node": "Buscar Not\u00edcias",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Buscar Not\u00edcias": {
      "main": [
        [
          {
            "node": "Gerar Artigo com IA",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Gerar Artigo com IA": {
      "main": [
        [
          {
            "node": "Criar Post no Blog",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "1",
  "tags": [
    {
      "name": "blog",
      "createdAt": "2025-01-22T00:00:00.000Z",
      "updatedAt": "2025-01-22T00:00:00.000Z"
    },
    {
      "name": "automa\u00e7\u00e3o",
      "createdAt": "2025-01-22T00:00:00.000Z",
      "updatedAt": "2025-01-22T00:00:00.000Z"
    }
  ]
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• openAiApi

About this workflow

Flownine - Auto Blog Post. Uses httpRequest, openAi. Scheduled trigger; 4 nodes.

Source: https://github.com/tecdsantana/automato-web-persuasion/blob/27c746ca1d09720b83a06ae794395d3bd3d87b4a/docs/n8n-blog-workflow.json — 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.