Having customer support messages, tweets or Facebook comments all in one table is helpful. There is no doubt about that. However, what’s even more useful, is the ability to search the texts quickly for emotionally tinged mentions of your company.

Even though everybody prefers reading positive reactions and reviews, it’s the negative ones that help us grow the most. Using Google Sheets along with Geneea’s text analytics, you can achieve this within a few minutes. Learn more about it in a short illustrative video below.

Geneea’s Interpretor REST API makes the connection with Google Sheets really easy. It has a whole series of functions available, such as text categorization, location and people identification. (In case you attended this year’s WebExpo, you might have seen our analysis of Svejk – available in Czech only; slides in English here).

As a demonstration, we have prepared a few emotionally charged sentences and created a function that calls Geneea’s API. Apply for your own API key here. We need a simple Google Apps Script; something like this:

function geneeaSentiment(text) {    
    var userkey = '<fill_your_api_key>'    
    var url = 'https://api.geneea.com:443/s1/sentiment?text='         
       + encodeURIComponent(text) + '&&user_key=' + userkey;    
    var response = UrlFetchApp.fetch(url);    
    var json = response.getContentText();    
    var data = JSON.parse(json);    

    return data.sentiment;
}

Replace in the code with the API key you have received.

Let’s use our new function =geneeaSentiment(A2) in the spreadsheet. We can see that the majority of detected sentiment cases corresponds to our own assessment. If you have thousands of such texts waiting for your attention, this will save a great deal of your time. Gone is the manual search for the most upset or the most pleased comments.

All necessary steps are reviewed in the following minute-long video: