Kund:innen-Persönlichkeitsanalyse (Bazi, DISC, Astrologie) mit Gemini und Google Sheets

Experte

Dies ist ein Lead Generation, Multimodal AI-Bereich Automatisierungsworkflow mit 24 Nodes. Hauptsächlich werden If, Code, Merge, Filter, Aggregate und andere Nodes verwendet. Kundenpersönlichkeitsanalyse (Bazi, DISC, Astrologie) mit Gemini und Google Sheets

Voraussetzungen
  • Google Sheets API-Anmeldedaten
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "meta": {
    "instanceId": "783d2046f405cc6ecb20ef185376ed1023323a3da628b9d8156b1fb75c75e037"
  },
  "nodes": [
    {
      "id": "1830c823-4513-4ef3-90d2-c76c32574cbe",
      "name": "Google Tabellen Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -32,
        352
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "872f99cc-9a63-4f54-8e17-ef77a04d19ab",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        1200,
        848
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "b6f1df09-ff2a-4f8d-82b4-be386cf60e7e",
      "name": "If1",
      "type": "n8n-nodes-base.if",
      "position": [
        1200,
        656
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "8b03f1c0-4618-40aa-ae45-04db1c82fe82",
      "name": "If2",
      "type": "n8n-nodes-base.if",
      "position": [
        1200,
        448
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "c9372ec7-1152-479a-95b3-d2b3a2b2a9ff",
      "name": "Zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        2096,
        624
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "91c350a4-ae83-4973-b50f-584bd52032fe",
      "name": "Aggregieren",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        2096,
        832
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "21be391a-4121-4640-9889-3505a67f3e6d",
      "name": "Update row in sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1840,
        432
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "545ae9fb-af0a-4902-9112-ba923c106156",
      "name": "Update row in sheet2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1840,
        640
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "27578658-3119-4726-ba00-943e2b11b31f",
      "name": "Update row in sheet3",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1840,
        832
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "546a1f41-9bf6-4a93-99ad-4e5882d46d96",
      "name": "Update row in sheet4",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        880,
        176
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "d9a135fe-3522-4697-8638-abaffff61eca",
      "name": "Filter",
      "type": "n8n-nodes-base.filter",
      "position": [
        176,
        352
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "720d5e54-999d-4c37-b7ab-b117d00b1675",
      "name": "Über Elemente schleifen",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        880,
        352
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "f9e5cbfa-e82e-4d9e-b252-baffcb4433a9",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1200,
        224
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "ed97228e-8590-4a9f-8b92-07a07cfef0f7",
      "name": "Update row in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2208,
        224
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "5e06bfdc-4cce-4e24-9172-82e776b57231",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "bedb9097-a577-4705-9b82-0f8c9fc72b29",
      "name": "Compute Bazi",
      "type": "n8n-nodes-base.code",
      "position": [
        400,
        352
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "4a551a1b-faa8-4c36-a31c-28ea7dcf3857",
      "name": "Compute Numerology",
      "type": "n8n-nodes-base.code",
      "position": [
        640,
        352
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "02af4f4c-b58d-4284-bb58-1ca473cd8276",
      "name": "Numerology analysis",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        1456,
        432
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "49c88283-828a-46d2-8a9e-425e423739ec",
      "name": "Bazi Analysis",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        1456,
        640
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "1aa1c178-e987-4af3-939f-239cf6e7cd4d",
      "name": "DISC Analysis",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        1456,
        832
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ff31f356-4935-43e5-80a7-f83a752c093c",
      "name": "Summary Customer Insight",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        1456,
        224
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "92866b3d-681f-44f4-b395-9a9ffa193b10",
      "name": "Writing Script for Salers",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        1808,
        224
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5220ff92-68a2-4007-8c94-1285f4c2a1cd",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        512
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "63e91a2d-bd2b-40e9-8534-7880c9a89adb",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        768
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "872f99cc-9a63-4f54-8e17-ef77a04d19ab": {
      "main": [
        [
          {
            "node": "1aa1c178-e987-4af3-939f-239cf6e7cd4d",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "b6f1df09-ff2a-4f8d-82b4-be386cf60e7e": {
      "main": [
        [
          {
            "node": "49c88283-828a-46d2-8a9e-425e423739ec",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "8b03f1c0-4618-40aa-ae45-04db1c82fe82": {
      "main": [
        [
          {
            "node": "02af4f4c-b58d-4284-bb58-1ca473cd8276",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge": {
      "main": [
        [
          {
            "node": "Aggregate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d9a135fe-3522-4697-8638-abaffff61eca": {
      "main": [
        [
          {
            "node": "bedb9097-a577-4705-9b82-0f8c9fc72b29",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bedb9097-a577-4705-9b82-0f8c9fc72b29": {
      "main": [
        [
          {
            "node": "4a551a1b-faa8-4c36-a31c-28ea7dcf3857",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "49c88283-828a-46d2-8a9e-425e423739ec": {
      "main": [
        [
          {
            "node": "545ae9fb-af0a-4902-9112-ba923c106156",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1aa1c178-e987-4af3-939f-239cf6e7cd4d": {
      "main": [
        [
          {
            "node": "27578658-3119-4726-ba00-943e2b11b31f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "f9e5cbfa-e82e-4d9e-b252-baffcb4433a9",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "8b03f1c0-4618-40aa-ae45-04db1c82fe82",
            "type": "main",
            "index": 0
          },
          {
            "node": "b6f1df09-ff2a-4f8d-82b4-be386cf60e7e",
            "type": "main",
            "index": 0
          },
          {
            "node": "872f99cc-9a63-4f54-8e17-ef77a04d19ab",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4a551a1b-faa8-4c36-a31c-28ea7dcf3857": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          },
          {
            "node": "546a1f41-9bf6-4a93-99ad-4e5882d46d96",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f9e5cbfa-e82e-4d9e-b252-baffcb4433a9": {
      "main": [
        [
          {
            "node": "ff31f356-4935-43e5-80a7-f83a752c093c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "02af4f4c-b58d-4284-bb58-1ca473cd8276": {
      "main": [
        [
          {
            "node": "21be391a-4121-4640-9889-3505a67f3e6d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "21be391a-4121-4640-9889-3505a67f3e6d": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "545ae9fb-af0a-4902-9112-ba923c106156": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "27578658-3119-4726-ba00-943e2b11b31f": {
      "main": [
        [
          {
            "node": "Merge",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "d9a135fe-3522-4697-8638-abaffff61eca",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ff31f356-4935-43e5-80a7-f83a752c093c": {
      "main": [
        [
          {
            "node": "92866b3d-681f-44f4-b395-9a9ffa193b10",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "92866b3d-681f-44f4-b395-9a9ffa193b10": {
      "main": [
        [
          {
            "node": "ed97228e-8590-4a9f-8b92-07a07cfef0f7",
            "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 - Lead-Generierung, Multimodales KI

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.

Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes24
Kategorie2
Node-Typen10
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Autor
Cong Nguyen

Cong Nguyen

@cong-nguyen

I’m a developer specialized in building web and mobile applications with AI integration and intelligent automation. With a solid background in data science, I help businesses build smarter digital solutions using cutting-edge technologies.

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34