It's not automation that creates jobs, it's the incentives embedded in our socio-economic culture that create the replacement jobs for those that automation destroys.
When labor is freed up, entrepreneurs look for new ways to employ it to make money. When production costs are lowered, entrepreneurs look for new ways to employ the freed up capital. This is why so many companies are hiring at the same time as they are firing. Taken at a national or global scale, the result is that labor and capital follow supply and demand curves and that adjustments to the system through automation are compensated elsewhere through economic incentives.