LinkedIn to Airtable, turn likes into content ideas
You hit “Like” on a LinkedIn post, tell yourself you’ll come back later, and then it disappears into the feed forever. A week later you’re staring at a blank doc, knowing you had at least five great angles saved “somewhere”.
This LinkedIn Airtable automation hits marketers hard, but founders and newsletter writers feel it too. If you rely on LinkedIn for ideas, this gives you a simple system that captures what you like and turns it into a searchable content vault.
Below you’ll see exactly how the workflow works, what it saves you in real time, and what you need to set it up without getting stuck in technical weeds.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: LinkedIn to Airtable, turn likes into content ideas
flowchart LR
subgraph sg0["Schedule Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Fetch LinkedIn Likes"]
n2@{ icon: "mdi:swap-vertical", form: "rounded", label: "Split Liked Posts", pos: "b", h: 48 }
n3@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Filter Insightful & Recent", pos: "b", h: 48 }
n4@{ icon: "mdi:swap-vertical", form: "rounded", label: "Format Content Idea", pos: "b", h: 48 }
n5@{ icon: "mdi:swap-vertical", form: "rounded", label: "Prepare for Airtable", pos: "b", h: 48 }
n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/airtable.svg' width='40' height='40' /></div><br/>Save to Airtable"]
n0 --> n1
n2 --> n3
n4 --> n5
n1 --> n2
n5 --> n6
n3 --> n4
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n3 decision
class n6 database
class n1 api
classDef customIcon fill:none,stroke:none
class n1,n6 customIcon
The Problem: Your best content ideas die in the LinkedIn feed
Likes are a signal. They’re also a graveyard. You like posts because they taught you something, challenged you, or perfectly phrased what you already believed. But LinkedIn doesn’t make it easy to build a working “idea library” from that signal. You end up scrolling back through your activity, opening a dozen tabs, and trying to remember why a post mattered in the first place. Even worse, if you’re planning content weekly, you can lose the context entirely. The post is there, but the spark is gone.
It adds up fast. Here’s where it usually breaks down:
- You spend about 30 minutes a week just re-finding posts you already liked.
- Copy-pasting into notes creates messy entries, missing links, and duplicate ideas.
- The “I’ll remember this later” approach fails the moment you have a busy week.
- There’s no consistent structure, so searching and tagging becomes a chore.
The Solution: Automatically save recent LinkedIn likes into Airtable
This workflow turns your LinkedIn reactions into a clean Airtable table you can actually use. It runs on a schedule, pulls your most recent liked posts through a LinkedIn scraping API (via RapidAPI), and then narrows the list to the reactions you care about from the last 7 days. After that, it packages each post into consistent fields, so you don’t get the usual “random blob of text with no link” problem. Finally, it creates a new record in Airtable for every qualifying post, including the author info, the post content, and the original URL. Your likes stop being passive. They become raw material for drafts, newsletter sections, swipe files, or client content planning.
The workflow starts with a scheduled trigger. Then it retrieves your reactions, splits them into individual entries, filters for “recent + insightful,” and formats the content. Airtable becomes your central idea vault, ready for tagging and planning.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you like about 10 posts a week and want to turn them into potential content. Manually, it’s maybe 5 minutes per post to find it again, copy the text, grab the author name, and paste the link into a doc, which is close to an hour. With this workflow, you spend about 5 minutes once to set your schedule and Airtable fields, then it quietly captures the last 7 days of likes for you. Your “idea capture” time drops to basically zero, and the ideas show up already structured.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Airtable for storing ideas in a base/table.
- RapidAPI to access the LinkedIn scraper endpoint.
- RapidAPI key (get it from your RapidAPI dashboard)
Skill level: Beginner. You’ll connect accounts, paste an API key, and match a few Airtable fields.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A schedule kicks things off. You choose how often it runs (daily is common), so your idea vault stays fresh without you remembering to do anything.
LinkedIn reactions are retrieved. n8n calls a LinkedIn reactions endpoint through RapidAPI, using your username and API key so it can fetch your most recent activity.
Only the good stuff makes it through. The workflow splits the results into individual posts, then filters them to keep posts from the last 7 days that match your chosen reaction type.
Airtable records get created. The post text, author details, and the source URL are formatted into clean fields, then saved into your Airtable “Ideas” table inside a “Content Hub” base.
You can easily modify the 7-day window to 14 days, or change the fields written to Airtable so it matches your content system. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Schedule Trigger
This workflow starts on a schedule to pull recent LinkedIn reactions automatically.
- Add the Scheduled Automation Start node as the trigger.
- In Rule → Interval, choose your desired schedule (the current configuration uses the default interval structure).
- Confirm the node is connected to Retrieve LinkedIn Reactions to begin the flow.
Step 2: Connect LinkedIn Reactions Retrieval
This step pulls your recent profile likes from the RapidAPI LinkedIn endpoint.
- Select the Retrieve LinkedIn Reactions node.
- Set URL to
https://linkedin-api8.p.rapidapi.com/get-profile-likes. - Enable Send Query Parameters and add username with value
[YOUR_ID]and start with value0. - Enable Send Headers and set x-rapidapi-host to
linkedin-api8.p.rapidapi.comand x-rapidapi-key to[CONFIGURE_YOUR_API_KEY]. - Connect Retrieve LinkedIn Reactions to Separate Liked Entries.
⚠️ Common Pitfall: The RapidAPI key is set in headers, not credentials. Make sure [CONFIGURE_YOUR_API_KEY] is replaced with a valid key or the request will fail.
Step 3: Split and Filter the Reaction Items
This stage separates items and keeps only insightful reactions from the last 7 days.
- Open Separate Liked Entries and set Field to Split Out to
data.items. - In Filter Insightful Recent, configure the conditions:
- Set the first condition to check Left Value
={{ $json.action }}containsinsightful. - Set the second condition to check Left Value
={{ new Date($json.postedDate).getTime() }}is greater than={{ new Date().getTime() - (7 * 24 * 60 * 60 * 1000) }}. - Confirm the flow continues to Compose Content Draft.
Step 4: Build Draft Fields and Prepare Airtable Columns
This step constructs the fields and splits them into individual entries before storing them.
- In Compose Content Draft, set the field assignments:
- Set Title to
=I just liked a linkedin post of {{ $json.author.username }}. - Set description to
={{ $json.text }}. - Set source to
={{ $json.postUrl }}. - In Split Fields for Airtable, set Field to Split Out to
Title, description, source.
Step 5: Configure Airtable Output
This action creates a new record in Airtable with the drafted content details.
- Open Create Airtable Record and set Operation to
create. - Select your Airtable Base and Table (currently set to
[YOUR_ID]placeholders). - Map fields in Columns:
- Set Type to
Linkedin, Title to={{ $json.Title }}, Source to={{ $json.source }}, Description to={{ $json.description }}, and Status tofalse. - Credential Required: Connect your airtableTokenApi credentials.
Step 6: Test and Activate Your Workflow
Validate each step to ensure reactions are captured and stored correctly.
- Click Execute Workflow to run the process manually.
- Confirm that Retrieve LinkedIn Reactions returns data and Filter Insightful Recent passes only recent “insightful” items.
- Verify that Create Airtable Record creates new rows in the Ideas table with correct Title, Description, and Source.
- Once successful, toggle the workflow to Active to enable scheduled automation.
Common Gotchas
- RapidAPI credentials can expire or need specific permissions. If things break, check your RapidAPI subscription status and header key in the “Retrieve LinkedIn Reactions” node first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 30 minutes if your Airtable base is ready.
No. You will paste an API key and map a few fields in Airtable.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in RapidAPI costs for the LinkedIn scraper endpoint.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, but you’ll change the filter logic. The “Filter Insightful Recent” node is where the 7-day limit lives, so you can adjust it to 30 days and keep everything else the same. Common customizations include writing extra fields to Airtable (like Topic or Hook), changing the reaction type you capture, and adding a quick AI summary before saving.
Most of the time it’s an expired Airtable token or the base/table changed names. Reconnect Airtable in the “Create Airtable Record” node, then re-select the base and table so the field mapping refreshes. Also check that your table has the required columns (Title, Description, Source, Type), because missing fields can cause silent failures.
It depends on your n8n plan and the API limits. On n8n Cloud Starter, you can run a set number of executions per month, and each scheduled run counts. If you self-host, there’s no execution limit, so the practical cap becomes your server size plus RapidAPI rate limits. In normal use (a few dozen likes a week), it runs comfortably without any tuning.
Often, yes, because the workflow relies on an API call, splitting items, filtering by recency, and then mapping fields into Airtable. That kind of multi-step logic is where n8n stays flexible without driving up task costs, and you can self-host if you want. Zapier or Make can still work, but you may spend more time fighting formatting and filter edge cases. The honest difference is control versus convenience. If you want it done quickly and correctly, Talk to an automation expert and we’ll point you to the best fit.
Once your likes land in Airtable automatically, content planning gets weirdly calm. The workflow handles the capture, so you can focus on writing the parts that actually sound like you.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
