The most basic level is GitHub, Gitlab, etc are used to store version controlled files which can be anything from like a wiki, an apps source files, your random collection of scripts, etc.

They have added features like the ability to offer artifacts which could be an already compiled exe or rpm, or just the source code for you to self compile. Which option they give is dependent on which repo and usually that repo maintainer will have directions for how you install their thing.