{"id":26045,"date":"2022-03-30T10:46:00","date_gmt":"2022-03-30T08:46:00","guid":{"rendered":"https:\/\/feedyou.ai\/?p=26045"},"modified":"2023-09-12T10:04:03","modified_gmt":"2023-09-12T08:04:03","slug":"chatbot-a-google-sheets-silna-dvojka","status":"publish","type":"post","link":"https:\/\/feedyou.ai\/cs\/novinky\/chatbot-a-google-sheets-silna-dvojka\/","title":{"rendered":"Chatbot a Google Sheets: Siln\u00e1 dvojka"},"content":{"rendered":"

[vc_section el_class=“vc_section-fullwidth“][vc_row el_class=“author-top“][vc_column width=“1\/6″][vc_single_image image=“25516″ img_size=“50×50″ css_animation=“none“][\/vc_column][vc_column width=“2\/4″][vc_column_text css_animation=“none“]Tea Navr\u00e1til \u0160imonov\u00e1<\/strong>
\nB\u00fdval\u00e1 Head of Conversation Design @ Feedyou[\/vc_column_text][\/vc_column][vc_column width=“1\/3″][vc_column_text]<\/p>\n

30. 3. 2022<\/div>\n

[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space height=“40px“][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css_animation=“none“]Zd\u00e1nliv\u011b dva rozd\u00edln\u00e9 sv\u011bty excelov\u00fdch tabulek a komunika\u010dn\u00edch struktur k sob\u011b maj\u00ed ve skute\u010dnosti docela bl\u00edzko. Alespo\u0148 ve sv\u011bt\u011b Feedyou Platform<\/a>. Nab\u00edz\u00ed toti\u017e symbi\u00f3zu, kter\u00e1 v\u00e1m umo\u017en\u00ed zobrazit ve sv\u00e9m chatbotovi neomezen\u00e9 mno\u017estv\u00ed polo\u017eek s mo\u017enost\u00ed snadno a p\u0159edev\u0161\u00edm kdykoliv je aktualizovat. Sta\u010d\u00ed vyu\u017e\u00edt v Designeru funkci Repository Query<\/i>.<\/p>\n

V\u00e1h\u00e1te, zda se pustit do hlubin integrac\u00ed na jedn\u00e9 stran\u011b a \u0159\u00e1dk\u016f a sloupc\u016f na stran\u011b druh\u00e9? Nemus\u00edte se b\u00e1t. Jen se nejd\u0159\u00edv rad\u011bji pono\u0159te do n\u00e1sleduj\u00edc\u00edho \u010dl\u00e1nku a nau\u010dte se vyu\u017e\u00edvat Google Sheets p\u0159i stavb\u011b chatbota.[\/vc_column_text][vc_empty_space height=“25px“][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css_animation=“none“]<\/p>\n

Ide\u00e1ln\u00ed \u0159e\u0161en\u00ed pro e-commerce<\/h2>\n

[\/vc_column_text][vc_column_text css_animation=“none“]Repository query <\/i>je ide\u00e1ln\u00edm \u0159e\u0161en\u00edm, chcete-li do chatbota zahrnout v\u011bt\u0161\u00ed mno\u017estv\u00ed polo\u017eek, jejich\u017e charakter \u010di po\u010det se m\u011bn\u00ed<\/strong> nebo v\u00edte, \u017ee se v \u010dase m\u011bnit bude. Pro zjednodu\u0161en\u00ed si p\u0159edstavte e-shop a jeho produktov\u00fd katalog s po\u010dtem kus\u016f na sklad\u011b, r\u016fzn\u00fdmi velikostmi, barvami, slu\u017ebami atd.[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=“blog-img-desc“][vc_column][vc_single_image image=“26076″ img_size=“full“][vc_empty_space height=“25px“][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css_animation=“none“]Pokud byste m\u011bli v\u0161echny artikly nebo jednotky postupn\u011b p\u0159id\u00e1vat do struktury chatbota, mohlo by v\u00e1s p\u0159ipravit o v\u0161echny nad\u011bje a hlavn\u011b o trp\u011blivost. Nav\u00edc n\u00e1sledn\u00e1 \u00fadr\u017eba struktury v takov\u00e9m rozsahu je \u010dasov\u011b n\u00e1ro\u010dn\u00e1 a stereotypn\u00ed<\/strong>. Na\u0161t\u011bst\u00ed ve\u0161ker\u00e9 polo\u017eky lze zan\u00e9st do Google sheet a tuto tabulku n\u00e1sledn\u011b propojit s chatbotem. V\u0161echny aktualizace, jako p\u0159id\u00e1v\u00e1n\u00ed nebo odeb\u00edr\u00e1n\u00ed polo\u017eek, zm\u011bny v cen\u011b nebo popisu lze pak jednodu\u0161e prov\u00e1d\u011bt tam a do chatbota se v\u017edy automaticky \u201cnat\u00e1hnou\u201d informace<\/strong> \u010derstv\u00e9 jako jarn\u00ed louka. D\u00edky p\u0159edem definovan\u00fdm kategori\u00edm lze polo\u017eky tak\u00e9 p\u0159\u00edmo v chatbotovi filtrovat a nab\u00edzet u\u017eivateli jen ty, kter\u00e9 ho zaj\u00edmaj\u00ed.<\/p>\n

Funkci Repository query<\/i> jsme vyu\u017eili nap\u0159\u00edklad v chatbotovi pro prodejce aut. U n\u011bj je toti\u017e jist\u00e9, \u017ee aktu\u00e1ln\u00ed nab\u00eddka se bude v \u010dase m\u011bnit, a\u0165 u\u017e p\u016fjde o modely, jejich cenu nebo v\u00fdbavu. V\u0161echny polo\u017eky jsou p\u0159ehledn\u011b shrom\u00e1\u017ed\u011bn\u00e9 v jedn\u00e9 tabulce<\/strong> s ve\u0161ker\u00fdmi informacemi a fotkami. Kdy\u017e si u\u017eivatel chce vybrat v\u016fz, m\u016f\u017ee zadat preferovan\u00e9 parametry na z\u00e1klad\u011b kter\u00fdch mu chatbot nab\u00eddne jen relevantn\u00ed v\u00fdsledek<\/strong>.[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=“blog-img-desc“][vc_column][vc_single_image image=“26082″ img_size=“full“][vc_empty_space height=“25px“][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css_animation=“none“]Podobn\u011b funguje tak\u00e9 e-shop s kosmetikou. Sv\u00fdm z\u00e1kazn\u00edk\u016fm d\u00e1v\u00e1 mo\u017enost si p\u0159\u00edmo v chatbotovi vybrat nejen konkr\u00e9tn\u00ed produkty<\/strong>, ale i zv\u00fdhodn\u011bn\u00e9 bal\u00ed\u010dky. Aby to nebylo p\u0159\u00edli\u0161 jednoduch\u00e9, tak n\u011bkter\u00e9 zbo\u017e\u00ed je v\u00e1zan\u00e9 na podm\u00ednky registrace a m\u011bn\u00ed se t\u00edm i jeho cena \u2013 to v\u0161e je zahrnuto v Google sheet. V\u0161echny produkty si klient spravuje s\u00e1m v tabulce a kdykoliv se mu to hod\u00ed. P\u0159itom ale nemus\u00ed s\u00e1hnout do struktury virtu\u00e1ln\u00edho asistenta<\/strong>, kter\u00fd je ale st\u00e1le aktu\u00e1ln\u00ed.[\/vc_column_text][\/vc_column][\/vc_row][vc_row el_class=“blog-img-desc“][vc_column][vc_single_image image=“26078″ img_size=“full“][vc_empty_space height=“25px“][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css_animation=“none“]<\/p>\n

3 kroky k \u00fasp\u011b\u0161n\u00e9mu napojen\u00ed<\/h2>\n

[\/vc_column_text][vc_column_text css_animation=“none“]Pokud pou\u017e\u00edv\u00e1te Feedyou Platform<\/a>, propoj\u00edte si tabulku s virtu\u00e1ln\u00edm asistentem v n\u011bkolika jednoduch\u00fdch kroc\u00edch sami:<\/p>\n

    \n
  1. Z\u00e1kladem je spr\u00e1vn\u011b vytvo\u0159en\u00e1 tabulka, ve kter\u00e9 budou kategorie pojmenov\u00e1ny tak, aby jim n\u00e1\u0161 Designer rozum\u011bl.<\/li>\n
  2. Dal\u0161\u00edm krokem je propojen\u00ed hotov\u00e9 tabulky s konkr\u00e9tn\u00edm chatbotem. Zde ur\u010d\u00edte, jak se m\u00e1 nov\u011b vytvo\u0159en\u00e1 symbi\u00f3za chovat: odkud si m\u00e1 bot sb\u00edrat data a jak\u00fdm zp\u016fsobem je t\u0159\u00eddit.<\/li>\n
  3. Potom zb\u00fdv\u00e1 se rozhodnout, kde ve struktu\u0159e chcete data z tabulky zobrazovat a co se m\u00e1 d\u00edt v p\u0159\u00edpad\u011b, \u017ee zadan\u00fdm parametr\u016fm nebude odpov\u00eddat \u017e\u00e1dn\u00e1 polo\u017eka. Ve\u0161ker\u00e9 toto nastaven\u00ed je pro v\u00e1s podrobn\u011b pops\u00e1no v na\u0161\u00ed <\/b>dokumentaci<\/b><\/a>.<\/b><\/li>\n<\/ol>\n

     <\/p>\n

    Shrnuto a podtr\u017eeno: propojen\u00ed Google Sheets s chatbotem je to prav\u00e9, kdy\u017e chcete u\u017eivatel\u016fm nab\u00eddnout ono \u010dasto sklo\u0148ovan\u00e9 \u201cn\u011bco nav\u00edc\u201d. D\u00edky funkci Repository query<\/i> nemus\u00ed lid\u00e9 pendlovat mezi poradenstv\u00edm v chatbotovi a webem s nab\u00eddkou polo\u017eek. M\u00edsto toho budou oba procesy prob\u00edhat ve vz\u00e1jemn\u00e9 souh\u0159e na jednom m\u00edst\u011b. V\u00fdsledkem je skv\u011bl\u00fd u\u017eivatelsk\u00fd z\u00e1\u017eitek<\/strong> a v\u00e1\u0161 u\u0161et\u0159en\u00fd \u010das<\/strong> a nervy.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space height=“60px“][\/vc_column][\/vc_row][\/vc_section][vc_section disable_element=“yes“ el_class=“vc_section-fullwidth border-top“][vc_row][vc_column][vc_empty_space height=“62px“][vc_column_text]<\/p>\n

    Pokra\u010dujte ve \u010dten\u00ed<\/h3>\n

    [\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space][\/vc_column][\/vc_row][vc_row el_class=“cs-dalsi-inspirace“][vc_column width=“1\/4″][vc_single_image image=“28346″ img_size=“full“ onclick=“custom_link“ css_animation=“none“ link=“https:\/\/feedyou.ai\/cs\/novinky\/nejcastejsi-gramaticke-chyby-pri-tvorbe-chatbotu-cast-2\/“][\/vc_column][vc_column width=“3\/4″][vc_column_text css_animation=“none“ el_class=“blog-post-title“]<\/p>\n

    Nej\u010dast\u011bj\u0161\u00ed gramatick\u00e9 chyby p\u0159i tvorb\u011b chatbot\u016f \u2013 #2<\/a><\/h3>\n

    [\/vc_column_text][vc_column_text el_class=“ctete-dal-text“]Ob\u010das se n\u011bjak\u00e9 ty chybi\u010dky do textu vloud\u00ed. V na\u0161\u00ed pravopisn\u00e9 s\u00e9rii se tentokr\u00e1t zam\u011b\u0159\u00edme na procenta.<\/a>[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space height=“20px“][\/vc_column][\/vc_row][\/vc_section][vc_section el_class=“vc_section-fullwidth vc_section-bg border-top“][vc_row][vc_column width=“2\/3″][vc_empty_space height=“10px“][vc_column_text]<\/p>\n

    P\u0159iprav\u00edme v\u00e1m \u0159e\u0161en\u00ed na m\u00edru<\/h2>\n

    [\/vc_column_text][\/vc_column][vc_column width=“1\/3″][vc_btn title=“Ozv\u011bte se n\u00e1m“ align=“center“ link=“url:https%3A%2F%2Ffeedyou.ai%2Fcs%2Fcontact-us%2F|||“ el_class=“btn-homepage“][\/vc_column][\/vc_row][vc_row][vc_column][vc_empty_space height=“10px“][\/vc_column][\/vc_row][\/vc_section]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

    Symbi\u00f3za excelov\u00fdch tabulek a komunika\u010dn\u00edch struktur chatbot\u016f. Pro\u010d tvo\u0159\u00ed ide\u00e1ln\u00ed p\u00e1r a jak v\u00e1m m\u016f\u017ee propojen\u00ed pomoci? <\/p>\n

    Zjist\u011bte v\u00edce…<\/a><\/p>\n","protected":false},"author":20,"featured_media":26048,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"h5ap_radio_sources":[],"footnotes":""},"categories":[32],"tags":[],"class_list":["post-26045","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-novinky"],"acf":[],"_links":{"self":[{"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/posts\/26045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/comments?post=26045"}],"version-history":[{"count":0,"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/posts\/26045\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/media\/26048"}],"wp:attachment":[{"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/media?parent=26045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/categories?post=26045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/feedyou.ai\/cs\/wp-json\/wp\/v2\/tags?post=26045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}