I'm importing personal finance data from the Plaid API and dumping it into a Google Sheet.

Right now, I'm feeding the transaction data through an "algorithm" which is essentially a function comprised of a bunch of if else statements. For example, if the Plaid category is "Shoe Store" change it to "Clothing and Accessories".

I know it's probably easiest to move this data into a SQL database and clean it up there (please correct me if I'm wrong), but I'd like to keep this in Google Sheets as the data needs to be easily accessible by my partner.

This feels terribly messy, and there's got to be a better way to do it in JS.