I actually debated on including the word "social" in the title and ultimately decided against it. It doesn't matter if you're building productivity software (spreadsheets, databases, etc…) or social software, you're going to learn exponentially more about the pain points your users experience once your app is in the wild.
At the end of the day users decide how they are going to use your product.