planeta ai logo
Darmowy szablon automatyzacji

Twórz ankiety satysfakcji z produktu za pomocą Telegramu, Arkuszy Google i sztucznej inteligencji

3211
27 dni temu
40
bloków

Opis automatyzacji ankiety satysfakcji produktowej w n8n

Ten szablon n8n wykorzystuje bota Telegram do przeprowadzania ankiety satysfakcji produktowej. Pobiera pytania z arkusza Google i zapisuje odpowiedzi, wykorzystując dodatkowo agenta AI do zadawania pytań pogłębiających w celu uzyskania bardziej szczegółowych informacji od użytkowników.

Jak to działa

  • Rozpoczyna się sesja czatu z użytkownikiem, który musi wprowadzić komendę "/next", aby rozpocząć ankietę
  • Szablon pobiera pytania z arkusza Google i zadaje je użytkownikowi w kolejności od lewej do prawej kolumny
  • Po udzieleniu odpowiedzi, węzeł klasyfikatora tekstu określa, czy należy zadać pytanie pogłębiające
  • W przypadku pozytywnej decyzji, agent AI inicjuje mini-konwersację w celu uzyskania dodatkowych szczegółów
  • Wszystkie odpowiedzi i mini-konwersacje są rejestrowane w arkuszu Google
  • Po zakończeniu ankiety użytkownik ma możliwość jej ponownego rozpoczęcia

Przykłady zastosowań

Ten szablon automatyzacji może być wykorzystany w różnych scenariuszach związanych z badaniem opinii i zbieraniem informacji od klientów. Oto kilka potencjalnych zastosowań:

  • Badanie satysfakcji klientów po zakupie produktu
  • Zbieranie feedbacku dotyczącego jakości usług
  • Ankiety dotyczące nowych funkcji produktu
  • Badanie potrzeb i preferencji klientów
  • Zbieranie opinii o wydarzeniach lub szkoleniach
  • Ocena skuteczności kampanii marketingowych
  • Monitorowanie lojalności klientów

Wymagania

  • Telegram do obsługi bota
  • Arkusz Google do przechowywania pytań i odpowiedzi
  • Redis do zarządzania stanem i pamięcią czatu
  • Licencja Community+ lub wyższa dla węzła Execution data (można go usunąć)

Jak używać

  • Skonfiguruj bota Telegram
  • Utwórz arkusz Google z kolumną ID i pytaniami ankiety
  • Zapewnij dostęp do instancji Redis (np. przez Upstash)
  • Zaktualizuj węzeł "Set Variable" o ID arkusza i tytuł ankiety
  • Udostępnij bota uczestnikom ankiety

Dostosowywanie workflow

  • Możliwość użycia innych platform czatowych (WhatsApp, WeChat)

    • li>Wzorzec zarządzania stanem można zastosować do innych typów ankiet

  • Możliwość modyfikacji dla różnych scenariuszy badawczych

   Skopiuj kod szablonu   
{"meta":{"instanceId":"408f9fb9940c3cb18ffdef0e0150fe342d6e655c3a9fac21f0f644e8bedabcd9","templateCredsSetupCompleted":true},"nodes":[{"id":"c537229c-ffdf-4a4b-8cdd-1d88621e58a0","name":"Telegram Trigger","type":"n8n-nodes-base.telegramTrigger","position":[-1060,2060],"webhookId":"1b9f2217-7c53-4440-b62b-aafcf1e1d45d","parameters":{"updates":["message"],"additionalFields":{}},"credentials":{"telegramApi":{"id":"wJqs1eMdbjilZH1W","name":"jimleuk_ai_survey_demo_bot"}},"typeVersion":1.1},{"id":"90426896-35d8-4449-8607-70e8485441ed","name":"Send Next Question","type":"n8n-nodes-base.telegram","position":[2560,1900],"webhookId":"4306c719-0b05-4986-8ea8-8bcda06e0ad1","parameters":{"text":"={{ $('Get Survey State1').first().json.next_question_idx }}. {{ Object.values($('Get Columns1').first().json)[$('Get Survey State1').first().json.next_question_idx+1] }}","chatId":"={{ $('Telegram Trigger').first().json.message.chat.id }}","additionalFields":{"appendAttribution":false}},"credentials":{"telegramApi":{"id":"wJqs1eMdbjilZH1W","name":"jimleuk_ai_survey_demo_bot"}},"typeVersion":1.2},{"id":"614b6d06-7bca-4710-aebf-3a2a685ace09","name":"Send Response","type":"n8n-nodes-base.telegram","position":[1540,2540],"webhookId":"dd1c616f-891c-48d4-8828-e612b13bca63","parameters":{"text":"={{ $('Interview Agent1').first().json.output }}","chatId":"={{ $('Telegram Trigger').first().json.message.chat.id }}","additionalFields":{"appendAttribution":false}},"credentials":{"telegramApi":{"id":"wJqs1eMdbjilZH1W","name":"jimleuk_ai_survey_demo_bot"}},"typeVersion":1.2},{"id":"c7f7acc4-c3f7-4fae-98dd-25dca9caae8b","name":"Has No Record?","type":"n8n-nodes-base.if","position":[60,2260],"parameters":{"options":{},"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"a9f08592-d870-44a4-a7f9-d70193cf721b","operator":{"type":"object","operation":"empty","singleValue":true},"leftValue":"={{ $json }}","rightValue":""}]}},"typeVersion":2.2},{"id":"207a2647-56eb-419a-8269-9a32edabe43a","name":"Is Survey Continue?","type":"n8n-nodes-base.if","position":[1980,2060],"parameters":{"options":{},"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"5685829b-a2b2-42c8-b6bc-22eaa03db1d2","operator":{"type":"boolean","operation":"false","singleValue":true},"leftValue":"={{ $('Increment Index1').item.json.is_survey_complete }}","rightValue":""}]}},"typeVersion":2.2},{"id":"a8e98579-6afa-4d7d-859d-9e635a0a1b0c","name":"Get State2","type":"n8n-nodes-base.redis","position":[-520,2060],"parameters":{"key":"={{ $json.cacheKey }}","options":{},"operation":"get","propertyName":"data"},"credentials":{"redis":{"id":"zU4DA70qSDrZM1El","name":"Redis account (localhost)"}},"typeVersion":1},{"id":"8074143c-eab7-4146-937c-16c44ef40333","name":"Get Columns1","type":"n8n-nodes-base.googleSheets","position":[1440,2060],"parameters":{"options":{"dataLocationOnSheet":{"values":{"firstDataRow":1,"rangeDefinition":"specifyRange"}}},"sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1KMNqWWO36osZx7jF-i1UL53z2GZnCn9fiBjtlGpvWB4/edit#gid=0","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"id","value":"={{ $('Set Variables1').first().json.gsheetId }}"}},"credentials":{"googleSheetsOAuth2Api":{"id":"XHvC7jIRR8A2TlUl","name":"Google Sheets account"}},"typeVersion":4.5},{"id":"1f75f3fc-7893-444d-8a1e-59ec3d42ea1d","name":"Set Variables1","type":"n8n-nodes-base.set","position":[-880,2060],"parameters":{"options":{},"assignments":{"assignments":[{"id":"2140b769-2e90-4828-8022-1b0a9baf6e44","name":"title","type":"string","value":"Product Satisfaction Survey: DJI Mini 2"},{"id":"fb7110cb-82d3-4c95-81ba-ac97a26fe05e","name":"gsheetId","type":"string","value":"1KMNqWWO36osZx7jF-i1UL53z2GZnCn9fiBjtlGpvWB4"},{"id":"6d9c4b02-8326-49f4-ac22-24bdec7fdd67","name":"cacheKey","type":"string","value":"=survey_user_{{ $json.sessionId }}"}]}},"typeVersion":3.4},{"id":"a0c06eb9-46d6-4888-85b0-e9a31a31337b","name":"Message Type1","type":"n8n-nodes-base.switch","position":[-320,2060],"parameters":{"rules":{"values":[{"outputKey":"is_bot_command","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"f5fa8b7c-fdda-4c6d-b610-e243d6299598","operator":{"type":"boolean","operation":"true","singleValue":true},"leftValue":"={{ ['/start','/next', '/reset'].includes($('Telegram Trigger').first().json.message.text) }}","rightValue":"="}]},"renameOutput":true}]},"options":{"fallbackOutput":"extra","renameFallbackOutput":"is_normal_message"}},"typeVersion":3.2},{"id":"315585fe-d2e4-4cb1-9d0e-a3e8bc053da3","name":"Get Command1","type":"n8n-nodes-base.set","position":[-120,1760],"parameters":{"options":{},"assignments":{"assignments":[{"id":"73335bd3-ce50-46c5-8bcf-f7b8cd992208","name":"command","type":"string","value":"={{ $('Telegram Trigger').first().json.message.text.slice($('Telegram Trigger').first().json.message.entities[0].offset, $('Telegram Trigger').first().json.message.entities[0].length ) }}"}]}},"typeVersion":3.4},{"id":"7036d250-0271-4c93-9f60-01b9ccaf8be3","name":"Bot Actions1","type":"n8n-nodes-base.switch","position":[60,1760],"parameters":{"rules":{"values":[{"outputKey":"new_session","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"6f427c86-090d-429a-bc99-d2dd7753c153","operator":{"type":"boolean","operation":"true","singleValue":true},"leftValue":"={{ $('Get Command1').first().json.command === '/start' }}","rightValue":"/start"}]},"renameOutput":true},{"outputKey":"next_question","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"bca60df4-278d-4598-afc9-6e8ee61b7ac5","operator":{"type":"boolean","operation":"true","singleValue":true},"leftValue":"={{ $('Get Command1').first().json.command === '/next' }}","rightValue":""}]},"renameOutput":true}]},"options":{"fallbackOutput":"extra"}},"typeVersion":3.2},{"id":"fa755815-29c2-419e-8e36-51102ee88681","name":"Memory3","type":"@n8n/n8n-nodes-langchain.memoryRedisChat","position":[2220,2060],"parameters":{"sessionKey":"={{ $('Set Variables1').first().json.cacheKey }}_history","sessionIdType":"customKey","contextWindowLength":10},"credentials":{"redis":{"id":"zU4DA70qSDrZM1El","name":"Redis account (localhost)"}},"typeVersion":1.4},{"id":"a231e026-e5bf-4864-a57b-29d01e32e1a8","name":"Get Survey State1","type":"n8n-nodes-base.set","position":[1620,2060],"parameters":{"options":{},"assignments":{"assignments":[{"id":"6836a5aa-2b51-48cc-8d8f-d64a85d8a52f","name":"title","type":"string","value":"={{ Object.values($json)[1] }}"},{"id":"7b2fdf1b-4f55-4b55-be54-a7b97dd094cb","name":"num_questions","type":"number","value":"={{ Object.keys($json).length - 2 }}"},{"id":"dc6d5c41-0f35-49c9-b9c9-b6b4f2ceb66c","name":"next_question_idx","type":"number","value":"={{ (Number($('Get State3').first().json.data?.current_question_idx) || 0) + 1 }}"},{"id":"8b17703f-fbff-40d2-a7bb-d450f2edfea3","name":"is_survey_complete","type":"boolean","value":"={{ ((Number($('Get State3').first().json.data?.current_question_idx) || 0) + 1) >= (Object.keys($json).length - 1) }}"}]}},"executeOnce":true,"typeVersion":3.4},{"id":"a3bb744d-c59f-45a9-8b9d-3c291fa8d860","name":"Reset Agent Memory1","type":"@n8n/n8n-nodes-langchain.memoryManager","position":[2240,1900],"parameters":{"mode":"insert","messages":{"messageValues":[{"message":"=You are a curious and inquisitive researcher conducting a survey with a user.n* In this conversation, you are only interested in one of the questions from the survey which you will ask.n* When asking an open-ended question, converse with the user to dig deeper into their answer and reveal insights into the user's experience. Do not ask other questions which do not try to expand the user's answer to the initial question.n* If this is closed-ended question, it is okay to receive a static response and move on to the next question.n* Only the initial question is numbered, following questions or messages should not be numbered or bulletpointed.n* If the user goes off-topic, doesn't want to answer the question or wants to do something else which is not related to the survey, then ignore what they say/ask and politely repeat the question."},{"type":"ai","message":"={{ $('Get Survey State1').first().json.next_question_idx }}. {{ Object.values($('Get Columns1').first().json)[$('Get Survey State1').first().json.next_question_idx+1] }}"}]},"insertMode":"override"},"typeVersion":1.1},{"id":"b9d693b7-c139-45d8-b0d8-fd8134c7ba84","name":"Memory4","type":"@n8n/n8n-nodes-langchain.memoryRedisChat","position":[1120,2700],"parameters":{"sessionKey":"={{ $('Set Variables1').first().json.cacheKey }}_history","sessionIdType":"customKey","contextWindowLength":100},"credentials":{"redis":{"id":"zU4DA70qSDrZM1El","name":"Redis account (localhost)"}},"typeVersion":1.4},{"id":"c8fd56f5-c4c0-40cb-b727-07a94b633657","name":"Start Session1","type":"n8n-nodes-base.redis","position":[440,1620],"parameters":{"key":"={{ $('Set Variables1').first().json.cacheKey }}","value":"={{n{n "has_session": true,n "session_createdAt": $now,n "current_question_idx": 0n}n}}","keyType":"hash","operation":"set"},"credentials":{"redis":{"id":"zU4DA70qSDrZM1El","name":"Redis account (localhost)"}},"typeVersion":1},{"id":"02eaa2cf-512c-4526-948e-b68989b3a8f4","name":"Get State3","type":"n8n-nodes-base.redis","position":[1260,2060],"parameters":{"key":"={{ $('Set Variables1').first().json.cacheKey }}","options":{},"operation":"get","propertyName":"data"},"credentials":{"redis":{"id":"zU4DA70qSDrZM1El","name":"Redis account (localhost)"}},"typeVersion":1},{"id":"85631c2a-9317-4b14-92d1-895ac022eb70","name":"Increment Index1","type":"n8n-nodes-base.redis","position":[1800,2060],"parameters":{"key":"={{ $('Set Variables1').first().json.cacheKey }}","value":"={{n{n "current_question_idx": $json.next_question_idx < $json.num_questionsn ? $json.next_question_idxn : $json.num_questions,n "session_updated": $now,n}n}}","keyType":"hash","operation":"set"},"credentials":{"redis":{"id":"zU4DA70qSDrZM1El","name":"Redis account (localhost)"}},"typeVersion":1},{"id":"4464f6fe-d579-4e03-a8ca-918515d38b30","name":"Interview Agent1","type":"@n8n/n8n-nodes-langchain.agent","position":[1040,2540],"parameters":{"text":"={{ $('Telegram Trigger').first().json.message.text }}","options":{},"promptType":"define"},"typeVersion":1.7},{"id":"11ec3d5a-5f89-4a84-96ef-291526ae7365","name":"Get Record1","type":"n8n-nodes-base.googleSheets","position":[-120,2260],"parameters":{"options":{"returnFirstMatch":true},"filtersUI":{"values":[{"lookupValue":"={{ $('Telegram Trigger').first().json.message.from.id }}","lookupColumn":"ID"}]},"sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1KMNqWWO36osZx7jF-i1UL53z2GZnCn9fiBjtlGpvWB4/edit#gid=0","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"id","value":"={{ $('Set Variables1').first().json.gsheetId }}"}},"credentials":{"googleSheetsOAuth2Api":{"id":"XHvC7jIRR8A2TlUl","name":"Google Sheets account"}},"typeVersion":4.5,"alwaysOutputData":true},{"id":"665d58f8-ba2f-4d87-ae56-260333c5ecdf","name":"Append Responses1","type":"n8n-nodes-base.set","position":[440,2440],"parameters":{"options":{},"assignments":{"assignments":[{"id":"8069d106-0918-4bc3-9f49-789322129136","name":"payload","type":"string","value":"={{n[n Object.values($('Get Record1').first().json)[Number($('Get State2').first().json.data.current_question_idx || 0) + 1],n 'User: ' + $('Telegram Trigger').first().json.message.text,n].join('\n\n').trim()n}}"},{"id":"d25c278c-d3a9-4a5a-9f49-01ee3ca8285a","name":"cell","type":"string","value":"={{n'abcdefghijklmnopqrstuvxyz'.toUpperCase().split('')[$('Message Type1').first().json.data.current_question_idx]n}}{{ $('Get Record1').first().json.row_number }}"}]}},"typeVersion":3.4},{"id":"4771e9e4-8b79-4530-8c4a-6e7ab0623d98","name":"Update Answer2","type":"n8n-nodes-base.httpRequest","position":[1360,2540],"parameters":{"url":"=https://sheets.googleapis.com/v4/spreadsheets/{{ $('Set Variables1').first().json.gsheetId }}/values/Sheet1!{{ $('Append Responses1').first().json.cell }}","method":"PUT","options":{},"jsonBody":"={{n{n "range": `Sheet1!${$('Append Responses1').first().json.cell}`,n "majorDimension": "ROWS",n "values": [[n $('Append Responses1').first().json.payload + '\n\nAgent: ' + $('Interview Agent1').first().json.output]]n}n}}","sendBody":true,"sendQuery":true,"specifyBody":"json","authentication":"predefinedCredentialType","queryParameters":{"parameters":[{"name":"valueInputOption","value":"RAW"}]},"nodeCredentialType":"googleSheetsOAuth2Api"},"credentials":{"googleSheetsOAuth2Api":{"id":"XHvC7jIRR8A2TlUl","name":"Google Sheets account"}},"typeVersion":4.2},{"id":"b7094d87-97ce-4f1a-8d30-4d6d57d24477","name":"Get Last Bot Message1","type":"n8n-nodes-base.redis","position":[260,2440],"parameters":{"key":"={{ $('Set Variables1').item.json.cacheKey }}_history","options":{},"operation":"get","propertyName":"data"},"credentials":{"redis":{"id":"zU4DA70qSDrZM1El","name":"Redis account (localhost)"}},"typeVersion":1},{"id":"6dc77f41-6c3b-4358-82bc-2ea299ef69b2","name":"Update Answer3","type":"n8n-nodes-base.httpRequest","position":[1020,2180],"parameters":{"url":"=https://sheets.googleapis.com/v4/spreadsheets/{{ $('Set Variables1').first().json.gsheetId }}/values/Sheet1!{{ $('Append Responses1').first().json.cell }}","method":"PUT","options":{},"jsonBody":"={{n{n "range": `Sheet1!${$('Append Responses1').first().json.cell}`,n "majorDimension": "ROWS",n "values": [[$('Append Responses1').first().json.payload]]n}n}}","sendBody":true,"sendQuery":true,"specifyBody":"json","authentication":"predefinedCredentialType","queryParameters":{"parameters":[{"name":"valueInputOption","value":"RAW"}]},"nodeCredentialType":"googleSheetsOAuth2Api"},"credentials":{"googleSheetsOAuth2Api":{"id":"XHvC7jIRR8A2TlUl","name":"Google Sheets account"}},"typeVersion":4.2},{"id":"dd67ca61-b36c-4f9f-84fe-0b25d411e459","name":"Model2","type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","position":[1000,2700],"parameters":{"model":{"__rl":true,"mode":"list","value":"gpt-4o-mini"},"options":{}},"credentials":{"openAiApi":{"id":"8gccIjcuf3gvaoEr","name":"OpenAi account"}},"typeVersion":1.2},{"id":"57698127-eea0-434e-af3a-4d49db4a7f15","name":"Model3","type":"@n8n/n8n-nodes-langchain.lmChatOpenAi","position":[600,2600],"parameters":{"model":{"__rl":true,"mode":"list","value":"gpt-4o-mini"},"options":{}},"credentials":{"openAiApi":{"id":"8gccIjcuf3gvaoEr","name":"OpenAi account"}},"typeVersion":1.2},{"id":"bad16467-bb3c-4d50-9dd8-014bac25fd61","name":"Should Follow Up?1","type":"@n8n/n8n-nodes-langchain.textClassifier","position":[620,2440],"parameters":{"options":{},"inputText":"=AI: {{ $('Get Last Bot Message1').item.json.data?.first().parseJson().data.content ?? ''}}nUSER: {{ $('Telegram Trigger').first().json.message.text }}","categories":{"categories":[{"category":"should_not_ask_followup_questions","description":"=Eithern* The user was asked a close-ended question and gave an adequate static responsen* There are no further insights to be learned from the user's answer"},{"category":"should_ask_followup_questions","description":"=Either one ofn* There are possibly more insights to be learned from the user's answer if we enquire. hint: did the user explaied or justified their answer?n* The user didn't answer the question"}]}},"typeVersion":1},{"id":"86545380-9ff1-4815-bfaf-c4137fa00fda","name":"Execution Data2","type":"n8n-nodes-base.executionData","position":[-700,2060],"parameters":{"dataToSave":{"values":[{"key":"jobType","value":"=state_message"},{"key":"gsheetId","value":"={{ $json.gsheetId }}"},{"key":"title","value":"={{ $json.title }}"},{"key":"fromId","value":"={{ $('Telegram Trigger').item.json.message.from.id }}"}]}},"typeVersion":1},{"id":"ed16f03b-621e-4766-b8fd-f1f662b2dd0b","name":"Create Record2","type":"n8n-nodes-base.googleSheets","position":[260,2060],"parameters":{"columns":{"value":{"ID":"={{ $('Telegram Trigger').first().json.message.from.id }}"},"schema":[{"id":"ID","type":"string","display":true,"removed":false,"required":false,"displayName":"ID","defaultMatch":false,"canBeUsedToMatch":true},{"id":"What's your name?","type":"string","display":true,"removed":true,"required":false,"displayName":"What's your name?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"What were the main factors that influenced your decision to purchase the DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"What were the main factors that influenced your decision to purchase the DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Did you compare the DJI Mini 2 with other drone models before purchasing? If yes, which other drone models were you considering? ","type":"string","display":true,"removed":true,"required":false,"displayName":"Did you compare the DJI Mini 2 with other drone models before purchasing? If yes, which other drone models were you considering? ","defaultMatch":false,"canBeUsedToMatch":true},{"id":"What ultimately convinced you to choose the DJI Mini 2 over other options?","type":"string","display":true,"removed":true,"required":false,"displayName":"What ultimately convinced you to choose the DJI Mini 2 over other options?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How satisfied are you with the DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"How satisfied are you with the DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"What features do you like most about the DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"What features do you like most about the DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Are there any features you feel are missing or could be improved?","type":"string","display":true,"removed":true,"required":false,"displayName":"Are there any features you feel are missing or could be improved?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Have you experienced any technical issues with the DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"Have you experienced any technical issues with the DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How likely are you to recommend the DJI Mini 2 to others?","type":"string","display":true,"removed":true,"required":false,"displayName":"How likely are you to recommend the DJI Mini 2 to others?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Where did you purchase your DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"Where did you purchase your DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How was your overall purchase experience?","type":"string","display":true,"removed":true,"required":false,"displayName":"How was your overall purchase experience?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Did you find all the information you needed before purchasing?","type":"string","display":true,"removed":true,"required":false,"displayName":"Did you find all the information you needed before purchasing?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"If you interacted with DJI customer support, how would you rate the experience?","type":"string","display":true,"removed":true,"required":false,"displayName":"If you interacted with DJI customer support, how would you rate the experience?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How can DJI improve the Mini 2 or future drone models?","type":"string","display":true,"removed":true,"required":false,"displayName":"How can DJI improve the Mini 2 or future drone models?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How can DJI improve the overall shopping and customer service experience?","type":"string","display":true,"removed":true,"required":false,"displayName":"How can DJI improve the overall shopping and customer service experience?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Any additional comments or feedback?","type":"string","display":true,"removed":true,"required":false,"displayName":"Any additional comments or feedback?","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":["ID"],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{},"operation":"appendOrUpdate","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1KMNqWWO36osZx7jF-i1UL53z2GZnCn9fiBjtlGpvWB4/edit#gid=0","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"id","value":"={{ $('Set Variables1').first().json.gsheetId }}"}},"credentials":{"googleSheetsOAuth2Api":{"id":"XHvC7jIRR8A2TlUl","name":"Google Sheets account"}},"typeVersion":4.5,"alwaysOutputData":true},{"id":"f2119ef5-aef3-4b0f-80f5-1715a4afe3e0","name":"Sticky Note8","type":"n8n-nodes-base.stickyNote","position":[-1120,1820],"parameters":{"color":7,"width":760,"height":500,"content":"## 1. Initiate Survey by Inviting User to Chatn[Learn more about the chat trigger](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-langchain.chattrigger/)nnTo present the survey to the user, we'll use n8n's builtin hosted chat. Survey questions are predefined and pulled from Google Sheet. Finally, for state and session management such as tracking which question we're asking, we'll use Redis as it's a fast write and ready database suitable for our chat."},"typeVersion":1},{"id":"9e7ca15c-0e31-4d78-b8af-31fd6260cd61","name":"Send Start","type":"n8n-nodes-base.telegram","position":[600,1620],"webhookId":"c5d13268-df58-450b-84c4-a61cd2e027ed","parameters":{"text":"={{ $('Set Variables1').first().json.title }}.nWelcome! Thank you for taking the time to participate in our survey.nnYou'll be asked a couple of pre-defined questions. For each question, we may ask follow-up questions to better understand your situation. If you want to skip to the next question at any time, simply reply with the "/next". Your responses will be recorded.nnTo start the survey, simply reply with "/next".","chatId":"={{ $('Telegram Trigger').first().json.message.chat.id }}","additionalFields":{"appendAttribution":false}},"credentials":{"telegramApi":{"id":"wJqs1eMdbjilZH1W","name":"jimleuk_ai_survey_demo_bot"}},"typeVersion":1.2},{"id":"e8be2d00-39c8-4dd1-a597-813fc4bffe10","name":"Send Start1","type":"n8n-nodes-base.telegram","position":[260,1900],"webhookId":"c5d13268-df58-450b-84c4-a61cd2e027ed","parameters":{"text":"=Sorry, that command is unrecognised. The available options are /start or /next.","chatId":"={{ $('Telegram Trigger').first().json.message.chat.id }}","additionalFields":{"appendAttribution":false}},"credentials":{"telegramApi":{"id":"wJqs1eMdbjilZH1W","name":"jimleuk_ai_survey_demo_bot"}},"typeVersion":1.2},{"id":"153bbe8b-52bc-403c-ae5f-346060a5aac3","name":"Completed Survey","type":"n8n-nodes-base.telegram","position":[2220,2280],"webhookId":"409dbc48-4916-415b-8c1b-caf3b359e1e4","parameters":{"text":"=Done! Thank you for completing our survey.nTo start the survey again, use "/start".","chatId":"={{ $('Telegram Trigger').first().json.message.chat.id }}","additionalFields":{"appendAttribution":false}},"credentials":{"telegramApi":{"id":"wJqs1eMdbjilZH1W","name":"jimleuk_ai_survey_demo_bot"}},"typeVersion":1.2},{"id":"c2e39206-f586-4c90-aeb0-d6a141e81d1d","name":"Sticky Note2","type":"n8n-nodes-base.stickyNote","position":[-180,1540],"parameters":{"color":7,"width":420,"height":380,"content":"## 2. Handle Bot Commandsn[Learn more about the switch node](https://docs.n8n.io/integrations/builtin/core-nodes/n8n-nodes-base.switch/)nnOur chatbot can be a mix of traditional chat mechanics and AI agent. Using bot commands, gives the user some control over the flow of the conversation such as skipping to the next question or starting over the survey."},"typeVersion":1},{"id":"6b6241ae-17b7-4f0f-9c00-f5de4d62f692","name":"Create Record1","type":"n8n-nodes-base.googleSheets","position":[280,1620],"parameters":{"columns":{"value":{"ID":"={{ $('Telegram Trigger').first().json.message.from.id }}"},"schema":[{"id":"ID","type":"string","display":true,"removed":false,"required":false,"displayName":"ID","defaultMatch":false,"canBeUsedToMatch":true},{"id":"What's your name?","type":"string","display":true,"removed":true,"required":false,"displayName":"What's your name?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"What were the main factors that influenced your decision to purchase the DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"What were the main factors that influenced your decision to purchase the DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Did you compare the DJI Mini 2 with other drone models before purchasing? If yes, which other drone models were you considering? ","type":"string","display":true,"removed":true,"required":false,"displayName":"Did you compare the DJI Mini 2 with other drone models before purchasing? If yes, which other drone models were you considering? ","defaultMatch":false,"canBeUsedToMatch":true},{"id":"What ultimately convinced you to choose the DJI Mini 2 over other options?","type":"string","display":true,"removed":true,"required":false,"displayName":"What ultimately convinced you to choose the DJI Mini 2 over other options?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How satisfied are you with the DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"How satisfied are you with the DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"What features do you like most about the DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"What features do you like most about the DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Are there any features you feel are missing or could be improved?","type":"string","display":true,"removed":true,"required":false,"displayName":"Are there any features you feel are missing or could be improved?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Have you experienced any technical issues with the DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"Have you experienced any technical issues with the DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How likely are you to recommend the DJI Mini 2 to others?","type":"string","display":true,"removed":true,"required":false,"displayName":"How likely are you to recommend the DJI Mini 2 to others?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Where did you purchase your DJI Mini 2?","type":"string","display":true,"removed":true,"required":false,"displayName":"Where did you purchase your DJI Mini 2?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How was your overall purchase experience?","type":"string","display":true,"removed":true,"required":false,"displayName":"How was your overall purchase experience?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Did you find all the information you needed before purchasing?","type":"string","display":true,"removed":true,"required":false,"displayName":"Did you find all the information you needed before purchasing?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"If you interacted with DJI customer support, how would you rate the experience?","type":"string","display":true,"removed":true,"required":false,"displayName":"If you interacted with DJI customer support, how would you rate the experience?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How can DJI improve the Mini 2 or future drone models?","type":"string","display":true,"removed":true,"required":false,"displayName":"How can DJI improve the Mini 2 or future drone models?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"How can DJI improve the overall shopping and customer service experience?","type":"string","display":true,"removed":true,"required":false,"displayName":"How can DJI improve the overall shopping and customer service experience?","defaultMatch":false,"canBeUsedToMatch":true},{"id":"Any additional comments or feedback?","type":"string","display":true,"removed":true,"required":false,"displayName":"Any additional comments or feedback?","defaultMatch":false,"canBeUsedToMatch":true}],"mappingMode":"defineBelow","matchingColumns":["ID"],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{},"operation":"appendOrUpdate","sheetName":{"__rl":true,"mode":"list","value":"gid=0","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1KMNqWWO36osZx7jF-i1UL53z2GZnCn9fiBjtlGpvWB4/edit#gid=0","cachedResultName":"Sheet1"},"documentId":{"__rl":true,"mode":"id","value":"={{ $('Set Variables1').first().json.gsheetId }}"}},"credentials":{"googleSheetsOAuth2Api":{"id":"XHvC7jIRR8A2TlUl","name":"Google Sheets account"}},"typeVersion":4.5,"alwaysOutputData":true},{"id":"f8f6b582-75d7-40a1-95a5-c1b80fa41c64","name":"Sticky Note3","type":"n8n-nodes-base.stickyNote","position":[520,2180],"parameters":{"color":7,"width":440,"height":420,"content":"## 3. Support to Follow-Up Questionsn[Learn more about the Text Classifier node](https://docs.n8n.io/integrations/builtin/cluster-nodes/root-nodes/n8n-nodes-langchain.text-classifier/)nnDepending on whether the current question is open-ended or closed-ended, we may not require the Agent to spend too much time on the answer. Here we're using the text classifier node to make that judgement call - when closed-ended, we can skip to the next question and when open-ended, we can attempt to dig deeper into the answer."},"typeVersion":1},{"id":"5aa8956b-787d-4b4a-b4dc-a2415434a331","name":"Sticky Note4","type":"n8n-nodes-base.stickyNote","position":[980,2340],"parameters":{"color":7,"width":700,"height":500,"content":"## 4. Deeper Insights with a Conversational AI Agentn[Learn more about the AI Agent](https://docs.n8n.io/integrations/builtin/cluster-nodes/root-nodes/n8n-nodes-langchain.agent/)nnThe way we utilise the AI in this workflow is by allowing the agent to converse back-and-forth with the user on any given question of the survey. This means answers can be more than just single sentence and can expand to minute-long conversations, producting much deeper insights for the survey."},"typeVersion":1},{"id":"aa304745-6d30-4fdb-8279-eb505ee06a61","name":"Sticky Note5","type":"n8n-nodes-base.stickyNote","position":[1200,1820],"parameters":{"color":7,"width":740,"height":380,"content":"## 5. Managing Conversational Flow with External Staten[Learn more about the Redis node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.redis/)nnWe use Redis as a quick and easy way to store and track the question index (or "state") as the user progresses through the survey. To calculate which question should be next or if the survey is complete, we query the spreadsheet row for the user's session and calculate our next state from there. "},"typeVersion":1},{"id":"4ce7ce73-d771-4794-b1fb-87c15ccdbdaf","name":"Sticky Note6","type":"n8n-nodes-base.stickyNote","position":[2160,1680],"parameters":{"color":7,"width":620,"height":520,"content":"## 6. Resetting Chat Memory for Every Questionn[Learn more about the Chat Memory Manager](https://docs.n8n.io/integrations/builtin/cluster-nodes/sub-nodes/n8n-nodes-langchain.memorymanager/)nnI discovered that to ensure my agent focused on a specific question when interacting with the user, I needed to clear all previous message context to prevent it from using past references. This is a really unconventional approach to controlling Agent behaviour but from my observation, greatly reduces hallucinations during the conversation."},"typeVersion":1},{"id":"2b26317c-6ba6-4ff0-92a6-525cce9e725d","name":"Sticky Note7","type":"n8n-nodes-base.stickyNote","position":[-1740,1300],"parameters":{"width":580,"height":1020,"content":"## Try It Outn### This n8n template demonstrates how you can build a structured chat journey augmented with AI for your business.nnIn this scenario, a chatbot conducts a product satisfaction survey with a user using a predefined set of questions. For each question, the agent can dive deeper into the user's answers by asking follow-up questions.nnThis chatbot template isn't fully "agentic" which makes it a bit more complicated and scripted but ensures a more deterministic user journey; suitable when you need more guide-rails on the experience.nnSee example survey here: https://docs.google.com/spreadsheets/d/e/2PACX-1vQWcREg75CzbZd8loVI12s-DzSTj3NE_02cOCpAh7umj0urazzYCfzPpYvvh7jqICWZteDTALzBO46i/pubhtml?gid=0&single=truenn### How it worksn* A chat session is started with the user who needs to enter the bot command "/next" to start the survey.n* Once started, the template pulls in questions from a google sheet to ask the user. Questions are asked in sequence from left to right.n* When the user answers the question, a text classifier node is used to determine nif a follow-up question could be asked.n* If not, the survey proceeds to the next question. Otherwise, an AI Agent will generate a follow-up question based on the user's response.n* All answers and AI conversations are recorded in the Google Sheet.n* When all questions are answered, the template will stop the survey and give the user a chance to restart.nn### How to usen* You'll need to setup a Telegram bot ([see docs](https://docs.n8n.io/integrations/builtin/credentials/telegram/))n* Create a google sheet with an ID column. Populate the rest of the columns with your survey questions ([see sample](https://docs.google.com/spreadsheets/d/e/2PACX-1vQWcREg75CzbZd8loVI12s-DzSTj3NE_02cOCpAh7umj0urazzYCfzPpYvvh7jqICWZteDTALzBO46i/pubhtml?gid=0&single=true))n* Ensure you have a Redis instance to capture state. Either self-host or sign-up to [Upstash](https://upstash.com?ref=jimleuk) for a free account.n* Update the "Set Variable" node with your google sheet ID and survey title.n* Share the bot with users to allow others to participate in your survey.nn### Can I use this for WhatsApp?nYes you can! Swapping out all telegram nodes for WhatsApp nodes should produce the same result.nnn### Need Help?nJoin the [Discord](https://discord.com/invite/XPKeKXeB7d) or ask in the [Forum](https://community.n8n.io/)!"},"typeVersion":1}],"pinData":{},"connections":{"Model2":{"ai_languageModel":[[{"node":"Interview Agent1","type":"ai_languageModel","index":0}]]},"Model3":{"ai_languageModel":[[{"node":"Should Follow Up?1","type":"ai_languageModel","index":0}]]},"Memory3":{"ai_memory":[[{"node":"Reset Agent Memory1","type":"ai_memory","index":0}]]},"Memory4":{"ai_memory":[[{"node":"Interview Agent1","type":"ai_memory","index":0}]]},"Get State2":{"main":[[{"node":"Message Type1","type":"main","index":0}]]},"Get State3":{"main":[[{"node":"Get Columns1","type":"main","index":0}]]},"Send Start":{"main":[[]]},"Get Record1":{"main":[[{"node":"Has No Record?","type":"main","index":0}]]},"Send Start1":{"main":[[]]},"Bot Actions1":{"main":[[{"node":"Create Record1","type":"main","index":0}],[{"node":"Get State3","type":"main","index":0}],[{"node":"Send Start1","type":"main","index":0}]]},"Get Columns1":{"main":[[{"node":"Get Survey State1","type":"main","index":0}]]},"Get Command1":{"main":[[{"node":"Bot Actions1","type":"main","index":0}]]},"Message Type1":{"main":[[{"node":"Get Command1","type":"main","index":0}],[{"node":"Get Record1","type":"main","index":0}]]},"Send Response":{"main":[[]]},"Create Record1":{"main":[[{"node":"Start Session1","type":"main","index":0}]]},"Create Record2":{"main":[[{"node":"Get State3","type":"main","index":0}]]},"Has No Record?":{"main":[[{"node":"Create Record2","type":"main","index":0}],[{"node":"Get Last Bot Message1","type":"main","index":0}]]},"Set Variables1":{"main":[[{"node":"Execution Data2","type":"main","index":0}]]},"Start Session1":{"main":[[{"node":"Send Start","type":"main","index":0}]]},"Update Answer2":{"main":[[{"node":"Send Response","type":"main","index":0}]]},"Update Answer3":{"main":[[{"node":"Get State3","type":"main","index":0}]]},"Execution Data2":{"main":[[{"node":"Get State2","type":"main","index":0}]]},"Increment Index1":{"main":[[{"node":"Is Survey Continue?","type":"main","index":0}]]},"Interview Agent1":{"main":[[{"node":"Update Answer2","type":"main","index":0}]]},"Telegram Trigger":{"main":[[{"node":"Set Variables1","type":"main","index":0}]]},"Append Responses1":{"main":[[{"node":"Should Follow Up?1","type":"main","index":0}]]},"Get Survey State1":{"main":[[{"node":"Increment Index1","type":"main","index":0}]]},"Send Next Question":{"main":[[]]},"Should Follow Up?1":{"main":[[{"node":"Update Answer3","type":"main","index":0}],[{"node":"Interview Agent1","type":"main","index":0}]]},"Is Survey Continue?":{"main":[[{"node":"Reset Agent Memory1","type":"main","index":0}],[{"node":"Completed Survey","type":"main","index":0}]]},"Reset Agent Memory1":{"main":[[{"node":"Send Next Question","type":"main","index":0}]]},"Get Last Bot Message1":{"main":[[{"node":"Append Responses1","type":"main","index":0}]]}}}
  • CSV
  • Sheet
  • Spreadsheet
  • GS
  • API
  • Request
  • URL
  • Build
  • cURL
  • human
  • form
  • wait
  • hitl
  • approval
  • LangChain
  • Chat
  • Conversational
  • Plan and Execute
  • ReAct
  • Tools
Planeta AI 2025 
magic-wandmenu linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram