Score inbound B2B leads with OpenAI GPT-5.4 using Tally and Google Sheets

Description

This workflow automatically scores B2B leads by fetching and analyzing real company website data. It helps marketing and sales teams qualify inbound leads without manually researching each company.

Overview

A marketing employee submits a company name, LinkedIn URL, website URL, and scoring criteria through a Tally form. The workflow fetches the company's actual homepage, strips it to readable text, and runs it through a chain of three AI agents: one to normalize the input, one to extract intelligence from the real website content (tech stack, industry, company size signals), and one to score the lead against the submitted criteria. The scored, enriched lead is logged to a Google Sheet with a grade and recommended next action for the sales rep.

Tools Used

- n8n: The automation platform that orchestrates the workflow. - Tally: Free form builder used as the input layer where marketing employees submit companies to research. Create forms at [tally.so](https://tally.so). - OpenAI (GPT-5.4): Powers three chained AI agents for data normalization, website content analysis, and lead scoring. - Google Sheets: Logs every scored lead with timestamp, company details, tech stack, score, grade, reasoning, and recommended action.

How it works

1. A marketing employee fills out a Tally form with the company name, LinkedIn URL, website URL, and which scoring criteria matter (company size, industry fit, tech stack, geography, funding stage, hiring signals). 2. The Tally Trigger fires and sends the raw submission to Agent 1, which normalizes the payload into clean structured fields. 3. An HTTP Request node fetches the company's homepage HTML directly. 4. A Code node strips the HTML down to plain readable text (removes scripts, styles, navigation, footers) and truncates to 6,000 characters. 5. Agent 2 reads the actual homepage content and extracts structured intelligence: what the company does, their tech stack, company size signals, industry, and signals relevant to the buyer's criteria. 6. Agent 3 scores the lead 1-10 against the submitted criteria using the real website intelligence, assigns a grade (A-D), and writes a recommended action for the sales rep. 7. The enriched lead is appended to a Google Sheet.