RB2B Visitor Digest to Slack via Google Sheets & Claude (n8n)

Turn RB2B website visitor signals into an instant Slack daily digest—automatically

This n8n workflow logs RB2B-identified visitors into Google Sheets and posts a morning Slack digest summarizing yesterday’s visits, including top pages and recommended follow-ups using Anthropic Claude.

What this workflow does

• Receives real-time visitor events via a webhook: when RB2B detects an identified visitor, it sends a POST request to the n8n endpoint (the rb2b-visitor webhook).
• Stores visitor details in Google Sheets: the workflow appends name, company, email, page, referrer, and timestamp into a “Visitors” sheet.
• Runs every morning on schedule, then loads all logged visitors from Google Sheets.
• Filters to yesterday’s visits and aggregates them into a single payload for reporting.
• Generates a structured summary with Claude: sends the aggregated visit data plus your focus instructions to Anthropic Claude to produce:
  • a summary of yesterday’s activity
  • top visited pages with counts
  • outreach recommendations / follow-up list
• Posts the digest to Slack in your configured channel (summary + follow-ups).

Use cases

• SaaS teams who want lead visibility from RB2B in a daily Slack report.
• Sales/BDR workflows that need page-based context (top pages) and recommended follow-ups.
• Automation engineers standardizing an n8n + Google Sheets + Slack reporting pipeline enhanced by Claude.

Technical details

• Webhook to receive RB2B events
• Google Sheets to append and read from the “Visitors” sheet
• Filter to keep only yesterday’s rows; Aggregate to build the digest payload
• Anthropic (Claude) to generate the summary and outreach recommendations
• Slack to post the formatted daily digest to a chosen channel
• Supports scheduled morning runs; configuration via workflow “Config (edit me)” values

Set it up once in RB2B, connect Google Sheets, Claude, and Slack, and let your team receive a daily, AI-assisted visitor report.