Score BizQuest listings and alert top deals with Apify, Claude, Sheets and Slack

Go to Workflow
0 views
Built by David Schreiber David Schreiber
Created on June 07, 2026

Description

Quick overview
This scheduled workflow scrapes BizQuest listings via an Apify API, deduplicates them against a Google Sheet, scores buyer fit with Anthropic Claude, and for high-fit deals generates broker outreach copy and sends a formatted alert to Slack while logging all scored listings to Google Sheets.

How it works
Runs daily on a cron schedule (default 5:00 AM).
Sends a POST request to the Apify BizQuest scraper task using your buy-box filters and normalizes the returned listings, estimating SDE as 10% of revenue when missing.
Sorts listings by SDE, keeps the top 100, and processes them one by one.
Checks Google Sheets for the listing link and skips any listing that already exists.
Uses Anthropic Claude (Haiku) to score buyer fit (1–5) and output a short rationale and confidence level for each new listing.
Appends low-scoring deals (1–3) to Google Sheets for audit tracking.
For deals scoring 4–5, uses Anthropic Claude (Sonnet) to draft a broker outreach message, appends the enriched row to Google Sheets, and posts a Slack message with the deal details and copy-ready outreach text.

Setup
Add credentials for Google Sheets (OAuth2), Slack (OAuth2), and Anthropic.
Create a Google Sheet with matching columns (including Link, Fit Score, Fit Rationale, Fit Confidence, and Broker Message) and replace YOUR_GOOGLE_SHEET_ID in both Google Sheets nodes.
Update the Apify task API URL in the HTTP request node and ensure it points to your BizQuest scraper task.
Edit the buy-box fields (buyBox text, keyword, cashFlowMin, priceMax, listingAgeDays) and set the target Slack user/channel ID for alerts.

Nodes Used (7)

AI Agent
@n8n/n8n-nodes-langchain.agent
Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic
Code
n8n-nodes-base.code
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
Slack
n8n-nodes-base.slack
Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured