MonkeyLearn makes it easy to process your data within Google Sheets. Here is the link to the plugin that you need to install. Below is what you will see once installed.
You can call for any public models for classification (sentiment, language, emotion, topic, etc.) and it works with your custom models as well. Certain extraction models are also available.
Instructions for the MonkeyLearn Google Sheets Add-on:
1. Install the extension from the Add-On page. Google will ask you for the required permissions to be able to run the add-on with your Google account.
2. Set your token ID under the "Add-ons > MonkeyLearn > Set Token". You will need to copy your token from your the "API Keys" setting from under your MonkeyLearn account properties
3. Go back to the "Add-ons" menu and click "Start". That will open up a new window on the right of your sheet. Select the ID of the MonkeyLearn model that you will want to use, or enter it manually using the model ID
4. Select the range you wish to analyze, and the column you would like to output results to. Whenever you want to process text, you will need to click "Run" in order to start the processing, the results will appear in the column indicated.
For a full guide on how to use the add-on for Google Sheets, please see our blog post "Introducing Google Sheets add-on for MonkeyLearn".