skills.rest
Military-Veteran-Team-LPT-Realty
Military-Veteran-Team-LPT-RealtyOFFICIAL
Explore all skills by this author →
GitHub

zillow-zip-management

Synchronizes Zillow Premier Agent ZIP assignments between Google Sheets and the Zillow Lead Routing page.

Updated Sep 16, 2026
Search Tags:#slack#google sheets#real estate#lead routing#zillow#name normalization#zip codes
One-click install
npx skills add https://github.com/Military-Veteran-Team-LPT-Realty/mvt-manus-public-skills --skill zillow-zip-management-military-veteran-team-lpt-realty
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: zillow-zip-management
Source: https://github.com/Military-Veteran-Team-LPT-Realty/mvt-manus-public-skills/tree/main/skills/zillow-zip-management
Command: npx skills add https://github.com/Military-Veteran-Team-LPT-Realty/mvt-manus-public-skills --skill zillow-zip-management-military-veteran-team-lpt-realty

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires requests, and includes scripts (resource) components.

What problem does it solve? Keeping Zillow Premier Agent ZIP code assignments consistent across a master Google Sheet, Pinellas team tabs, and the Zillow Lead Routing page is error-prone manual work, especially with name mismatches, missing agents, and unsorted lists. ## Core Features & Use Cases - ZIP Synchronization: Rewrites Pinellas tab ZIP assignments from the authoritative master sheet, with verification passes to confirm exact matches. - Agent Auditing: Extracts agents from the Zillow Lead Routing page, adds missing agents, sorts lists alphabetically, and flags agents lacking Zillow Preferred or Seller Connections status. - Slack Reporting: Posts change reports and audit findings (agents with fewer than 10 ZIPs, missing agents, backfilled ZIPs) to the #zillow-change-log channel. - Use Case: A team admin needs to reconcile the Pinellas roster after Zillow routing changes — the skill syncs ZIPs from the master sheet, backfills empty ZIP rows directly from Zillow with pink-flag formatting, and posts a summary to Slack. ## Quick Start Ask the agent to sync the Zillow ZIP codes from the master sheet to both Pinellas tabs and post the audit report to Slack.

Frequently Asked Questions about zillow-zip-management

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I sync Zillow ZIP codes with a Google Sheet?▼

Fetch the master ZIP tab and both Pinellas tabs via the Google Sheets API, look up each agent's ZIPs from the master using case-insensitive matching, then rewrite the tabs with master data. Always re-fetch afterward to verify each agent's ZIPs match the master exactly.

How do I extract agent data from the Zillow Lead Routing page?▼

Zillow uses PerimeterX bot protection, so direct API calls return HTTP 403. Extract data through the user's desktop Chrome browser via AppleScript with JavaScript injection on the routing page, then parse the concatenated name and product tag text.

Why does Python's .title() break agent name normalization?▼

The .title() method corrupts Mc/Mac prefixes (Mccartney), apostrophe surnames (D'aloisio), abbreviations (Jj, Pllc), and accented characters. Use the provided normalize_names.py script, which handles these patterns with dedicated rules and an accent map.

Can I use the gws CLI for Google Sheets batch updates?▼

No, the gws CLI does not support array parameters correctly for batchUpdate or format operations. Use the Google Sheets REST API directly via Python with an OAuth token obtained from the rclone config; reserve gws for simple values get reads.

What happens when an agent has no ZIP codes in the sheet?▼

After the master sync, empty-ZIP agents are looked up directly on the Zillow Lead Routing page. Any ZIPs found are written into the sheet with bold bright pink formatting to flag them for review and later addition to the master sheet.

Related Skills

Explore More Marketing & Sales Skills→
zapierzapier
114

google-sheets

Automate read, write, and manage operations in Google Sheets via API v4.

Official
Intermediate
Zenobia000Zenobia000
1

lead-capture

Extract lead details, score priority, and write records to Notion or Google Sheets.

Community
Intermediate
jedrecordjedrecord

update-project-docs

Scan project docs and reconcile them with the filesystem state.

Community
Advanced
pmcdowallpmcdowall

google-drive

Access and update Google Drive files and spreadsheet records via authenticated APIs.

Community
Intermediate