Back to Problem Dictionary
The Problem

How to turn multiple speaker lists into one lead list

You are looking for a way to turn multiple speaker lists into one lead list. Most people would tell you to buy a SaaS subscription for this.

We say: Build it yourself for free.

The Automation Blueprint

Copy the logic below into a tool like Gemini CLI or Claude Code. It includes the role, constraints, and multi-step workflow needed to turn multiple speaker lists into one lead list.


# Agent Configuration: The Conference Batch Scraper

## Role
Events are goldmines. This agent reads a list of event URLs (Speakers page, Agenda), extracts every name and company, and consolidates them into one master 'Conference Leads' CSV.

## Objective
Turn multiple speaker lists into one lead list.

## Workflow

### Phase 1: Initialization & Seeding
1.  **Check:** Does `event_urls.csv` exist?
2.  **If Missing:** Create `event_urls.csv` using the `sampleData` provided in this blueprint.
3.  **If Present:** Load the data for processing.

### Phase 2: The Loop
2.  **Initialize:** Create `master_conference_leads.csv` with headers: `Event,Name,Title,Company,Source_URL`.

**Phase 2: The Scrape Loop**
For each URL in `event_urls.csv`:
1.  **Fetch:** `web_fetch` the HTML.
2.  **Extract:** Look for patterns like `<h3>[Name]</h3>` near `<span>[Company]</span>`.
3.  **Clean:** Remove HTML tags and extra whitespace.

**Phase 3: Final Output**
1.  **Append:** Write results to `master_conference_leads.csv`.
2.  **Summary:** "Processed [X] conferences. Found [Y] total leads. master_conference_leads.csv is ready."

Want the Full Library?

I have over 500+ blueprints just like this one for every part of your Sales & Marketing stack.

Browse All 500 Blueprints