Add-ons
Check out the store for many more
Add-on

Text Analysis


(40)
offered by aylien.com
10,784 users

Overview

The Text Analysis add-on provides an easy way to analyze any text (links, tweets or documents) without leaving Google Spreadsheets.
Use The Text Analysis add-on to:

* Perform Sentiment Analysis on Social Media streams to identify what is positive, negative or neutral about your company or brand
* Extract fine-grained Sentiment from customer feedback and reviews
* Extract mentions of entities and concepts such as people, organizations, places and products from documents
* Summarize long chunks of text and articles into a few key sentences
* Detect the language of a document or tweet
* Find the best hashtags for your content for better discoverability on Social Media
* Classify your documents or links into more than 500 categories
* Extract the full text of an article, as well as its author name, embedded media and so on
* Find related phrases and keywords
* Built-in formulas for maximum flexibility:
   =Author(url): Returns the author name from an URL.
   =Classification(value): Returns the classification of a text or URL.
   =Summarize(value,[title]): Returns a list of key sentences from a text or URL.
   =Hashtags(value): Returns a list of suggested hashtags for a text or URL.
   =Language(value): Returns the main language of a text or URL in ISO 639-1 format.
   =Concepts(value): Returns a list of concepts mentioned in a text or URL.
   =SentimentPolarity(value): Returns the polarity (‘positive’ or ‘negative’) of a text or URL.
   =SentimentSubjectivity(value): Returns the subjectivity (‘subjective’ or ‘objective’) of a text or URL.
   =People(value): Returns a list of the people mentioned in a text or URL.
   =Organizations(value): Returns a list of the organizations mentioned in a text or URL.
   =Locations(value): Returns a list of the locations mentioned in a text or URL.
   =Keywords(value): Returns a list of keywords from a text or URL.
   =Dates(value): Returns a list of all date values mentioned in a text or URL.
   =Money(value): Returns a list of all money values mentioned in a text or URL.
   =Percentages(value): Returns a list of all percentage values mentioned in a text or URL.
   =Times(value): Returns a list of all time values mentioned in a text or URL.
   =URLs(value): Returns a list of all links mentioned in a text or URL.
   =Emails(value): Returns a list of all email addresses mentioned in a text or URL.
   =Phones(value): Returns a list of all phone numbers mentioned in a text or URL.
   =PageTitle(url): Returns the title of an URL.
   =PageText(url): Returns the text of an URL.
   =MainImage(url): Returns the main image of an URL.
   =Videos(url): Returns the embedded videos of an URL.
   =Related(value): Returns a list of phrases related to the provided keyword or phrase.

Powered by the AYLIEN Text Analysis API, this add-on brings the smarts of different Natural Language Processing and Machine Learning tools to your Spreadsheets to transform it into a powerful yet easy-to-use machine for performing various types of Text Analysis.

Details

Version: 29
Updated: November 18, 2016
Language: English (United States)