n8n Workflow: Apify filings + OpenAI lead scoring to Sheets, Slack & Gmail

Get daily “new filings” leads scored by OpenAI—then routed to the right place in Sheets, Slack, and Gmail

This n8n automation pulls fresh business filings from Apify every day, evaluates them with OpenAI lead scoring, saves results into Google Sheets without duplicates, and pushes hot leads to Slack for quick approval while warm leads receive a digest email via Gmail. A separate weekly run emails a 7‑day summary report.

What this workflow does

• Runs on a daily schedule (or manually) to load settings like Apify actor inputs, scoring thresholds, and delivery targets.
• Starts the “new-business-filings” Apify actor via the Apify API, then waits and polls until the run succeeds or fails.
• Downloads and validates dataset results, checks required fields, and deduplicates records against prior runs using workflow static data.
• Scores and qualifies each filing using rule-based criteria plus OpenAI output, generating structured results such as a fit score, verdict, summary, outreach angle, and red flags.
• Combines rule + OpenAI scoring into a final tier (hot/warm/cold).
• Upserts into Google Sheets to avoid duplicates across re-runs.
• Routes outcomes:
  • Hot leads: sent to Slack as an approve/dismiss message, and the decision is written back to Sheets.
  • Warm leads: emailed as an HTML digest via Gmail.
  • Cold leads: remain in the sheet only.
• Weekly schedule: reads the last 7 days from Google Sheets, builds a top-leads summary, and emails it via Gmail.

Use cases

• SaaS and sales teams turning business filings into qualified leads automatically.
• Operators who want human-in-the-loop review for high-priority prospects using Slack approve/dismiss.
• Marketing teams that need a 7-day lead digest without manual spreadsheet work.

Technical details

• Apify API to run the “new-business-filings” actor (authenticate using an HTTP Header Auth token, e.g., Authorization: Bearer ...).
• Core n8n nodes/logic: if, set, code, no op, wait, and Gmail.
• Google Sheets for upsert + deduplication checks; Slack for hot-lead approvals.
• OpenAI for structured lead scoring fields (fit score, verdict, summary, outreach angle, red flags).