Modèle de flux de travail de conversion de mots-clés en article de blog
Ceci est unContent Creation, Multimodal AIworkflow d'automatisation du domainecontenant 23 nœuds.Utilise principalement des nœuds comme Code, Webhook, SplitOut, Aggregate, Wordpress. Automatisation de la création de contenu SEO avec Google SERP, Claude AI et WordPress
- •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
- •Clé API Anthropic
Nœuds utilisés (23)
Catégorie
{
"id": "cVycGSs6Kl1k4DvB",
"meta": {
"instanceId": "5acc1d4f8dd8b88bff7bef6ebd1e1357663357e2db96ad19039848081531bd44"
},
"name": "Keyword To Blog Post Automation Template",
"tags": [
{
"id": "7k0vNuUSUb76SZ0j",
"name": "Template",
"createdAt": "2025-07-14T19:46:04.274Z",
"updatedAt": "2025-07-14T19:46:04.274Z"
}
],
"nodes": [
{
"id": "2e9c1ed9-1b06-4a81-af44-0a97364480f9",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
580,
140
],
"webhookId": "208f9a1a-60ce-40d8-ac20-1909f0ac4257",
"parameters": {
"path": "208f9a1a-60ce-40d8-ac20-1909f0ac4257",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "9baf6433-5253-4b05-829e-ca20da37d003",
"name": "Note autocollante",
"type": "n8n-nodes-base.stickyNote",
"position": [
780,
0
],
"parameters": {
"color": 3,
"width": 340,
"height": 280,
"content": "## Item Extraction\nReceive content ideas through webhook and process each one"
},
"typeVersion": 1
},
{
"id": "c9e9048c-1b4b-4afe-9740-0698000f3e4c",
"name": "Diviser",
"type": "n8n-nodes-base.splitOut",
"position": [
900,
140
],
"parameters": {
"options": {},
"fieldToSplitOut": "body.rows"
},
"typeVersion": 1
},
{
"id": "e5a12b33-abac-4b98-a355-c7c729c4f822",
"name": "Note autocollante1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"width": 460,
"height": 1260,
"content": "## Workflow explanation\n\n*last updated: 11.08.2025*\n\n### Preparation \n\n1. *(In Excel)* you set the keyword you want to generate content for on **Prioritized = yes**\n2. *(In Excel)* you click on **Prepare Content** and the workflow will be triggered automatically\n\n## Workflow functionality\n\n### 1. Receive Data and prepare runs\n1. Webhook receives the prioritized rows from the google sheet\n2. it separates each row and extracts the actual keyword\n2.1 it updated the row in google sheets that the automation has started\n\n### 2. Get real-time SERP results from Google\n1. Query a custom Search Engine and search for the target keyword\n2. Split the SERP results into separate items\n3. Get the actual real-time data from the website\n4. Extract the text from the web page\n\n### 3. AI Article Analysis\n1. Analyse each text with AI. Get content structure and additional information.\n2. Aggregate all analyzed articles separately\n3. Create a SEO optimized Content Brief by comparing analyzed texts, identify content gaps etc.\n4. Create a content draft from the Content Brief with AI\n\n#### 4. Publish and update google sheet\n1. Publish the content draft directly to your WordPress Website (still a draft)\n2. Update Google Sheet \n\n\n\n## Setup\n1. Copy Excel Template\n2. Add your webhook to the Google Script\n3. Create Custom Search API and connect via API key\n4. Add your Claude API Key \n5. Connect to your WordPress website\n\n\n### Full Setup Guide ###\nhttps://opaque-face-45b.notion.site/Content-Automation-Pipeline-Walkthrough-221f1bceaabe808fb4efdc7c7be71bac"
},
"typeVersion": 1
},
{
"id": "5bd96cde-cacd-452f-be56-0d40d4393a04",
"name": "Note autocollante2",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
700
],
"parameters": {
"color": 4,
"width": 1520,
"height": 540,
"content": "## AI Article Analysis\n"
},
"typeVersion": 1
},
{
"id": "37bdb2ec-9c5a-4b01-b46e-6da0866f79d4",
"name": "Note autocollante4",
"type": "n8n-nodes-base.stickyNote",
"position": [
2060,
0
],
"parameters": {
"color": 5,
"width": 440,
"height": 660,
"content": "## Update Excel\n\nUddating the rows that are being processed\n\n"
},
"typeVersion": 1
},
{
"id": "8206d317-13ab-4406-af94-cb570dafdd00",
"name": "Note autocollante5",
"type": "n8n-nodes-base.stickyNote",
"position": [
2060,
700
],
"parameters": {
"color": 5,
"width": 440,
"height": 300,
"content": "## Send Draft to Wordpress\n"
},
"typeVersion": 1
},
{
"id": "c07308e8-1ab0-4ce7-82f7-c1ca34dbe19f",
"name": "Séparer en différents résultats SERP",
"type": "n8n-nodes-base.splitOut",
"position": [
1160,
420
],
"parameters": {
"options": {},
"fieldToSplitOut": "items"
},
"typeVersion": 1
},
{
"id": "ac323545-015f-4eb7-8a79-5483f5ff8473",
"name": "Agréger",
"type": "n8n-nodes-base.aggregate",
"position": [
1220,
800
],
"parameters": {
"options": {},
"fieldsToAggregate": {
"fieldToAggregate": [
{
"fieldToAggregate": "output"
}
]
}
},
"typeVersion": 1
},
{
"id": "adc61223-1536-4871-8415-1050360ade36",
"name": "Claude Modèle Haiku 3.5",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
920,
1060
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "claude-3-5-haiku-20241022",
"cachedResultName": "Claude Haiku 3.5"
},
"options": {}
},
"credentials": {
"anthropicApi": {
"id": "6ofdvdr8Hm4jzCvt",
"name": "Placeholder Anthropic Account"
}
},
"typeVersion": 1.3
},
{
"id": "8346dd6f-4da9-44ff-b8cb-896581286a28",
"name": "Claude Sonnet 3.7",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
1760,
1060
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "claude-3-7-sonnet-20250219",
"cachedResultName": "Claude Sonnet 3.7"
},
"options": {}
},
"credentials": {
"anthropicApi": {
"id": "6ofdvdr8Hm4jzCvt",
"name": "Placeholder Anthropic Account"
}
},
"typeVersion": 1.3
},
{
"id": "6076d8f4-f732-43b9-8f31-f081796a637f",
"name": "Structure d'analyse de contenu",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1160,
1060
],
"parameters": {
"jsonSchemaExample": "{\n \"contentFormat\": \"listicle | how-to | guide | comparison | opinion | review | other\",\n \"contentType\": \"informational | commercial | transactional | navigational\",\n \"intentClues\": [\n \"e.g. how to\", \n \"best tools\", \n \"buy\", \n \"guide\", \n \"vs\", \n \"tutorial\", \n \"top 10\"\n ],\n \"averageWordCount\": 0,\n \"headings\": [\n \"H1 Title Example\",\n \"H2 Subtopic One\",\n \"H2 Subtopic Two\",\n \"H3 Nested Topic\"\n ],\n \"subtopics\": [\n \"Definition of X\",\n \"Benefits of Y\",\n \"How to do Z\",\n \"Common mistakes\"\n ],\n \"summaryTakeaways\": [\n \"Key takeaway 1\",\n \"Key takeaway 2\",\n \"Key takeaway 3\"\n ],\n \"answeredQuestions\": [\n \"What is X?\",\n \"How does Y work?\",\n \"Why is Z important?\"\n ],\n \"uniqueAngles\": [\n \"Case study from a startup using X\",\n \"Comparison to real-world analogy\",\n \"Includes visuals that others don’t\"\n ],\n \"contentGaps\": [\n \"No examples of practical implementation\",\n \"Missed current 2024 data updates\",\n \"Lacked pros and cons comparison\"\n ]\n}"
},
"typeVersion": 1.3
},
{
"id": "7f0ff7a4-aab7-4692-9565-e36e72858289",
"name": "Structure de brief de contenu",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1560,
1060
],
"parameters": {
"jsonSchemaExample": "{\n \"targetKeyword\": \"your keyword here\",\n \"searchIntent\": \"informational | commercial | etc.\",\n \"recommendedFormat\": \"how-to | listicle | etc.\",\n \"idealLength\": \"1200–1500 words\",\n \"targetAudience\": \"e.g. SaaS founders, content creators\",\n \"titleSuggestion\": \"Best Tools for Automating Content Repurposing in 2024\",\n \"metaDescription\": \"Discover the top tools and workflows to repurpose YouTube content into blogs, social posts, and more.\",\n \"outline\": [\n \"Introduction\",\n \"Why Content Repurposing Matters\",\n \"Top Tools to Use\",\n \"How to Set Up an Automation Flow\",\n \"Common Mistakes to Avoid\",\n \"Conclusion\"\n ],\n \"mustIncludeSubtopics\": [\n \"Benefits of content repurposing\",\n \"Overview of tools like Repurpose.io, Zapier, n8n\",\n \"Step-by-step setup guide\"\n ],\n \"answeredQuestions\": [\n \"How do I turn a YouTube video into a blog post?\",\n \"What tools automate content repurposing?\"\n ],\n \"uniqueAngle\": \"Focus on a solo creator’s use case using free/low-cost tools\",\n \"contentGapsToFill\": [\n \"Most competitors don’t explain setup steps clearly\",\n \"None include a downloadable automation template\"\n ],\n \"ctaSuggestion\": \"Download the free workflow template + join my newsletter\"\n}"
},
"typeVersion": 1.3
},
{
"id": "5d8ddcda-34e3-4de2-b7d3-ec7d2973f2fb",
"name": "Analyse d'article par IA",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
880,
800
],
"parameters": {
"text": "=This is the text:\n {{ $json.text }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "You are a seasonsed SEO professional and Text Analyser with some deep insights into helpful content. Whenever you get a text, I want you to analyse and understand the text. Then, I want you to extract the following from each text: \n1. the ContentFormat, which is either a listicle, how-to, guide, comparision, opinion, review, or other. \n2. the ContentType, which is either informational, commercial, transactional or navigational\n3. the IntentClues, which can be how-to, best tools, buy, guide, vs, tutorial, ranking, top 10,\n4. the AverageWordCount, which is the average word length of the text\n5. all the headings, h1,h2,h3, up to h6 if necessary. And, if possible, also Add the hX tag before the heading\n6. all the subtopics: definitions of x, benefits of y, how to do.. and so on\n7. a list of key-takeaways.\n8. a list of answered questions in the text\n9. the UniqueAngles of the text. for example case studies, comparisons to real-world scenarios, etc.\n10. a list of contentGaps that you see in the text."
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"executeOnce": false,
"typeVersion": 1.7
},
{
"id": "cac3d12d-5777-4929-87aa-a2739592160a",
"name": "Générateur de brief de contenu IA",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1400,
800
],
"parameters": {
"text": "=The target Keyword is: AI Agent vs AI Chatbot\n\nhere are the summaries: \n{{ JSON.stringify($json.output) }}\n",
"batching": {},
"messages": {
"messageValues": [
{
"message": "You are an expert SEO content strategist. Your task is to analyze a list of SERP summaries (from top-ranking pages for a keyword) and generate a high-quality content brief to guide the writing of a new blog post that is more useful and competitive than existing content. \n\nEach SERP summary is structured in JSON and contains insights about a competing article, including content format, content type, headings, subtopics, summary takeaways, answered questions, unique angles, and content gaps. \n\nUse this information to: \n- Identify the dominant content format and intent \n- Suggest a competitive and original structure \n- Fill in the content gaps identified across competitors \n- Highlight what to include and what to improve \n- Suggest a title, meta description, outline, subtopics, and CTA \n- Focus on user value and differentiation \n\nReturn the output as a single JSON object with the following structure: { \"targetKeyword\": \"string\", \"searchIntent\": \"string\", \"recommendedFormat\": \"string\", \"idealLength\": \"string\", \"targetAudience\": \"string\", \"titleSuggestion\": \"string\", \"metaDescription\": \"string\", \"outline\": [\"h2 header one\", \"h2 header two\",\"h3 sub-header two-one\", \"...\"], \"mustIncludeSubtopics\": [\"topic 1\", \"topic 2\", \"...\"], \"answeredQuestions\": [\"question 1\", \"question 2\", \"...\"], \"uniqueAngle\": \"string\", \"contentGapsToFill\": [\"gap 1\", \"gap 2\", \"...\"], \"ctaSuggestion\": \"string\" } Use clear, specific language in your output. Be strategic, not generic."
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "f54e0944-b55e-4409-bacf-18db8471af2e",
"name": "Brouillon de contenu IA",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1760,
800
],
"parameters": {
"text": "=This is the keyword: \n'AI Agents vs AI Chatbots'\n\nThe content brief is here:\n{{ JSON.stringify($json.output) }}\n\nThese are the summaries:\n{{ JSON.stringify($('Aggregate').item.json.output) }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "You are a seasoned SEO blog writer and technical content creator. Your writing style is warm, human, and easy to understand — like you're explaining things to a curious and smart 16-year-old. You combine technical depth with clarity and a dash of quirkiness. You're speaking to solopreneurs, developers, and technically minded professionals. The goal is to educate, inform, and sometimes lightly entertain.\n\nYou will receive:\n- A main keyword\n- A content brief in JSON format\n- A list of summarized top-ranking articles from the first page of Google (also in JSON format)\n- A preferred content structure, such as “how-to guide” or “listicle”\n\nYou must understand the content brief and all provided article summaries before drafting anything.\n\nYour tasks:\n\n1. Generate a fresh, SEO-friendly title, primarily based on the brief, but also informed by top articles.\n\n2. Create an outline using <h2> and <h3> headers. Make sure each section is relevant to the keyword and useful for the reader.\n- If a header doesn’t make sense, leave it out.\n- Follow the format and tone requested in the structure parameter (e.g., how-to guide, opinion, etc.)\n\n3. For each <h2> and <h3>:\n- List a few bullet points on what should be covered and from what angle.\n- Write a draft paragraph for each bullet point.\n\n4. Whenever appropriate, include examples, data, or references.\n- If you can’t find any directly, add a placeholder like [add example here] or [research link for XYZ] — this helps the human editor finish the post efficiently.\n\n\nImportant notes:\n\n🔚 Final Output Format (IMPORTANT)\nOutput only the HTML text\n\nDo NOT return markdown, YAML, or any explanation.\nDo NOT include \"output\" or \"response\" keys.\nDo NOT return a code block. just the raw html text"
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "ee722c5b-d96b-481a-8393-f75d88cf58ed",
"name": "Note autocollante6",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
320
],
"parameters": {
"color": 3,
"width": 1520,
"height": 340,
"content": "## SERP Extraction\nGet the SERPS from Google for given Keyword"
},
"typeVersion": 1
},
{
"id": "f6fbe74d-8efa-4cc6-9671-4dcb479adcdc",
"name": "Recherche via Google Search API1",
"type": "n8n-nodes-base.httpRequest",
"position": [
900,
420
],
"parameters": {
"url": "https://www.googleapis.com/customsearch/v1",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "q",
"value": "{{ $json.keywordString }}"
},
{
"name": "key"
},
{
"name": "cx"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "ffa72fee-3e14-45cd-bf75-ddce5cdbdba7",
"name": "Obtenir la page web brute",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
1380,
420
],
"parameters": {
"url": "={{ $json.link }}",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "96c04d4a-148c-4832-ab16-1758abd09cb3",
"name": "Extraire le texte de la page web",
"type": "n8n-nodes-base.code",
"onError": "continueErrorOutput",
"position": [
1640,
420
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const data = $json.data;\n\nfunction extractTextWithHeaders(html) {\n let cleanedHTML = html\n .replace(/<script[\\s\\S]*?>[\\s\\S]*?<\\/script>/gi, '')\n .replace(/<style[\\s\\S]*?>[\\s\\S]*?<\\/style>/gi, '');\n\n cleanedHTML = cleanedHTML.replace(/<(h[1-6])[^>]*>(.*?)<\\/\\1>/gi, (match, tag, content) => {\n return `\\n\\n[${tag.toUpperCase()}] ${content.trim()} [/${tag.toUpperCase()}]\\n\\n`;\n });\n\n cleanedHTML = cleanedHTML.replace(/<[^>]+>/g, '');\n\n cleanedHTML = cleanedHTML.replace(/\\s+/g, ' ').trim();\n\n return cleanedHTML;\n}\n\nconst extractedText = extractTextWithHeaders(data);\n\nconsole.log(extractedText);\n\n// Return as output\nreturn { text: extractedText };\n"
},
"typeVersion": 2
},
{
"id": "3012bb4f-7f50-4bf1-aba6-bf8098415b80",
"name": "Envoyer le brouillon vers WordPress",
"type": "n8n-nodes-base.wordpress",
"position": [
2140,
800
],
"parameters": {
"title": "Testtest",
"additionalFields": {
"content": "={{ $json.text }}"
}
},
"credentials": {
"wordpressApi": {
"id": "sQgKVLHWhLpSqgSU",
"name": "Placeholder Wordpress API"
}
},
"typeVersion": 1
},
{
"id": "ee44cee8-60ce-48d2-90a7-6064752c6486",
"name": "Mettre à jour les informations de progression",
"type": "n8n-nodes-base.googleSheets",
"position": [
2300,
140
],
"parameters": {
"columns": {
"value": {
"Column 1": "Started processing",
"row_number": "={{ $json.rowNumber }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Parent",
"type": "string",
"display": true,
"required": false,
"displayName": "Parent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Info",
"type": "string",
"display": true,
"required": false,
"displayName": "Info",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comment",
"type": "string",
"display": true,
"required": false,
"displayName": "Comment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "post type",
"type": "string",
"display": true,
"required": false,
"displayName": "post type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword type",
"type": "string",
"display": true,
"required": false,
"displayName": "keyword type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Prioritized",
"type": "string",
"display": true,
"required": false,
"displayName": "Prioritized",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Processed",
"type": "string",
"display": true,
"required": false,
"displayName": "Processed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "written",
"type": "string",
"display": true,
"required": false,
"displayName": "written",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "published",
"type": "string",
"display": true,
"required": false,
"displayName": "published",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "internal links added everywhere",
"type": "string",
"display": true,
"required": false,
"displayName": "internal links added everywhere",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 1",
"type": "string",
"display": true,
"required": false,
"displayName": "Column 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1deCQg3HYLywY_gNcr7QNnTyc-ZKbOec-KKg132pxRcs/edit#gid=0",
"cachedResultName": "Ideas"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1deCQg3HYLywY_gNcr7QNnTyc-ZKbOec-KKg132pxRcs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1deCQg3HYLywY_gNcr7QNnTyc-ZKbOec-KKg132pxRcs/edit?usp=drivesdk",
"cachedResultName": "CallMeEugeniusContent"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Kw0awgkSoSjNZzSJ",
"name": "Placeholder Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "798de9a5-94ad-4488-96a8-fddde3969095",
"name": "Mettre à jour la feuille Excel",
"type": "n8n-nodes-base.googleSheets",
"position": [
2300,
380
],
"parameters": {
"columns": {
"value": {
"Column 1": "processing finished",
"row_number": "={{ $json.row_number }}"
},
"schema": [
{
"id": "Keyword",
"type": "string",
"display": true,
"required": false,
"displayName": "Keyword",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Parent",
"type": "string",
"display": true,
"required": false,
"displayName": "Parent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Info",
"type": "string",
"display": true,
"required": false,
"displayName": "Info",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comment",
"type": "string",
"display": true,
"required": false,
"displayName": "Comment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "post type",
"type": "string",
"display": true,
"required": false,
"displayName": "post type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "keyword type",
"type": "string",
"display": true,
"required": false,
"displayName": "keyword type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Prioritized",
"type": "string",
"display": true,
"required": false,
"displayName": "Prioritized",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Processed",
"type": "string",
"display": true,
"required": false,
"displayName": "Processed",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "written",
"type": "string",
"display": true,
"required": false,
"displayName": "written",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "published",
"type": "string",
"display": true,
"required": false,
"displayName": "published",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "internal links added everywhere",
"type": "string",
"display": true,
"required": false,
"displayName": "internal links added everywhere",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Column 1",
"type": "string",
"display": true,
"required": false,
"displayName": "Column 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"row_number"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1deCQg3HYLywY_gNcr7QNnTyc-ZKbOec-KKg132pxRcs/edit#gid=0",
"cachedResultName": "Ideas"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1deCQg3HYLywY_gNcr7QNnTyc-ZKbOec-KKg132pxRcs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1deCQg3HYLywY_gNcr7QNnTyc-ZKbOec-KKg132pxRcs/edit?usp=drivesdk",
"cachedResultName": "CallMeEugeniusContent"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Kw0awgkSoSjNZzSJ",
"name": "Placeholder Google Sheets account"
}
},
"typeVersion": 4.5
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "f9f316c8-82cf-44b8-a986-2fefd03d24cc",
"connections": {
"2e9c1ed9-1b06-4a81-af44-0a97364480f9": {
"main": [
[
{
"node": "c9e9048c-1b4b-4afe-9740-0698000f3e4c",
"type": "main",
"index": 0
}
]
]
},
"ac323545-015f-4eb7-8a79-5483f5ff8473": {
"main": [
[
{
"node": "cac3d12d-5777-4929-87aa-a2739592160a",
"type": "main",
"index": 0
}
]
]
},
"c9e9048c-1b4b-4afe-9740-0698000f3e4c": {
"main": [
[
{
"node": "ee44cee8-60ce-48d2-90a7-6064752c6486",
"type": "main",
"index": 0
},
{
"node": "f6fbe74d-8efa-4cc6-9671-4dcb479adcdc",
"type": "main",
"index": 0
}
]
]
},
"f54e0944-b55e-4409-bacf-18db8471af2e": {
"main": [
[
{
"node": "3012bb4f-7f50-4bf1-aba6-bf8098415b80",
"type": "main",
"index": 0
}
]
]
},
"ffa72fee-3e14-45cd-bf75-ddce5cdbdba7": {
"main": [
[
{
"node": "96c04d4a-148c-4832-ab16-1758abd09cb3",
"type": "main",
"index": 0
}
]
]
},
"8346dd6f-4da9-44ff-b8cb-896581286a28": {
"ai_languageModel": [
[
{
"node": "f54e0944-b55e-4409-bacf-18db8471af2e",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"5d8ddcda-34e3-4de2-b7d3-ec7d2973f2fb": {
"main": [
[
{
"node": "ac323545-015f-4eb7-8a79-5483f5ff8473",
"type": "main",
"index": 0
}
]
]
},
"adc61223-1536-4871-8415-1050360ade36": {
"ai_languageModel": [
[
{
"node": "5d8ddcda-34e3-4de2-b7d3-ec7d2973f2fb",
"type": "ai_languageModel",
"index": 0
},
{
"node": "cac3d12d-5777-4929-87aa-a2739592160a",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"7f0ff7a4-aab7-4692-9565-e36e72858289": {
"ai_outputParser": [
[
{
"node": "cac3d12d-5777-4929-87aa-a2739592160a",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"3012bb4f-7f50-4bf1-aba6-bf8098415b80": {
"main": [
[
{
"node": "798de9a5-94ad-4488-96a8-fddde3969095",
"type": "main",
"index": 0
}
]
]
},
"cac3d12d-5777-4929-87aa-a2739592160a": {
"main": [
[
{
"node": "f54e0944-b55e-4409-bacf-18db8471af2e",
"type": "main",
"index": 0
}
]
]
},
"6076d8f4-f732-43b9-8f31-f081796a637f": {
"ai_outputParser": [
[
{
"node": "5d8ddcda-34e3-4de2-b7d3-ec7d2973f2fb",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"96c04d4a-148c-4832-ab16-1758abd09cb3": {
"main": [
[
{
"node": "5d8ddcda-34e3-4de2-b7d3-ec7d2973f2fb",
"type": "main",
"index": 0
}
]
]
},
"f6fbe74d-8efa-4cc6-9671-4dcb479adcdc": {
"main": [
[
{
"node": "c07308e8-1ab0-4ce7-82f7-c1ca34dbe19f",
"type": "main",
"index": 0
}
]
]
},
"c07308e8-1ab0-4ce7-82f7-c1ca34dbe19f": {
"main": [
[
{
"node": "ffa72fee-3e14-45cd-bf75-ddce5cdbdba7",
"type": "main",
"index": 0
}
]
]
}
}
}Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé - Création de contenu, IA Multimodale
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Eugen
@callmeeugeniusData- & Workflow Automation. 10+ years of experience in automating data onboarding, data management and workflow optimization in the energy trading environment.
Partager ce workflow