if the row exist I take some aditional data and add it to google sheet
if the rows does not exist I need to create it
I know I could use split in items, but it seems weird I cannot do it without. Am I missing something?
For some reason supabase only return an item if the row exists. I would expect it would return the same number of items as the input. I tried activating always output data, but it returns just 1 item and only if none of the rows are available.
While I can understand your expectation here, enabling Always Output Data will cause n8n to return a single empty item if otherwise no item is returned, but it won’t respect the number of incoming items. That split items workaround you mentioned would be a workaround that helps with all nodes in n8n in these cases, not just Supabase
You could try this SQL query to do what you’re looking for, though:
You would unfortunately still need an extra node, as the Supabase node itself doesn’t have the option to run custom SQL queries.