Hi,
For Spain, as far as I know the last change in the law was in December 2017.
If your drone is less than 2Kg it's quite easy : basically you can't fly in controlled airspace or in/over National Parks, not near airports (must be at least 8Km), not over buildings/cities and crowds, you must maintain visual line of sight and are limited to 120m AGL.
There is an official map that shows where it's permitted to fly :
ENAIRE Drones
FAQ about Spanish rules (in Spanish) :
Preguntas frecuentes-Drones-Trabajos aéreos-Compañías o empresas-AESA-Agencia Estatal de Seguridad Aérea - Ministerio de Fomento
I have no idea for Andorra.