AI-Powered Credit Card Recommendation System with OpenAI GPT, Telegram & Google Sheets
Experte
Dies ist ein AI Chatbot, Multimodal AI-Bereich Automatisierungsworkflow mit 31 Nodes. Hauptsächlich werden If, Set, Code, Merge, Switch und andere Nodes verwendet.
Voraussetzungen
- •Telegram Bot Token
- •Google Sheets API-Anmeldedaten
- •OpenAI API Key
Verwendete Nodes (31)
Kategorie
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": "7el5prnIFj3s0DOI",
"meta": {
"instanceId": "4864679018d565a892ca43ce23dcbf870b964133cd1081846447be064da60377",
"templateCredsSetupCompleted": true
},
"name": "Credit Card with Chatgpt Agent Prompt checks",
"tags": [],
"nodes": [
{
"id": "e869214b-4356-45f8-843a-1002fecfe015",
"name": "Frage-Text abrufen",
"type": "n8n-nodes-base.code",
"position": [
-704,
336
],
"parameters": {},
"typeVersion": 2
},
{
"id": "bc1e2374-5e1a-4bd0-8c96-85bfd94e1a00",
"name": "Frage senden",
"type": "n8n-nodes-base.telegram",
"position": [
-336,
288
],
"webhookId": "63909487-c99a-4b09-b80b-4a7d6347ed1d",
"parameters": {},
"credentials": {
"telegramApi": {
"id": "A4cdb9dt09U7Waiv",
"name": "Telegram account 2"
}
},
"typeVersion": 1.2
},
{
"id": "c3cc1299-ee15-496c-8a49-477f44669b3d",
"name": "Telegram",
"type": "n8n-nodes-base.telegram",
"position": [
-1040,
-80
],
"webhookId": "5c4c2d93-e4cb-4e3b-b9dd-38d1bf64b183",
"parameters": {},
"credentials": {
"telegramApi": {
"id": "A4cdb9dt09U7Waiv",
"name": "Telegram account 2"
}
},
"typeVersion": 1.2
},
{
"id": "c3008975-38de-4aca-ad1e-984dfcbb120e",
"name": "Ist Q7 beantwortet?",
"type": "n8n-nodes-base.if",
"position": [
-1056,
192
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "d17066e8-9fb1-42c5-91cf-9932695e3dea",
"name": "Kreditkarten abfragen",
"type": "n8n-nodes-base.googleSheets",
"position": [
-688,
-112
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "aec9f45b-29ef-476e-89a1-902ac19f16d5",
"name": "Q1–Q7 Eingaben bereinigen",
"type": "n8n-nodes-base.set",
"position": [
-688,
128
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4,
"alwaysOutputData": true
},
{
"id": "2e850a37-bd00-469a-850c-fc5d2af9b164",
"name": "Trigger: Eingehende Telegram Nachricht",
"type": "n8n-nodes-base.telegramTrigger",
"position": [
-1104,
-640
],
"webhookId": "8851cdd8-fd7a-4168-b34d-75d6a90536f8",
"parameters": {},
"credentials": {
"telegramApi": {
"id": "zOvTboLjszOmjhKj",
"name": "Telegram account 3"
}
},
"typeVersion": 1.2
},
{
"id": "022df149-16cb-4887-9b44-b17eda095d05",
"name": "Telegram Nachrichtentext extrahieren",
"type": "n8n-nodes-base.code",
"position": [
-880,
-640
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1618ceb8-9480-432f-b88d-7fe85e670b1c",
"name": "Benutzerstatus abfragen (Google Sheet)",
"type": "n8n-nodes-base.googleSheets",
"onError": "continueRegularOutput",
"position": [
-656,
-736
],
"parameters": {},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "ac8551bc-19aa-431b-9fbc-e3fd168310ea",
"name": "Eingehende Nachricht mit Status zusammenführen",
"type": "n8n-nodes-base.merge",
"position": [
-432,
-576
],
"parameters": {},
"typeVersion": 3.2,
"alwaysOutputData": true
},
{
"id": "36e658f2-1c7f-438b-a74e-88f0f48a8a0a",
"name": "Prüfen, ob Benutzer in DB existiert",
"type": "n8n-nodes-base.if",
"position": [
-208,
-576
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "6f5ed263-2d00-46f8-8cc2-b28f947bbda6",
"name": "Antwort für Google Sheet mappen & formatieren",
"type": "n8n-nodes-base.code",
"position": [
208,
-528
],
"parameters": {},
"typeVersion": 2
},
{
"id": "9d1cccbc-9d7e-41da-9f45-28bded82540a",
"name": "Metadaten aus Antwort extrahieren",
"type": "n8n-nodes-base.set",
"position": [
400,
-528
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "977b8392-ddb7-4063-afbe-cecccf8d23a6",
"name": "Vollständigen Benutzerstatus zur Verarbeitung anhängen",
"type": "n8n-nodes-base.code",
"position": [
592,
-544
],
"parameters": {},
"typeVersion": 2
},
{
"id": "6a7b940f-5271-4d75-9aec-a920a46b37ca",
"name": "Aktualisierten Status für nächsten Schritt zusammenführen",
"type": "n8n-nodes-base.merge",
"position": [
736,
-800
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "56c50495-7c4c-4768-b9ec-613194c1a480",
"name": "Vorherige Antworten übernehmen",
"type": "n8n-nodes-base.set",
"position": [
944,
-816
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "964192de-8ead-41df-85f4-a8a97cba0463",
"name": "Antwort in Google Sheet aktualisieren",
"type": "n8n-nodes-base.googleSheets",
"position": [
1136,
-800
],
"parameters": {},
"typeVersion": 4.6,
"alwaysOutputData": true
},
{
"id": "df3fa4be-5cb4-4cd2-a8cd-9518ccd68a21",
"name": "Neuen Benutzer in Google Sheet einfügen",
"type": "n8n-nodes-base.googleSheets",
"position": [
1088,
-560
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "9d8e2199-789d-4a74-a73a-bbf2053d2373",
"name": "Nächste Quizfrage bestimmen",
"type": "n8n-nodes-base.code",
"position": [
1328,
-624
],
"parameters": {},
"typeVersion": 2
},
{
"id": "a275010c-7616-4c2e-a44c-750ea4911145",
"name": "Prüfen, ob weitere Fragen vorhanden sind",
"type": "n8n-nodes-base.switch",
"position": [
-1264,
48
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "0425f294-897e-44d1-a487-ee491aebd545",
"name": "Benutzerprofil & Kreditkarten-Datensatz zusammenführen",
"type": "n8n-nodes-base.merge",
"position": [
-320,
80
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "9664c35e-3b1c-4f5e-92b3-fd52b2876869",
"name": "GPT Prompt mit Benutzerprofil & Kartendaten erstellen",
"type": "n8n-nodes-base.code",
"position": [
160,
112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "002101d2-7798-464b-8542-e014735c4b53",
"name": "Prompt an GPT zur Kartenabgleichung senden",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
352,
112
],
"parameters": {},
"credentials": {
"openAiApi": {
"id": "oCR84cjCbtgnT95o",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "cf11ccaf-40ee-4e44-89af-f4db4b93ac79",
"name": "GPT Ausgabe bereinigen & in Abschnitte teilen",
"type": "n8n-nodes-base.code",
"position": [
688,
112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "babdd4b6-5f2f-4c24-aa3a-358560f97744",
"name": "GPT Kartenempfehlungen für Telegram formatieren",
"type": "n8n-nodes-base.code",
"position": [
896,
112
],
"parameters": {},
"typeVersion": 2
},
{
"id": "e0fbd374-614c-4681-890a-a786b9ae0288",
"name": "Kartenempfehlungen an Telegram senden",
"type": "n8n-nodes-base.telegram",
"position": [
1120,
112
],
"webhookId": "2786061c-b68d-45cd-bd45-04e849068ad0",
"parameters": {},
"credentials": {
"telegramApi": {
"id": "zOvTboLjszOmjhKj",
"name": "Telegram account 3"
}
},
"typeVersion": 1.2
},
{
"id": "f0acc684-bdf0-4193-9cfc-05bee0d9697e",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
608
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d5123091-7314-45ad-a937-0e6ece77efd2",
"name": "Haftnotiz6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
-880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "2c6f97d4-261f-462f-a970-dafbc648f802",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "156beb71-93c6-4788-9dad-b735a6c4b7b4",
"name": "Haftnotiz7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1280,
-160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "60142bf7-eaf8-472d-bdfb-3a6cb79c1848",
"name": "Haftnotiz8",
"type": "n8n-nodes-base.stickyNote",
"position": [
16,
-160
],
"parameters": {},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Trigger: Incoming Telegram Message": [
{
"json": {
"message": {
"chat": {
"id": 5357385827,
"type": "private",
"username": "NishantPandita",
"last_name": "Pandita",
"first_name": "Nishant"
},
"date": 1752344698,
"from": {
"id": 5357385827,
"is_bot": false,
"username": "NishantPandita",
"last_name": "Pandita",
"first_name": "Nishant",
"language_code": "en"
},
"text": "Hello",
"message_id": 42
},
"update_id": 574139253
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "993b0eb6-0005-429e-8142-2c796c22e946",
"connections": {
"d17066e8-9fb1-42c5-91cf-9932695e3dea": {
"main": [
[
{
"node": "0425f294-897e-44d1-a487-ee491aebd545",
"type": "main",
"index": 0
}
]
]
},
"c3008975-38de-4aca-ad1e-984dfcbb120e": {
"main": [
[
{
"node": "d17066e8-9fb1-42c5-91cf-9932695e3dea",
"type": "main",
"index": 0
},
{
"node": "aec9f45b-29ef-476e-89a1-902ac19f16d5",
"type": "main",
"index": 0
}
],
[
{
"node": "e869214b-4356-45f8-843a-1002fecfe015",
"type": "main",
"index": 0
}
]
]
},
"e869214b-4356-45f8-843a-1002fecfe015": {
"main": [
[
{
"node": "bc1e2374-5e1a-4bd0-8c96-85bfd94e1a00",
"type": "main",
"index": 0
}
]
]
},
"aec9f45b-29ef-476e-89a1-902ac19f16d5": {
"main": [
[
{
"node": "0425f294-897e-44d1-a487-ee491aebd545",
"type": "main",
"index": 1
}
]
]
},
"36e658f2-1c7f-438b-a74e-88f0f48a8a0a": {
"main": [
[
{
"node": "6f5ed263-2d00-46f8-8cc2-b28f947bbda6",
"type": "main",
"index": 0
}
],
[
{
"node": "df3fa4be-5cb4-4cd2-a8cd-9518ccd68a21",
"type": "main",
"index": 0
}
]
]
},
"9d8e2199-789d-4a74-a73a-bbf2053d2373": {
"main": [
[
{
"node": "a275010c-7616-4c2e-a44c-750ea4911145",
"type": "main",
"index": 0
}
]
]
},
"9d1cccbc-9d7e-41da-9f45-28bded82540a": {
"main": [
[
{
"node": "977b8392-ddb7-4063-afbe-cecccf8d23a6",
"type": "main",
"index": 0
}
]
]
},
"022df149-16cb-4887-9b44-b17eda095d05": {
"main": [
[
{
"node": "1618ceb8-9480-432f-b88d-7fe85e670b1c",
"type": "main",
"index": 0
},
{
"node": "ac8551bc-19aa-431b-9fbc-e3fd168310ea",
"type": "main",
"index": 1
}
]
]
},
"964192de-8ead-41df-85f4-a8a97cba0463": {
"main": [
[
{
"node": "9d8e2199-789d-4a74-a73a-bbf2053d2373",
"type": "main",
"index": 0
}
]
]
},
"56c50495-7c4c-4768-b9ec-613194c1a480": {
"main": [
[
{
"node": "964192de-8ead-41df-85f4-a8a97cba0463",
"type": "main",
"index": 0
}
]
]
},
"1618ceb8-9480-432f-b88d-7fe85e670b1c": {
"main": [
[
{
"node": "6a7b940f-5271-4d75-9aec-a920a46b37ca",
"type": "main",
"index": 0
},
{
"node": "ac8551bc-19aa-431b-9fbc-e3fd168310ea",
"type": "main",
"index": 0
}
]
]
},
"a275010c-7616-4c2e-a44c-750ea4911145": {
"main": [
[
{
"node": "c3008975-38de-4aca-ad1e-984dfcbb120e",
"type": "main",
"index": 0
}
],
[
{
"node": "c3cc1299-ee15-496c-8a49-477f44669b3d",
"type": "main",
"index": 0
}
]
]
},
"df3fa4be-5cb4-4cd2-a8cd-9518ccd68a21": {
"main": [
[
{
"node": "9d8e2199-789d-4a74-a73a-bbf2053d2373",
"type": "main",
"index": 0
}
]
]
},
"ac8551bc-19aa-431b-9fbc-e3fd168310ea": {
"main": [
[
{
"node": "36e658f2-1c7f-438b-a74e-88f0f48a8a0a",
"type": "main",
"index": 0
}
]
]
},
"6a7b940f-5271-4d75-9aec-a920a46b37ca": {
"main": [
[
{
"node": "56c50495-7c4c-4768-b9ec-613194c1a480",
"type": "main",
"index": 0
}
]
]
},
"0425f294-897e-44d1-a487-ee491aebd545": {
"main": [
[
{
"node": "9664c35e-3b1c-4f5e-92b3-fd52b2876869",
"type": "main",
"index": 0
}
]
]
},
"2e850a37-bd00-469a-850c-fc5d2af9b164": {
"main": [
[
{
"node": "022df149-16cb-4887-9b44-b17eda095d05",
"type": "main",
"index": 0
}
]
]
},
"6f5ed263-2d00-46f8-8cc2-b28f947bbda6": {
"main": [
[
{
"node": "9d1cccbc-9d7e-41da-9f45-28bded82540a",
"type": "main",
"index": 0
}
]
]
},
"002101d2-7798-464b-8542-e014735c4b53": {
"main": [
[
{
"node": "cf11ccaf-40ee-4e44-89af-f4db4b93ac79",
"type": "main",
"index": 0
}
]
]
},
"977b8392-ddb7-4063-afbe-cecccf8d23a6": {
"main": [
[
{
"node": "6a7b940f-5271-4d75-9aec-a920a46b37ca",
"type": "main",
"index": 1
}
]
]
},
"cf11ccaf-40ee-4e44-89af-f4db4b93ac79": {
"main": [
[
{
"node": "babdd4b6-5f2f-4c24-aa3a-358560f97744",
"type": "main",
"index": 0
}
]
]
},
"babdd4b6-5f2f-4c24-aa3a-358560f97744": {
"main": [
[
{
"node": "e0fbd374-614c-4681-890a-a786b9ae0288",
"type": "main",
"index": 0
}
]
]
},
"9664c35e-3b1c-4f5e-92b3-fd52b2876869": {
"main": [
[
{
"node": "002101d2-7798-464b-8542-e014735c4b53",
"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 - KI-Chatbot, 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.
Verwandte Workflows
Automatisierung für die Veröffentlichung und Terminbuchung von Haustierpflegediensten
Automatisierung von Veröffentlichungen und Terminen für Haustierpflege durch KI, Facebook und Telegram-Bots
If
Set
Switch
+
If
Set
Switch
36 NodesChristian Moises
KI-Chatbot
Telegram-Forum-Puls: Community-Monitoring mit Gemini und Groq AI-Modellen
Telegram-Forum-Puls: Community-Überwachung mit Gemini- und Groq-KI-Modellen
If
Set
Code
+
If
Set
Code
59 NodesNguyen Thieu Toan
Verschiedenes
Automatische Erzeugung von Social-Media-Beiträgen mit KI, Telegramm und mehrfacher Veröffentlichung basierend auf URLs
Automatisierte Erstellung von Social-Media-Beiträgen aus URLs mit KI, Telegram und Mehrplattform-Veröffentlichung
If
Set
Code
+
If
Set
Code
42 NodesKarol
Content-Erstellung
Kalt-E-Mail-Workflow mit GPT-4-Antrieb, mit vollständig angepasster Folge-E-Mail-Serie von 3 E-Mails
Automatisierung personalisierter Kalt-E-Mail-Serien mit GPT-4, Mailgun und Supabase
If
Set
Code
+
If
Set
Code
100 NodesPaul
Lead-Pflege
Multimodaler Telegram-KI-Assistent mit Gemini, Sprach- und Bildgenerierung bauen
Multimodalen Telegram-KI-Assistenten mit Gemini, Sprach- und Bildgenerierung bauen
If
Set
Code
+
If
Set
Code
95 NodesIniyavan JC
Persönliche Produktivität
Vollständiger B2B-Vertriebsprozess: Apollo Lead-Generierung, Mailgun-Outreach und KI-Antwortverwaltung
Vollständiger B2B-Vertriebsprozess: Apollo Lead-Generierung, Mailgun Outreach und AI-Antwortmanagement
If
Set
Code
+
If
Set
Code
116 NodesPaul
Content-Erstellung
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes31
Kategorie2
Node-Typen10
Autor
Nishant
@panditaExterne Links
Auf n8n.io ansehen →
Diesen Workflow teilen