Lead scoring
“score our hubspot contacts export from the lead scoring points table by company size, job title, and pages viewed; show each lead with total points and Status "Agrees" when the score matches the rules and nothing is missing”
score our HubSpot contacts export from the Lead scoring points table by company size, Lead scoring points table by job title, and Lead scoring points table by pages viewed; show each lead with total points and Status "Agrees" when the score matches the rules and nothing is missing
What the agent built
8 steps, each one an ordinary Mammoth step you can open and change.
- FileHubSpot contacts exportCSV export · 24 rows
- FileLead scoring points tableCSV export · 15 rows
- FileLead scoring points tableCSV export · 15 rows
- FileLead scoring points tableCSV export · 15 rows
- StepPrepare lead keysStep 4
- StepKeep company rulesStep 1
- StepKeep job rulesStep 2
- StepExpand page rulesStep 3
- JoinAdd company points23 of 24 paired
- JoinAdd job points20 of 24 paired
- JoinAdd page points23 of 24 paired
- StepTotal points and statusStep 8
- ResultLead score check24 rows · 6 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 24 rows came out, and the join paired 23 of 24 rows; the join paired 20 of 24 rows; the join paired 23 of 24 rows.
- Download HubSpot contacts export sample (24 rows)HubSpot: Contacts > Contacts > Export view
- Download Lead scoring points table sample (15 rows)HubSpot: Contacts > Lists/Scoring rules > Export points table
- Download Lead scoring points table sample (15 rows)HubSpot: Contacts > Lists/Scoring rules > Export points table
- Download Lead scoring points table sample (15 rows)HubSpot: Contacts > Lists/Scoring rules > Export points table
What you get back
The result of that run, the rows to look at first.
| Company size | Job title | Pages viewed | vid | firstname | lastname | company | company_size | job_title | pages_viewed | lead_source | create_date | last_activity_date | Company size key | Job title key | Pages viewed key | Company points | Job points | Page points | Total points | Status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11-50 | Account Executive | 2 | 8,401,207 | sophia.nguyen@pulseware.example | Sophia | Nguyen | Pulseware | 11-50 | Account Executive | 2 | Organic Search | 2026-10-02 | 2026-10-23 | 11-50 | account executive | 2 | 10 | · | 3 | 13 | Missing job title rule |
| 1-10 | Marketing Director | 9 | 8,401,210 | ethan.brooks@riverpine.example | Ethan | Brooks | Riverpine | 1-10 | Marketing Director | 9 | Referral | 2026-10-11 | 2026-10-21 | 1-10 | marketing director | 9 | 5 | · | 15 | 20 | Missing job title rule |
| 201-500 | Growth Lead | 3 | 8,401,222 | nina.bell@quarrycloud.example | Nina | Bell | Quarry Cloud | 201-500 | Growth Lead | 3 | Paid Search | 2026-10-13 | 2026-10-23 | 201-500 | growth lead | 3 | 20 | · | 8 | 28 | Missing job title rule |
| 11-50 | Chief Revenue Officer | 8 | 8,401,219 | amelia.scott@pinehollow.example | Amelia | Scott | Pine Hollow | 11-50 | Chief Revenue Officer | 8 | Webinar | 2026-10-07 | 2026-10-26 | 11-50 | chief revenue officer | 8 | 10 | · | 15 | 25 | Missing job title rule |
| 1001-5000 | CEO | 7 | 8,401,211 | chloe.wilson@peakpilot.example | Chloe | Wilson | Peakpilot | 1001-5000 | CEO | 7 | Organic Search | 2026-10-08 | 2026-10-29 | 1001-5000 | ceo | 7 | · | 20 | 15 | 35 | Missing company size rule |
| 11-50 | Sales Manager | 0 | 8,401,212 | daniel.ross@bluecove.example | Daniel | Ross | Bluecove | 11-50 | Sales Manager | 0 | Direct | 2026-09-18 | 2026-10-20 | 11-50 | sales manager | 0 | 10 | 12 | · | 22 | Missing pages viewed rule |
| 201-500 | Head of Marketing | 5 | 8,401,203 | mia.roberts@brightbeam.example | Mia | Roberts | BrightBeam | 201-500 | Head of Marketing | 5 | Referral | 2026-10-10 | 2026-10-27 | 201-500 | head of marketing | 5 | 20 | 16 | 8 | 44 | Agrees |
| 11-50 | Director of Operations | 10 | 8,401,215 | ruby.white@novapath.example | Ruby | White | Novapath | 11-50 | Director of Operations | 10 | Organic Search | 2026-10-01 | 2026-10-25 | 11-50 | director of operations | 10 | 10 | 14 | 15 | 39 | Agrees |
| 51-200 | Founder | 1 | 8,401,214 | mason.lee@orbitaloak.example | Mason | Lee | Orbital Oak | 51-200 | Founder | 1 | Event | 2026-10-06 | 2026-10-19 | 51-200 | founder | 1 | 15 | 20 | 3 | 38 | Agrees |
| 51-200 | Sales Manager | 4 | 8,401,218 | elijah.king@driftstone.example | Elijah | King | Driftstone | 51-200 | Sales Manager | 4 | Organic Social | 2026-10-04 | 2026-10-24 | 51-200 | sales manager | 4 | 15 | 12 | 8 | 35 | Agrees |
| 501-1000 | VP Sales | 6 | 8,401,216 | lucas.hall@catalystgrid.example | Lucas | Hall | Catalyst Grid | 501-1000 | VP Sales | 6 | Referral | 2026-10-15 | 2026-10-28 | 501-1000 | vp sales | 6 | 25 | 18 | 15 | 58 | Agrees |
| 1-10 | CEO | 2 | 8,401,223 | caleb.turner@evermint.example | Caleb | Turner | Evermint | 1-10 | CEO | 2 | Direct | 2026-10-09 | 2026-10-20 | 1-10 | ceo | 2 | 5 | 20 | 3 | 28 | Agrees |
How do you score our leads on company size, job title and pages viewed using my points table and list the hot ones?
Export your HubSpot contacts, then use your points table for company size, job title, and pages viewed. The workflow adds the points for each lead, then shows the total and the Status for each row. Leads that match all rules and have no missing values are marked Agrees.
How it works
How to use the Lead score check workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Lead score check: questions
What export should I use?
What happens if a lead does not match a rule?
How do I change the scoring rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Measure how fast the pipeline turns into revenue, and where people drop out of your funnel.
- Pipeline velocityExport HubSpot deals and review pipeline velocity by month using your chosen rule for open deals, win rate, deal size and cycle days.See the workflow Built by the agent
- Sales cycle lengthMeasure sales cycle length from your HubSpot deals export by rep and source, using closed-won deals from the last 6 months.See the workflow Built by the agent
- Sales pipeline reportBuild a weekly sales pipeline report from Salesforce exports, grouped by rep and stage, with stage changes and past-due deals.See the workflow Built by the agent
- Win rate by rep and sourceCalculate win rate from a Salesforce opportunities export by rep and lead source for the last two quarters.See the workflow Built by the agent
- HubSpot deals vs Stripe invoicesCheck closed won HubSpot deals against Stripe invoices by amount, and list the ones that do not match.See the workflow Built by the agent
- Sales velocityEach rep's open deals, win rate, deal size, sales cycle and velocity, and the team'sSee the workflow Template