Can anyone tell what the possibilities of purchasing a car with an automatic transmission -a used car are, and what’s the best place to look?

The cars sold in Spain are the same as in other countries, so you will find automatic transmissions without a problem.
Just take a look at the local dealer and other car sellers.

Thank you,Clav.

You are welcome.  😉