Claude Skills by gethouston

Get a rigorous readout on what your data is actually telling you. Pick what you need: an experiment readout with lift, significance, confidence intervals, and an explicit ship / kill / iterate / inconclusive call; an anomaly sweep that flags metrics deviating past rolling baselines with hypothesized causes; or a data-quality audit that checks nulls, dupes, freshness, and referential integrity on the tables you care about.

Ask any question about your data in plain English and get a real answer. I translate to read-only SQL against your connected warehouse, warn you before anything expensive runs, execute, save the query for reuse, and return the result with caveats called out so you don't ship a number that's quietly wrong.

See your real annualized SaaS spend in one place, including the subscriptions you forgot about. I aggregate everything from your billing provider, your inbox receipts, and your contract library, flag duplicates and unused tools, and surface the top three cancel candidates with rationale. Most founders are surprised by the headline number the first time.

Get a meeting on the calendar without the back-and-forth eating your week. I propose three times that respect your focus blocks, daily meeting cap, and buffers, draft the counterparty message in your voice, iterate as they reply, and only create the event after you explicitly say to book it.

Get the brief you need to walk into your day or your meeting prepared. Pick what you need: a daily roll-up of your inbox, calendar, chat, and recent docs into today's plan; a deep attendee pre-read for an upcoming meeting with agenda and likely asks; or post-meeting notes that turn a transcript into decisions, owners, and follow-ups.

Run the weekly update loop without nagging your team yourself. I send the prompt over Slack or email in your voice, collect what comes back, and analyze each update against your active priorities so you can see what's on track, what's drifting, who's blocked, and who didn't answer. Stays dormant with a friendly message if you don't have a team section in your ops info yet.

Get a message drafted in your voice and saved to your inbox so you only have to hit send. Pick what you need: a reply to an inbound thread; a follow-up that either logs a commitment to your ledger or drafts the fulfillment when one comes due; or vendor outreach for renewals, cancellations, trials, or reference checks grounded in your real contract terms.

Find what's actually slowing your company down so you can unblock it. I cluster evidence from your recent reviews, pending decisions, open anomalies, and off-track goals into named bottlenecks, each with a hypothesis and a proposed owner to unblock it. Use this when something feels stuck and you can't put your finger on why.

Capture a decision properly so you have a record you can point at later. I write an ADR-style entry with context, alternatives considered, trade-offs, the decision itself, rationale, and consequences. Tell me what you decided and I keep it in your decision ledger.

Get a trip pack drafted so you can travel without dropping the rest of your week. I assemble a trip summary, an itinerary with flight and hotel search criteria, and a packing checklist adapted to the destination and trip type. Tell me where and when; I draft, you book.

Draft the package you need for your board or your investors without starting from a blank page. Pick what you need: a board pack with the standard 8 sections (TL;DR, business update, metrics, goals, wins, challenges, asks, appendix); or a monthly or quarterly investor update written in your voice grounded in real goal movement, decisions, and metrics. I flag every TBD instead of inventing numbers.

Get the standard clauses out of a contract or a whole folder of them without reading legalese yourself. I extract liability caps, termination terms, auto-renewal, payment terms, IP, data handling, uptime commitments, and exclusivity, each with the verbatim quote, a plain-language summary, and a flag on anything unfavorable for your vendor posture. The renewal calendar updates automatically.

Get a cited, structured briefing on a topic, a company or person, or your social feed instead of scanning everything yourself. Tell me what to dig into and I pull from news and research providers, rank what matters against your priorities, and write a TL;DR plus a 'so what for us' section. Every claim ships with a source URL.

Roll up what shipped and what moved across your whole ops surface. Pick what you need: a weekly review that aggregates every skill's output, cross-references priorities and renewals, flags gaps, and recommends the one move; or a metrics-rollup that walks every tracked metric, computes week-over-week change, and surfaces what to look at first.

Score any inbound that needs your decision against a real rubric instead of going by gut. Drop in an advisor pitch, a partnership ask, a press request, or a generic vendor application and I run it against your saved criteria, gather public-signal evidence, and produce an approve / decline / more-info recommendation with the one line of evidence that matters most.

Tell me how your company actually runs so every other ops skill stops asking the same questions. I capture your priorities for the quarter, your operating rhythm, key contacts, vendor posture, hard nos, and voice into one living doc. You only do this once and I keep it updated as things change.

Set up the operational tracking you need so you're not flying blind. Pick what you need: a single metric I snapshot daily against your warehouse, or a full dashboard spec with sections, visualizations, cadence, and read-only SQL behind every chart. I draft the spec, you or your BI tool renders it.

See where you actually stand on your goals without piecing it together by hand. I refresh each goal metric's current value from your connected goal tracker, classify on-track / at-risk / off-track against the expected attainment curve, and surface likely root causes from linked decisions and priorities. Run it weekly or whenever someone asks how the quarter's going.

Stop getting surprised by auto-renewals. I scan your contracts and any connected drive for renewal dates, notice windows, and auto-renew language, then maintain a living renewal calendar grouped by lead-time tier so you always know what's next. I also produce a quarterly digest with negotiation candidates and anything past the cancel window.

Cut through your inbox or calendar so you know what actually needs you today. Pick what you need: an inbox triage that sorts the last 24 hours into needs-me-today, can-wait, and ignore with a specific verb-plus-object action per thread; or a calendar scan that flags overbooks, missing buffers, focus-block clashes, unprotected VIP slots, and meetings without prep across the next 7 days.

Run due-diligence on a vendor before you sign. Pick what you need: a fit evaluation that scores them 1-10 against your rubric with risk tier and recommendation, or a compliance check that verifies their frameworks, names their security leadership, and surfaces public incidents. Every claim cited.

Create a new Airtable table with the full lead-tracking schema (lead fields + enrichment fields + outreach status) and batch-load records from a scrape file. Uses 4 parallel agents to load 4x faster, working around Airtable's one-record-per-call limit. Phase 2 of both pipelines, also runnable standalone if you have a JSON list of leads.

Find verified emails for a list of leads via Apollo's bulk match (batches of 10), update the Airtable rows with email + company + title + location, and create Apollo contacts under a named label so the leads show up in your Apollo CRM workflows. Phase 3 of both pipelines, runnable standalone if you have an Airtable table populated by the loader.

Co-write a 3-email cold outreach sequence with you, one email at a time, using the James Shields framework: personalized subject (not body), 3 sentences plus PS, irresistible offer, low-friction reply CTA. I lock each email with you before moving to the next so voice, social proof, and offer all stay tight. Phase 4 of both pipelines, also runnable standalone if you have a verified contact list and want fresh copy.

Create a paused cold email campaign in Instantly with all leads loaded and all sending accounts attached. I read your locked sequence, sanitize bodies (Instantly drops bodies that contain a literal ampersand - documented bug), bulk-load up to 1000 leads per call, and configure the schedule with a timezone Instantly accepts (America/Vancouver for Pacific, handles DST automatically). Always paused for your review - never auto-launched.

Scrape every commenter on a LinkedIn post via Apify. I pull names, headlines, profile URLs, comment text, and reaction counts; dedupe by profile URL; drop null profiles; save the list to a per-run file. Phase 1 of the comment-to-outreach pipeline, but also runnable standalone if you only need the list.

Turn a single LinkedIn post URL into a paused cold email campaign in Instantly. I scrape every commenter, store them in Airtable, find verified emails through Apollo, co-write a 3-email sequence with you, then load it all into Instantly. End to end takes 30-60 minutes, most of it in the email copy. Always paused for your review - I never auto-launch. Use for higher-intent, lower-volume audiences (commenting takes effort).

Scrape every reactor on a LinkedIn post via Apify with profileScraperMode=main, so each row comes back with a full LinkedIn profile attached: experience history, education, skills, certifications, location, connections count. 5-10x more leads than the comment scrape and far richer data per lead. Phase 1 of the reaction-to-outreach pipeline, also runnable standalone.

Same end-to-end pipeline as the comment version, but for people who reacted to a LinkedIn post. 5-10x more leads than commenters and the scrape returns full LinkedIn profiles (experience, education, skills, certifications, location, connections count) in one shot. Best for broader-audience plays where you want volume + rich personalization data. Always paused for your review - I never auto-launch.

Answer a people policy question, like 'does {employee} qualify for {benefit}' or 'what's our policy on remote work, equipment, or leave'. You get a direct answer when the policy is clear, an escalation note when the question goes beyond your written rubric.

Sample your past HR comms - offers, check-ins, hard conversations - so I can match your tone in every draft. Connect Gmail or Outlook for the sharpest fingerprint, or paste three to five examples.

Schedule a candidate's interview loop - find times that work across the panel, draft per-panelist briefs, and hand you the slate to confirm. I never send invites, you do.

Pull together panel feedback after an interview loop into themes, contradictions, rubric scores, and a hire / no-hire memo. You decide; I just give you the cleanest read of what the panel actually said.

Draft a people document for you, like an offer letter, an onboarding plan, a performance improvement plan (PIP), or a stay conversation script. I draft against your comp bands, voice, leveling framework, and hard nos so it sounds like you wrote it. Drafts only, you ship every one.

Score a candidate against an open role - paste a resume or share a LinkedIn URL and I give you a rubric score, the evidence behind it, red flags, and what to probe in interviews. Branches on `source`: `resume` or `linkedin`.

Get a one-page interview prep brief before you (or a panelist) walk in - candidate background, the questions worth asking, red flags from the rubric, and the scoring sheet. Scannable in two minutes.

Prep your next performance-review cycle - self-review template, manager template, calibration doc, and the full timeline. Anchored on your review rhythm and leveling so it doesn't feel generic.

Pull together everything I know about an employee into a one-pager - HR profile, onboarding plan, recent check-ins, interview loop history. Useful before a 1:1, a comp conversation, or a hard meeting.

Tell me how you do HR - values, leveling (IC and manager, L1-L5), comp bands, review-cycle rhythm, policy canon, escalation rules, voice, and hard nos - so I can give you sharp drafts and answers. This is the foundation doc every other people Action reads first.

Pull a ranked list of candidates for an open role from GitHub, LinkedIn, communities, or open-source contributors. I score each one against your role rubric so you don't have to read 200 LinkedIn pages. You can also use this skill to seed the rubric for a new req before sourcing.

Keep a living people-compliance calendar - I-9 / W-4 status, visa renewals, vesting cliffs, review-cycle dates, policy-refresh cadence. I scan your HR system, update the calendar in place, and nudge you before things expire.

Wake up with a one-screen brief: today's meetings, drafts waiting on your sign-off, the top three moves I'd make today, and your watch list of stalled deals or red customers. Calendar is the anchor; I never invent meetings.

Build a battlecard for one specific deal versus one specific competitor - not a generic comparison sheet. Three-criterion grid anchored in what this prospect cares about, three trap-set discovery questions, three objection rebuttals grounded in your real differentiators, and two proof points from anchor accounts. Every claim cites a source.

Turn a transcript or recording into structured notes: agenda actual versus intended, attendees, pains in their words, decisions, action items split internal versus external, and the next step. I match the call to the right lead, update their dossier, and only sync to your CRM with your nod.

Get a read on how your sales motion is actually doing. Pick what you need: a Monday rollup across every domain, a cross-call synthesis with playbook edits, a win-loss pattern read, a deep read on a single discovery call, or a pipeline snapshot with the leakiest stage. Every read ends with a concrete next move, not a dashboard.

Surface fresh leads in a segment from a source you pick: your CRM closed-won lookalikes, a LinkedIn comment thread, a recent-funding feed, a Google Maps search, or a subreddit. I quick-score each against your playbook's hard disqualifiers and only keep GREEN and YELLOW. Every row cites the trigger signal that surfaced them.

Scan your GREEN customers for expansion signals - usage spikes past tier thresholds, team-size growth, feature-request patterns, new-product adoption - and rank upsell, cross-sell, add-on, and seat-expansion opportunities by annual revenue upside over effort to close. Every row cites the signal so you know why I surfaced it.

Draft a sharp three-sentence reframe to use on the call (acknowledge → concrete anchor-account example → dated next step) plus a short follow-up email in your voice. I look up the objection in your playbook and recent call insights so the response is grounded, not improvised.

Run the CRM action you need: a hygiene sweep that diffs dupes and stage mismatches without mutating, a natural-language read-only query, a routing pass that assigns GREEN, nurtures YELLOW, and drops RED, or a follow-up task pushed to your task tool. I never mutate without your per-row approval.

Plan a new customer's first ninety days: kickoff agenda, success metric locked in their words at kickoff, time-to-value milestones, named champions and blockers, and the first-thirty-day risk list. The anchor every later account review and renewal pulls from.