LinkedIn Posts & Engagement Data Extraction

For the past 12 months I want every piece of activity on my LinkedIn account captured and laid out in a single Google Sheets workbook—no scraping tools, browser extensions, or automated scripts are allowed. I will share temporary access to the profile once we agree on an approach, and you will browse it manually.

Scope
• Copy every post I have published in the last year, pasting the full text
• Record every visible engagement on each post—likes/reactions, comments (with commenter name, timestamp, and comment text), and any reposts or shares you can see.
• Export my complete followers list with displayed name, headline, and the date they followed (if shown).
• Export my full connections list with name, headline, current role, and first-connection date (again, only what LinkedIn shows).

Organization
All rows must be grouped chronologically by post date. Use additional columns to distinguish engagement type and to link each engagement row back to its parent post.

Deliverables
You will extract:
• all posts
• all visible engagement (likes, comments, reposts)
• followers list
• connections list

Sheet 1: Posts
For each post/blog/article:
• post_id
• post_title (or first line)
• post_text_short
• post_url
• post_type (text/image/video/article)
• posted_date

Sheet 2: Persons
Create a unique list of all people from:
• post engagements
• followers
• connections

For each person:
• person_id
• full_name
• linkedin_url
• company_name
• title_role

Sheet 3: Engagement
For each post, capture all visible engagement:
• engagement_id
• post_id
• person_id
• eng_type (like / comment / repost)
• comment_text (if comment)
• repost_text (if applicable)