n8n Workflow: Track Threads Posts with Apify + Google Sheets

Track Threads posts from your watchlist—and get a daily digest automatically

This n8n workflow monitors Threads profile watchlists in Google Sheets, uses Apify’s meta-threads-posts-scraper to fetch only posts since yesterday, and writes results into dedicated Google Sheets tabs—highlighting new posts, high-engagement posts, and any profiles that need attention.

What this workflow does

• Reads a Threads watchlist from Google Sheets to get the set of profile handles to check.
• Skips chronically failing profiles to focus resources on accounts that are still eligible for retries.
• Fetches recent posts via Apify using the Apify actor meta-threads-posts-scraper (configured to pull posts since yesterday).
• Routes outcomes to Google Sheets by outcome type:
  • Fetch failures are logged as “needs attention”.
  • Posts with 50+ combined likes and replies are flagged as high engagement.
  • All other new posts are added to the daily digest.
• Tracks fetch health per profile and updates the watchlist:
  • Marks profiles as failing (with a timestamp) after failed runs.
  • Clears the failing status after a successful run.
• Appends a run audit summary row to a Google Sheets run log, including counts for failures, high-engagement posts, new posts, and profile status changes.
• Monthly maintenance: a Schedule Trigger escalates profiles failing for 7+ days to chronically_failing, and clears that status for a fresh retry.

Use cases

• Competitive monitoring for SaaS teams tracking Threads announcements.
• Marketing ops workflows that turn Threads activity into a daily digest in Google Sheets.
• Ops visibility dashboards that surface which profile scrapes are failing and when.

Technical details

• Apify integration using the community node: @apify/n8n-nodes-apify.
• Uses logic and flow control nodes such as code, filter, switch, merge, aggregate, and a sticky note.
• Writes results, high-engagement flags, and per-run audit summaries back to Google Sheets.