Google Sheet Not Empty & Empthy Value

Hi,

Is there an easy way to look up for “email” not empty?

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

I don’t think this is supported. Two strategies that could work:

  • Just get all rows and use the filter node to remove unwanted ones.
  • Add another column with an array formula that returns ‘empty’ or ‘not empty’ based on the email cell on that row.
2 Likes

Hey @bartv,

Thanks I will try those approaches. Are you aware if Airtable allows this feature?

I don’t know from the top of my head - just give it a try :slight_smile:

1 Like