Prospects User Guide

Prospects User Guide

Prospects are the contacts you’ll send action plans to. This guide covers how to add, import, manage, and organize your prospect database.


Table of Contents

  1. What is a Prospect?
  2. Adding Prospects
  3. Importing Prospects from CSV
  4. Managing Prospects
  5. Prospect Fields & Personalization
  6. Best Practices
  7. Troubleshooting

What is a Prospect?

A Prospect is a contact in your database — someone you want to follow up with. Each prospect has:

  • Basic Info: Name, email, phone
  • Location Data: Address, city, state, ZIP
  • Classification: Category, source, status, tags
  • Notes: Free-form text for additional context
  • Unique ID: Automatically generated Prospect ID (e.g., PR-000001)

Why Prospects Matter:
– Prospects are the recipients of your action plans
– All prospect data is available as merge fields in emails
– You can organize prospects by category and filter by status
– Your prospect database lives entirely in your Google Sheet


Adding Prospects

Method 1: Using the Menu (Recommended)

  1. Click Action Plan Manager menu → 👥 Prospects → Add New Prospect
  2. Fill in the form:
  3. Name (required) — Full name (e.g., “Jane Doe”)
  4. Email (required) — Primary email address
  5. Phone — Phone number (any format)
  6. Address — Street address
  7. City — City name
  8. State — Two-letter state code (e.g., “IL”)
  9. ZIP — Postal code
  10. Category — Seller, Buyer, General, Investor
  11. Source — Where the lead came from (e.g., “Website”, “Referral”, “Cold Call”)
  12. Tags — Comma-separated tags (e.g., “hot lead, FSBO, motivated”)
  13. Notes — Any additional information
  14. Click Save Prospect

What happens:
– System generates a unique Prospect ID
– Splits name into First Name and Last Name automatically
– Sets Status to “New”
– Records Created Date and Last Modified date

Method 2: Direct Sheet Entry (Advanced)

  1. Open the Prospects sheet
  2. Add a new row at the bottom
  3. Fill in columns:
  4. Prospect ID — Leave blank (auto-generated)
  5. First Name — First name
  6. Last Name — Last name
  7. Full Name — Full name (or use =A2&" "&B2 formula)
  8. Email — Email address
  9. Phone — Phone number
  10. Fill in remaining fields as needed

Important:
– First Name and Last Name are required for merge fields to work correctly
– Email is required to send campaigns
– Leave Prospect ID blank — it generates automatically


Importing Prospects from CSV

For bulk uploads, use CSV import:

Step 1: Prepare Your CSV File

Create a CSV file with these columns (in any order):

Required columns:
– Name or Full Name — Full name of prospect
– Email — Email address

Optional columns:
– First Name or FirstName
– Last Name or LastName
– Phone
– Address
– City
– State
– ZIP or Zip Code
– Category
– Source
– Status
– Tags
– Notes
– Custom Field

Example CSV:

Name,Email,Phone,Address,City,State,ZIP,Category,Source
Jane Homeowner,jane@example.com,(555) 123-4567,123 Main St,Springfield,IL,62701,Seller,Website Form
John Buyer,john@example.com,(555) 987-6543,456 Oak Ave,Chicago,IL,60601,Buyer,Facebook Ad

Step 2: Import the CSV

Option A: Using the Menu
1. Click Action Plan Manager → 👥 Prospects → Import CSV
2. Upload your CSV file
3. Map columns (if headers don’t match exactly)
4. Click Import

Option B: Manual Copy-Paste
1. Open your CSV file in Excel or Google Sheets
2. Select all data (including headers)
3. Copy (Ctrl+C or Cmd+C)
4. Open your FollowUp Pilot spreadsheet → Prospects sheet
5. Click on cell A2 (first cell below headers)
6. Paste (Ctrl+V or Cmd+V)
7. The system will process and generate Prospect IDs on the next automation cycle

Step 3: Verify Import

  1. Check the Prospects sheet
  2. Verify:
  3. Prospect IDs were generated
  4. Names were split correctly (First Name / Last Name)
  5. Emails are formatted correctly
  6. Categories and statuses are set

Pro Tip: Import 5-10 test prospects first, verify they look correct, then import your full list.


Managing Prospects

Editing Prospect Information

  1. Open the Prospects sheet
  2. Find the prospect by name or Prospect ID
  3. Edit any field directly in the sheet
  4. Last Modified date updates automatically

Changing Prospect Status

Use the Status field to track progress:

Status When to Use
New Just added, not yet contacted
Contacted Initial outreach sent
Qualified Responded positively, potential deal
Active Currently working with them
Closed Deal completed (won or lost)
Inactive No longer pursuing

How to change:
1. Find prospect in Prospects sheet
2. Click Status cell
3. Choose from dropdown

Using Tags

Tags help you organize and filter prospects:

Examples:
– hot lead — High priority
– FSBO — For Sale By Owner
– motivated seller — Needs to sell quickly
– pre-approved — Buyer with financing ready
– investor — Looking for investment properties
– referral from John — Source tracking

Format: Comma-separated list

hot lead, FSBO, motivated seller

Pro Tip: Use consistent tag names. Don’t mix hot-lead, Hot Lead, and hotlead.

Filtering and Sorting

Filter by Category:
1. Click the filter icon in the Prospects sheet header row
2. Click the Category column filter dropdown
3. Select specific categories (e.g., show only “Seller”)

Sort by Last Modified:
1. Select the entire data range (A1:R1000)
2. Click Data menu → Sort range
3. Sort by “Last Modified” column, Z → A (newest first)

Find duplicates:
1. Select the Email column
2. Click Data menu → Data cleanup → Remove duplicates

Deleting Prospects

Soft Delete (recommended):
1. Change Status to “Inactive”
2. Add note explaining why (e.g., “Unsubscribed”, “Bounced”, “Not interested”)
3. Prospect stays in database for historical reference

Hard Delete (permanent):
1. Find prospect row in Prospects sheet
2. Right-click row number → Delete row

Warning: Deleting a prospect does NOT stop active campaigns. To stop campaigns, pause or cancel the execution in the Plan Executions sheet.


Prospect Fields & Personalization

Every prospect field can be used as a merge variable in your emails:

Standard Merge Fields

Merge Variable Prospect Field Example Value
{{firstName}} First Name Jane
{{lastName}} Last Name Homeowner
{{prospectName}} Full Name Jane Homeowner
{{prospectEmail}} Email jane@example.com
{{prospectPhone}} Phone (555) 123-4567
{{propertyAddress}} Address 123 Main Street
{{city}} City Springfield
{{state}} State IL
{{zip}} ZIP 62701

Non-Prospect Merge Fields

These come from the Settings sheet (not prospect data):

Merge Variable Source Example Value
{{agentName}} Settings: Agent Name John Smith
{{agentEmail}} Settings: Agent Email john@example.com
{{agentPhone}} Settings: Agent Phone (555) 987-6543
{{companyName}} Settings: Company Name Acme Real Estate
{{currentDate}} Today’s date March 21, 2026

Example Email Using Merge Fields

Subject:

Quick question about {{propertyAddress}}, {{firstName}}

Body:

Hi {{firstName}},

I noticed your home at {{propertyAddress}} in {{city}}, {{state}}.

I've helped dozens of homeowners in {{city}} sell their properties quickly and for top dollar. Based on current market conditions in {{zip}}, I believe your home could sell for 10-15% more than you might expect.

Would you be open to a quick 10-minute call this week to discuss?

Best regards,
{{agentName}}
{{companyName}}
{{agentPhone}}
{{agentEmail}}

Result for Jane Homeowner:

Subject: Quick question about 123 Main Street, Jane

Hi Jane,

I noticed your home at 123 Main Street in Springfield, IL.

I've helped dozens of homeowners in Springfield sell their properties quickly and for top dollar. Based on current market conditions in 62701, I believe your home could sell for 10-15% more than you might expect.

Would you be open to a quick 10-minute call this week to discuss?

Best regards,
John Smith
Acme Real Estate
(555) 987-6543
john@example.com

Best Practices

1. Always Collect First Name and Last Name

❌ Bad:

Full Name: Jane Homeowner
First Name: [empty]
Last Name: [empty]

✅ Good:

Full Name: Jane Homeowner
First Name: Jane
Last Name: Homeowner

Why: Merge fields like {{firstName}} won’t work if First Name is empty. “Hi {{firstName}}” becomes “Hi ” (awkward!).

2. Use Consistent Email Formatting

❌ Bad:

JANE@EXAMPLE.COM
Jane@Example.com
jane @example.com (with space)

✅ Good:

jane@example.com

Why: Email addresses are case-insensitive, but consistency helps with deduplication and tracking.

3. Standardize Phone Formatting

Pick one format and stick with it:

Option A: (555) 123-4567
Option B: 555-123-4567
Option C: 5551234567

Why: Consistent formatting makes reports and exports cleaner.

4. Fill in Address Data When Available

Even if you don’t need it now, collect:
– Address
– City
– State
– ZIP

Why: More data = more personalization options. Example subject line: “Market update for {{city}}, {{state}}”

5. Use Categories Strategically

Don’t create 50 categories. Keep it simple:

  • Seller — Homeowners selling residential property
  • Buyer — People buying residential property
  • Investor — Cash buyers, flippers, wholesalers
  • General — Misc or multi-purpose

Why: Too many categories make filtering harder. Use tags for fine-grained organization.

6. Tag Aggressively

Tags are flexible. Use them for:
– Lead quality: hot lead, cold lead, warm lead
– Lead source: facebook, google ads, referral, zillow
– Property type: FSBO, pre-foreclosure, vacant property
– Motivation: motivated seller, downsizing, relocating
– Deal stage: needs follow-up, appointment set, contract signed

Why: Tags let you create custom segments without adding more columns.

7. Add Notes for Context

Use the Notes field to capture:
– How you got their contact info
– What they’re looking for
– Pain points or objections
– Preferred contact method
– Best time to call

Example:

Met at open house 3/15. Looking to sell within 90 days. 
Needs to relocate for job. Prefers email over phone. 
Mentioned competing with 2 other agents.

Why: When you follow up 30 days later, you’ll remember the context.

8. Keep Prospects Updated

Update the Status field as you progress:

New → Contacted → Qualified → Active → Closed

Why: You can quickly see which prospects need attention vs. which are already being worked.

9. Remove Unsubscribes Immediately

If someone asks to be removed:
1. Change Status to “Inactive”
2. Add note: “Unsubscribed [date]”
3. Pause or cancel any active executions
4. Do NOT delete (keep for compliance records)

Why: CAN-SPAM compliance and professional courtesy.

10. Deduplicate Regularly

Run duplicate checks monthly:
1. Select Email column in Prospects sheet
2. Data menu → Data cleanup → Remove duplicates

Why: Duplicate emails = sending the same campaign twice = annoyed prospects.


Troubleshooting

Problem: Merge fields show empty values

Example: Email says “Hi ” instead of “Hi Jane”

Solution:
1. Check Prospects sheet
2. Verify First Name field is filled in
3. If Full Name is filled but not First Name:
– Option A: Manually split the name into First Name and Last Name
– Option B: Use formula: =SPLIT(D2, " ") to split Full Name

Problem: Import created duplicates

Solution:
1. Data menu → Data cleanup → Remove duplicates
2. Choose Email column as the key
3. Keep the most recent entry

Prevention:
– Before importing, search for existing emails
– Use VLOOKUP to check for duplicates before importing

Problem: Prospect ID not generating

Solution:
1. Verify you’re using the menu to add prospects (not direct sheet entry)
2. If editing sheet directly, leave Prospect ID column blank
3. Wait for next automation cycle (15 minutes) for ID generation
4. Or run: Action Plan Manager → 🔧 System → Re-initialize System

Problem: Campaign not sending to prospect

Solutions:
1. Check Email field — is it valid? (no spaces, correct format)
2. Check Plan Executions — is the execution Status = “Active”?
3. Check Activity Log — does it show “Failed” status? Check error message
4. Check for bounces in Email Tracking sheet


Free vs. Pro Limits

Feature Free Plan Pro Plan
Prospects 25 Unlimited
CSV Import Yes Yes
Merge Fields 14 fields 14 fields

When you hit the limit:
– You’ll see: “Prospect limit reached (25/25). Upgrade to Pro for unlimited prospects.”
– Upgrade to Pro to remove the limit


Next Steps


Your prospect database is the foundation of your follow-up success! 👥

← Back to Action Plans | Continue to Templates Guide →