Scrape posts from X accounts into a Google Sheet
A sheet of an X account's posts with full text, links, dates, and engagement metrics
Go to X and pull posts from [accounts, e.g. @handle1, @handle2] into a Google Sheet [sheet link, or create one]. For each account, open the profile and scroll through [range, e.g. the last 30 days, or the latest 200 posts]. Include [post types, e.g. original posts and threads; skip replies and reposts]. Add one row per post: account, date (YYYY-MM-DD), full text (expand "Show more" and keep threads together), post URL, likes, reposts, replies, views, and media type. Use the post ID from the URL to deduplicate. Scroll at a human pace. If X shows a rate limit, login wall, captcha, or error, stop and tell me where you got to instead of retrying. Read-only: do not like, follow, reply, or repost. When done, sort by [metric, e.g. views] and send me a short summary: posts captured per account, the date range actually covered, the top five posts, and anything you could not read.