Facebook Public Data to Google Sheets Connector
Access public Facebook Page data, post engagement, and URL sharing metrics without needing a Facebook account connection. Free forever plan with 35 monthly updates.
No credit card required
Why connect Facebook Public Data to Google Sheets?
- Data centralization
- Automatic updates
- Custom analysis tailored to your needs and goals
- Campaign optimization
Everything You Need for Facebook Public Data Reporting
Page Info & Metadata
Retrieve any public Facebook Page's name, category, description, follower count, and location details. Monitor competitor pages or track your own brand presence.
Post-Level Engagement
Analyze individual post performance with likes, reactions (love, wow, haha, sad, angry), comments, and shares. Track engagement rates over time.
Reaction Breakdown
Go beyond simple likes — see the full breakdown of Love, Wow, Haha, Sad, and Angry reactions on every post. Understand audience sentiment at a granular level.
URL Engagement Metrics
Measure how any URL performs on Facebook — track shares, comments, reactions, and comment plugin activity. Great for content marketing analysis.
No OAuth Required
Unlike other data sources, Facebook Public Data works without connecting a Facebook account. Simply enter a page name or URL to start pulling data instantly.
Computed Per-Post Rates
Get pre-calculated averages like likes per post, reactions per post, comments per post, and shares per post for quick performance benchmarking.
Facebook Public Data in numbers
200+
Connected accounts
100+
Weekly users
10K+
Queries executed last week
Google Sheets Features
Query Builder
Select exactly the metrics and dimensions you need. Apply filters to refine your data without writing formulas.
Scheduled Updates
Set automatic refreshes hourly, daily, weekly or monthly. Your reports update themselves while you sleep.
Multiple Accounts
Each query supports unlimited accounts. Pull data from all your clients' accounts in one single request.
How It Works
Install Detrics Add-on
Get Detrics from Google Workspace Marketplace. No Facebook account needed.
Enter a Page Name or URL
Type any public Facebook Page name or paste a URL. Choose the metrics and dimensions you want to track.
Automate
Set refresh schedules from hourly to monthly. Your reports update automatically.
Start Free, Scale When Ready
No credit card. No trial limits. Free forever plan included.
Free Forever
$0
35 queries/month with all features
What you'll get
- All Data Sources
- 1,000 rows per query
- Unlimited accounts
- Hourly refresh
1,000+ Agencies Already Trust Us
- 50+ agencies migrated from Supermetrics to Detrics
- Average savings of $15K USD annually
- Quality and satisfaction guarantee