Templates / Capture social DMs with purchase intent using FanBase, Apify and Google Sheets

Capture social DMs with purchase intent using FanBase, Apify and Google Sheets

Unknown

by sebastian · 2 views · created 2026-08-12 · Lead Generation, AI RAG

Unknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 12 nodes and runs on a schedule (every 15 minutes). Along the way it connects MCP Client, Google Sheets and Apify (community).

How it runs

Trigger: On a schedule (every 15 minutes).

  1. Retrieve Watermark Data (Data table): get
  2. Fetch Direct Messages (MCP Client): uses MCP Client
  3. Identify Intent in DMs (Code): runs custom JavaScript code
  4. Store Watermark Data (Data table): create or update
  5. Process CRM Page (MCP Client): uses MCP Client
  6. Process CRM Page (MCP Client): uses MCP Client
  7. Merge: merges the data from its input branches
  8. Resolve Social Handles (Code): runs custom JavaScript code
  9. Execute Actor for Lead Data (Apify): run actor and get dataset
  10. Assemble CRM Data Row (Code): runs custom JavaScript code

…plus 1 more step. See the full node list below.

Services it uses

MCP ClientGoogle SheetsApify (community)

Before you upgrade to n8n 3.0

We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).

  • Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Execute Actor for Lead Data).

Nodes used (7)

From the author

Quick overview This workflow runs every 15 minutes to scan your socials with FanBase Copilot DMs for purchase-intent messages, enriches matched fans by resolving their social handle via FanBase CRM and scraping their Instagram profile with Apify, then writes…

Excerpt from sebastian's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.