See llms.txt for all machine-readable content.

Back to Templates

Send a weekly competitor LinkedIn digest with Apify, OpenAI and Slack

Quick overview

Every Monday this reads your competitors' LinkedIn posts and the posts that mention them, and compares each with last week. AI sums up the themes and spots launches, funding or layoffs. Each competitor gets a Google Sheets row. Spikes and announcements alert Slack, and the rest arrive as one digest.

How it works

  1. A Schedule trigger runs every Monday at eight.
  2. A Set node holds your competitors (name, LinkedIn company page, search name), what you sell and the alert rules.
  3. Google Sheets reads last week's row for each competitor, from the same sheet the workflow writes to.
  4. The first Actor reads the past week of posts on each competitor's company page, including the employee posts the page shows.
  5. The second Actor searches public LinkedIn posts that mention each competitor in the same week.
  6. A Code node tags every post with its competitor and drops search results that never name it. Remove Duplicates skips posts that were already counted in an earlier week.
  7. A Code node adds up posts, mentions and engagement per competitor and builds a numbered post list. If nothing could be collected at all, a Slack warning goes out instead.
  8. The Information Extractor writes themes, a two-sentence summary, what changed since last week and one takeaway. It points at any announcement by its post number.
  9. A Code node checks the number against the list and decides between an alert and the digest. Every competitor is appended to Google Sheets.
  10. Alerts go to Slack one by one, with the reason and the post link. The other competitors arrive in one digest message.

Setup

  1. Create a free Apify account, copy the API token from Settings, Integrations, and add it as an Apify credential on both Actor nodes.
  2. Add an OpenAI credential on the chat model node, or swap in any other chat model.
  3. Connect Google Sheets and pick the same spreadsheet and tab on both Sheets nodes.
  4. Connect Slack and pick a channel on all three Slack nodes.
  5. In the Set node, list each competitor's name, LinkedIn company page URL and the name people use for it in posts, and describe what you sell.
  6. Activate the workflow.

Requirements

  • An Apify account; the free tier covers a weekly run for a handful of competitors
  • An OpenAI API key, or any chat model credential n8n supports
  • Google Sheets and Slack credentials
  • No LinkedIn account, cookie or social listening subscription

Customization

  • competitors takes a name, a company page URL and a search name each; up to 25 pages and 20 search names per run
  • search is the phrase looked up in other people's posts. Use the name people actually write, such as "folk CRM" instead of "folk"
  • spikeFactor, minEngagement and minMentions set what counts as a spike against last week's row
  • days sets the window; use 1 with a daily schedule for a daily brief
  • Add your own company to the list to see your posts next to theirs
  • Add the optional leader posts step, or email the digest instead of posting it

Additional info

How do I monitor competitors on LinkedIn without checking every page? List each competitor's company page once. Every Monday the template reads the past week of posts on each page with a LinkedIn posts API and searches for posts by other people that name them. You get one Slack digest instead of five open tabs, and a separate alert when something actually changed.

What counts as a spike or an announcement? Engagement is likes plus comments on the posts on their page. A competitor alerts when that reaches twice last week's figure and at least 150, when mentions double and reach at least four, or when the model finds a post that announces something new, such as a launch, pricing change, funding, acquisition, partnership, senior hire or layoffs. The model points at the post by its number on a list, and a Code node drops any number that isn't on the list, so an alert always links to a real post.

Is this LinkedIn social listening without a login? Yes. Both Actors read public LinkedIn pages, so you never connect an account or paste a cookie. The mentions step works as a small social listening API for LinkedIn: one row per post with its text, author, date, reactions and comments.

Why are some search results dropped? LinkedIn's post search returns loosely related posts as well as exact matches. The template keeps a result only if the post actually names the competitor. On our test run that dropped one of five results, a post that matched the phrase "folk CRM" without ever saying "folk".

What if LinkedIn hides a competitor's page? Some company feeds aren't shown to signed-out visitors. That competitor is still tracked through the posts that mention it, and the sheet and digest say the page could not be read. If nothing at all can be collected, for example because every URL is wrong, Slack gets a warning instead of an empty digest.

Where does last week's baseline come from? From the same Google Sheet. Each run appends one row per competitor, and the next run reads the latest earlier row back. The first week has nothing to compare with, so only announcements alert that week.

What does it cost? Three competitors cost about 3 cents a week in Apify charges on the free plan and under a cent on a paid plan, plus one small model call per competitor. Search pages seen again within a few days come from a cache and are not charged, and a failed search is never charged.

What else can these Actors do? LinkedIn Posts API returns the recent posts of any public person or company page, or specific posts by URL, with post engagement numbers, tagged companies and top comments. LinkedIn Post Search API finds public posts and articles by keyword, name or hashtag for any date range. If you self-host n8n, n8n-nodes-linkedin-posts-api wraps the posts Actor as a community node.

About Apify. LinkedIn Posts API runs on Apify, a platform of ready-made scrapers and APIs for sources that have no usable public API. Actors are pay per use with no subscription. They run in the cloud, so nothing runs on your machine, and nothing breaks when the source changes its markup.

New to Apify? You can set up a free account and get the API token this template needs in a couple of minutes.