Générez des idées de contenu avec Gemini Pro et stockez-les dans Google Sheets

• •Clé API de service IA (comme 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": "Saisie manuelle",
      "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": "Générer des idées (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": "Formater les idées",
      "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": "Écrire dans 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
}