ProspectFinder Pro

ProspectFinder Pro

prospectfinderpro.com

Overwhelmed / needs systems

Losing leads / follow-up

Growing team or biz

Industry pain point

Ad spend / CPA pain

Call tracking / lead ops

Google Sheets connection

No webhook URL saved yet

One-time Google Sheets setup

1

Create a new Google Sheet at sheets.google.com. Name it "LI Leads".

2

Row 1 headers: Name | Company | Title | LinkedIn URL | Interest | Notes | Date | Source

3

Click Extensions → Apps Script. Delete existing code and paste this:

const SHEET_NAME = "Sheet1";

function doPost(e) {
  try {
    const sheet = SpreadsheetApp.getActiveSpreadsheet()
      .getSheetByName(SHEET_NAME);
    const data = JSON.parse(e.postData.contents);
    sheet.appendRow([
      data.name || "",
      data.company || "",
      data.title || "",
      data.url || "",
      data.interest || "",
      data.notes || "",
      data.date || "",
      data.source || "LI Search Pro"
    ]);
    return ContentService
      .createTextOutput(JSON.stringify({ result: "success" }))
      .setMimeType(ContentService.MimeType.JSON);
  } catch(err) {
    return ContentService
      .createTextOutput(JSON.stringify({ result: "error", error: err.toString() }))
      .setMimeType(ContentService.MimeType.JSON);
  }
}

function doGet(e) {
  return ContentService
    .createTextOutput(JSON.stringify({ result: "ok" }))
    .setMimeType(ContentService.MimeType.JSON);
}

4

Deploy → New deployment → Web app. Execute as: Me. Access: Anyone. Click Deploy and copy the URL.

5

Paste the URL above and hit Save. Click Test to verify a row appears in your sheet.

AI extraction setup

Anthropic API key — stored in your browser only.

Paste LinkedIn content

Paste a post, comment, or profile text from LinkedIn

Lead details

Full name

Company

Title / role

LinkedIn URL

CRM interest level

Notes / pain points observed

Session log 0

Leads sent this session. All leads live permanently in your Google Sheet.

No leads sent yet this session.

Workflow

Copy a post from your Microsoft Teams or Telegram PPC / lead gen group and paste it below. AI will identify who posted it, extract their details, generate LinkedIn search links to find their profile, and note which group it came from so you have a warm opener ready.

Which group is this from?

Paste the post text here — include any name or username visible

Extracted lead

After pasting a post and clicking Extract, review the details AI pulled out and add the LinkedIn URL before saving.

Name from post

Company

Role / title

Found in group

LinkedIn URL (find via search links below)

Interest level

What they posted about

How this works

1

See a hot post in your Teams or Telegram group — CPL complaints, tool questions, follow-up struggles

2

Copy the post text (and their name/handle if visible) and paste it into the Paste Post panel

3

AI extracts their name, company, and pain point — and generates LinkedIn search links to find their profile

4

Find them on LinkedIn, add the URL, save the lead — it goes straight to your Google Sheet

Reputation check mode

Enter a name and company to generate reputation check search links across LinkedIn, Google, and BBB. Run these before reaching out to a new prospect.

Scam & complaint signals

Use this to either vet a prospect you found OR to paste a post from someone complaining about being scammed — AI will flag red signals and summarize the issue.

Paste a post or profile to check for red flags

Quick reputation searches

Lead vendor scam warnings

People calling out bad lead sellers on LI

I got scammed — business posts

Owners sharing scam experiences publicly

Do not use — company warnings

Public warnings about specific companies

Disappointed with my CRM

People actively switching — your perfect prospect

Pipeline

All leads from Lexi & AJ — live from Airtable

—

Total leads

—

Hot

—

Warm

—

Qualified

—

New / unworked

—

This week

Connect Airtable in Settings to load your pipeline.

Settings

Your preferences are saved in your browser. Airtable connection is pre-configured.

Who is using this app?

Select your name so every lead you submit is attributed correctly in the pipeline. Users are managed in Airtable — new team members appear here automatically.

Loading users from Airtable...

Currently logged in as: —

Anthropic API key

Required for AI extraction — paste a post from LinkedIn, Teams, or Telegram and AI will identify the person, extract pain points, and write a warm opener. Each user sets their own key.

API Key

Airtable connection

Pre-configured and shared across all users. Leads go directly to the team Airtable base.

Checking connection...

Reset

Clear your local preferences — name selection and API key. Does not affect Airtable data.