GeoTech Realty, Inc. · Confidential Internal System
GeoTech CRM
Realty & Environmental
Connecting to database…
Dashboard
🌴 Miami

🏆 2026 Business Plan — Live Scorecard

📞 Prospecting Activity

🔴 Overdue Follow-Ups

🎯 Top Priority Contacts

📅 Due This Week

📈 Pipeline Snapshot

Contacts0

🔍
ContactEmailAddressType StageEnv StatusPriorityFollow-Up

Deal Pipeline

Priority Funnel 0

⏳ AI is analyzing your full pipeline…

Email Request

Request an email from the marketing team → sent to gfreezefuel@gmail.com
Request an Email Draft

Fill this out when Quoya or Neil needs an email written. It sends the request straight to the marketing inbox (gfreezefuel@gmail.com) so a draft can be created.

How this works

The marketing team writes the actual emails. Use this form to hand them exactly what you need:
Purpose — the goal of the email
Date to be sent — when it should go out
Notes & key points — everything they need to draft it

When you click send, the whole request is emailed to gfreezefuel@gmail.com. No copy-paste needed.

Tasks & Follow-Ups

🔴 Overdue & Today

📅 Upcoming

✅ Completed

Archive 0

Contacts moved here after manual verification. Excluded from all scoring, pipeline, and funnel views.

🔍
ContactEmailAddressType Env Status

⚙️ Settings

🤖 AI Provider Configuration

Choose any AI provider and enter your API key. Gemini and Groq are 100% free — no credit card needed.

🔒 Governance (G3): AI keys are stored in your browser only — they are not sent to GeoTech servers. Before saving a key, disclose it per Neil's G3 requirement: which service, which account, and what contact data will be sent to it.
Google Gemini
🆓 FREE
gemini-2.0-flash
Groq
🆓 FREE
llama-3.3-70b
Claude
claude-sonnet-4-6
OpenAI
gpt-4o-mini
🔐 Users & Access Control

Manage who can access this CRM. Only the Admin (Neil) can add or remove users.

📧 Microsoft Outlook Sync
⚫ Not connected to Microsoft

Connect your Microsoft account to auto-sync CRM contacts to Outlook Contacts. Contacts are pushed automatically when saved.

Register app at portal.azure.com → Azure AD → App Registrations

📋 Azure Setup (one-time, 5 min):

1. Go to portal.azure.com → Azure Active Directory
2. App Registrations → New Registration
3. Name: "GeoTech CRM" · Redirect URI:
4. API Permissions → Microsoft Graph → Contacts.ReadWrite
5. Copy the Application (client) ID above

📧 Email Requests

The Email Request page sends to gfreezefuel@gmail.com using Web3Forms (free, no server). Set it up once:

  1. Go to web3forms.com, enter gfreezefuel@gmail.com, and copy the Access Key they email you.
  2. Paste it below and click Save. (Everyone on the team can share the same key.)
🗄️ Database Status
🔑 Current Session

Import Contacts

Import from CSV File
📂
Click to select a CSV file
Columns: Name, Email, Phone, Company, Address, Type, Stage, Notes
Paste a Contact List

Paste names & emails from any source. Claude will parse it.

⏳ Parsing your list…
CSV Template
✅ Lead Verification Import

Upload the GeoTech_Lead_Verification spreadsheet (.xlsx) to update existing contacts with verified phone numbers (6 sources), BCPA tax owner, Sunbiz status, registered agent, and confidence scores. Matches contacts by Property Address or Parcel ID.

📊
Click to select verification spreadsheet (.xlsx)
Expected columns: Property Address, Parcel ID, BCPA Tax Owner, Phone 1–6, Sunbiz Status, Officers, Confidence…
📥 Monthly Refresh & Discharge Data Merge

Every month, pull the latest FDEP data (Contamination Locator, OCULUS, or DEP Nexus) and upload it here. The CRM matches by Facility ID, detects field changes, highlights outreach triggers (dep_co becoming C, facilities going OPEN or ABANDONED), and updates all matching contacts — without touching anything that doesn't match.

Works for: monthly FDEP pulls · tank discharge data · any FDEP export with a facility ID column
Monthly SOP: (1) Download fresh CSV from floridadep.gov · (2) Click "Upload New FDEP Data" · (3) Review outreach triggers · (4) Click "Apply All Updates" · (5) Follow up with any 🚨 triggered contacts within 48 hrs.

✨ GeoTech AI

Hi — I'm the GeoTech AI assistant. I have full access to your contacts, pipeline, tasks, and SOP workflow. Select an AI provider below (Gemini and Groq are free!) then enter your API key.

I can help with:
• Who to call & what to say
• SOP next steps per contact
• Draft emails (Servant Advisor style)
• Environmental risk analysis (🧪)
• Pipeline analysis & priorities
⏳ AI is thinking…
Ctrl+Enter to send · Requires Anthropic API key

Add Contact

Contact Information
Property Details
Pipeline & Outreach
Parallel Referral Tracks — 2026 Targets
SOP Phase A–H Tracking — Two-Flag Gate AI drafts → Neil approves → Santiago files
⚠️ Two-Flag Rule: A phase chip turns GREEN only when Neil's Approved flag is set. AI Drafted alone = amber/pending. No written deliverable before Advisory Engagement Signed (Stage 3).
SOP Notes & Intake
Phase A — Advisory Interview Nilesh completes · Santiago logs
Phase C — Property Condition Pre-Screen
Phase D — Ownership Verification
Phase F — File Setup & Document Collection
Phase H — Offering Memorandum
FDEP Facility Data
Owner / Registered Agent Data
⏳ Not Verified
Click the button after you call and confirm this contact is correct.
Phone Numbers by Source — populated from lead verification spreadsheet
BCPA — Broward County Property Appraiser
Sunbiz — Florida Division of Corporations
Verification Summary
Prospecting Status — Appendix A activity tracking
Touch / Activity Log
All recordings attached to this contact

Add Task

Add Note

📞 Log Touch

This adds one entry to the activity log, increments the touch count, and updates the last-touch date.

📥 Monthly Refresh & Discharge Data Merge

Upload a new FDEP data CSV — monthly pull from floridadep.gov (Contamination Locator, OCULUS, or DEP Nexus) or tank facility discharge data. Records are matched to existing contacts by Facility ID. Non-matching rows are discarded. Status changes (P→C, OPEN→ABANDONED) become outreach triggers.

📥
Drop FDEP CSV here or click to select
Supported formats: FDEP standard export ("fac id", "fac state", "dep co"…) or underscore variants (fac_id, fac_state, dep_co…)

Import Contacts

Select a CSV file. Columns: Name, Email, Phone, Company, Address, Type, Stage, Notes (header row required)

📂
Click to select CSV