Gemini Proを使用してコンテンツのアイデアを生成し、Google スプレッドシートに保存

• •AIサービスAPIキー（OpenAI、Anthropicなど）

{
  "id": "content-idea-generator",
  "name": "Generate Content Ideas with Gemini Pro and Store in Google Sheets",
  "tags": [
    "marketing",
    "ai",
    "content-creation",
    "google-sheets",
    "beginner"
  ],
  "nodes": [
    {
      "id": "manual-input",
      "name": "手動入力",
      "type": "n8n-nodes-base.manualInput",
      "position": [
        200,
        200
      ],
      "parameters": {
        "description": "Manually input the topic or keyword for which you want to generate content ideas. Add a field named 'topic' in the JSON input (e.g., {\"topic\": \"your desired topic\"})."
      },
      "typeVersion": 1
    },
    {
      "id": "google-ai",
      "name": "アイデア生成 (Google AI)",
      "type": "n8n-nodes-base.google-ai",
      "position": [
        450,
        200
      ],
      "parameters": {
        "model": "gemini-pro",
        "prompt": "Generate 5 content ideas related to the topic: {{ $json.topic }}. Please format each idea as a short sentence or title.",
        "operation": "generateContent",
        "description": "Uses the Google AI model (Gemini Pro) to generate content ideas based on the provided topic from the 'Manual Input' node. Requires Google AI credentials to be set up in n8n.",
        "additionalParameters": {}
      },
      "credentials": {
        "googleAiApi": "YOUR_GOOGLE_AI_CREDENTIALS"
      },
      "typeVersion": 1
    },
    {
      "id": "format-ideas",
      "name": "アイデアのフォーマット",
      "type": "n8n-nodes-base.function",
      "position": [
        700,
        200
      ],
      "parameters": {
        "jsCode": "return items.map(item => {\n  const ideas = item.json.candidates[0].content.parts[0].text.split('\\n').filter(idea => idea.trim() !== '');\n  return ideas.map(idea => ({ json: { idea: idea.trim() } }));\n}).flat();",
        "description": "Processes the raw text output from the 'Generate Ideas (Google AI)' node. It splits the generated ideas (expected to be newline-separated) into individual items, making them ready to be written as separate rows in Google Sheets."
      },
      "typeVersion": 1
    },
    {
      "id": "google-sheets",
      "name": "Google Sheetへの書き込み",
      "type": "n8n-nodes-base.google-sheets",
      "position": [
        950,
        200
      ],
      "parameters": {
        "range": "Sheet1!A:A",
        "values": "={{ $json.idea }}",
        "options": {},
        "operation": "append",
        "description": "Appends each formatted content idea (from the 'Format Ideas' node) as a new row to the specified Google Sheet. Remember to replace 'YOUR_GOOGLE_SHEET_ID' with your actual Google Sheet ID and connect your Google Sheets OAuth2 credentials.",
        "spreadsheetId": "YOUR_GOOGLE_SHEET_ID"
      },
      "credentials": {
        "googleSheetsOAuth2Api": "YOUR_GOOGLE_SHEETS_CREDENTIALS"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "events": {},
  "folder": null,
  "pinData": {},
  "settings": {},
  "timeZone": "Europe/Berlin",
  "createdAt": "2025-05-27T00:00:00.000Z",
  "updatedAt": "2025-05-27T00:00:00.000Z",
  "versionId": null,
  "staticData": null,
  "connections": {
    "google-ai": {
      "main": [
        [
          {
            "node": "format-ideas",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "format-ideas": {
      "main": [
        [
          {
            "node": "google-sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "manual-input": {
      "main": [
        [
          {
            "node": "google-ai",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "description": "A beginner-friendly marketing workflow that uses AI (Google AI) to generate content ideas based on a given topic and then saves these ideas into a Google Sheet for easy organization and planning. This n8n workflow template uses community nodes and is only compatible with the self-hosted version of n8n.",
  "triggerCount": 0
}