AutomationFlowsAI & RAG › AI-Powered Notion Report Generator

AI-Powered Notion Report Generator

Original n8n title: Awesome N8n Templates (notion)

Awesome N8N Templates. Uses notion, lmChatOpenAi, outputParserStructured, chainLlm. Event-driven trigger; 36 nodes.

Event trigger★★★★★ complexityAI-powered36 nodesNotionOpenAI ChatOutput Parser StructuredChain LlmCryptoHTTP RequestAgentLm Chat Google Vertex
AI & RAG Trigger: Event Nodes: 36 Complexity: ★★★★★ AI nodes: yes Added:

This workflow follows the Agent → Chainllm 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 →

Download .json
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "e1716e31-c9e1-4888-adf8-1346461f7c70",
      "name": "Set Done",
      "type": "n8n-nodes-base.notion",
      "position": [
        3024,
        768
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2.2
    },
    {
      "id": "805e7523-e73e-448c-b1d8-9cf3a0410f03",
      "name": "OpenAI Chat Model4",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -240,
        1136
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "011d8674-ad72-40bc-be7e-6aa97a9d8523",
      "name": "Structured Output Parser4",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        -96,
        1136
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "143afddb-a90f-4d70-9def-0d3ef399234b",
      "name": "Create Row",
      "type": "n8n-nodes-base.notion",
      "position": [
        112,
        912
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "35808a02-dd5c-4c20-a5be-a2027bf74bf1",
      "name": "Report Page Generator",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -240,
        912
      ],
      "parameters": {},
      "typeVersion": 1.5
    },
    {
      "id": "691e8cd7-b85b-4ac0-b5d2-3f1a1ed397bb",
      "name": "Get Existing Row",
      "type": "n8n-nodes-base.notion",
      "position": [
        336,
        912
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "4fcb71bb-a65f-44e1-b8d7-832cc33c63cd",
      "name": "Generate Request ID",
      "type": "n8n-nodes-base.crypto",
      "position": [
        -448,
        912
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "da875116-f165-404a-99e5-e4e956ba920a",
      "name": "Content Analyzer LLM",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        544,
        1136
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "be7d0447-6477-418d-b3a1-94897723dbd5",
      "name": "Content Analysis Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        672,
        1136
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "941172d0-e0c4-4a9a-ad2b-369c1c1787b3",
      "name": "Structure Generator LLM",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        896,
        1136
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "8f6b8029-8351-4979-bb7b-cd773f1c5d70",
      "name": "Structure Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        1024,
        1136
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "ee401edd-eabd-4037-82ba-42674a80bd2a",
      "name": "Database Structure Generator",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        896,
        912
      ],
      "parameters": {},
      "typeVersion": 1.5
    },
    {
      "id": "9a2e2308-d090-499f-8f76-c74358afc84f",
      "name": "Create Sample Pages",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        3024,
        960
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "739a2590-22bb-472a-9893-9fab0c70b2e3",
      "name": "LLM Smart Mapping",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        2112,
        1136
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "19d70272-1e05-4ef9-8941-e0cd4b1bb7a6",
      "name": "Parse LLM Response",
      "type": "n8n-nodes-base.code",
      "position": [
        2384,
        912
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "5a1892f5-9de0-4e38-9c73-528f937985ab",
      "name": "AI Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1952,
        912
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "ad18c9db-ea38-49f6-a6f5-4af1f43f8957",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2800,
        912
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "b3a5c5a4-2973-47f9-b23c-da812627ee87",
      "name": "Split Out",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        2592,
        912
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "685ce899-2f61-4819-b4f7-4108f1453059",
      "name": "Google Vertex Chat Model2",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleVertex",
      "position": [
        1984,
        1136
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e59af55e-a89a-48e3-ad95-3d2088b4c341",
      "name": "Data Formatter2",
      "type": "n8n-nodes-base.set",
      "position": [
        1280,
        912
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "f9ec1602-616d-48da-b88d-6fe7621a2780",
      "name": "Prepare Notion Data1",
      "type": "n8n-nodes-base.code",
      "position": [
        1504,
        912
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "760d7440-a13a-48af-824a-74612f78b2ab",
      "name": "Create Notion Database4",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1728,
        912
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "1c4c05d5-2777-411c-9695-b74f83313e88",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        -672,
        912
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "8e40a68c-29a6-4614-9f9a-e57c52774391",
      "name": "Content Analyzer",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        544,
        912
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "559531a8-0ed0-41be-a789-046c6f230633",
      "name": "Google Drive Trigger",
      "type": "n8n-nodes-base.googleDriveTrigger",
      "position": [
        -1568,
        912
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a5e08e62-d63c-403d-9688-6548a8426cbb",
      "name": "Analyze image",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        -896,
        800
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2d059c82-8476-4f39-bfbc-7c2eb867da5e",
      "name": "Download file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -1344,
        912
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "9442d9ea-3b66-486c-b4ae-ae7ea40be58a",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        -1120,
        912
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "568c4f31-a171-43bb-b83c-349787688ac2",
      "name": "Transcribe a recording",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        -896,
        1024
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "95b09f9d-01f4-4179-a244-ca6ed006c9d5",
      "name": "Setup Instructions",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2128,
        592
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fc187102-ae7d-4d5b-b53e-af6efa55e971",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1600,
        592
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a49935ad-17f9-417c-b61f-56a0431d5e4c",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1152,
        592
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "2c7c682a-d3bf-4da1-9c74-7c30a3075568",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -496,
        592
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6a63debe-b904-4c8b-9b5d-2cbe53d9cba8",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        512,
        592
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7810c1f7-2761-4c6c-a5bf-4dfe054adc46",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1216,
        592
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0d69c65e-e773-481e-b048-3211346227b3",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2336,
        592
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Analyze image",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Transcribe a recording",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Agent": {
      "main": [
        [
          {
            "node": "Parse LLM Response",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Row": {
      "main": [
        [
          {
            "node": "Get Existing Row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Generate Request ID",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Analyze image": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download file": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Data Formatter2": {
      "main": [
        [
          {
            "node": "Prepare Notion Data1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Set Done",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Create Sample Pages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Content Analyzer": {
      "main": [
        [
          {
            "node": "Database Structure Generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Existing Row": {
      "main": [
        [
          {
            "node": "Content Analyzer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structure Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Database Structure Generator",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "LLM Smart Mapping": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 1
          }
        ]
      ]
    },
    "OpenAI Chat Model4": {
      "ai_languageModel": [
        [
          {
            "node": "Report Page Generator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Parse LLM Response": {
      "main": [
        [
          {
            "node": "Split Out",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Sample Pages": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Request ID": {
      "main": [
        [
          {
            "node": "Report Page Generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Content Analyzer LLM": {
      "ai_languageModel": [
        [
          {
            "node": "Content Analyzer",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Google Drive Trigger": {
      "main": [
        [
          {
            "node": "Download file",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prepare Notion Data1": {
      "main": [
        [
          {
            "node": "Create Notion Database4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Report Page Generator": {
      "main": [
        [
          {
            "node": "Create Row",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Transcribe a recording": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Content Analysis Parser": {
      "ai_outputParser": [
        [
          {
            "node": "Content Analyzer",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Create Notion Database4": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structure Generator LLM": {
      "ai_languageModel": [
        [
          {
            "node": "Database Structure Generator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Google Vertex Chat Model2": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser4": {
      "ai_outputParser": [
        [
          {
            "node": "Report Page Generator",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Database Structure Generator": {
      "main": [
        [
          {
            "node": "Data Formatter2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

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

How this works

This workflow harnesses AI to automate the creation and management of Notion templates, saving you hours of manual organisation by generating structured content and reports on demand. It's ideal for content creators, project managers, or teams relying on Notion for knowledge bases who want intelligent, event-driven updates without constant oversight. The key step involves an OpenAI-powered chain that analyses inputs, parses outputs into Notion-compatible formats, and populates databases seamlessly, ensuring your templates stay dynamic and up-to-date.

Use this workflow when you need to trigger template generation from events like new ideas or data inputs, streamlining repetitive Notion tasks with AI precision. Avoid it for simple data syncs without AI needs, as the 36-node complexity suits advanced automation rather than basic integrations. Common variations include swapping OpenAI for other LLM providers or adding HTTP requests for external data feeds to customise template sourcing.

About this workflow

Awesome N8N Templates. Uses notion, lmChatOpenAi, outputParserStructured, chainLlm. Event-driven trigger; 36 nodes.

Source: https://github.com/ScraperNode/awesome-n8n-templates/blob/main/templates/ai-and-llm/7972-create-structured-notion-workspaces-from-notes-voice-using-gemini-gpt/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.

AI & RAG

The best content automation template in the market is now even better—with “deep research” on time-sensitive topics\! Unlike most n8n content automation templates that are mainly for “demo purposes,”

OpenAI, HTTP Request, XML +11
AI & RAG

Who is this for? Agencies, consultants, and service providers who conduct discovery calls and need to quickly turn conversations into professional proposals.

Tool Think, Tool Calculator, Agent Tool +18
AI & RAG

This comprehensive n8n workflow automates the entire Meta (Facebook/Instagram) advertising process, from asset analysis to ad creation. It combines AI-powered content analysis with automated ad deploy

Facebook Graph Api, HTTP Request, Google Drive +5
AI & RAG

Transcript Evalu8r V2 is a robust browser-based transcript analysis tool powered by Deepgram’s speech-to-text API and built into an n8n workflow template. This release introduces full in-browser audio

Google Drive Trigger, HTTP Request, Agent +5
AI & RAG

Transcript Evalu8r is an AI-powered transcript analysis workflow that automates the processing, visualization, and evaluation of transcribed conversations. This n8n workflow template is designed to he

Google Drive Trigger, HTTP Request, Agent +5