#Column Data Extraction Prompts

Ready-to-use Custom Prompt presets for extracting owner names, titles, services, and contact details from your scraped data.

Ready-to-paste prompts for the Custom Prompt preset. Mentions use the #ColumnName system - click # in the prompt editor to insert a {{Column}} chip that substitutes each row’s value at run time. Prompts are capped at 1,000 characters.

1. Owner & Founder Name Extraction

Use Case: Extract decision-maker names from scraped website URLs.

Prompt / Code
Visit {{Website}} and find the owner, founder, or director of {{Name}}.
Return their full name and exact job title.
If no individual is named anywhere on the site, return "None".

2. Contact & Social Discovery

Use Case: Extract direct contact details and social profiles from website headers and footers.

Prompt / Code
Inspect {{Website}} for contact information:
- The best direct email address (prefer a person over info@)
- An official WhatsApp or phone number
- The official Facebook or LinkedIn profile URL
Return each on its own line. If not found, return "None" for that line.

3. Service Specialization

Use Case: Qualify leads by what they actually sell.

Prompt / Code
Look at {{Website}} and list the 3 main services {{Name}} offers.
Be specific (e.g. "dental implants", "emergency plumbing", "wedding photography").
Return them as a comma-separated list, or "None" if the site doesn't say.

4. Tech Stack Detection

Use Case: Find prospects on a specific platform (great for agency outreach).

Prompt / Code
Analyze {{Website}} and detect what it's built with:
CMS/builder (WordPress, Shopify, Webflow, Wix, Squarespace, custom),
whether it has online booking or e-commerce, and if it looks outdated.
One short line per finding.

5. Lead Qualification Score

Use Case: Prioritize outreach with a simple score + reason.

Prompt / Code
Based on {{Website}}, the {{Reviews}} reviews and {{Rating}} rating of {{Name}}:
score this business 1-10 as a prospect for a website improvement service.
Return only: SCORE - one-sentence reason.

Tips