Introduction

AYLIEN’s Text Analysis Google Sheets add-on is built on a package of Natural Language Processing and Artificial Intelligence tools that provide sophisticated Text Analysis capabilities from within a Google Sheet.

The add-on was designed to provide an easy to use, sophisticated and feature rich Text Analysis tool to users who may not have the technical know how to get up and running with the AYLIEN Text Analysis API.

The add-on is free to use to any Google Sheets user for up to 1000 credits and thereafter operates on a pay as you go basis where users can top up credits in their account whenever necessary. How the credits work is explained below.

Formulas

The Text Analysis API add-on comes with its own unique set of functions which can be used to invoke formulas within your spreadsheet.

The functions can be used, in the same way, any standard spreadsheet function would be used to invoke formulas. In the example below we are using the “language” function to analyse what language a tweet is written in.

Screen shot 2014-09-09 at 6.47.05 PM

 

 

 Download Cheat Sheet

Formula List

  • =Classification(value): Returns the classification of 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.
  • =Summarize(value,[title]): Returns a list of key sentences from 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.
  • =Author(url): Returns the author name of an URL.

Getting Started

Step 1. Install the the Google Sheets Add-on

Screen shot 2014-08-27 at 5.17.35 PMinstall2-highlighted

 

Step 2. Navigate to the Add-ons section in your Sheets toolbar and under the Text Analysis drop down, click Start (You will see the Text Analysis tool populate in the right-hand side of your Google Sheet)

Screen shot 2014-08-27 at 5.53.49 PM

Step 3. Copy and paste the text you wish to analyze into a column in your Google Sheet

Screen shot 2014-08-28 at 3.10.20 PM

Step 4. Select the cells containing the text or links you wish to analyze (note that the cells must be in one column and choose the desired analysis task from the sidebar (Summarize, Classify, Sentiment etc..)

Screen shot 2014-08-28 at 3.12.21 PM

Tutorials

Sentiment Analysis Tutorial Video

Analyzing URL’s Tutorial Video

Credits

Credits act as the base currency of the Text analysis add-on. Our TA add-on is free to use for up to 1000 credits. A credit is a single unit of operation for performing one analysis task on a single value. Say analyzing the sentiment of 1 tweet would use 1 credit.

Thereafter, the Text Analysis Add-On is priced on a pay as you go basis and you can top up your credits right within the chrome store or top up by following the link below.

You can top up your credits from within your spreadsheet. Navigate to add-ons, click text analysis and choose buy credits.

Screen shot 2014-09-09 at 9.30.34 AM

Screen shot 2014-09-09 at 7.13.38 PM