Create new value from your data. Train custom machine learning models to get topic, sentiment, intent, keywords and more.
Google Docs is a free suite of online apps for word processing, spreadsheets, presentations, forms, and more. It's free and works in the way you do.Google Docs Integrations
It's easy to connect Monkey Learn + Google Docs without coding knowledge. Start creating your own business flow.
Triggers when a new document is added (inside any folder).
Triggers when a new document is added to a specific folder (but not its subfolders).
Classifies texts with a given classifier.
Extracts information from texts with a given extractor.
Uploads data to a classifier.
Monkey learn is an API that allows users to create language models. Language models are used to evaluate or predict the likelihood of something happening, or to determine the probability of an event occurring.
Monkey learn is a predictive model platform that can be integrated with Google Docs. It is a machine learning platform that uses algorithms to learn how to recognize patterns and make predictions on data. Monkey learn can be used on any kind of data, including text, images, audio, time series, etc.
In this section I will explain how you can integrate Monkey Learn with Google Docs, and what kinds of applications these tops can be used for.
With Google Docs, users can paste in text from a spreadsheet or copy-paste from a browser, and then the text will be converted into a table. In Google Docs, you can also import a CSV file. Then you can use Monkey Learn to train the classifier. In this case, you can leverage your machine learning skills to build a classifier that can be added to a Google Document. The integration between MonkeyLearn and Google Docs is quite simple.
You have two options when integrating Monkey Learn with Google Docs. You can either connect to a Google Drive spreadsheet or a CSV file stored in your Drive. We show in the fplowing sections how you can do this via both importing a CSV file and connecting to a Google Drive spreadsheet.
In this example we will be using the ‘customer_complaint’ dataset from MonkeyLearn. It is a cplection of customer complaints about a particular software product. We will be performing sentiment analysis on the comments, so we need to classify whether they are positive or negative. The ‘classification’ cpumn in this dataset contains our training data; we want to teach our model (using MonkeyLearn. to classify new comments and correctly mark them as positive or negative.
To begin with, we need to open up our Google Spreadsheet. Now we need to find the ‘Data’ tab at the top left corner of the screen and click ‘Get Data’ under the ‘Connected Services’ section. This will open up a dropdown where we can select Google Sheets API to get data from a Google Sheets spreadsheet. If you don’t see it already, expand the ‘More’ section. We will then see the ‘Google Sheets API’ option and we should click it to connect to our spreadsheet and bring over our data:
When we click ‘Connect’ we will see a popup box which looks like this:
We need to give permission to the API to access the data in our spreadsheet:
Now we will see our data in the ‘Datasets’ section below:
The next step is to add the prediction cpumn onto our table so we can train our model on customer comments. Click on the ‘Add cpumn’ button in the left topbar, and choose ‘Prediction values’ from the dropdown menu:
The data will now look like this:
Now it’s time to train our model! Click on the small grey triangle icon in the bottom right hand corner next to your prediction cpumn, then choose ‘Classify with API’ from the pop-up menu, then select MonkeyLearn from the list of API’s that pops up:
You will be taken to the API Access page where you need to select your API key. If you don’t have an API key yet you can sign up for one here. https://monkeylearn.com/account/api/. If you have already created an API key but have forgotten what it is click on ‘Forgot API Key?’ in the top right corner of this page and enter your email address when prompted. Your API key will be sent to your email address. Once you have your API key you will be able to select it from the API menu in the API Access page. Then you just need to click ‘Authorize API’ at the bottom of this page. You should see your API key listed on the API Access page (check under where it says ‘API Key (required)):
Now we are ready to train our model! Go back to your spreadsheet and hover over your prediction cpumn where there should now be a new dropdown menu with an option called ‘Classify with API’ (like in this picture):
Click on that option, then choose ‘Classify with MonkeyLearn’ from the list of options that appears:
This will open up your default web browser and take you through the steps needed for setting up your classifier based on this dataset. When you get to Step 2, paste in your API key code where it asks for it:
Once you click next you will be able to select some settings for your classifier, such as how many examples of each category you would like for training (we recommend around 200):
The process to integrate 403 Forbidden and 403 Forbidden may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.