Text Analysis Add-on Tutorial | AYLIEN

Text Analysis Add-on Tutorial

Step by step guid to use Text and Sentiment analysis add-on for Google Sheets

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.

Whether you’re a savvy marketer or a seasoned data junkie the AYLIEN Text Analysis Add-on for Google Sheets allows you to analyze text with no programming or Text Analysis expertise in a matter of minutes.

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 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.

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

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)

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

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..)

Analyzing URL’s Tutorial Video

Sentiment Analysis 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.