Despite holding a six point lead, Clare were made sweat till the final seconds to secure their place in the provincial final