A global survey of 600 CIOs and IT decision makers shows automation demand surged across nearly all companies.