CSV as Data Source for SN

Hello, looking to use a CSV file as a data source for smart notes. The SN would need to look for null values in a string field. Eventually, there may be more conditions to look for (e.g. Column 1 is null, or, Column 2 = Y and Column 3 = No).

Is this possible conceptually? I was able to set up a CSV file as a data source, but am stuck here and have several questions such as: When I update the Info Set it returns an 'errors' message, but I can still preview the data? Do I need to create a measure on said fields when defining the Info Set? How should the notification be set up to look for null values?

Any tips are welcome!