LEAD GENERATION

On-Demand Local Prospect List from a Webhook Request to Google Drive

Accepts a niche+location request via webhook, searches Brave, verifies live sites, dedupes, AI-ranks the results, and delivers a finished prospect spreadsheet to Google Drive.

CategoryLead Generation
Enginesim
Difficultyintermediate
Triggerwebhook
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWebhook request with niche + locationHTTP webhook
  • ActionSearch Brave for local businessesBraveBrave Search
  • LogicVerify live sites and dedupe in-batch
  • ActionLLM ranks and annotates resultsOpenAI
  • OutputUpload ranked CSV to Google DriveGoogle DriveGoogle Drive

What it does

Lets anyone request a prospect list on demand by submitting a niche and location to a webhook. The flow searches Brave, drops dead and parked domains, removes duplicate domains within the batch, has an LLM rank the survivors by apparent fit, and writes a ready-to-use spreadsheet into a shared Google Drive folder.

When to use it

Use this to make prospect-list generation self-serve for sales or partner teams. They submit a request; minutes later a clean, ranked sheet appears in Drive, no operator in the loop.

How it works

  1. 1A webhook receives a request with niche, location, and result count.
  2. 2Brave Search returns candidate businesses.
  3. 3A filter verifies each site resolves and removes in-batch duplicate domains.
  4. 4An LLM ranks the cleaned list by apparent fit and adds a short note per row.
  5. 5A CSV is generated and uploaded to a shared Google Drive folder, named by request.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect HTTP webhookTrigger any URL on agent actions.
  2. 2
    Connect Brave SearchWeb, news, image, video search.
  3. 3
    Connect OpenAIModels, embeddings, files.
  4. 4
    Connect Google DriveDocs, sheets, slides, files.
  5. 5
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  6. 6
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  7. 7
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.