Start with macro recorders [0] that let users record and replay sequences of operations. This already exists in certain household appliances, or when making a music playlist. Give them the ability to view and modify the macro code. Add loops and variables etc., and some portion of people will create more complex macros, even if they are no software developers and have no interest in being one. It’s like writing a cooking recipe, people understand that. Apple iOS Shortcuts are also a form of that.

[0] https://en.wikipedia.org/wiki/Macro_recorder