{
  "name": "Extract business leads from Reddit using GPT-4.1-mini analysis and Google Sheets",
  "nodes": [
    {
      "id": "b0a2f427-1788-4707-b2ca-07b7ba9878ab",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -2040,
        1040
      ]
    },
    {
      "id": "9bf6edaf-e2ad-4702-8730-0600775531cb",
      "name": "Post Summarization",
      "type": "@n8n/n8n-nodes-langchain.chainSummarization",
      "position": [
        20,
        680
      ]
    },
    {
      "id": "9541106a-af9c-4326-91b1-07f68c9ee386",
      "name": "Merge Input",
      "type": "n8n-nodes-base.merge",
      "position": [
        -720,
        980
      ]
    },
    {
      "id": "b0ad0465-0daa-48f6-a9c5-8dadca2ca4e1",
      "name": "Output The Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1140,
        820
      ]
    },
    {
      "id": "16c397ea-1625-43c6-8602-9150a79858a4",
      "name": "Merge 3 Inputs",
      "type": "n8n-nodes-base.merge",
      "position": [
        800,
        820
      ]
    },
    {
      "id": "f59b3a35-9502-4a69-8b18-6760538765ab",
      "name": "Filter Posts By Features",
      "type": "n8n-nodes-base.if",
      "position": [
        -1620,
        1040
      ]
    },
    {
      "id": "d88efb10-91cf-4ac0-9f7b-796bfa8a75ab",
      "name": "Filter Posts By Content",
      "type": "n8n-nodes-base.if",
      "position": [
        -460,
        980
      ]
    },
    {
      "id": "405f37a4-d3a8-4d92-8add-ad232be014b7",
      "name": "Select Key Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        -1380,
        1020
      ]
    },
    {
      "id": "6a6143e1-6181-45a0-988f-e8ed7e634bd8",
      "name": "Get Posts",
      "type": "n8n-nodes-base.reddit",
      "position": [
        -1820,
        1040
      ]
    },
    {
      "id": "1937b724-18a1-4b5b-8338-1752f478eccf",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2140,
        800
      ],
      "parameters": {
        "width": 880,
        "height": 440,
        "content": "# Data Extraction\n## Retrieves recent posts from specific Reddit community (subreddit)\n## Filters content by keywords and upvotes"
      }
    },
    {
      "id": "5d4a1df6-16a5-473e-b6b4-42e7966a5cd2",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1140,
        580
      ],
      "parameters": {
        "width": 820,
        "height": 660,
        "content": "# Transformation Step\n## Analyze using LLM (AI)\n## Filter for business opportunities"
      }
    },
    {
      "id": "399afd5a-ced1-447b-95de-a7191632d266",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -200,
        480
      ],
      "parameters": {
        "width": 1460,
        "height": 760,
        "content": "#Transformation 2nd Step + Load to Gsheet\n## Insight Generation \n## Generates executive summaries of key opportunities\n## Submit findings in Google Sheets"
      }
    },
    {
      "id": "571bf6e7-ef36-4a7d-9e9d-e97aef4e7015",
      "name": "OpenRouter Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        -1100,
        940
      ]
    },
    {
      "id": "7e157fc9-a7cd-42d4-80d5-233308a2441a",
      "name": "OpenRouter Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
      "position": [
        40,
        860
      ]
    },
    {
      "id": "9f2020d1-77f2-4dbc-b6ce-7dae7acd1263",
      "name": "Basic LLM Chain",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -1100,
        760
      ]
    },
    {
      "id": "b048b2f6-3c46-4ad2-8255-5b0509e9da0f",
      "name": "Edit Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        460,
        680
      ]
    },
    {
      "id": "924219fa-ae4d-44b3-a42d-e2c67dc85545",
      "name": "Edit Fields1",
      "type": "n8n-nodes-base.set",
      "position": [
        280,
        960
      ]
    }
  ],
  "connections": {
    "Get Posts": {
      "main": [
        [
          {
            "node": "Filter Posts By Features",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields": {
      "main": [
        [
          {
            "node": "Merge 3 Inputs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Input": {
      "main": [
        [
          {
            "node": "Filter Posts By Content",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields1": {
      "main": [
        [
          {
            "node": "Merge 3 Inputs",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Merge 3 Inputs": {
      "main": [
        [
          {
            "node": "Output The Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Basic LLM Chain": {
      "main": [
        [
          {
            "node": "Merge Input",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Select Key Fields": {
      "main": [
        [
          {
            "node": "Merge Input",
            "type": "main",
            "index": 1
          },
          {
            "node": "Basic LLM Chain",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Post Summarization": {
      "main": [
        [
          {
            "node": "Edit Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "OpenRouter Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Basic LLM Chain",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenRouter Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Post Summarization",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Filter Posts By Content": {
      "main": [
        [
          {
            "node": "Post Summarization",
            "type": "main",
            "index": 0
          },
          {
            "node": "Edit Fields1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Posts By Features": {
      "main": [
        [
          {
            "node": "Select Key Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Get Posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}