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

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:

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

2. 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

1. 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

1. 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

1. 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

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

---

Set up steps

1. 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

1. 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

1. 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

1. 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

1. 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.