Track Facebook Page post Engagement (Comments, Like, Shares) in Google Sheets

Description

This workflow automatically retrieves engagement data (likes, comments, and shares) from a Facebook Page and stores the results in a Google Sheets document for reporting and analysis.

This workflow is particularly useful for:

Social Media Managers
Marketing Agencies
Performance Analysts
Client reporting automation

It provides a lightweight but powerful engagement monitoring system without requiring expensive analytics tools.

Key Advantages

1. ✅ Automated Engagement Tracking

It eliminates manual data collection from Facebook Insights, saving time and reducing human error.

2. ✅ Centralized Reporting

All engagement metrics (likes, comments, shares) are consolidated into a single Google Sheet, making it easy to:

Build dashboards
Share reports with clients or teams
Track performance over time

3. ✅ Scalable & Configurable

The number of posts analyzed can be changed easily.
The workflow can be scheduled instead of manually triggered.
It can be extended to include additional metrics (e.g., reach, impressions).

4. ✅ Structured Data Management

Using:

POST ID as a unique key
Append or Update mode

ensures data consistency and prevents duplication.

5. ✅ API Rate-Limit Protection

The use of:

Split in Batches
Wait nodes

helps prevent hitting Facebook API rate limits.

6. ✅ Modular & Maintainable Design

Each engagement type (comments, likes, shares) is handled in a separate branch, making:

Debugging easier
Future modifications simpler
Extensions more structured

How it works

The workflow follows this process:

Trigger & Configuration: The workflow is manually triggered and begins by setting a maximum number of posts to analyze (default: 3)

Data Collection:
Fetches basic page information using Facebook Graph API
Retrieves the page feed with the specified post limit
Splits the feed data into individual post items for processing

Parallel Processing: The workflow creates three parallel loops to handle different engagement metrics:
Loop 1: Processes comments for each post
Loop 2: Processes reactions/likes for each post
Loop 3: Processes shares for each post

API Calls: Within each loop, the workflow makes specific Facebook Graph API calls to fetch:
Comments with summary statistics
Reactions with type breakdown
Share counts

Data Storage: Each metric is written to Google Sheets using separate Google Sheets nodes, updating rows based on POST ID matching to maintain data consistency

Rate Limiting: Wait nodes are placed after each Google Sheets operation to prevent hitting API rate limits

Set up steps

Facebook Graph API Setup:
Obtain a temporary access token from Facebook Graph API Explorer and select the Facebook App and your Facebook Page
Configure the "Facebook Graph" credential in n8n with your access token
Ensure your Facebook page ID is accessible via the "me" node endpoint

Google Sheets Configuration:
Clone this Google Sheet
Set up the sheet with columns: POST ID, POST, LIKES, COMMENTS, SHARES
Configure Google Sheets OAuth2 credentials in n8n

Workflow Customization:
Adjust the max_post value in the "Set Max Posts" node to control how many posts to analyze
Modify the Wait node timings if needed (currently using default settings)
Update the Google Sheets document ID if using a different spreadsheet

Testing:
Execute the workflow manually to verify connections
Check Google Sheets for properly populated engagement data
Monitor n8n execution logs for any API errors or rate limiting issues

Scheduling (Optional):
Replace the manual trigger with a Schedule Trigger node to run automatically
Set desired frequency (daily, weekly, etc.) for regular engagement tracking

👉 Subscribe to my new YouTube channel. Here I’ll share videos and Shorts with practical tutorials and FREE templates for n8n.

Need help customizing?
Contact me for consulting and support or add me on Linkedin.