Text Analysis - Google Sheets add-on

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.