Text Analysis Add-on

AYLIEN's Text Analysis add-on for Google Sheets is a plugin that allows you to run Natural Language Processing features from right inside your spreadsheet.

The add-on is 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.

Install the Text Analysis Add-on

The add-on is free to use to any Google Sheets user for up to 1,000 credits and thereafter operates on a pay as you go basis where users can top up credits in their account whenever necessary.

Getting Started

Getting started with Text Analysis for Google Sheets is easy and you can be up and running in a matter of minutes. Check out our walkthroughs and videos in this section.

Step One

Click here to create a new Spreadsheet, and then install the the Text Analysis Add-on by navigating to Add-ons > Get add-ons... and searching for "text analysis" or "aylien" in the Add-on store.

Google sheets 1

Google sheets 2

Step Two

Navigate to the Add-ons section in your Sheets toolbar and under the Text Analysis drop down, click Start (this will open the Text Analysis sidebar in the right-hand side of your Google Sheet)

Google sheets 3

Step Three

Add some Text or URLs anywhere on your Spreadsheet, and make sure you've selected the range you wish to analyze:

Google sheets 5

Step Four

Choose the analysis tasks you wish to perform from the Add-on sidebar and hit Analyze:

Google sheets 6

Step Five

The results of your analysis will be added to your sheet, to the right of the selected range.

Google sheets 7

You are now ready to create charts and reports based on these results.

Topping Up Your Account

Credits act as the base currency of the Text analysis add-on. The add-on is free to use for up to 1,000 credits. A credit is a single unit of operation for performing one analysis task on a single value. For instance, analyzing the sentiment of 1 tweet would use 1 credit.

Thereafter, usage of the 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 > Text Analysis and choose Buy Credits:

Google sheets 8

Google sheets 9

Text Analysis Add-on Examples

Sentiment Analysis in Google Sheets

You can use the Text Analysis add-on to easily collect and analyze tweets, reviews and comments from within your Google Spreadsheets:

See also:

Analyzing News in Google Sheets

You can use the Text Analysis add-on to easily collect and analyze blog posts and news articles from within your Google Spreadsheets:

See also:

Add-on Formulas

The Text Analysis add-on comes with a set of formulas for performing Text Analysis operations with more flexibility, just like how you use the =SUM function or any other formula in Excel or Google Spreadsheets.

Just enter an equal sign = in a cell and start typing a formula from the below list to get suggestions:

Google sheets 10

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.

Download in PDF format