Rückmeldung speichern und Bericht generieren
Experte
Dies ist ein CRM, AI Summarization-Bereich Automatisierungsworkflow mit 28 Nodes. Hauptsächlich werden Set, Code, EmailSend, GoogleSheets, ManualTrigger und andere Nodes verwendet. Analyse von Verkaufs Transaktions Ergebnissen mit Azure OpenAI und Google Sheets und Berichtserstellung
Voraussetzungen
- •Google Sheets API-Anmeldedaten
- •OpenAI API Key
Verwendete Nodes (28)
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"id": "INCHeFIxjP8eus8J",
"meta": {
"instanceId": "8443f10082278c46aa5cf3acf8ff0f70061a2c58bce76efac814b16290845177",
"templateCredsSetupCompleted": true
},
"name": "Feedback save and report generation",
"tags": [],
"nodes": [
{
"id": "e47ac8b4-ccb8-49df-82f0-05fdbff7828a",
"name": "Notizen/E-Mails extrahieren",
"type": "n8n-nodes-base.code",
"position": [
16,
112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "9cb26417-5674-44cb-ab6f-28c44b168094",
"name": "KI-Antwort analysieren",
"type": "n8n-nodes-base.code",
"position": [
1264,
-224
],
"parameters": {},
"typeVersion": 2
},
{
"id": "60a74709-38da-48d6-9227-eeed1734c0f6",
"name": "In Google Sheets speichern",
"type": "n8n-nodes-base.googleSheets",
"position": [
1488,
-96
],
"parameters": {},
"typeVersion": 4
},
{
"id": "3f508420-a1a3-4a46-b07b-a6bd0664f789",
"name": "Google Sheet-Daten abrufen",
"type": "n8n-nodes-base.googleSheets",
"position": [
448,
480
],
"parameters": {},
"typeVersion": 4
},
{
"id": "5bb2b739-60d9-4043-9771-979ad1c593da",
"name": "Aktuelle Daten filtern",
"type": "n8n-nodes-base.code",
"position": [
1232,
416
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a06f354f-3cdc-47bf-9ef3-c25b76135778",
"name": "E-Mail-Zusammenfassung senden",
"type": "n8n-nodes-base.emailSend",
"position": [
1472,
416
],
"webhookId": "2fd9cd32-4351-49a0-ba18-310a17f086b5",
"parameters": {},
"typeVersion": 2
},
{
"id": "073e3c65-5662-4c40-8f7c-abb1b5d54030",
"name": "Bei Klick auf 'Workflow ausführen'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-432,
112
],
"parameters": {},
"typeVersion": 1
},
{
"id": "38f26876-4138-49fc-8f79-93ac5ad7876d",
"name": "Zeile(n) in Sheet abrufen",
"type": "n8n-nodes-base.googleSheets",
"position": [
-208,
112
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "dd009347-1c1e-4d77-880f-98a1268feab6",
"name": "KI-Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
432,
-368
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "3914f8f7-955b-4464-9548-89f6b79f67bb",
"name": "Azure OpenAI Chat-Modell",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
464,
-208
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c59c230c-fb7d-47ea-aa19-210c5b65dccd",
"name": "Über Elemente iterieren",
"type": "n8n-nodes-base.splitInBatches",
"position": [
240,
112
],
"parameters": {},
"typeVersion": 3
},
{
"id": "62ebbddb-b10b-4af2-ae56-4e642e5cd610",
"name": "Felder bearbeiten",
"type": "n8n-nodes-base.set",
"position": [
896,
-368
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "d114ef1f-19de-49ce-92c6-df5e75c187c2",
"name": "KI-Agent1",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
752,
416
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "5529bf2c-a211-43bb-8a1a-1c2027fb7daf",
"name": "Azure OpenAI Chat-Modell1",
"type": "@n8n/n8n-nodes-langchain.lmChatAzureOpenAi",
"position": [
832,
592
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d1043f1a-2691-4f2f-a5e9-108431e7a7f8",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-720,
0
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d232025f-784f-4ef6-8a4d-d0b62a7bd651",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-256
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "222b661a-1825-42f0-9548-b4c7a35928b5",
"name": "Haftnotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
304
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bfc6fdc7-1535-4849-8995-8cbabb4b4db5",
"name": "Haftnotiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
48,
-320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3d1bbe23-6654-4708-9088-3e931e8da497",
"name": "Haftnotiz4",
"type": "n8n-nodes-base.stickyNote",
"position": [
448,
-752
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "33538927-39dd-4cbe-8e7b-a8cf69bdad23",
"name": "Haftnotiz5",
"type": "n8n-nodes-base.stickyNote",
"position": [
592,
-176
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2bd5d02c-5fbc-4b0b-8526-3222daeef829",
"name": "Haftnotiz6",
"type": "n8n-nodes-base.stickyNote",
"position": [
832,
-704
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "db617a0c-d9d3-4e46-b305-c471b35884e1",
"name": "Haftnotiz7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1216,
-608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "1c2fd82b-2067-43c8-8a6b-2eaaa00e20aa",
"name": "Haftnotiz8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1584,
-432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e87af0fc-8734-47d6-8630-d20cee16d6bc",
"name": "Haftnotiz9",
"type": "n8n-nodes-base.stickyNote",
"position": [
416,
704
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "e8d0fdf6-e192-4d2d-ba57-e38f413fde9d",
"name": "Haftnotiz10",
"type": "n8n-nodes-base.stickyNote",
"position": [
752,
144
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4ac6d3a4-4c29-4fea-adb8-28bff7c90f9d",
"name": "Haftnotiz11",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
752
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "3ecd8bc0-6e57-40c1-bee9-ecce4253097b",
"name": "Haftnotiz12",
"type": "n8n-nodes-base.stickyNote",
"position": [
1184,
608
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "007b3968-5938-4abf-b369-16e119de46c9",
"name": "Haftnotiz13",
"type": "n8n-nodes-base.stickyNote",
"position": [
1664,
256
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "1552e070-ec28-47ce-b4e6-41c3fd0dd004",
"connections": {
"dd009347-1c1e-4d77-880f-98a1268feab6": {
"main": [
[
{
"node": "62ebbddb-b10b-4af2-ae56-4e642e5cd610",
"type": "main",
"index": 0
}
]
]
},
"d114ef1f-19de-49ce-92c6-df5e75c187c2": {
"main": [
[
{
"node": "5bb2b739-60d9-4043-9771-979ad1c593da",
"type": "main",
"index": 0
}
]
]
},
"62ebbddb-b10b-4af2-ae56-4e642e5cd610": {
"main": [
[
{
"node": "9cb26417-5674-44cb-ab6f-28c44b168094",
"type": "main",
"index": 0
}
]
]
},
"c59c230c-fb7d-47ea-aa19-210c5b65dccd": {
"main": [
[
{
"node": "3f508420-a1a3-4a46-b07b-a6bd0664f789",
"type": "main",
"index": 0
}
],
[
{
"node": "dd009347-1c1e-4d77-880f-98a1268feab6",
"type": "main",
"index": 0
}
]
]
},
"9cb26417-5674-44cb-ab6f-28c44b168094": {
"main": [
[
{
"node": "60a74709-38da-48d6-9227-eeed1734c0f6",
"type": "main",
"index": 0
}
]
]
},
"a06f354f-3cdc-47bf-9ef3-c25b76135778": {
"main": [
[]
]
},
"5bb2b739-60d9-4043-9771-979ad1c593da": {
"main": [
[
{
"node": "a06f354f-3cdc-47bf-9ef3-c25b76135778",
"type": "main",
"index": 0
}
]
]
},
"38f26876-4138-49fc-8f79-93ac5ad7876d": {
"main": [
[
{
"node": "e47ac8b4-ccb8-49df-82f0-05fdbff7828a",
"type": "main",
"index": 0
}
]
]
},
"e47ac8b4-ccb8-49df-82f0-05fdbff7828a": {
"main": [
[
{
"node": "c59c230c-fb7d-47ea-aa19-210c5b65dccd",
"type": "main",
"index": 0
}
]
]
},
"60a74709-38da-48d6-9227-eeed1734c0f6": {
"main": [
[
{
"node": "c59c230c-fb7d-47ea-aa19-210c5b65dccd",
"type": "main",
"index": 0
}
]
]
},
"3914f8f7-955b-4464-9548-89f6b79f67bb": {
"ai_languageModel": [
[
{
"node": "dd009347-1c1e-4d77-880f-98a1268feab6",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"3f508420-a1a3-4a46-b07b-a6bd0664f789": {
"main": [
[
{
"node": "d114ef1f-19de-49ce-92c6-df5e75c187c2",
"type": "main",
"index": 0
}
]
]
},
"5529bf2c-a211-43bb-8a1a-1c2027fb7daf": {
"ai_languageModel": [
[
{
"node": "d114ef1f-19de-49ce-92c6-df5e75c187c2",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"073e3c65-5662-4c40-8f7c-abb1b5d54030": {
"main": [
[
{
"node": "38f26876-4138-49fc-8f79-93ac5ad7876d",
"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 - Kundenbeziehungsmanagement, KI-Zusammenfassung
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
YouTube-Kanal mit GPT-4o-mini und Gmail analysieren und Performance-Bericht senden
GPT-4o-mini und Gmail zur Analyse eines YouTube-Kanals und zur Sendingung von Leistungsberichten verwenden
Code
Email Send
Http Request
+
Code
Email Send
Http Request
20 NodesRahul Joshi
Marktforschung
API-Ratenbegrenzung und Authentifizierungs-FAQ-Tests
Automatisierte Qualitätstests für API-Häufig gestellte Fragen mit GPT-4o-mini, Google Sheets und Slack-Benachrichtigungen
If
Set
Code
+
If
Set
Code
19 NodesRahul Joshi
Dokumentenextraktion
Automatisierte Tracking-Abhängigkeitsaktualisierung
Abhängigkeitsaktualisierungsrisikoanalyse mit GPT-4o, Slack, Jira und Google Sheets
If
Set
Code
+
If
Set
Code
23 NodesRahul Joshi
DevOps
Vorschlagsgenerierung_Entwurfsspeicher-Automatisierung
Mit Azure GPT-4o Geschäftsvorschläge erstellen und aus Sheets als Gmail-Entwurf speichern
If
Code
Gmail
+
If
Code
Gmail
16 NodesRahul Joshi
Kundenbeziehungsmanagement
Intelligente Lead-Markierung und -Routing
KI-gesteuerte Lead-Klassifizierung und -Routing basierend auf HighLevel und Azure GPT-4o-mini
If
Code
Email Send
+
If
Code
Email Send
17 NodesRahul Joshi
Lead-Generierung
Personalisierte Absage/Nächste-Schritt-E-Mails
Automatisierte Kandidatenablehnung mit Google Sheets, GPT-4o-mini, Gmail und ClickUp
If
Set
Code
+
If
Set
Code
38 NodesRahul Joshi
Personalwesen
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes28
Kategorie2
Node-Typen9
Autor
Rahul Joshi
@rahul08Rahul Joshi is a seasoned technology leader specializing in the n8n automation tool and AI-driven workflow automation. With deep expertise in building open-source workflow automation and self-hosted automation platforms, he helps organizations eliminate manual processes through intelligent n8n ai agent automation solutions.
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen