Usar Gemini Pro para generar ideas de contenido y almacenarlas en Google Sheets

• •Clave de API de servicio de IA (como OpenAI, Anthropic, etc.)

{
  "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": "Entrada Manual",
      "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": "Generar Ideas (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": "Formatear Ideas",
      "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": "Escribir en 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
}