realtor-youtube-system

Builds and maintains the agent's Content Dashboard in THEIR OWN Notion — one board for all their content, modeled on Mike Sherrard's real YouTube dashboard, with a YouTube long-form view, a Short-Form view, and a calendar. Seeded with the next ~2 weeks from their actual Game Plan (a rolling window that tops itself up — the full 90-day backlog stays in the plan doc), and then kept alive by the system: when a video gets made, its card fills with the full script, SEO package, lead magnet, and the top-3 proven reference videos — everything in one card. Bring-your-own Notion; never required. Triggers on "build my content board", "set up my board", "content board in notion", "notion board", "notion dashboard", "content dashboard", "put my plan in notion", "update my board", or after the Game Plan when the agent says yes to the board offer.

Market Pulse — the weekly Monday Kickoff for the realtor content system. Once a week (Monday morning) it reads what's happening in the agent's market — local news, "things to do", new developments, rate moves, and what buyers & sellers are asking — and turns it into ONE organized briefing: this week locally, the market moves that matter, and a ranked content menu for the week (2 YouTube topics AND 3–5 short-form/green-screen themes, each with a hook). The agent picks their whole week in 5 minutes. It provisions its OWN weekly schedule (no team setup) and also runs on demand; sends one short email from the agent's Gmail when connected. Triggers on: "set up my market pulse", "turn on my market pulse", "turn on my weekly briefing", "run my market pulse", "run my Monday kickoff", "send my kickoff now", "market pulse", "weekly briefing", "my content for the week", "stop my market pulse".

The Coach for the Realtor YouTube System — on-demand only. The agent's YouTube coach, delivering Mike Sherrard's coaching: it reviews their real performance + market context and gives direct, motivating, framework-grounded coaching the way Mike would — names the win and why, the single highest-leverage fix with a specific tactic, and the mindset to keep going. Every point backed by their real numbers, never generic tips. Also runs a full channel audit on demand. Reads Analytics output, the Research Brief, and the AI Brain (goals, cadence, voice). Triggers on "audit my channel", "coach me", "how do I improve", "what should I fix", "review my channel", "I'm not getting views", "should I keep going".

The Comment Engine for the Realtor YouTube System — works ONLY on the agent's REAL comments, never invented ones. Two jobs. (1) The comment sweep: works from the actual comments on their recent videos (they drop screenshots or paste them), triages them — real questions, potential leads, quick-thanks, skip-the-trolls — and drafts paste-ready replies in the agent's voice, flagging the high-intent commenters who are leads hiding in public. (2) The mine: clusters what viewers are literally asking across their comments into proven video ideas ("6 people asked about property tax — that's your next video"), quoting the real comments as evidence, and feeds Ideation. Drafts only — the agent pastes; nothing is ever posted by the system. Triggers on "check my comments", "reply to my comments", "answer my comments", "my youtube comments", "what are people commenting", "what are people asking", "mine my comments", "comment ideas", "help me respond to comments", "someone left a comment".

The Consistency Engine for the Realtor YouTube System — solves the real reason most realtor channels die: they quit. Provides batch-day mode (plan one filming day = several ready scripts + the smartest filming order), streak tracking + gentle momentum nudges, and a guided 30/60/90-day ramp so beginners don't drown. Reads the AI Brain (cadence, goal), the Videos folders + channel (what's shipped), and uses Google Calendar for filming/batch days and reminders. Triggers on "plan a batch day", "help me film a batch", "set up my filming day", "keep me consistent", "what's my 30/60/90 plan", "am I on track", "plan my month".

The flagship FIRST deliverable of the Realtor YouTube System — a complete, personalized YouTube Game Plan built on Mike Sherrard's frameworks. It audits the agent's existing channel (scaled to however many videos they have — 100, 10, 2, or none), picks 3 high-intent content pillars for their market, generates exact search-optimized video titles per pillar, reverse-engineers their business goal into a content plan, and lays out a 90-day calendar + success metrics — assembled into one premium Google Doc stamped "Powered by Mike Sherrard Coaching Inc Frameworks." Runs automatically at the end of setup, or on demand. Triggers on "build my game plan", "my youtube game plan", "my youtube strategy", "my channel plan", "map my channel", "what's my youtube plan", "refresh my game plan", "give me my youtube strategy", or right after setup as the first thing the agent receives.

Workflow 1 of 2 — Ideation. The realtor's main entry point, and where everything starts — fully ON-DEMAND, the agent asks whenever they're ready for their next batch of content. It asks how many videos they want, pulls fresh market signals right then, and hands back ready-to-film ideas hyper-specific to their market — a BLEND of broad general/relocation ideas and niche-specific ideas, with coverage gaps automatically baked into the batch — each with a title and a one-line data-backed "why," in the agent's voice (the hook and thumbnail text are prepared behind the scenes and surface in Step 1 of Make This Video). When the agent picks one, it tells them to open a NEW chat for that video (one chat = one video) and run "Make This Video." Triggers on "what should I film", "find my next video", "give me ideas", "give me video ideas", "ideas for this week", "what to make next", "I want to make a video", "help me with my YouTube".

The Lead Engine for the Realtor YouTube System — turns each video into a lead capture. For a video, produces a complete Lead Magnet MAP — a page-by-page content + framework + offer + CTA spec the agent copies into their own design tool (we map; we do not design) — engineered from the avatar's real fear plus that video's topic. Runs inside that video's one chat as part of the video package (one chat = one video). Reads the AI Brain (offer, USP, avatars, CTA, booking link). Saves the "Lead Magnet Map" Google Doc in the video's folder. Triggers on "lead magnet for this video", "map my lead magnet", or "make a lead magnet" ONLY inside a video's chat. (A standalone "build my lead magnet" / "set up my lead capture" with no video in play belongs to the Lead Capture System — Plugin 5 — not here.)

Workflow 2 of 2 — Video Production. Run this in a NEW chat that becomes the video (one chat = one video). Given a chosen idea, it produces everything for that one video — step by step, in the agent's voice, all saved to that video's folder. It locks the packaging (title, hook, 3 thumbnail texts), writes the script, builds the SEO package, maps the lead magnet, and — after the agent films and publishes — repurposes it into shorts, a blog, an email, and social posts. Triggers on "make this video", "produce this video", "let's make the video", "build this video", or when a chosen idea is pasted into a fresh chat.

Monthly Market Report for the Realtor YouTube System — the highest-leverage video most agents never make. Once a month (or on demand) it pulls the agent's LOCAL market data (sourced + dated, never invented), then builds a clean presentation deck the agent simply screen-records (Loom/Zoom) slide by slide — with conversational talking points under every slide. The deck always covers what the numbers mean for three audiences — local buyers, local sellers, and people relocating in — so one recording serves every lead type. Saves the deck + talking points into that month's video folder; the normal pipeline (SEO, lead magnet, repurposing) follows. Triggers on "market report", "monthly market update", "run my market report", "market update video", "build my market presentation", "this month's market update".

Competitor Intelligence for the Realtor YouTube System — two jobs. (1) Outlier scan, weekly at most — watches competitor channels for videos that GENUINELY overperform (more than 2,000 views AND at least 3x the channel's subscriber count, and clearly above that channel's own norm) and reverse-engineers them into stronger, localized versions for the agent. (2) Evergreen competition analysis — maps the agent's market for channels over 2,000 subscribers, compiles their most popular videos that are 2+ years old (proven, durable demand), and helps the agent recreate them better. Reads the AI Brain for market, niche, and named competitors. Triggers on "what's working for competitors", "find outlier videos", "competitor research", "competition analysis", "what's blowing up in my niche", "what should I recreate".

The Repurposing Engine for the Realtor YouTube System — turns one long-form video/script into a full pack of written assets, no editing. From the script it writes short-form scripts (Reels/Shorts/TikTok), a blog post (to rank on Google as well as YouTube — the double-dip), an email newsletter, LinkedIn + Facebook posts, and an Instagram carousel script — all in the agent's voice. Reads the AI Brain. Saves a "Repurposing Pack" Google Doc in the video's folder. Triggers on "repurpose this", "turn this into posts", "blog + email from this video", "repurposing pack", "write shorts scripts from this". Written assets ONLY: it never edits or cuts a video file. Cutting actual reels out of a recording is the AI Editing Studio's job (studio-repurpose), which uses this pack's short-form hooks to choose its moments.

The Research Engine for the Realtor YouTube System. Gathers what's happening in the agent's specific market and niche right now — local real estate market data, local + lifestyle news, and rising search trends — and synthesizes a Research Brief that feeds Ideation and the Coach. Reads the agent's AI Brain for market, communities, niche, price band, and avatars so research is always local and specific, never generic. Runs fresh whenever the agent asks for ideas, or on demand. Triggers on "run my research", "what's happening in my market", "weekly research", "market research", "what's new in [city]", or as a step inside the optional Monday Kickoff when it is enabled.

Script Studio — writes the full video script (long-form, plus a short-form cut) for a chosen idea, in the agent's own voice, teleprompter-ready. Reads the AI Brain for voice, avatars, offer/CTA, and market so the script sounds like the agent and speaks to the right viewer, and pulls the chosen idea's packaging (title + hook) from Ideation. Runs every script through the Compliance Guardrail, then saves it as a clean Google Doc inside that video's folder. Triggers on "write my script", "script this", "script idea

The SEO Engine for the Realtor YouTube System. Makes a video findable on YouTube AND Google. For a chosen idea/script it produces a complete SEO package — title options, a full description with timestamped chapters, tags, hashtags, and a pinned comment — all in the agent's voice with their CTA and links. Reads the AI Brain (market, niche, communities, offer/CTA) and the script. Saves an "SEO Package" Google Doc in that video's folder. Triggers on "SEO for this", "write my description and tags", "SEO package", "optimize this video", or as a hand-off after scripting.

Local-Event Triggers (Newsjacking) for the Realtor YouTube System. Watches the agent's specific market for timely events worth a video while they're hot — interest-rate decisions, new development or community launches, school-ranking changes, major infrastructure, big local news — and turns them into time-sensitive video suggestions flagged "film this week." Reads the AI Brain for communities, niche, and avatars. Checked fresh whenever the agent asks for ideas, or on demand. Triggers on "anything timely to film", "local news angles", "newsjack", "what's happening this week in [city]".