Verwendung von Gemini Pro zur Ideenentwicklung und Speicherung in Google Sheets

• •KI-Service API Key (z.B. 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": "Manuelle Eingabe",
      "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": "Ideen generieren (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": "Ideen formatieren",
      "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": "In Google Sheet schreiben",
      "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
}