{"id":18,"date":"2015-10-26T14:07:21","date_gmt":"2015-10-26T14:07:21","guid":{"rendered":"http:\/\/blog.geneea.com\/?p=18"},"modified":"2026-01-29T21:24:41","modified_gmt":"2026-01-29T21:24:41","slug":"rychla-analyza-sentimentu-v-google-sheets","status":"publish","type":"post","link":"https:\/\/geneea.com\/news\/cs\/rychla-analyza-sentimentu-v-google-sheets","title":{"rendered":"Rychl\u00e1 anal\u00fdza sentimentu v Google Sheets"},"content":{"rendered":"

M\u00edt zpr\u00e1vy ze z\u00e1kaznick\u00e9 podpory, tweety nebo koment\u00e1\u0159e z Facebooku v\u0161echny v jedn\u00e9 tabulce je ur\u010dit\u011b u\u017eite\u010dn\u00e9. Um\u011bt v nich ale rychle vyhled\u00e1vat emocion\u00e1ln\u011b zabarven\u00e9 zm\u00ednky o va\u0161\u00ed firm\u011b je je\u0161t\u011b u\u017eite\u010dn\u011bj\u0161\u00ed. V\u0161ichni si r\u00e1di \u010dteme pozitivn\u00ed ohlasy, ale u\u010dit se a r\u016fst m\u016f\u017eeme hlavn\u011b d\u00edky t\u011bm negativn\u00edm. V Google Sheets je to s vyu\u017eit\u00edm <\/span>Geneea<\/a><\/strong> textov\u00e9 analytiky mo\u017en\u00e9 za p\u00e1r minut.\u00a0N\u00e1zorn\u011b v\u00e1m to uk\u00e1\u017eeme i v kr\u00e1tk\u00e9m videu.<\/span>
\n<\/span><\/p>\n

Propojit Google Sheet s Geneea Interpretorem<\/a><\/strong> je jednoduch\u00e9 d\u00edky <\/span>REST API<\/a><\/strong>. To nab\u00edz\u00ed celou \u0159adu funkc\u00ed, nap\u0159\u00edklad kategorizace text\u016f, rozpozn\u00e1v\u00e1n\u00ed geografick\u00fdch n\u00e1zv\u016f, jmen lid\u00ed a podobn\u011b. (Jestli jste byli na leto\u0161n\u00edm WebExpu, mo\u017en\u00e1 jste vid\u011bli <\/span>na\u0161i anal\u00fdzu \u0160vejka<\/a><\/strong>.)<\/span><\/p>\n

Na uk\u00e1zku jsme p\u0159ipravili p\u00e1r emocion\u00e1ln\u011b zabarven\u00fdch v\u011bt a vytvo\u0159ili jsme funkci,<\/strong> kter\u00e1 bude volat Geneea API. API kl\u00ed\u010d pro va\u0161e pot\u0159eby z\u00edsk\u00e1te snadno <\/strong><\/span>zde<\/a><\/strong>.<\/span><\/p>\n

Pot\u0159ebujeme jednoduch\u00fd <\/span>Google Apps Script<\/strong>, kter\u00fd vypad\u00e1 n\u011bjak takhle:<\/span><\/p>\n

\n
function <\/span>geneeaSentiment(text<\/span>) {    \n   var<\/span> userkey<\/span> = '<vyplnte_vas_api_key>'<\/span>    \n   var<\/span> url<\/span> = 'https:\/\/api.geneea.com\/s2\/sentiment?text='<\/span> \n      + encodeURIComponent(text<\/span>) + '&&user_key='<\/span> + userkey<\/span>;\n   var<\/span> response<\/span> = UrlFetchApp.fetch(url<\/span>);\n   var<\/span> json<\/span> = response.getContentText();\n   var<\/span> data<\/span> = JSON.parse(json<\/span>);\n   return<\/span> data<\/span>.sentiment;\n}<\/span><\/pre>\n<\/blockquote>\n
M\u00edsto ‘<vyplnte_vas_api_key>’ <\/span>zadejte kl\u00ed\u010d z registrace. Tento k\u00f3d ulo\u017ete jako skript do editoru skript\u016f, kter\u00fd otev\u0159ete pomoc\u00ed Tools > Script editor<\/strong> (N\u00e1stroje > Editor skript\u016f v \u010desk\u00e9m rozhran\u00ed)<\/span><\/p>\n
Do bu\u0148ky spreadsheetu vlo\u017e\u00edme na\u0161\u00ed novou funkci <\/span>=geneeaSentiment(<\/span>A2<\/span>)<\/span>. Vid\u00edme, \u017ee v naprost\u00e9 v\u011bt\u0161in\u011b p\u0159\u00edpad\u016f automaticky detekovan\u00fd sentiment odpov\u00edd\u00e1 tomu, co jsme o\u010dek\u00e1vali<\/strong>. Pokud takov\u00fdhle text\u016f m\u00e1te tis\u00edce, m\u016f\u017ee v\u00e1m to u\u0161et\u0159it spoustu \u010dasu s hled\u00e1n\u00edm t\u011bch nejv\u00edce na\u0161tvan\u00fdch nebo naopak pochvaln\u00fdch zm\u00ednek<\/strong>.<\/span><\/p>\n
Cel\u00fd postup m\u016f\u017eete vid\u011bt na tomto minutov\u00e9m videu:<\/span><\/p>\n