Sometimes there are Facebook groups that notify you about open slots if the consulate is popular enough. Personally I was successful only after emailing the embassy to please inform me the moment when slots are open, and even then I was too slow and had to ask again. I guess I got lucky or happened across a nice person? Other than that, I'm not sure much else can be done except to just be persistent. It's really frustrating though and I totally understand