{
  "name": "Scrape, structure, and store news data using Decodo, Gemini AI and Google Sheets",
  "nodes": [
    {
      "id": "a221efb8-cc52-4307-a283-a5feb82e16ed",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        960,
        384
      ]
    },
    {
      "id": "32df9c8e-e19e-4ed5-a32c-7a72e2138531",
      "name": "Split Forums",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1408,
        384
      ]
    },
    {
      "id": "50452a8d-e10e-4d8e-bdf3-e31718084c6f",
      "name": "Iterate Forums",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1632,
        384
      ]
    },
    {
      "id": "16f66f13-eeec-43c3-930e-e1e2c45293ab",
      "name": "Google Gemini Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        2096,
        480
      ]
    },
    {
      "id": "61e2f466-dbd5-4e0b-84a4-811bf4ac80d1",
      "name": "Extract Structured News Data",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        2080,
        256
      ]
    },
    {
      "id": "f895a2a7-ead3-4fea-b5de-a65abd5d747f",
      "name": "Parse JSON Output",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        2224,
        480
      ]
    },
    {
      "id": "2729e432-f311-4987-803e-195c87beda3e",
      "name": "Split News Items",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        2432,
        112
      ]
    },
    {
      "id": "2f5c6ed4-0a4f-47d7-8c99-5380251165cf",
      "name": "Generate Unique Key",
      "type": "n8n-nodes-base.crypto",
      "position": [
        2656,
        112
      ]
    },
    {
      "id": "3db0bc16-f718-4086-a310-0c386b792ae2",
      "name": "Wait Between Scrapes",
      "type": "n8n-nodes-base.wait",
      "position": [
        2656,
        480
      ]
    },
    {
      "id": "426b16cc-72fb-47be-91a2-76059472d81d",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 864,
        "height": 848,
        "content": "![Waha Johan](https://drive.google.com/thumbnail?id=1SHtHQ7h1pflq_L_obGfBK29wGUY16-Vg&sz=w2000)\n## AI-Powered News Scraper using Decodo and Gemini AI\n\nSign up for Decodo [HERE](https://visit.decodo.co"
      }
    },
    {
      "id": "d7080fb7-a9c5-488b-96b7-6d0212840f14",
      "name": "Update Google Sheet (News)",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2880,
        112
      ]
    },
    {
      "id": "bb8bd038-ae46-41c2-b825-7c57062f840e",
      "name": "Workflow Config",
      "type": "n8n-nodes-base.set",
      "position": [
        1184,
        384
      ]
    },
    {
      "id": "647461db-0ac5-4e40-9cf4-e4efa25ef91e",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1136,
        288
      ],
      "parameters": {
        "width": 192,
        "height": 240,
        "content": "### Specify forum URLs, geolocation, and Sheet ID"
      }
    },
    {
      "id": "ce1e6d6f-6b4a-4ea4-8739-05851eed79dc",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2832,
        16
      ],
      "parameters": {
        "width": 192,
        "height": 272,
        "content": "### Ensure your sheet tab matches the column schema"
      }
    },
    {
      "id": "ec03d0bb-cad4-40cc-a9a9-a127e67daf71",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        912,
        288
      ],
      "parameters": {
        "width": 192,
        "height": 240,
        "content": "### Adjust schedule (e.g., every day at midnight)"
      }
    },
    {
      "id": "8e495053-ed4d-408a-92a9-49a0e26c6f17",
      "name": "Scrape Forum Data",
      "type": "@decodo/n8n-nodes-decodo.decodo",
      "position": [
        1856,
        256
      ]
    },
    {
      "id": "bff896ee-261c-4c98-91d9-805b2b94bf5c",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2384,
        256
      ],
      "parameters": {
        "width": 192,
        "height": 272,
        "content": "### Ensure your sheet tab matches the column schema"
      }
    },
    {
      "id": "58c57d13-dc9d-43e3-a5a6-816dbcb864e4",
      "name": "Log Scrape Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2432,
        352
      ]
    },
    {
      "id": "f4675599-f622-4d87-96a6-17e0e755853b",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1216,
        -544
      ],
      "parameters": {
        "width": 1008,
        "height": 592,
        "content": "@[youtube](mJJt2dDDOgw)\n"
      }
    }
  ],
  "connections": {
    "Split Forums": {
      "main": [
        [
          {
            "node": "Iterate Forums",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Iterate Forums": {
      "main": [
        [],
        [
          {
            "node": "Scrape Forum Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflow Config": {
      "main": [
        [
          {
            "node": "Split Forums",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Workflow Config",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split News Items": {
      "main": [
        [
          {
            "node": "Generate Unique Key",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Parse JSON Output": {
      "ai_outputParser": [
        [
          {
            "node": "Extract Structured News Data",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Scrape Forum Data": {
      "main": [
        [
          {
            "node": "Extract Structured News Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log Scrape Results": {
      "main": [
        [
          {
            "node": "Wait Between Scrapes",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Unique Key": {
      "main": [
        [
          {
            "node": "Update Google Sheet (News)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Model": {
      "ai_languageModel": [
        [
          {
            "node": "Extract Structured News Data",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Wait Between Scrapes": {
      "main": [
        [
          {
            "node": "Iterate Forums",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Structured News Data": {
      "main": [
        [
          {
            "node": "Split News Items",
            "type": "main",
            "index": 0
          },
          {
            "node": "Log Scrape Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}