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
- What is a Prospect?
- Adding Prospects
- Importing Prospects from CSV
- Managing Prospects
- Prospect Fields & Personalization
- Best Practices
- 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)
- Click Action Plan Manager menu → 👥 Prospects → Add New Prospect
- Fill in the form:
- Name (required) — Full name (e.g., “Jane Doe”)
- Email (required) — Primary email address
- Phone — Phone number (any format)
- Address — Street address
- City — City name
- State — Two-letter state code (e.g., “IL”)
- ZIP — Postal code
- Category — Seller, Buyer, General, Investor
- Source — Where the lead came from (e.g., “Website”, “Referral”, “Cold Call”)
- Tags — Comma-separated tags (e.g., “hot lead, FSBO, motivated”)
- Notes — Any additional information
- 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)
- Open the Prospects sheet
- Add a new row at the bottom
- Fill in columns:
- Prospect ID — Leave blank (auto-generated)
- First Name — First name
- Last Name — Last name
- Full Name — Full name (or use
=A2&" "&B2formula) - Email — Email address
- Phone — Phone number
- 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
- Check the Prospects sheet
- Verify:
- Prospect IDs were generated
- Names were split correctly (First Name / Last Name)
- Emails are formatted correctly
- 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
- Open the Prospects sheet
- Find the prospect by name or Prospect ID
- Edit any field directly in the sheet
- 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}} |
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
- Launch Campaigns: Execution & Monitoring Guide
- Personalize Emails: Email Templates Guide
- Automate with AI: AI Action Plan Generator
Your prospect database is the foundation of your follow-up success! 👥