You need a credentials.json file from Google Cloud Console.
How to get it:
1. Go to console.cloud.google.com
2. Create a project → Enable Gmail API
3. Create OAuth 2.0 credentials (Web application type)
4. Add http://localhost:5000/api/auth/callback as an authorized redirect URI
5. Download the JSON and upload it below
🔒
Drop credentials.json here
or click to browse
STEP 2 OF 3
Connect Gmail
Click below to authorize the tool to send emails from your Gmail account.
A Google login window will open — sign in and grant access.
Your credentials are stored locally and never leave your computer.
Waiting for authorization…
STEP 3 OF 3
All Set!
Your credentials are saved and Gmail is connected. Fill in your Warranty Company settings
in the Home Warranty tool and you are ready to go.
These settings are saved automatically — you only need to do this setup once.
✓
credentials.json uploaded
✓
Gmail connected
?
Fill in Warranty Company settings in Step 1 of the tool
KWRP AUTOMATION SUITE
Internal tools for Keller Williams Realty Partners — automating your daily listing workflows.
🏠
Home Warranty Tool
Process FMLS CSV exports, look up property owners via BatchData, generate Excel reports, and automatically email listing agents and your warranty company contact.
BatchData APIGmailExcel ExportAgent Emails
→
📊
Supreme Leads Tool
Convert FMLS exports to Supreme Lending portal format, look up property owners, and auto-submit listings for both Woodstock and Canton offices via the portal.
BatchData APISeleniumWoodstockCanton
→
KWRP / Home Warranty Tool
Gmail not connected
1
Settings
2
Upload
3
Review
4
Send
⚙️ Settings
Warranty Company
Your Info
Agent Email Cache
0 agentsCSV needs: Name, Phone, Email
Add Agent Manually
📂 Upload CSV
Address History: 0 stored
📋
Drop FMLS Matrix CSV Here
or click to browse
⚠️ New Agents Found
These agents weren't in your cache. Add their emails below.
📊 Listings
💡 Orange rows missing owner name. Click 🔍 to look up on Melissa, then paste name.
Agent
Full Address
Agent Email
Phone
Owner Name
📧 Send Emails
Will send:
Sending…
KWRP / Supreme Leads Tool
1
Select Office
2
Upload CSV
3
Review
4
Submit
🏢 Select Office
Choose which office you are submitting listings for.
KW Woodstock
Monthly Target: 122 Listings
SL008
KW Canton
Monthly Target: 18 Listings
SL053
Monthly Progress
0%
KW Woodstock
0 of 122 —
0%
KW Canton
0 of 18 —
📂 Upload FMLS CSV
Office: KW Woodstock · History: 0 stored
📋
Drop FMLS Matrix CSV Here
or click to browse
📊 Review Listings
⚠
💡 Orange rows are missing owner info — fill in manually or leave blank.
Street
City
State
Zip
Owner First
Owner Last
Owner Email
🚀 Submit to Portal
Submission Summary
⚠ Selenium will open a Chrome window, log into the Supreme portal, and upload the CSV. Do not close it until complete.
