Marketing

Facebook Page Metrics into Google Sheets

Alex Black

Alex Black

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.

GET

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

Add data sources

Build reports & dashboards

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

Facebook Page Metrics

Please fill in any necessary fields and click Run.

GET

Preview

View the API data, get a live Google Sheet dashboard

name
period
values
title
description
id
      
      
      

Get a live Google Sheet

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

Automatically updated

Add data sources

Build reports & dashboards