Friend [subject-が] here [at-に] not-present [because-ので] disappointment is.
がっかり is a 擬態語 for the sinking feeling of disappointment — more visceral than the English word, evoking a physical deflation. ので softly connects the cause to the emotional result, less blunt than から.