You are not idiot at all. You just want to be real friend but you get closed more so look at it like mistake that every body could do it .it’s not end of the world forgive your self and try to keep yourself busy with other things other friend or other relation and improve the skill to say NO when she sent message reply oh I understand what do you mean I am sorry but I can not some to see you or I am sorry I can not talk now I am busy I must finish my project I hope evry thing get fine or some answers like this it show you care and you understand but you can not solve all the problems in this world
Good luck