how to install simple ml for sheets
IN SUMMARY
Simple ML for Google Sheets is a machine learning extension that allows you to automate data categorization and prediction tasks within your spreadsheets. It can save you significant time by learning from a sample of your data and applying that knowledge to the rest of your dataset.
Prerequisites
You'll need a Google account to access Google Sheets and the Google Workspace Marketplace, where you'll find the Simple ML extension.
Simple ML is a Chrome extension, so you'll need to have the Google Chrome browser installed on your computer.
To train the machine learning model, you'll need a sample of your data that you've manually categorized or labeled. This will teach the model how to categorize the rest of your data.
Installation Steps
Log in to your Google account and open a new or existing Google Sheet that contains the data you want to categorize.
In your Google Chrome browser, navigate to the Google Workspace Marketplace and search for 'Simple ML for Sheets'. Click the 'Install' button to add the extension to your Google Sheets.
In your Google Sheet, manually categorize or label a sample of your data (at least 50 rows, as recommended by Simple ML). This will serve as the training data for the machine learning model.
Using Simple ML
In your Google Sheet, open the Simple ML sidebar by going to 'Extensions' > 'Simple ML for Sheets' > 'Start'.
In the Simple ML sidebar, select 'Predict Missing Values'. This will allow the model to categorize the remaining data based on the sample you provided.
Review the predicted categories and make any necessary corrections. You can then retrain the model with the updated data to improve its accuracy.