Track Facebook page engagement with Facebook Graph API and Google Sheets
Ready for 3.0What this workflow does
This workflow has 15 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Facebook Graph API and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Configuration (Edit Fields (Set)): sets 3 fields: max_posts, graph_api_version, wait_seconds_between_posts
- Get Facebook Page Info (Facebook Graph API): uses Facebook Graph API
- Get Recent Page Posts (Facebook Graph API): uses Facebook Graph API
- Split Out: splits a list into separate items
- Fetch Post Comments (Facebook Graph API): uses Facebook Graph API
- Fetch Post Reactions (Facebook Graph API): uses Facebook Graph API
- Fetch Post Shares (Facebook Graph API): uses Facebook Graph API
- Format Comment Count (Edit Fields (Set)): sets 2 fields: post_id, comment_count
- Format Like Count (Edit Fields (Set)): sets 2 fields: post_id, like_count
- Format Share Count (Edit Fields (Set)): sets 3 fields: post_id, post_message, share_count
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Facebook Graph API
n8n-nodes-base.facebookGraphApi - Split Out
n8n-nodes-base.splitOut - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait
From the author
Quick overview This workflow runs manually or daily to pull your Facebook Page’s most recent posts, calculate per-post likes, comments, and shares via the Facebook Graph API, and append or update each post’s engagement metrics in a Google Sheets spreadsheet.…