Meta-Werbeanzeigen-Bibliothek abrufen und mit Gemini-Videos analysieren, Daten in Google Sheets speichern

Name: Meta-Werbeanzeigen-Bibliothek abrufen und mit Gemini-Videos analysieren, Daten in Google Sheets speichern
Rating: 4.5 (10 reviews)
Author: Daniel Setzermann

Experte

Dies ist ein AI, Marketing-Bereich Automatisierungsworkflow mit 24 Nodes. Hauptsächlich werden Set, Code, Sort, Wait, Limit und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Verwenden Sie Gemini, um Videowerbung aus der Meta-Werbethemen-Sammlung zu analysieren und die Ergebnisse in Google Sheets zu speichern

Voraussetzungen

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

Verwendete Nodes (24)

OutputParserStructured

Kategorie

Künstliche Intelligenz

Marketing

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Bei Klick auf 'Workflow testen'

Einstellungen

Über Elemente iterieren

Google Gemini Chat Model

Prompt bereinigen

Daten speichern

Structured Output Parsing Agent

Auf Upload-Verarbeitung warten

Werte für Gemini übergeben

Video zu Gemini hochladen

Video mit Gemini analysieren

Datei herunterladen

Dateityp zu Video ändern

Meta-Anzeigenbibliothek mit Apify crawlen

Relevante Felder übergeben

Structured Output Parser

Laufzeit in Tagen berechnen

Nach Reichweite oder Laufzeit sortieren

Nur Videoanzeigen filtern

Zu analysierende Videos begrenzen

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "Yfi6wLGrS1JxYNeN",
  "meta": {
    "instanceId": "e57685206b2ffad6bb88e99d036876c83d8c4db170e93fa79e832ec88de4560b",
    "templateCredsSetupCompleted": true
  },
  "name": "Scrape Meta Ad Library and analyze Video Ads with Gemini and store data to Google Sheets",
  "tags": [],
  "nodes": [
    {
      "id": "30c7e140-fafe-4ae7-9de9-a969857967d5",
      "name": "Bei Klick auf 'Workflow testen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -100,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d38614bf-bbcc-4619-bcc4-cb42a80a1148",
      "name": "Einstellungen",
      "type": "n8n-nodes-base.set",
      "position": [
        100,
        380
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "7bb34d03-5cf0-497a-bead-87df84661ffd",
      "name": "Über Elemente iterieren",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1960,
        380
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "d23fed5b-f230-4511-b4ea-76393617e740",
      "name": "Google Gemini Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "position": [
        3460,
        700
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e56dbefc-458f-40db-850e-f243740c5651",
      "name": "Prompt bereinigen",
      "type": "n8n-nodes-base.code",
      "position": [
        300,
        380
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "6dbce614-58ce-4389-be16-a117ba5b6032",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1f26b54d-d0c5-483b-b3cf-e5e971128f2e",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3260,
        300
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "e554fcd8-90f0-4f38-ad78-1b08f4cd4a82",
      "name": "Notiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3360,
        860
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "96359003-2cd3-4ebf-90aa-8be4c44f1949",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3640,
        320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3e3c13b8-063c-4e0d-99dd-93902646c197",
      "name": "Daten speichern",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        3860,
        440
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "717fa264-afc3-4e2f-a48a-f3101e3ccf97",
      "name": "Structured Output Parsing Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        3480,
        440
      ],
      "parameters": {},
      "retryOnFail": true,
      "typeVersion": 1.7
    },
    {
      "id": "a61b82eb-21bf-4a0a-8863-e3fd3321c280",
      "name": "Auf Upload-Verarbeitung warten",
      "type": "n8n-nodes-base.wait",
      "position": [
        3020,
        440
      ],
      "webhookId": "a0e5485e-3f3c-47c6-ab19-9b9dc6158ab5",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "b3a0113f-a5e4-45e6-b093-a61ec5933446",
      "name": "Werte für Gemini übergeben",
      "type": "n8n-nodes-base.set",
      "position": [
        2780,
        440
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "590f1356-4e6a-4e2a-aef4-9ec3c421b3bf",
      "name": "Video zu Gemini hochladen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2580,
        440
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "88d88a31-4137-40e9-8470-4fb247cfac27",
      "name": "Video mit Gemini analysieren",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        3240,
        440
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "2168902d-1a0c-4807-9e88-08b9349ba19a",
      "name": "Datei herunterladen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2200,
        440
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "4fc6c731-ac04-4b33-a7df-919bff17ddc1",
      "name": "Dateityp zu Video ändern",
      "type": "n8n-nodes-base.code",
      "position": [
        2380,
        440
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "9cb29e1e-be52-4f7d-90aa-c930d283d442",
      "name": "Meta-Anzeigenbibliothek mit Apify crawlen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        500,
        380
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "59a198fa-3859-41a0-806b-280e9b9dd72a",
      "name": "Relevante Felder übergeben",
      "type": "n8n-nodes-base.set",
      "position": [
        1720,
        380
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "ea30c850-3ae8-455e-9681-f42f59681a8a",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        3660,
        700
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "ac3ae0cd-8dda-4b38-858e-d3f4f21f7e5c",
      "name": "Laufzeit in Tagen berechnen",
      "type": "n8n-nodes-base.set",
      "position": [
        700,
        380
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "28d391b3-d708-43a1-9d4b-28da08bc8175",
      "name": "Nach Reichweite oder Laufzeit sortieren",
      "type": "n8n-nodes-base.sort",
      "position": [
        960,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "82f7bdd7-5d20-4431-9772-4255e21ea963",
      "name": "Nur Videoanzeigen filtern",
      "type": "n8n-nodes-base.filter",
      "position": [
        1200,
        380
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "b0a7273e-f540-49e9-98c2-f0437ea2749d",
      "name": "Zu analysierende Videos begrenzen",
      "type": "n8n-nodes-base.limit",
      "position": [
        1460,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "79ac2590-6d68-4f1d-adb5-2c2fb5541f90",
  "connections": {
    "d38614bf-bbcc-4619-bcc4-cb42a80a1148": {
      "main": [
        [
          {
            "node": "e56dbefc-458f-40db-850e-f243740c5651",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3e3c13b8-063c-4e0d-99dd-93902646c197": {
      "main": [
        [
          {
            "node": "7bb34d03-5cf0-497a-bead-87df84661ffd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e56dbefc-458f-40db-850e-f243740c5651": {
      "main": [
        [
          {
            "node": "9cb29e1e-be52-4f7d-90aa-c930d283d442",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2168902d-1a0c-4807-9e88-08b9349ba19a": {
      "main": [
        [
          {
            "node": "4fc6c731-ac04-4b33-a7df-919bff17ddc1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7bb34d03-5cf0-497a-bead-87df84661ffd": {
      "main": [
        [],
        [
          {
            "node": "2168902d-1a0c-4807-9e88-08b9349ba19a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "59a198fa-3859-41a0-806b-280e9b9dd72a": {
      "main": [
        [
          {
            "node": "7bb34d03-5cf0-497a-bead-87df84661ffd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "82f7bdd7-5d20-4431-9772-4255e21ea963": {
      "main": [
        [
          {
            "node": "b0a7273e-f540-49e9-98c2-f0437ea2749d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b3a0113f-a5e4-45e6-b093-a61ec5933446": {
      "main": [
        [
          {
            "node": "a61b82eb-21bf-4a0a-8863-e3fd3321c280",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "590f1356-4e6a-4e2a-aef4-9ec3c421b3bf": {
      "main": [
        [
          {
            "node": "b3a0113f-a5e4-45e6-b093-a61ec5933446",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b0a7273e-f540-49e9-98c2-f0437ea2749d": {
      "main": [
        [
          {
            "node": "59a198fa-3859-41a0-806b-280e9b9dd72a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4fc6c731-ac04-4b33-a7df-919bff17ddc1": {
      "main": [
        [
          {
            "node": "590f1356-4e6a-4e2a-aef4-9ec3c421b3bf",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d23fed5b-f230-4511-b4ea-76393617e740": {
      "ai_languageModel": [
        [
          {
            "node": "717fa264-afc3-4e2f-a48a-f3101e3ccf97",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "ea30c850-3ae8-455e-9681-f42f59681a8a": {
      "ai_outputParser": [
        [
          {
            "node": "717fa264-afc3-4e2f-a48a-f3101e3ccf97",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "88d88a31-4137-40e9-8470-4fb247cfac27": {
      "main": [
        [
          {
            "node": "717fa264-afc3-4e2f-a48a-f3101e3ccf97",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ac3ae0cd-8dda-4b38-858e-d3f4f21f7e5c": {
      "main": [
        [
          {
            "node": "28d391b3-d708-43a1-9d4b-28da08bc8175",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a61b82eb-21bf-4a0a-8863-e3fd3321c280": {
      "main": [
        [
          {
            "node": "88d88a31-4137-40e9-8470-4fb247cfac27",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "28d391b3-d708-43a1-9d4b-28da08bc8175": {
      "main": [
        [
          {
            "node": "82f7bdd7-5d20-4431-9772-4255e21ea963",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "717fa264-afc3-4e2f-a48a-f3101e3ccf97": {
      "main": [
        [
          {
            "node": "3e3c13b8-063c-4e0d-99dd-93902646c197",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9cb29e1e-be52-4f7d-90aa-c930d283d442": {
      "main": [
        [
          {
            "node": "ac3ae0cd-8dda-4b38-858e-d3f4f21f7e5c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "30c7e140-fafe-4ae7-9de9-a969857967d5": {
      "main": [
        [
          {
            "node": "d38614bf-bbcc-4619-bcc4-cb42a80a1148",
            "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?

Experte - 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.