Google sheets data compare help!

Hello,
I want to compare the text in the table with my own text and write "OK" if it is the same, and "NO" if it is different. However, the data in the table comes to me as ["'xxxx'']. How can I extract only the text? Thanks.




If you had looked at your responseContent, you would see that you are getting back a list of lists, (GoogleSheets returns a column of data like this). Therefore you first need to select the correct index for the comparison (as you are doing), but then you need to extract the content of the inner list.

[["one"],["two"],["three"],...]

image