Back

Scrape Facebook page or group posts into a sheet

A Google Sheet of posts from a Facebook page or group with text, engagement, and links

MarketingAnalysts
Prompt

Open [Facebook page or group URL, e.g. a local business page or an industry group I belong to] in my logged-in Facebook and collect posts from [date range, e.g. the last 90 days]. Scroll the feed at a human pace and expand "See more" on each post. For every post capture [fields, e.g. post date, author name, post text, reaction, comment and share counts, image URLs, post link]. List multiple image URLs in one cell. Read-only: do not react, comment, join, or message anyone. Stop at any captcha, rate warning, login prompt, or members-only wall and report how far you got. Put the results in a Google Sheet [new sheet or existing sheet name], one row per post, deduplicated, dates as YYYY-MM-DD, counts as numbers. Add a tab with the top [number, e.g. 10] posts by total engagement. Finish with the post count, the date range covered, and any posts you could not fully read.

Works withfacebook.comdocs.google.com