Assumes your working data is in the first sheet and that the first row contains the headers.
Just write Javascript.
Using lodash, compare two arrays and return true if a partial match is found within a value.
Test if input is valid JSON.