8
n8n Deutschamn8n.com

✍️ SEO- und Größen-Auditor für Blog-Bilder (Ghost und Google Sheets)

Fortgeschritten

Dies ist ein AI, Marketing-Bereich Automatisierungsworkflow mit 15 Nodes. Hauptsächlich werden Set, Code, Ghost, HttpRequest, GoogleSheets und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. ✍️ Auditor für Blog-Bilder-SEO und -Dimensionen (Ghost und Google Tabellen)

Voraussetzungen
  • •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • •Google Sheets API-Anmeldedaten

Verwendete Nodes (15)

Set
Code
Ghost
StickyNote
HttpRequest
GoogleSheets
ManualTrigger
SplitInBatches

Kategorie

Künstliche Intelligenz
Marketing
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "meta": {
    "instanceId": "",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "f20cd1d4-671c-420c-a25d-1c9fe05b67d9",
      "name": "Bei Klick auf 'Test Workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1000,
        -1030
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "edf80cc8-a4b3-42dd-96dc-c729d209aef9",
      "name": "Blogbeiträge extrahieren",
      "type": "n8n-nodes-base.ghost",
      "position": [
        -780,
        -1030
      ],
      "parameters": {
        "limit": 1,
        "options": {},
        "operation": "getAll"
      },
      "credentials": {
        "ghostContentApi": {
          "id": "",
          "name": ""
        }
      },
      "notesInFlow": true,
      "typeVersion": 1
    },
    {
      "id": "b2f0a448-5b73-499a-a78e-e69b75fc8f9d",
      "name": "Beitragsinhalt extrahieren",
      "type": "n8n-nodes-base.set",
      "position": [
        -560,
        -1030
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "00b337cd-1c61-4f19-8c51-b76f3a8dece1",
              "name": "id",
              "type": "string",
              "value": "={{ $json.id }}"
            },
            {
              "id": "8d38f4bc-bca6-4343-8c5e-5d9fd9cbe178",
              "name": "title",
              "type": "string",
              "value": "={{ $json.title }}"
            },
            {
              "id": "c34ddd76-0db6-4225-82fa-04d5542f9c7c",
              "name": "featured_image",
              "type": "string",
              "value": "={{ $json.feature_image }}"
            },
            {
              "id": "c0f9593c-0d5a-4659-9e25-91b098318bd6",
              "name": "excerpt",
              "type": "string",
              "value": "={{ $json.excerpt }}"
            },
            {
              "id": "0d11d3d5-49f8-473a-8602-b49769f88005",
              "name": "content",
              "type": "string",
              "value": "={{ $json.html }}"
            },
            {
              "id": "ec89a00d-9d76-4594-a8ce-98aa177e6737",
              "name": "link",
              "type": "string",
              "value": "={{ $json.url }}"
            }
          ]
        }
      },
      "notesInFlow": true,
      "typeVersion": 3.4
    },
    {
      "id": "e80bde5d-28c0-4fa7-a7ff-bff0fcddbf94",
      "name": "Über Elemente iterieren",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -360,
        -800
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "1052cc12-c1cd-468f-9cf7-33f73ff43642",
      "name": "Alle Bilder sammeln",
      "type": "n8n-nodes-base.code",
      "position": [
        500,
        -1300
      ],
      "parameters": {
        "jsCode": "const results = [];\n\nfor (const item of items) {\n  const articleUrl = item.json.link;\n  const articleTitle = item.json.title;\n  const articleId = item.json.id;\n  const html = item.json.content;\n\n  const imgRegex = /<img[^>]*src=\"([^\"]+)\"[^>]*alt=\"([^\"]*)\"?[^>]*>/g;\n  let match;\n\n  while ((match = imgRegex.exec(html)) !== null) {\n    const imageUrl = match[1];\n    const altText = match[2];\n\n    results.push({\n      json: {\n        articleId: articleId,\n        articleTitle: articleTitle,\n        article_url: articleUrl,\n        image_url: imageUrl,\n        alt_text: altText\n      }\n    });\n  }\n}\n\nreturn results;\n"
      },
      "typeVersion": 2
    },
    {
      "id": "b2176289-ded3-471c-bc8a-225dacc33aeb",
      "name": "Datensätze hinzufügen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        720,
        -1300
      ],
      "parameters": {
        "columns": {
          "value": {
            "alt_text": "={{ $json.alt_text }}",
            "articleId": "={{ $json.articleId }}",
            "image_url": "={{ $json.image_url }}",
            "article_url": "={{ $json.article_url }}",
            "articleTitle": "={{ $json.articleTitle }}"
          },
          "schema": [
            {
              "id": "articleId",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "articleId",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "articleTitle",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "articleTitle",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "article_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "article_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "image_url",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "image_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "alt_text",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "alt_text",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 886110184,
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Nk_2xwvK0ipSjnSbP50AQFc92IlHWaOkSK57-vt_3GY",
          "cachedResultUrl": "",
          "cachedResultName": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "",
          "name": ""
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "cdb245eb-a3e3-45d1-bcce-f1d0ce65297c",
      "name": "Datensätze nach ID sammeln",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -140,
        -760
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $json.id }}",
              "lookupColumn": "articleId"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 886110184,
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Nk_2xwvK0ipSjnSbP50AQFc92IlHWaOkSK57-vt_3GY",
          "cachedResultUrl": "",
          "cachedResultName": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "ePnaAS4PG1sN2E50",
          "name": "Google Sheets LogiGreenBot"
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "dbec4c36-c7e3-49ea-976d-cec6dee70f76",
      "name": "Über Elemente iterieren1",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        80,
        -760
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "0254622b-3593-4ad8-820c-f6e27e31c53c",
      "name": "Bild abrufen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        300,
        -780
      ],
      "parameters": {
        "url": "={{ $json.image_url }}",
        "options": {
          "response": {
            "response": {
              "responseFormat": "file"
            }
          }
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "bb2a182b-82ae-4263-b3ab-9a7e30a5b97c",
      "name": "Bildinformationen extrahieren",
      "type": "n8n-nodes-base.code",
      "position": [
        520,
        -780
      ],
      "parameters": {
        "mode": "runOnceForEachItem",
        "jsCode": "const base64 = $binary[\"data\"].data;\nconst fileName = $binary[\"data\"].fileName || 'unknown.png';\nconst extension = fileName.split('.').pop().toLowerCase();\nconst fileSizeKB = $binary[\"data\"].fileSize || 'unknown.png';\nconst size_ok = fileSizeKB <= 500 ? true : false;\n\nreturn {\n  json: {\n    file_name: fileName,\n    file_size_kb: fileSizeKB,\n    format: extension,\n    filename_seo: /[a-z0-9-]{3,}/.test(fileName) ? true : false,\n    size_ok: size_ok\n  }\n};\n"
      },
      "typeVersion": 2
    },
    {
      "id": "871e3d19-87c7-4dd6-a481-d83fc652478b",
      "name": "Ergebnisbilder",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        740,
        -680
      ],
      "parameters": {
        "columns": {
          "value": {
            "format": "={{ $json.format }}",
            "size_ok": "={{ $json.size_ok }}",
            "image_url": "={{ $('Get Image').item.json.image_url }}",
            "file_size_kb": "={{ $json.file_size_kb }}",
            "filename_seo": "={{ $json.filename_seo }}"
          },
          "schema": [
            {
              "id": "articleId",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "articleId",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "articleTitle",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "articleTitle",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "article_url",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "article_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "image_url",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "image_url",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "alt_text",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "alt_text",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "file_size_kb",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "file_size_kb",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "format",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "format",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "filename_seo",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "filename_seo",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "size_ok",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "size_ok",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "image_url"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 886110184,
          "cachedResultUrl": "",
          "cachedResultName": ""
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1Nk_2xwvK0ipSjnSbP50AQFc92IlHWaOkSK57-vt_3GY",
          "cachedResultUrl": "",
          "cachedResultName": ""
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "",
          "name": ""
        }
      },
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "ad236989-0707-40ca-885c-c5d5550d7954",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -820,
        -1380
      ],
      "parameters": {
        "color": 7,
        "width": 400,
        "height": 520,
        "content": "### 2. Extract Blog Posts Content\nThe Ghost node extracts all the posts of your blog with content and metadata. In the second node, we extract description, URL, content and features image url.\n\n#### How to setup?\n- **Ghost Account API**:\n   1. Add your Ghost Blog Account Credentials\n   2. Select the number of Blog Posts you want to collect\n  [Learn more about the Ghost Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.ghost)\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "8d296af6-9e32-4669-bacc-decab229847a",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1040,
        -1380
      ],
      "parameters": {
        "color": 7,
        "width": 200,
        "height": 520,
        "content": "### 1. Workflow Trigger\nThis workflow uses simple trigger.\n\n#### How to setup?\n*Nothing to do.*\n"
      },
      "typeVersion": 1
    },
    {
      "id": "092719b3-65d7-40b8-af99-36cd3f41ea55",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -1380
      ],
      "parameters": {
        "color": 7,
        "width": 1360,
        "height": 280,
        "content": "### 3. First Loop to Collect Images\nWe loop through all the articles extracted by the Ghost Node. For each article, this section will collect all the images of the article with their **image_url** and **alt_text**. The results will be recorded in a **Google Sheet**.\n\n#### How to setup?\n- **Record Long Break in the Google Sheet Node**:\n   1. Add your Google Sheet API credentials to access the Google Sheet file\n   2. Select the file using the list, an URL or an ID\n   3. Select the sheet in which you want to record the images information\n   4. Map the fields: **article_id**, **article_Title**, **article_url**, **image_url**, **alt_text**, **file_size_kb**, **format**, **filename_seo**\n  [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "71a03b91-fa30-4ede-88f4-f307b5fd7889",
      "name": "Haftnotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -1080
      ],
      "parameters": {
        "color": 7,
        "width": 1360,
        "height": 620,
        "content": "### 4. Second Loop to Extract Image Information\nWe loop through all the images in the article, for each image we **download** the content using the **HTTP request** node to record **image_size** in kilobytes and **image_name** in a Google Sheet. If the image size is higher than **500 kb**, it is flagged as **not ok**.\n#### How to setup?\n- **Record Image File Name and Size**:\n   1. Add your Google Sheet API credentials to access the Google Sheet file\n   2. Select the file using the list, an URL or an ID\n   3. Select the sheet in which you want to record the images information\n  [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n\n\n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "0254622b-3593-4ad8-820c-f6e27e31c53c": {
      "main": [
        [
          {
            "node": "bb2a182b-82ae-4263-b3ab-9a7e30a5b97c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b2176289-ded3-471c-bc8a-225dacc33aeb": {
      "main": [
        [
          {
            "node": "e80bde5d-28c0-4fa7-a7ff-bff0fcddbf94",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "871e3d19-87c7-4dd6-a481-d83fc652478b": {
      "main": [
        [
          {
            "node": "dbec4c36-c7e3-49ea-976d-cec6dee70f76",
            "type": "main",
            "index": 0
          },
          {
            "node": "e80bde5d-28c0-4fa7-a7ff-bff0fcddbf94",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e80bde5d-28c0-4fa7-a7ff-bff0fcddbf94": {
      "main": [
        [],
        [
          {
            "node": "1052cc12-c1cd-468f-9cf7-33f73ff43642",
            "type": "main",
            "index": 0
          },
          {
            "node": "cdb245eb-a3e3-45d1-bcce-f1d0ce65297c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "dbec4c36-c7e3-49ea-976d-cec6dee70f76": {
      "main": [
        [],
        [
          {
            "node": "0254622b-3593-4ad8-820c-f6e27e31c53c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1052cc12-c1cd-468f-9cf7-33f73ff43642": {
      "main": [
        [
          {
            "node": "b2176289-ded3-471c-bc8a-225dacc33aeb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "edf80cc8-a4b3-42dd-96dc-c729d209aef9": {
      "main": [
        [
          {
            "node": "b2f0a448-5b73-499a-a78e-e69b75fc8f9d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bb2a182b-82ae-4263-b3ab-9a7e30a5b97c": {
      "main": [
        [
          {
            "node": "871e3d19-87c7-4dd6-a481-d83fc652478b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b2f0a448-5b73-499a-a78e-e69b75fc8f9d": {
      "main": [
        [
          {
            "node": "e80bde5d-28c0-4fa7-a7ff-bff0fcddbf94",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cdb245eb-a3e3-45d1-bcce-f1d0ce65297c": {
      "main": [
        [
          {
            "node": "dbec4c36-c7e3-49ea-976d-cec6dee70f76",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f20cd1d4-671c-420c-a25d-1c9fe05b67d9": {
      "main": [
        [
          {
            "node": "edf80cc8-a4b3-42dd-96dc-c729d209aef9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten - Künstliche Intelligenz, Marketing

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Verwandte Workflows

✍️ KI-Agent zur Erstellung von Blog-Promotion-LinkedIn-Posts mit GPT-4o
✍️ KI-Agent zur Erstellung von Blog-Promotion-LinkedIn-Posts mit GPT-4o
Set
Code
Ghost
+
Set
Code
Ghost
13 NodesSamir Saci
Künstliche Intelligenz
🧑‍🦯 Barrierefreiheit von Websites mit GPT-4o und Google Tabellen verbessern
🧑‍🦯 Website-Barrierefreiheit mit GPT-4o und Google Tabellen verbessern
If
Set
Code
+
If
Set
Code
14 NodesSamir Saci
Produkt
🗞️ KI-gestützte Nachhaltigkeits-Marketing-Briefing (mit Gmail, GPT-4o)
🗞️ KI-gesteuertes Nachhaltigkeits-Marketing-Briefing (mit Gmail, GPT-4o)
If
Set
Code
+
If
Set
Code
21 NodesSamir Saci
Künstliche Intelligenz
EU-Event-Scraping mit Google Sheets
🏤 Scrapping von EU-Ereignissen mit Google Sheets
If
Set
Code
+
If
Set
Code
20 NodesSamir Saci
Künstliche Intelligenz
Meta-Werbeanzeigen-Bibliothek abrufen und mit Gemini-Videos analysieren, Daten in Google Sheets speichern
Verwenden Sie Gemini, um Videowerbung aus der Meta-Werbethemen-Sammlung zu analysieren und die Ergebnisse in Google Sheets zu speichern
Set
Code
Sort
+
Set
Code
Sort
24 NodesDaniel Setzermann
Künstliche Intelligenz
Mein Workflow 5
Automatisierte LinkedIn-Lead-Generierung mit personalisierter E-Mail-KI (unvollendet)
If
Set
Code
+
If
Set
Code
37 NodesMatthieu
Vertrieb
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes15
Kategorie2
Node-Typen8
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Autor
Samir Saci

Samir Saci

@samirsaci

Automation, AI and Analytics for Supply Chain & Business Optimization Helping businesses streamline operations using n8n, AI agents, and data science to enhance efficiency and sustainability. Linkedin: www.linkedin.com/in/samir-saci

Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34