How to automatically open a regular window?
Not really. There are plenty of ventilation systems in use, but it would be cumbersome and expensive to involve windows. 

Exhaust fans do the job by sending stale air out. This creates a very slight low pressure condition inside the home, so that even if there's no "makeup air" or air exchange system installed, air will be drawn in through the many small leaks any home has. 

I strongly suggest that you install a digital/smart timer on your bath fan or furnace so that you can run them on a schedule or on demand, instead of seeking a motorized apparatus that's likely to be unsightly and noisy.