There is nothing to worry. Approach your boss and show him how your ingenuity has helped the company. Show them that while you can make mistakes when performing mundane/routine tasks, the scripts/automation software will not. This may have already saved your company some money. But also show them that you keeping on monitoring and improving robustness of the automated processes is very important.

If I were the manager, rather than laying you off, I will see if you can automate at least parts of other employees' jobs, and then try to take advantage of the new excess time to do productive and more complex/analytical work that could not be automated. In any case, offer your manager to automate some other mundane/routine processes. For example, I created a small program to do some analytics on the reported bugs for our software product, which created an Excel document with some nice pie charts. This was praised a lot and very quickly there were more requests of similar requirements.

There is nothing to worry. Approach your boss and show him how your ingenuity has helped the company. Show them that while you can make mistakes when performing mundane/routine tasks, the scripts/automation software will not. This may have already saved your company some money. But also show them that you keeping on monitoring and improving robustness of the automated processes is very important.

If I were the manager, rather than laying you off, I will see if you can automate at least parts of other employees' jobs, and then try to take advantage of the new excess time to do productive and more complex/analytical work that could not be automated. In any case, offer your manager to automate some other mundane/routine processes. For example, I created a small program to do some analytics on the reported bugs for our software product, which created an Excel document with some nice charts. This was praised a lot and very quickly there were more requests of similar requirements.