Facebook Page Metrics into Google Sheets

💡

We have articles on tracking subscriber counts for: Facebook, Instagram, Twitter and YouTube.

Overview

You can get facebook page metrics into Google Sheets using our Facebook Page Insights connector, part of the SyncWith Google Sheets Addon.

In this article we're going to show you how to do that from scratch, using the Facebook Graph API, to enable you to do this in a completely custom way.

Step 1: Listing your pages

The first step is to list your Facebook pages. In order to get metrics for a Facebook page you'll need to know its ID, and have an access_token for it.

List Facebook Pages

Please fill in any necessary fields and click Run.

Endpoint

GET

Authentication

limit

Preview

View the API data, get a live Google Sheet dashboard

access_token	name	id

Get a live Google Sheet

Export your data to a google sheet, with the SyncWith Addon, or download to CSV

Automatically updated

Schedule your data to update hourly or daily

Add data sources

Import additional data from other apps

Build reports & dashboards

Easily build live reports within Google Sheets

Step 2: Get your facebook page's metrics

Once you have found your Facebook page's ID and access_token (above), now you can fetch metrics for it using the Facebook Insights API.

For a list of all possible metrics and more info see: https://developers.facebook.com/docs/graph-api/reference/v12.0/insights