Automate Google Sheets Data Entry with Anthropic Claude and Apify

Automate data entry into Google Sheets using an AI agent powered by Anthropic Claude and Apify. This workflow processes incoming data from various sources, ensuring real-time updates without manual effort. Features include automatic data parsing, intelligent filtering, and seamless integration with Google Sheets for instant access to your data. Perfect for data management teams handling multiple data streams or analysts looking to streamline reporting tasks. Requires 3 accounts: Anthropic API, Google Sheets OAuth, Apify API. Save up to 10 hours a week by automating data collection and entry, enabling your team to focus on analysis instead.

Chat Trigger
57 views36 nodesSep 2025Mia Sullivan

Categories

Content CreationMultimodal AI

APIs

Anthropic ClaudeApifyGoogle Sheets API

AI Features

Anthropic ClaudeAI ChatAI Agent

Credentials

3 required

Quick Actions

Copy or download to import into your n8n instance

Workflow JSON
{
  "meta": {
    "instanceId": "393ca9e36a1f81b0f643c72792946a5fe5e49eb4864181ba4032e5a408278263"
  },
  "nodes": [
    {
      "id": "2563146e-dbdb-498a-b213-8beb82534f50",
      "name": "Filter1",
      "type": "n8n-nodes-base.filter",
      "position": [
        272,
        544
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "d0a801f4-942f-4f2b-b71f-f31f23066f28",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $json['Keyword'] }}",
              "rightValue": ""
            },
            {
              "id": "6e0d041d-30cd-413d-913d-3c1775840277",
              "operator": {
                "type": "string",
                "operation": "empty",
                "singleValue": true
              },
              "leftValue": "={{ $json['<h1>'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "44cb6085-acf9-4645-a78e-849f3d6e8fe3",
      "name": "If1",
      "type": "n8n-nodes-base.if",
      "position": [
        464,
        544
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "b5344169-b18b-482d-9d03-b02c170668b9",
              "operator": {
                "type": "string",
                "operation": "exists",
                "singleValue": true
              },
              "leftValue": "={{ $json['Keyword'] }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "1e886a0f-1e95-4285-a63a-751206f23b12",
      "name": "Anthropic Chat Model2",
      "type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
      "position": [
        2448,
        736
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "claude-sonnet-4-20250514",
          "cachedResultName": "Claude Sonnet 4"
        },
        "options": {}
      },
      "credentials": {
        "anthropicApi": {
          "id": "WXQf5QsxCs3AyxlW",
          "name": "Anthropic account"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "06872cb6-5c22-4864-aff4-6e1c605ae0f4",
      "name": "Structured Output Parser2",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        2944,
        736
      ],
      "parameters": {
        "jsonSchemaExample": "{\n\t\"meta_title\": \"Courtage Assurance : Services & Avantages d'un Courtier en 2023\",\n\t\"meta_description\": \"Découvrez comment optimiser votre compte de libre passage avec Revolution. Conseils d'experts pour maximiser votre capital retraite et faire les meilleurs choix. Consultez-nous !\",\n    \"h1\": \"Compte de libre passage : Guide complet pour gérer votre 2e pilier\"\n}"
      },
      "typeVersion": 1.2
    },
    {
      "id": "0c1e0c3c-d015-4689-97ef-76319f453b96",
      "name": "Anthropic Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
      "position": [
        3312,
        736
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "claude-sonnet-4-20250514",
          "cachedResultName": "Claude Sonnet 4"
        },
        "options": {}
      },
      "credentials": {
        "anthropicApi": {
          "id": "WXQf5QsxCs3AyxlW",
          "name": "Anthropic account"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "e1c3a867-eee8-48b4-8d30-df7c0cee24c2",
      "name": "Titre 1",
      "type": "n8n-nodes-base.code",
      "position": [
        1888,
        32
      ],
      "parameters": {
        "jsCode": "// Fonction pour extraire et regrouper les titres par niveau\nfunction extractAndGroupTitles(markdownText) {\n  // Expression régulière pour capturer les titres h1-h6\n  const headingRegex = /^(#{1,6})\\s+(.+)$/gm;\n  \n  // Initialiser tous les niveaux avec \"pas de h{n}\"\n  const titlesByLevel = {\n    h1: [],\n    h2: [],\n    h3: [],\n    h4: [],\n    h5: [],\n    h6: []\n  };\n  \n  let match;\n  \n  // Parcourir toutes les correspondances\n  while ((match = headingRegex.exec(markdownText)) !== null) {\n    const level = match[1].length; // Nombre de #\n    let text = match[2].trim();\n    \n    // Retirer les liens markdown : [texte](url) -> texte\n    text = text.replace(/\\[([^\\]]+)\\]\\([^)]+\\)/g, '$1');\n    \n    const levelTag = `h${level}`;\n    \n    titlesByLevel[levelTag].push(text);\n  }\n  \n  // Créer l'objet de résultat\n  const result = {};\n  \n  Object.keys(titlesByLevel).forEach(level => {\n    if (titlesByLevel[level].length === 0) {\n      result[level] = `${level} : pas de ${level}`;\n    } else {\n      result[level] = `${level} :\\n${titlesByLevel[level].join('\\n')}`;\n    }\n  });\n  \n  return result;\n}\n\n// Récupérer les données d'entrée\nconst inputData = $input.first();\n\n// Vérifier la structure et récupérer le markdown\nlet markdown = '';\nif (inputData && inputData.json && inputData.json.data && inputData.json.data.markdown) {\n  markdown = inputData.json.data.markdown;\n} else {\n  console.log(\"Structure non reconnue:\", JSON.stringify(inputData).substring(0, 300));\n  return {\n    json: {\n      h1: \"h1 : pas de h1\",\n      h2: \"h2 : pas de h2\",\n      h3: \"h3 : pas de h3\",\n      h4: \"h4 : pas de h4\",\n      h5: \"h5 : pas de h5\",\n      h6: \"h6 : pas de h6\"\n    }\n  };\n}\n\n// Extraire et regrouper les titres\nconst titres = extractAndGroupTitles(markdown);\n\n// Retourner le résultat dans le format demandé\nreturn {\n  json: titres\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "e155b00c-2cea-4d8d-a80b-6a0b5089b235",
      "name": "Titre 2",
      "type": "n8n-nodes-base.code",
      "position": [
        1888,
        256
      ],
      "parameters": {
        "jsCode": "// Fonction pour extraire et regrouper les titres par niveau\nfunction extractAndGroupTitles(markdownText) {\n  // Expression régulière pour capturer les titres h1-h6\n  const headingRegex = /^(#{1,6})\\s+(.+)$/gm;\n  \n  // Initialiser tous les niveaux avec \"pas de h{n}\"\n  const titlesByLevel = {\n    h1: [],\n    h2: [],\n    h3: [],\n    h4: [],\n    h5: [],\n    h6: []\n  };\n  \n  let match;\n  \n  // Parcourir toutes les correspondances\n  while ((match = headingRegex.exec(markdownText)) !== null) {\n    const level = match[1].length; // Nombre de #\n    let text = match[2].trim();\n    \n    // Retirer les liens markdown : [texte](url) -> texte\n    text = text.replace(/\\[([^\\]]+)\\]\\([^)]+\\)/g, '$1');\n    \n    const levelTag = `h${level}`;\n    \n    titlesByLevel[levelTag].push(text);\n  }\n  \n  // Créer l'objet de résultat\n  const result = {};\n  \n  Object.keys(titlesByLevel).forEach(level => {\n    if (titlesByLevel[level].length === 0) {\n      result[level] = `${level} : pas de ${level}`;\n    } else {\n      result[level] = `${level} :\\n${titlesByLevel[level].join('\\n')}`;\n    }\n  });\n  \n  return result;\n}\n\n// Récupérer les données d'entrée\nconst inputData = $input.first();\n\n// Vérifier la structure et récupérer le markdown\nlet markdown = '';\nif (inputData && inputData.json && inputData.json.data && inputData.json.data.markdown) {\n  markdown = inputData.json.data.markdown;\n} else {\n  console.log(\"Structure non reconnue:\", JSON.stringify(inputData).substring(0, 300));\n  return {\n    json: {\n      h1: \"h1 : pas de h1\",\n      h2: \"h2 : pas de h2\",\n      h3: \"h3 : pas de h3\",\n      h4: \"h4 : pas de h4\",\n      h5: \"h5 : pas de h5\",\n      h6: \"h6 : pas de h6\"\n    }\n  };\n}\n\n// Extraire et regrouper les titres\nconst titres = extractAndGroupTitles(markdown);\n\n// Retourner le résultat dans le format demandé\nreturn {\n  json: titres\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "2e536985-af39-48cd-83d4-a3513899f4f0",
      "name": "Titre 3",
      "type": "n8n-nodes-base.code",
      "position": [
        1888,
        480
      ],
      "parameters": {
        "jsCode": "// Fonction pour extraire et regrouper les titres par niveau\nfunction extractAndGroupTitles(markdownText) {\n  // Expression régulière pour capturer les titres h1-h6\n  const headingRegex = /^(#{1,6})\\s+(.+)$/gm;\n  \n  // Initialiser tous les niveaux avec \"pas de h{n}\"\n  const titlesByLevel = {\n    h1: [],\n    h2: [],\n    h3: [],\n    h4: [],\n    h5: [],\n    h6: []\n  };\n  \n  let match;\n  \n  // Parcourir toutes les correspondances\n  while ((match = headingRegex.exec(markdownText)) !== null) {\n    const level = match[1].length; // Nombre de #\n    let text = match[2].trim();\n    \n    // Retirer les liens markdown : [texte](url) -> texte\n    text = text.replace(/\\[([^\\]]+)\\]\\([^)]+\\)/g, '$1');\n    \n    const levelTag = `h${level}`;\n    \n    titlesByLevel[levelTag].push(text);\n  }\n  \n  // Créer l'objet de résultat\n  const result = {};\n  \n  Object.keys(titlesByLevel).forEach(level => {\n    if (titlesByLevel[level].length === 0) {\n      result[level] = `${level} : pas de ${level}`;\n    } else {\n      result[level] = `${level} :\\n${titlesByLevel[level].join('\\n')}`;\n    }\n  });\n  \n  return result;\n}\n\n// Récupérer les données d'entrée\nconst inputData = $input.first();\n\n// Vérifier la structure et récupérer le markdown\nlet markdown = '';\nif (inputData && inputData.json && inputData.json.data && inputData.json.data.markdown) {\n  markdown = inputData.json.data.markdown;\n} else {\n  console.log(\"Structure non reconnue:\", JSON.stringify(inputData).substring(0, 300));\n  return {\n    json: {\n      h1: \"h1 : pas de h1\",\n      h2: \"h2 : pas de h2\",\n      h3: \"h3 : pas de h3\",\n      h4: \"h4 : pas de h4\",\n      h5: \"h5 : pas de h5\",\n      h6: \"h6 : pas de h6\"\n    }\n  };\n}\n\n// Extraire et regrouper les titres\nconst titres = extractAndGroupTitles(markdown);\n\n// Retourner le résultat dans le format demandé\nreturn {\n  json: titres\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "8acc9d62-9d55-445e-a858-c733d6e6b68c",
      "name": "Titre 4",
      "type": "n8n-nodes-base.code",
      "position": [
        1888,
        688
      ],
      "parameters": {
        "jsCode": "// Fonction pour extraire et regrouper les titres par niveau\nfunction extractAndGroupTitles(markdownText) {\n  // Expression régulière pour capturer les titres h1-h6\n  const headingRegex = /^(#{1,6})\\s+(.+)$/gm;\n  \n  // Initialiser tous les niveaux avec \"pas de h{n}\"\n  const titlesByLevel = {\n    h1: [],\n    h2: [],\n    h3: [],\n    h4: [],\n    h5: [],\n    h6: []\n  };\n  \n  let match;\n  \n  // Parcourir toutes les correspondances\n  while ((match = headingRegex.exec(markdownText)) !== null) {\n    const level = match[1].length; // Nombre de #\n    let text = match[2].trim();\n    \n    // Retirer les liens markdown : [texte](url) -> texte\n    text = text.replace(/\\[([^\\]]+)\\]\\([^)]+\\)/g, '$1');\n    \n    const levelTag = `h${level}`;\n    \n    titlesByLevel[levelTag].push(text);\n  }\n  \n  // Créer l'objet de résultat\n  const result = {};\n  \n  Object.keys(titlesByLevel).forEach(level => {\n    if (titlesByLevel[level].length === 0) {\n      result[level] = `${level} : pas de ${level}`;\n    } else {\n      result[level] = `${level} :\\n${titlesByLevel[level].join('\\n')}`;\n    }\n  });\n  \n  return result;\n}\n\n// Récupérer les données d'entrée\nconst inputData = $input.first();\n\n// Vérifier la structure et récupérer le markdown\nlet markdown = '';\nif (inputData && inputData.json && inputData.json.data && inputData.json.data.markdown) {\n  markdown = inputData.json.data.markdown;\n} else {\n  console.log(\"Structure non reconnue:\", JSON.stringify(inputData).substring(0, 300));\n  return {\n    json: {\n      h1: \"h1 : pas de h1\",\n      h2: \"h2 : pas de h2\",\n      h3: \"h3 : pas de h3\",\n      h4: \"h4 : pas de h4\",\n      h5: \"h5 : pas de h5\",\n      h6: \"h6 : pas de h6\"\n    }\n  };\n}\n\n// Extraire et regrouper les titres\nconst titres = extractAndGroupTitles(markdown);\n\n// Retourner le résultat dans le format demandé\nreturn {\n  json: titres\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "659ebdb8-e76d-494c-96de-b257d9888461",
      "name": "Titre 5",
      "type": "n8n-nodes-base.code",
      "position": [
        1888,
        880
      ],
      "parameters": {
        "jsCode": "// Fonction pour extraire et regrouper les titres par niveau\nfunction extractAndGroupTitles(markdownText) {\n  // Expression régulière pour capturer les titres h1-h6\n  const headingRegex = /^(#{1,6})\\s+(.+)$/gm;\n  \n  // Initialiser tous les niveaux avec \"pas de h{n}\"\n  const titlesByLevel = {\n    h1: [],\n    h2: [],\n    h3: [],\n    h4: [],\n    h5: [],\n    h6: []\n  };\n  \n  let match;\n  \n  // Parcourir toutes les correspondances\n  while ((match = headingRegex.exec(markdownText)) !== null) {\n    const level = match[1].length; // Nombre de #\n    let text = match[2].trim();\n    \n    // Retirer les liens markdown : [texte](url) -> texte\n    text = text.replace(/\\[([^\\]]+)\\]\\([^)]+\\)/g, '$1');\n    \n    const levelTag = `h${level}`;\n    \n    titlesByLevel[levelTag].push(text);\n  }\n  \n  // Créer l'objet de résultat\n  const result = {};\n  \n  Object.keys(titlesByLevel).forEach(level => {\n    if (titlesByLevel[level].length === 0) {\n      result[level] = `${level} : pas de ${level}`;\n    } else {\n      result[level] = `${level} :\\n${titlesByLevel[level].join('\\n')}`;\n    }\n  });\n  \n  return result;\n}\n\n// Récupérer les données d'entrée\nconst inputData = $input.first();\n\n// Vérifier la structure et récupérer le markdown\nlet markdown = '';\nif (inputData && inputData.json && inputData.json.data && inputData.json.data.markdown) {\n  markdown = inputData.json.data.markdown;\n} else {\n  console.log(\"Structure non reconnue:\", JSON.stringify(inputData).substring(0, 300));\n  return {\n    json: {\n      h1: \"h1 : pas de h1\",\n      h2: \"h2 : pas de h2\",\n      h3: \"h3 : pas de h3\",\n      h4: \"h4 : pas de h4\",\n      h5: \"h5 : pas de h5\",\n      h6: \"h6 : pas de h6\"\n    }\n  };\n}\n\n// Extraire et regrouper les titres\nconst titres = extractAndGroupTitles(markdown);\n\n// Retourner le résultat dans le format demandé\nreturn {\n  json: titres\n};"
      },
      "typeVersion": 2
    },
    {
      "id": "74000c37-8dd3-47e7-bb55-3cd7532c1274",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        4016,
        528
      ],
      "parameters": {
        "jsCode": "// Code avec conservation de toutes les colonnes existantes\nconst items = [];\n\n// Récupérer les données de vos différents nodes\nconst loopItem = $('Loop Over Items').item.json;\nconst metaTagsOutput = $('Meta tag + h1').item.json.output;\nconst briefOutput = $json.output;\n\n// Créer l'objet avec toutes les colonnes et le mapping des nouvelles valeurs\nconst transformedItem = {\n  // Copier toutes les propriétés existantes\n  ...loopItem,\n  \n  // Écraser/ajouter les nouvelles valeurs\n  '<title>': metaTagsOutput.meta_title,\n  '<meta-desc>': metaTagsOutput.meta_description,\n  '<h1>': metaTagsOutput.h1,\n  'brief': briefOutput\n};\n\n// Retourner l'item transformé\nitems.push(transformedItem);\n\nreturn items;"
      },
      "typeVersion": 2
    },
    {
      "id": "d90859a4-bf2b-48b4-9180-ee001cb7bf58",
      "name": "Apify",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1120,
        544
      ],
      "parameters": {
        "url": "https://api.apify.com/v2/acts/nFJndFXA5zjCTuudP/run-sync-get-dataset-items",
        "method": "POST",
        "options": {
          "timeout": 300000,
          "response": {
            "response": {
              "responseFormat": "json"
            }
          }
        },
        "jsonBody": "={\n    \"countryCode\": \"fr\",\n    \"forceExactMatch\": false,\n    \"includeIcons\": false,\n    \"includeUnfilteredResults\": false,\n    \"languageCode\": \"fr\",\n    \"maxPagesPerQuery\": 1,\n    \"mobileResults\": false,\n    \"queries\": \"{{ $json['Keyword'] }}\",\n    \"resultsPerPage\": 10,\n    \"saveHtml\": false,\n    \"saveHtmlToKeyValueStore\": false\n}",
        "sendBody": true,
        "sendQuery": true,
        "specifyBody": "json",
        "authentication": "predefinedCredentialType",
        "queryParameters": {
          "parameters": [
            {
              "name": "timeout",
              "value": "240"
            },
            {
              "name": "memory",
              "value": "512"
            },
            {
              "name": "maxItems",
              "value": "10"
            },
            {
              "name": "format",
              "value": "json"
            },
            {
              "name": "maxTotalChargeUsd",
              "value": "0.50"
            }
          ]
        },
        "nodeCredentialType": "httpHeaderAuth"
      },
      "credentials": {
        "httpHeaderAuth": {
          "id": "jAy18eDHHP2ZoGrH",
          "name": "Apify"
        }
      },
      "executeOnce": true,
      "typeVersion": 4.2
    },
    {
      "id": "cf903821-ca3a-44f8-924c-9d2d280bb2f3",
      "name": "Update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        4368,
        528
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "Niv 0",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Niv 0",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Niv 1",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Niv 1",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Niv 2",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Niv 2",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Niv 3",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Niv 3",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "mots clés",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "mots clés",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "vol",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "vol",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "KD%",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "KD%",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Type de page",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Type de page",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "URL",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "URL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "<title>",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "<title>",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "<meta-desc>",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "<meta-desc>",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "<h1>",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "<h1>",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "brief",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "brief",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "mots clés secondaires",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "mots clés secondaires",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "intentions de recherche",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "intentions de recherche",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "nombre de mots",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "nombre de mots",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Premiere version",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Premiere version",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Thot",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Thot",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "col_11",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "col_11",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "col_13",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "col_13",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "col_15",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "col_15",
              "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": "autoMapInputData",
          "matchingColumns": [
            "mots clés"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "FR"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('When chat message received').item.json.chatInput }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "wBRLUCktxqXE6DVJ",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "cb78803f-39aa-4634-a551-bece02c2a548",
      "name": "Scrape 1",
      "type": "@mendable/n8n-nodes-firecrawl.firecrawl",
      "onError": "continueRegularOutput",
      "position": [
        1616,
        32
      ],
      "parameters": {
        "url": "={{ $('Apify').item.json.organicResults[0].url }}",
        "operation": "scrape",
        "scrapeOptions": {
          "options": {
            "headers": {},
            "includeTags": {
              "items": [
                {
                  "tag": "h1, h2, h3, h4"
                }
              ]
            }
          }
        },
        "requestOptions": {}
      },
      "credentials": {
        "firecrawlApi": {
          "id": "E34WDB80ik5VHjiI",
          "name": "Firecrawl account"
        }
      },
      "typeVersion": 1,
      "alwaysOutputData": false
    },
    {
      "id": "b0ec431f-99c9-452c-866f-b5bf167b69a1",
      "name": "Scrape 2",
      "type": "@mendable/n8n-nodes-firecrawl.firecrawl",
      "onError": "continueRegularOutput",
      "position": [
        1616,
        256
      ],
      "parameters": {
        "url": "={{ $('Apify').item.json.organicResults[1].url }}",
        "operation": "scrape",
        "scrapeOptions": {
          "options": {
            "headers": {},
            "includeTags": {
              "items": [
                {
                  "tag": "h1, h2, h3, h4"
                }
              ]
            }
          }
        },
        "requestOptions": {}
      },
      "credentials": {
        "firecrawlApi": {
          "id": "E34WDB80ik5VHjiI",
          "name": "Firecrawl account"
        }
      },
      "typeVersion": 1,
      "alwaysOutputData": false
    },
    {
      "id": "a7e82453-e1f5-4010-8f30-7cf09146165f",
      "name": "Scrape 5",
      "type": "@mendable/n8n-nodes-firecrawl.firecrawl",
      "onError": "continueRegularOutput",
      "position": [
        1616,
        880
      ],
      "parameters": {
        "url": "={{ $('Apify').item.json.organicResults[4].url }}",
        "operation": "scrape",
        "scrapeOptions": {
          "options": {
            "headers": {},
            "includeTags": {
              "items": [
                {
                  "tag": "h1, h2, h3, h4"
                }
              ]
            }
          }
        },
        "requestOptions": {}
      },
      "credentials": {
        "firecrawlApi": {
          "id": "E34WDB80ik5VHjiI",
          "name": "Firecrawl account"
        }
      },
      "typeVersion": 1,
      "alwaysOutputData": false
    },
    {
      "id": "78a4da3e-6249-4462-8a12-bba576445077",
      "name": "Scrape 4",
      "type": "@mendable/n8n-nodes-firecrawl.firecrawl",
      "onError": "continueRegularOutput",
      "position": [
        1616,
        688
      ],
      "parameters": {
        "url": "={{ $('Apify').item.json.organicResults[3].url }}",
        "operation": "scrape",
        "scrapeOptions": {
          "options": {
            "headers": {},
            "includeTags": {
              "items": [
                {
                  "tag": "h1, h2, h3, h4"
                }
              ]
            }
          }
        },
        "requestOptions": {}
      },
      "credentials": {
        "firecrawlApi": {
          "id": "E34WDB80ik5VHjiI",
          "name": "Firecrawl account"
        }
      },
      "typeVersion": 1,
      "alwaysOutputData": false
    },
    {
      "id": "40b057e3-87a1-4bf8-ae6e-a9815efaa7ff",
      "name": "Scrape 3",
      "type": "@mendable/n8n-nodes-firecrawl.firecrawl",
      "onError": "continueRegularOutput",
      "position": [
        1616,
        480
      ],
      "parameters": {
        "url": "={{ $('Apify').item.json.organicResults[2].url }}",
        "operation": "scrape",
        "scrapeOptions": {
          "options": {
            "headers": {},
            "includeTags": {
              "items": [
                {
                  "tag": "h1, h2, h3, h4"
                }
              ]
            }
          }
        },
        "requestOptions": {}
      },
      "credentials": {
        "firecrawlApi": {
          "id": "E34WDB80ik5VHjiI",
          "name": "Firecrawl account"
        }
      },
      "typeVersion": 1,
      "alwaysOutputData": false
    },
    {
      "id": "aed07f3a-0ba8-4c92-a850-0c0220b88d7c",
      "name": "Client Information",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -176,
        544
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "Client information"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('When chat message received').item.json.chatInput }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "wBRLUCktxqXE6DVJ",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "f4904275-5cb3-4beb-9450-90fe2531ec63",
      "name": "SEO information",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        48,
        544
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "SEO"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $('When chat message received').item.json.chatInput }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "wBRLUCktxqXE6DVJ",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "89682183-704d-4c21-9a32-baa0a2563cb6",
      "name": "When chat message received",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -448,
        544
      ],
      "webhookId": "88a8efaa-7712-49bd-ba94-4bb130719dbe",
      "parameters": {
        "mode": "webhook",
        "public": true,
        "options": {
          "responseMode": "responseNode"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "3b94e750-0ad8-433d-aa83-86bc70479bea",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        704,
        528
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "a61be69b-6a4a-42f2-9955-e76b9b65d2ba",
      "name": "Meta tag + h1",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "maxTries": 5,
      "position": [
        2576,
        528
      ],
      "parameters": {
        "text": "=[Main keyword]: {{ $('Loop Over Items').item.json['Keyword'] }}\n\n[Page]: {{ $('SEO information').item.json.Page }}\n\n[Site]: {{ $('Client Information').item.json['Client name'] }} ({{ $('Client Information').item.json['Client information'] }})\n\n[Description]:{{ $('Loop Over Items').item.json.Description }}\n\n[Competitor info]:\n\nCompetitor 1:\n{{ $('Apify').item?.json?.organicResults?.[0]?.url || '' }}\n\nMeta title: {{ $('Apify').item?.json?.organicResults?.[0]?.title || '' }}\nMeta description: {{ $('Apify').item?.json?.organicResults?.[0]?.description || '' }}\n{{ $('Titre 1').item.json.h1 }}\n\nCompetitor 2:\n{{ $('Apify').item?.json?.organicResults?.[1]?.url || '' }}\nMeta title: {{ $('Apify').item?.json?.organicResults?.[1]?.title || '' }}\nMeta description: {{ $('Apify').item?.json?.organicResults?.[1]?.description || '' }}\n{{ $('Titre 2').item.json.h1 }}\n\nCompetitor 3:\n{{ $('Apify').item?.json?.organicResults?.[2]?.url || '' }}\nMeta title: {{ $('Apify').item?.json?.organicResults?.[2]?.title || '' }}\nMeta description: {{ $('Apify').item?.json?.organicResults?.[2]?.description || '' }}\n{{ $('Titre 3').item.json.h1 }}\n\nCompetitor 4:\n{{ $('Apify').item?.json?.organicResults?.[3]?.url || '' }}\nMeta title: {{ $('Apify').item?.json?.organicResults?.[3]?.title || '' }}\nMeta description: {{ $('Apify').item?.json?.organicResults?.[3]?.description || '' }}\n{{ $('Titre 4').item.json.h1 }}\n\nCompetitor 5:\n{{ $('Apify').item?.json?.organicResults?.[4]?.url || '' }}\nMeta title: {{ $('Apify').item?.json?.organicResults?.[4]?.title || '' }}\nMeta description: {{ $('Apify').item?.json?.organicResults?.[4]?.description || '' }}\n{{ $('Titre 5').item.json.h1 }}\n\n[Client name]: {{ $('Client Information').item.json['Client name'] }}",
        "options": {
          "systemMessage": "# Rules\n\nAs an SEO expert, I need you to analyze the [Main keyword] for the page [Page], for the site [Site]. You also have a short description [Description] of what the page is about. You must also analyze the competitor info [Competitor info] (url, meta title, meta description, h1)\n\n# Deliverables\n\nto provide the following elements:\n\nMETA TITLE (65 characters maximum):\nCreate a catchy and optimized meta title that includes the main keyword at the beginning of the title if possible, while remaining natural and click-inducing. The format should be in sentence case. Expected structure for the title: Main keyword, cta (do not include the [Client name] in the title)\n\nMETA DESCRIPTION (165 characters maximum):\nWrite a persuasive meta description that clearly summarizes the page's added value, includes the main keyword and features an effective call-to-action.\n\nH1 (70 characters maximum):\nPropose an impactful H1 that integrates the main keyword while being attractive to the user. The format should be in sentence case.\n\nDo not write an introduction or conclusion to your response."
        },
        "promptType": "define",
        "hasOutputParser": true
      },
      "retryOnFail": true,
      "typeVersion": 1.9,
      "waitBetweenTries": 5000
    },
    {
      "id": "72cff01f-82e0-4021-9f6b-b3b373b93a59",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -496,
        448
      ],
      "parameters": {
        "color": 2,
        "width": 1360,
        "height": 256,
        "content": "# Phase 1: Data Input and Configuration"
      },
      "typeVersion": 1
    },
    {
      "id": "6c894ea3-f23e-422b-9050-5c22827a0aba",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        -32
      ],
      "parameters": {
        "color": 3,
        "width": 1248,
        "height": 1072,
        "content": "# Phase 2: Competitor Research and Analysis\n"
      },
      "typeVersion": 1
    },
    {
      "id": "114d2259-481b-4173-9346-f1d51958a541",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2400,
        448
      ],
      "parameters": {
        "color": 5,
        "width": 656,
        "height": 560,
        "content": "# Phase 3: Meta Tags and H1 Generation"
      },
      "typeVersion": 1
    },
    {
      "id": "b2a2e14f-5fa2-4334-a03d-6ef0cc761461",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3968,
        448
      ],
      "parameters": {
        "color": 7,
        "width": 560,
        "height": 256,
        "content": "# Phase 5: Data Integration and Sheet Updates"
      },
      "typeVersion": 1
    },
    {
      "id": "d8821a1e-3295-457f-8d60-53df802859f2",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1152,
        224
      ],
      "parameters": {
        "color": 4,
        "width": 544,
        "height": 944,
        "content": "# Phase 0: Setup and Configuration\n\n## What you do:\n\nCopy the template spreadsheet from this link: https://docs.google.com/spreadsheets/d/1cRlqsueCTgfMjO7AzwBsAOzTCPBrGpHSzRg05fLDnWc\n\n### Fill in the Client Information sheet with your business details:\n\nClient name: Your company or client's name\nClient information: Brief description of the business and what it does\nURL: The website address\nTone of voice: How you want the content to sound (professional, friendly, etc.)\nRestrictive instructions: Topics or approaches to avoid\n\n\n### Complete the SEO sheet with your page details:\n\nPage: What page you're optimizing (e.g., \"Homepage\", \"About Us\")\nKeyword: The main search term you want to rank for\nAwareness level: How familiar visitors are with your business\nPage type: Category of page (homepage, product page, blog article, etc.)\n\n\n\n## What the system does:\n\nStores your configuration for use throughout the workflow\nValidates your data to ensure all required fields are completed\nPrepares the automation to process your keywords and generate SEO content\n\n## Result:\n\n✅ Personalized workflow configured with your business information\n✅ Target keywords and pages ready for optimization\n✅ AI system trained on your specific requirements and restrictions\n✅ Foundation set for automated SEO content generation"
      },
      "typeVersion": 1
    },
    {
      "id": "c9d8682d-ad2b-4ba0-9b80-62cda1c98962",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -496,
        752
      ],
      "parameters": {
        "color": 2,
        "width": 1360,
        "height": 464,
        "content": "### What you do:\n\nProvide a Google Sheets URL via the chat trigger to initialize the workflow\nConfigure the Client Information sheet with your client details (name, description, website URL, Supabase database name, tone of voice, and content restrictions)\nSet up the SEO sheet with page information (page name, target keywords, user awareness level, and page type)\n\n### What the system does:\n\nReceives the chat input and extracts the Google Sheets document ID\nReads the Client Information sheet to gather all client-specific configuration data\nReads the SEO sheet to retrieve keyword and page targeting information\nFilters the data to process only rows with valid keywords and empty H1 fields\nValidates keyword existence using conditional logic\nInitiates batch processing to handle multiple keywords sequentially\n\n### Result:\n\n✅ Workflow configured with client-specific parameters\n✅ Valid keywords identified and queued for processing\n✅ Data properly structured for automated analysis\n✅ Batch processing system activated for efficient handling\n"
      },
      "typeVersion": 1
    },
    {
      "id": "60d1d1e6-1e99-48fc-98f7-77c0731f54be",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        1088
      ],
      "parameters": {
        "color": 3,
        "width": 1248,
        "height": 368,
        "content": "### What the system does:\n\nSearches Google using Apify API to retrieve top 10 organic results for each target keyword\nScrapes competitor websites using Firecrawl to extract content from the first 5 search results\nAnalyzes page structure by extracting H1-H6 headings from each competitor page using JavaScript\nProcesses markdown content to identify heading hierarchies and content organization\nHandles scraping errors gracefully by continuing execution even if some sites fail\nCompiles competitor intelligence including URLs, meta titles, meta descriptions, and heading structures\n\n### Result:\n\n✅ Comprehensive competitor analysis for each keyword\n✅ Detailed heading structure mapping from top 5 competitors\n✅ Meta tag information collected for benchmarking\n✅ Content organization patterns identified\n✅ Robust error handling ensures workflow completion\n"
      },
      "typeVersion": 1
    },
    {
      "id": "34828cbe-a9d1-4a81-81e6-b9e2024475e3",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2400,
        1056
      ],
      "parameters": {
        "color": 5,
        "width": 656,
        "height": 384,
        "content": "### What the system does:\n\nAnalyzes keyword context using Claude AI with competitor intelligence and client information\nGenerates optimized meta elements including title (65 chars max), description (165 chars max), and H1 (70 chars max)\nApplies SEO best practices by positioning keywords naturally while maintaining readability\nUses structured output parsing to ensure consistent JSON formatting\nIncorporates RAG database to personalize content with client-specific details\n\n### Result:\n\n✅ SEO-optimized meta title with target keyword placement\n✅ Compelling meta description with effective call-to-action\n✅ User-focused H1 that balances SEO and engagement\n✅ Character limits respected for optimal search display\n"
      },
      "typeVersion": 1
    },
    {
      "id": "bf5d8681-ddd6-4bc6-ae9e-46637a155811",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3200,
        448
      ],
      "parameters": {
        "color": 6,
        "width": 656,
        "height": 560,
        "content": "# Phase 4: Content Brief Creation"
      },
      "typeVersion": 1
    },
    {
      "id": "a797dbaa-905a-413d-83bc-3011e4202906",
      "name": "Content brief",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "maxTries": 5,
      "position": [
        3424,
        528
      ],
      "parameters": {
        "text": "=[Site]:  {{ $('Client Information').item.json['Client name'] }}({{ $('Client Information').item.json['Client information'] }})\n[Main keyword]: {{ $('Loop Over Items').item.json.Keyword }}\n[h1]: {{ $('Meta tag + h1').item.json.output.h1 }}\n[Description]: {{ $('Loop Over Items').item.json.Description }}\n[Awareness]: {{ $('Loop Over Items').item.json['Awareness level'] }}\n[Competitor info]:\nCompetitor 1:\n{{ $('Apify').item.json.organicResults[0].url }}\n{{ $('Titre 1').item.json.h1 }}\n{{ $('Titre 1').item.json.h2 }}\n{{ $('Titre 1').item.json.h3 }}\n{{ $('Titre 1').item.json.h4 }}\n{{ $('Titre 1').item.json.h5 }}\n{{ $('Titre 1').item.json.h6 }}\nCompetitor 2:\n{{ $('Apify').item.json.organicResults[1].url }}\n{{ $('Titre 2').item.json.h1 }}\n{{ $('Titre 2').item.json.h2 }}\n{{ $('Titre 2').item.json.h3 }}\n{{ $('Titre 2').item.json.h4 }}\n{{ $('Titre 2').item.json.h5 }}\n{{ $('Titre 2').item.json.h6 }}\nCompetitor 3:\n{{ $('Apify').item.json.organicResults[2].url }}\n{{ $('Titre 3').item.json.h1 }}\n{{ $('Titre 3').item.json.h2 }}\n{{ $('Titre 3').item.json.h3 }}\n{{ $('Titre 3').item.json.h4 }}\n{{ $('Titre 3').item.json.h5 }}\n{{ $('Titre 3').item.json.h6 }}\nCompetitor 4:\n{{ $('Apify').item.json.organicResults[3].url }}\n{{ $('Titre 4').item.json.h1 }}\n{{ $('Titre 4').item.json.h2 }}\n{{ $('Titre 4').item.json.h3 }}\n{{ $('Titre 4').item.json.h4 }}\n{{ $('Titre 4').item.json.h5 }}\n{{ $('Titre 4').item.json.h6 }}\nCompetitor 5:\n{{ $('Apify').item.json.organicResults[4].url }}\n{{ $('Titre 5').item.json.h1 }}\n{{ $('Titre 5').item.json.h2 }}\n{{ $('Titre 5').item.json.h3 }}\n{{ $('Titre 5').item.json.h4 }}\n{{ $('Titre 5').item.json.h5 }}\n{{ $('Titre 5').item.json.h6 }}\n[Page type]: {{ $('Loop Over Items').item.json['Type de page'] ? $('Loop Over Items').item.json['Type de page'] : '' }}\n[Client name]: {{ $('Client Information').item.json['Client name'] }}",
        "options": {
          "systemMessage": "# Rules\n\nI want to create an SEO content brief for a web page for the site [Site]. The main keyword I'm targeting is [Main keyword] and the h1 is the following [h1]. Here's a short description of the page [Description] And here's the awareness level that corresponds to the page [Awareness] Here's additional information about competitors positioning on this keyword, use this as inspiration to respond to the request [Competitor info]\n\n# Deliverables\n\nCan you provide a complete content brief including:\n\nPage type: [Page type]\nDetailed analysis of the search intent behind the main keyword (informational, transactional, navigational as percentages for each intent)\nStrategy to highlight the company in this content based on the main keyword\nRich media suggestions to integrate (images, videos, infographics, tables, etc.)\nDetailed MECE (Mutually Exclusive, Collectively Exhaustive) page structure with:\n\nthe h1 [h1]\nIntroduction\nH2 sections with key points for each section\nH3 subsections if necessary\n\n\nRecommended level of detail for writing on a scale of 1 to 10\n\nPlease ensure that the proposed structure is coherent, exhaustive, without redundancies, and optimized for SEO while remaining relevant for users.\nDo not write an introduction or conclusion to your response."
        },
        "promptType": "define"
      },
      "retryOnFail": true,
      "typeVersion": 1.9,
      "waitBetweenTries": 5000
    },
    {
      "id": "eab92685-858d-41ca-bee7-488ca35b84b5",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3200,
        1056
      ],
      "parameters": {
        "color": 6,
        "width": 656,
        "height": 400,
        "content": "### What the system does:\n\nAnalyzes search intent behind the target keyword (informational, transactional, navigational percentages)\nDevelops content strategy based on competitor analysis and client positioning\nCreates MECE page structure with detailed H2 sections and H3 subsections where needed\nSuggests rich media elements (images, videos, infographics, tables) for enhanced engagement\nProvides writing recommendations including detail level scoring (1-10 scale)\nIntegrates client database information to ensure brand-consistent messaging\nDelivers comprehensive brief covering all aspects needed for content creation\n\n### Result:\n\n✅ Complete content strategy with search intent analysis\n✅ Detailed page structure optimized for SEO and user experience\n✅ Rich media recommendations for improved engagement\n✅ Writing guidelines with specific detail level recommendations\n"
      },
      "typeVersion": 1
    },
    {
      "id": "22e206d0-4226-4c0d-abe0-a6bc8af1c1fc",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3968,
        752
      ],
      "parameters": {
        "color": 7,
        "width": 560,
        "height": 416,
        "content": "### What the system does:\n\nCombines all generated content (meta tags, H1, and content brief) into a unified data structure\nPreserves existing data while updating only the new SEO elements in the spreadsheet\nMaps output fields to corresponding Google Sheets columns (title, meta-desc, h1, brief)\nUpdates the original sheet using Google Sheets API with the generated content\nTriggers loop continuation to process the next keyword in the batch\nMaintains data integrity throughout the update process\n\n### Result:\n\n✅ Google Sheets automatically updated with generated SEO content\n✅ Original data preserved with new SEO elements added\n✅ Batch processing continues until all keywords are processed\n✅ Complete SEO content package ready for implementation\n✅ Workflow loops back for additional keywords in the queue"
      },
      "typeVersion": 1
    },
    {
      "id": "4a6e883c-ada1-4a1c-a0c0-7c50772d2e45",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -192,
        -80
      ],
      "parameters": {
        "width": 816,
        "height": 336,
        "content": "## Need more advanced automation solutions? Contact us for custom enterprise workflows!\n\n# Growth-AI.fr\n\n## https://www.linkedin.com/in/allanvaccarizi/\n## https://www.linkedin.com/in/hugo-marinier-%F0%9F%A7%B2-6537b633/"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {
    "When chat message received": [
      {
        "action": "sendMessage",
        "chatInput": "t",
        "sessionId": "bae7e54a70ab4df5a59a2f8841897496"
      }
    ]
  },
  "connections": {
    "If1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code": {
      "main": [
        [
          {
            "node": "Update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apify": {
      "main": [
        [
          {
            "node": "Scrape 1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter1": {
      "main": [
        [
          {
            "node": "If1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Titre 1": {
      "main": [
        [
          {
            "node": "Scrape 2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Titre 2": {
      "main": [
        [
          {
            "node": "Scrape 3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Titre 3": {
      "main": [
        [
          {
            "node": "Scrape 4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Titre 4": {
      "main": [
        [
          {
            "node": "Scrape 5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Titre 5": {
      "main": [
        [
          {
            "node": "Meta tag + h1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape 1": {
      "main": [
        [
          {
            "node": "Titre 1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape 2": {
      "main": [
        [
          {
            "node": "Titre 2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape 3": {
      "main": [
        [
          {
            "node": "Titre 3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape 4": {
      "main": [
        [
          {
            "node": "Titre 4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Scrape 5": {
      "main": [
        [
          {
            "node": "Titre 5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Content brief": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Meta tag + h1": {
      "main": [
        [
          {
            "node": "Content brief",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Apify",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "SEO information": {
      "main": [
        [
          {
            "node": "Filter1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Client Information": {
      "main": [
        [
          {
            "node": "SEO information",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update row in sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Anthropic Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "Content brief",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Anthropic Chat Model2": {
      "ai_languageModel": [
        [
          {
            "node": "Meta tag + h1",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser2": {
      "ai_outputParser": [
        [
          {
            "node": "Meta tag + h1",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "When chat message received": {
      "main": [
        [
          {
            "node": "Client Information",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Related Workflows

Automate Social Media Content Creation with Google Gemini & OpenAI

Streamline your social media content strategy with an automated workflow using Google Gemini and OpenAI GPT. This solution allows social media managers to generate, schedule, and publish posts across Facebook, Instagram, and LinkedIn seamlessly, saving hours of manual work each week. Features real-time content generation, intelligent scheduling, and integration with Facebook Graph API and Twitter API for effective outreach. Perfect for social media managers handling multiple accounts and needing consistent, engaging content for their audience. Requires 9 accounts: Google Palm API, OpenAI API, Facebook Graph API, and more. Experience up to 70% faster content creation and manage over 30 posts daily with AI-driven insights.

271,744 views
Social MediaMultimodal AI

Automate AI Video Creation with Google Sheets and OpenAI for TikTok

Automate the generation of AI videos for TikTok, YouTube, and Instagram using the Google Sheets API and OpenAI GPT. Leverage structured data from Google Sheets to create engaging video content effortlessly. Features seamless integration with multiple platforms, automatic content generation, and real-time video uploads. Perfect for digital marketers, content creators, and social media managers looking to enhance their video production workflow. Requires 3 accounts: Google Sheets OAuth, OpenAI API, and Blotato API. Save up to 10 hours weekly by automating video creation and uploads, allowing you to focus on strategy and engagement.

220,201 views
Content CreationMultimodal AI

Automate Video Creation with Google Sheets & OpenAI for YouTube Uploads

Automate your video creation process using Google Sheets and OpenAI GPT to generate content, then seamlessly upload videos to YouTube via the Google Drive API. This workflow simplifies the video production cycle from concept to publication. Features include real-time content generation with GPT, automated scheduling for uploads, and integration with Google Sheets for data management. Perfect for content creators managing multiple video projects or marketing teams needing consistent video output. Requires 3 accounts: Google Sheets OAuth, Google Drive OAuth, OpenAI API Key. Save up to 10 hours weekly by automating video creation and uploads, enabling you to focus on strategy and engagement.

196,042 views
Content CreationMultimodal AI

Automate Short-Form Video Creation with OpenAI, Google Drive, and Discord

Automate the generation of short-form videos using AI with OpenAI and seamlessly upload them to social networks using Google Drive API. This workflow integrates automated video creation, storage, and distribution to save your team time and streamline content production. Features include real-time video rendering, automatic uploads to multiple platforms, and integration with Google Sheets for analytics tracking. Perfect for marketing teams and content creators looking to enhance their social media presence without manual effort. Requires 4 accounts: OpenAI API Key, Google Drive OAuth, Discord Webhook, and more. Save up to 10 hours a week by producing and distributing engaging video content effortlessly.

160,661 views
Content CreationMultimodal AI

How to Use This Workflow

1Import to n8n

  1. Copy the JSON using the button above
  2. Open your n8n instance
  3. Click “Import workflow” or press Ctrl+V
  4. Paste the JSON and click “Import”

2Before Running

Configure credentials and update service-specific settings before executing the workflow. Review required credentials in the Technical Details section above.

57