Something essential when working with social media is to keep track of the progress. There are many reasons to work with social media but no matter if it’s for marketing or brand building one needs to have some type of metrics to evaluate work. The simplest is just tracking amount of followers whilst other more complicated could be tracking user sentiment towards your brand.
This blog post describes how to “How to import social media data into a Google spreadsheet with the ImportXML function”. It lists how to do this for Linkedin, Pinterest, Alexa rank, Facebook, twitter, Instagram, Google+, Quora, Reddit and Youtube. Formulaes are working as of January 2016.