Render Positive
Get in touch


Render Positive

Get Social Sharing Stats in a Spreadsheet

By Han | 5th Mar 2015 | Posted in Data and Tools

SharedCount logo


A couple of years ago, we shared a spreadsheet that you can use for getting sharing stats across Facebook, Twitter, Reddit, Pinterest, LinkedIn… plus a few more. Since then, the SharedCount API that made this possible has changed a little bit, so we’ve made some updates to the Google Docs sheet so that it still works.

sharing stats

Here’s what you need to do:

  1. Sign in to Google.
  2. Open the spreadsheet.
  3. Go to File > Make a copy… to save a version to your own account.
  4. Head to and sign up for a free account.
  5. Grab your API key from your account info page, and paste it into cell B1.
  6. Update column A with all the URLs you want stats for, and drag the formulas down as necessary!

As with the previous version, there are a couple of things to bear in mind: the data will reload every time you open your spreadsheet, so it’s worth exporting as a CSV or Excel file if you want to keep a snapshot. SharedCount caches its metrics and updates every five minutes, so if you want to re-check something then you’ll have to wait that long.


Sign up now!

Get more great stuff delivered fresh to your inbox.

2 Responses to “Get Social Sharing Stats in a Spreadsheet”

  1. Just what I was looking for guys, a free way to monitor my social shares on a Google Spreadsheet.


Leave a Reply

Want to know what we could achieve for you?

View all resources Useful stuff

Meet the team

Jon Buchan
Hannah Brown
Jenny Longmuir
Tess Bowles
Lee Buchan
Asher Baker
Bree Van Zyl
Sam Reynolds
Aida Staskeviciute
Laura Reddington
Dipak Hemraj
Jess Collett
Gemma MacNaught
Laila Khan
Gary Buchan
James Hackney
Stuart Lawrence

Jon Buchan Chief Executive Officer
07949 283 785
Hannah Brown Creative Yet Technical Manager
07453 779 030
Jenny Longmuir Content Marketing Editor
Tess Bowles Social Media & Content Marketing Manager
Lee Buchan SEO and Social Media Executive
Asher Baker SEO & PPC Manager (and Lord)
07525 744 178
Bree Van Zyl Video Productionista
Sam Reynolds Copywriter
Aida Staskeviciute Graphic Designer
Laura Reddington Copywriter
Dipak Hemraj All Rounder
Jess Collett Copywriter
Gemma MacNaught Head of UX and Conversion Rate Optimisation
Laila Khan Head of PR
Gary Buchan Managing Director
07525 839 157
James Hackney Client Services Manager
07725 209 820
Stuart Lawrence Chief Technical Officer
07725 209 819

Stalk us on social…