I've read the assertion that the spreadsheet is the first "programming environment" for the general population, and I like the idea. Input some numbers into 2 or more cells and the most basic function would be that the output is the sum of these numbers, displayed in another cell.
https://nodered.org/ offers a drag and drop environment, although indeed the general public would not understand the nodes ("TCP, mqtt, websocket?"), if they could make it more general it would be "easy" to make branches, which is what an if-else-statement is.