Conditional SMS Notification from SQL Query

[Sepehran]

I have created a flow that sends the results of a SQL query as an SMS to a specific recipient using Microsoft SQL components and an HTTP request. I would like to modify the flow so that the SMS is sent only when the query result exceeds 10. I would greatly appreciate any guidance or suggestions you could provide.

[haimich]

Welcome to the n8n community @Sepehran!

It will probably be enough in your case to add an if node between the “Microsoft SQL” and “HTTP Request” node. You can specify a condition in the if node by referencing the output of the SQL node - here’s an example: