{
  "name": "Generate content ideas with Gemini Pro and store in Google Sheets",
  "nodes": [
    {
      "id": "09c0ca0d-d7d1-4fbf-a24a-4e42d7dc90f5",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -540,
        -40
      ]
    },
    {
      "id": "841332db-96ec-4892-a253-5de4194aa8e0",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -540,
        -380
      ],
      "parameters": {
        "width": 540,
        "height": 280,
        "content": "## Workflow Setup\n\n**Credentials:** Configure your Google AI and Google Sheets credentials in n8n.\n\n**Google Sheets:** Create a new Google Sheet or use an existing one. Note down the Spreadsheet ID (f"
      }
    },
    {
      "id": "d1ac37c4-554b-4d72-9f55-f922a2aeccee",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        480,
        -40
      ]
    },
    {
      "id": "dbc70763-d6a2-4ca0-b146-32dd1c896fa5",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        280,
        -40
      ]
    },
    {
      "id": "3001a6ba-6ce0-4eb8-b690-91a691c5542a",
      "name": "LLM Content Generator",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        960,
        -20
      ]
    },
    {
      "id": "8f0b5c9d-81d8-49cd-80ff-cbb73742af49",
      "name": "Google Gemini Chat Model for Content Generation",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        1060,
        140
      ]
    },
    {
      "id": "b1661b78-752d-47c6-bb8d-87de862c12ed",
      "name": "Structured Output Parser for Content Idea Generator",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        80,
        140
      ]
    },
    {
      "id": "52f76748-1eac-406b-bacd-f27a65a69665",
      "name": "Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1340,
        -20
      ]
    },
    {
      "id": "c6f1cf1b-89f7-4796-bb20-d8d0a6751a0e",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        60,
        -380
      ],
      "parameters": {
        "width": 540,
        "height": 280,
        "content": "## Google Sheet\n\nMake sure to have the following column names on your google sheet.\n\n1. title\n2. description\n3. content"
      }
    },
    {
      "id": "c339eb0f-4978-46b0-a63d-492b7b69a731",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        660,
        -380
      ],
      "parameters": {
        "width": 440,
        "height": 240,
        "content": "## LLM Usages\n\nGoogle Gemini LLM is being utilized for the structured data extraction handling."
      }
    },
    {
      "id": "8f8e28b1-3466-48aa-afab-2f0f4f071ddf",
      "name": "Set the title & description",
      "type": "n8n-nodes-base.set",
      "position": [
        700,
        -20
      ]
    },
    {
      "id": "ef4b937f-9d16-4747-b863-6b75d79e2319",
      "name": "Set the input fields",
      "type": "n8n-nodes-base.set",
      "position": [
        -320,
        -40
      ]
    },
    {
      "id": "4ed4561e-915d-4ebe-aff6-2cb16720a02e",
      "name": "Content Idea Generator",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        -100,
        -40
      ]
    },
    {
      "id": "f48de4f1-c46f-4134-afed-e3fcf552f79c",
      "name": "Google Gemini Chat Model for Content Idea Generator",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        -100,
        140
      ]
    }
  ],
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Set the title & description",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set the input fields": {
      "main": [
        [
          {
            "node": "Content Idea Generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "LLM Content Generator": {
      "main": [
        [
          {
            "node": "Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Content Idea Generator": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set the title & description": {
      "main": [
        [
          {
            "node": "LLM Content Generator",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Set the input fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model for Content Generation": {
      "ai_languageModel": [
        [
          {
            "node": "LLM Content Generator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Google Gemini Chat Model for Content Idea Generator": {
      "ai_languageModel": [
        [
          {
            "node": "Content Idea Generator",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser for Content Idea Generator": {
      "ai_outputParser": [
        [
          {
            "node": "Content Idea Generator",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    }
  }
}