You’re then going to dump this huge, ugly, uncategorized list into Google sheets:

Time spent so far: 25 minutes (or an hour and 25 minutes if you got every product category from River Islands website)

Using BigML’s API to categorize your keywords 

Get the BigML addon on Google sheets:

You’ll need to pop your username and API key in, but you’ll find these easily within your BigML dashboard and settings.

Now the fun begins.

1. Highlight the array that needs to be categorized and select the model you trained that you want to use. In this instance I am using category 1 (at the moment I think we can only do one category at a time. I haven’t worked out how to both which is why we trained two different models):

Then, click “predict” and let it go: