Skip to content

Prospecting · For your bots

Enrich the rows in a lead table

Fill in the blanks on rows already in a table -- website, size, signal, contact role -- from sourced public facts, and write them back with update_rows.

In Lobstack: Skills › Library › Add

Download Lobstack

When to use it

A lead or account table has rows with empty or stale columns, and someone wants them filled before outreach.

What your bot will do

  1. 01

    query_table for the rows with gaps, all of them, following next_offset. Say how many there are before starting.

  2. 02

    For each row, find the missing facts on the company's own site first, then news and public profiles. An enrichment connector (Apollo, Clay, Hunter) is fine when the bot has one; say which source each fact came from.

  3. 03

    Write each row back with update_rows as you go, not all at the end, so a stopped run keeps its work. Put the source link in Notes or a link column.

  4. 04

    Leave a cell empty rather than guess. Mark doubtful facts as such.

  5. 05

    Finish with a count: rows filled, rows still missing something, and why.

Business facts only: no home addresses, family or personal life, even when public. Personal email addresses only from an enrichment tool the person connected, never guessed.

The file

lead-enrichment/SKILL.md29 lines
---name: lead-enrichmentdescription: "Fill in the blanks on rows already in a table -- website, size, signal, contact role -- from sourced public facts, and write them back with update_rows."metadata:  title: "Enrich the rows in a lead table"  category: prospecting  tags: [leads, tables, enrichment]--- ## When to use this A lead or account table has rows with empty or stale columns, and someone wantsthem filled before outreach. ## How 1. query_table for the rows with gaps, all of them, following next_offset.   Say how many there are before starting.2. For each row, find the missing facts on the company's own site first, then   news and public profiles. An enrichment connector (Apollo, Clay, Hunter)   is fine when the bot has one; say which source each fact came from.3. Write each row back with update_rows as you go, not all at the end, so a   stopped run keeps its work. Put the source link in Notes or a link column.4. Leave a cell empty rather than guess. Mark doubtful facts as such.5. Finish with a count: rows filled, rows still missing something, and why. Business facts only: no home addresses, family or personal life, even whenpublic. Personal email addresses only from an enrichment tool the personconnected, never guessed.

Get Lobstack.