There is no walk-in service for United States citizens who require a service related to citizenship. These services are by appointment only:
Schedule an appointment for citizenship services at Embassy Madrid
Schedule an appointment for citizenship services at Consulate General Barcelona