Awesome Open Source
Awesome Open Source


Automatically monitor and log fans/followers/likes counters from social media (Facebook Pages, Twitter, Instagram, YouTube, Google+, OneSignal, Alexa) using APIs to Google Spreadsheet. Very useful for website admins and social media managers.

This Google Apps Script reads numbers from social media and pages via APIs or URL parsing EVERY DAY - so you don't need to! Also you can analyze them at long-term and create cute charts.

I'm using this for some time and wanted to share it since I couldn't find this much automated and exact solution. These are all I can do with my current level of expertise (read as:"beginner"). If you know shorter ways, or want to add any social media/application, pull requests are very welcome!

Currently Available Stats

  • Likes count from a Facebook Page you're admin/moderator of
  • Likes count from any Facebook Page - though needs improvement
  • Followers count from any Twitter profile
  • Followers count from any Instagram profile
  • Subscribers count from any YouTube channel
  • Followers count from any Google+ page
  • Reachable subcsribers count from OneSignal
  • Current international and local page rank from Alexa

Needed Integrations

  • Google Analytics
  • Google AdWords
  • WordPress

Example Spreadsheet

Here is an example spreadsheet with further analysis and charts!


Hopefully, this covers everything needed. If something doesn't work for you (or if it saves you time!) drop a comment here. Happy tracking!

Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
Automation (6,751
Monitoring (4,111
Twitter (3,906
Script (3,904
Youtube (3,441
Chart (2,234
Analytics (2,174
Instagram (2,102
Social Media (1,185
Alexa (802
Spreadsheet (558
Google Analytics (555
Google Apps Script (469
Counter (406
Google Spreadsheet (190
Related Projects