使用 Gemini Pro 生成内容创意并存储到 Google Sheets

• •AI 服务 API Key（如 OpenAI、Anthropic 等）

{
  "id": "content-idea-generator",
  "name": "使用 Gemini Pro 生成内容创意并存储到 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": "手动输入您想要生成内容创意的主题或关键词。在 JSON 输入中添加一个名为 'topic' 的字段（例如：{\"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": "使用 Google AI 模型 (Gemini Pro) 根据 '手动输入' 节点提供的主题生成内容创意。需要在 n8n 中设置 Google AI 凭据。",
        "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": "处理 '生成创意 (Google AI)' 节点的原始文本输出。它将生成的创意（预期为换行分隔）拆分为单独的项目，使其准备好作为单独行写入 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": "将每个格式化的内容创意（来自 '格式化创意' 节点）作为新行追加到指定的 Google Sheet。请记得将 'YOUR_GOOGLE_SHEET_ID' 替换为您实际的 Google Sheet ID，并连接您的 Google Sheets OAuth2 凭据。",
        "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
}