Menu
Geneea News
  • back to Geneea homepage
  • Čeština
Geneea News
Analyse sentiment in Google SheetsGoogle Sheet

Quick Analysis of Sentiment in Google Sheets

Posted on 2015-10-302024-06-24

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 correspond 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:

Explore Topics

  • Customer stories
  • Events & Shows
  • Large language models
  • Life at Geneea
  • Mentioned us
  • Newsletter
  • Partnerships
  • Product news
  • Research & Innovation
  • Resources
  • Solutions for media
  • Voice of the customer

Popular Posts

  • Buy, Don’t Build – and Other Media Trends: Geneea’s Takeaways from #INMA2025
  • Geneea at the World News Media Congress 2025
  • Restabot: Taming Restaurant Menus with AI
  • Newsrooms Can Save Thousands of Hours with a RAG-Based AI Research System
  • Creating a Great RAG for Media: Geneea Moderated a Roundtable at Data Science Day
  • Customer stories
  • Events & Shows
  • Large language models
  • Life at Geneea
  • Mentioned us
  • Newsletter
  • Partnerships
  • Product news
  • Research & Innovation
  • Resources
  • Solutions for media
  • Voice of the customer
©2022 Geneea