Summit Home Renovations — Quote Generator

This skill uses ClickUp statuses to create a clean boundary between what the AI does and when a human steps in.

The AI's job ends at READY TO REVIEW. Everything after that — tweaking numbers, personalizing further, sending to the homeowner — is Mike's call.

Step 1 — Find Unprocessed Leads

Use clickup_filter_tasks to pull all tasks from the Leads Pipeline list that have NOT been processed yet.

clickup_filter_tasks:
  list_ids: ["901415127898"]
  statuses: ["to do"]    # or whatever the default unstarted status is

If no tasks come back with "to do", try also checking for statuses like "open", "new", or use clickup_search filtered to the Leads Pipeline list with task_statuses: ["unstarted"].

If there are zero unprocessed leads, tell the user "No new leads in the pipeline" and stop.

For each lead found, read its full details with clickup_get_task using detail_level: "detailed". Extract:

• Name (the lead/project title)
• Description (what the homeowner is asking for — this is the core input for quoting)
• Task ID (needed later to update status and link the quote)

Step 2 — Load the Pricing Model

Pull all tasks from the Pricing Model list to get the line-item breakdowns:

clickup_filter_tasks:
  list_ids: ["901415129435"]

Read each task's description. The key tasks are:

• Kitchen Remodel — Line Item Pricing
• Bathroom Remodel — Line Item Pricing
• Deck Build — Line Item Pricing
• Finished Basement — Line Item Pricing
• Quote Assembly — How to Build a Price from Line Items ← this is the master instruction

Pay special attention to the Quote Assembly task — it defines the step-by-step process for turning line items into a finished quote (margins, contingency, rounding, payment terms, disqualifiers, timelines).

Step 3 — Load Company Memory (Optional but Recommended)

If Zapier Tables tools are available, pull the company memory records from "Your Brain" table (ID 01KMC3WYXKSTYDWTEWF59BCBVR) to get:

• Communication style ("How We Talk to Clients")
• Standard proposal intro ("Our standard proposal intro")
• Company identity ("Who We Are")

Search for records where the type field (f7) = "memory" and the project field (f8) = "Summit Home Renovations" or "Summit Home Renovations".

If Zapier tools aren't available, use these defaults from memory:

• Friendly, direct tone. No jargon. "Demo" not "selective demolition."
• Mike Dalton signs everything personally.
• Mention timeline early.
• If not a fit, say so honestly and recommend alternatives.

Step 4 — Generate the Quote

For each unprocessed lead, work through this process:

4a. Classify the Project

Read the lead description and match it to one or more project types:

• Kitchen remodel
• Bathroom remodel
• Deck build (pressure-treated or composite)
• Finished basement
• Half bath addition (use bathroom pricing, adjusted)
• Combination (e.g., kitchen + bathroom)

4b. Check Disqualifiers

Before building a quote, check against the disqualifier list:

• Under $10K estimated → pass (unless noted as repeat client)
• Commercial work → decline
• Roofing or electrical-only → decline
• Outside 30-mile radius of Springfield, MA → decline
• No clear homeowner vision → needs qualifying questions

If a disqualifier hits, draft a polite decline or qualifying response instead of a full quote. Use Mike's voice.

4c. Build Line Items

Pull the relevant line-item pricing task(s) and scope each item based on what the homeowner described. Not every line item applies to every job — only include what's relevant.

For each applicable line item:

1. Start with the raw cost range (labor hours × rate, materials, sub costs)
2. Apply margins: Labor × 1.35–1.40, Materials × 1.15, Subs × 1.10 (except painting subs = no markup)
3. Permits passed at cost

4d. Add Contingency

• If the home is pre-1980 (or age unknown / described as "older"): add 15%
• If post-1980 or newer: add 10%

4e. Round and Format

• Round to nearest $500
• Present as a LOW–HIGH range, never a single number
• Always project-based, never hourly

4f. Write the Proposal

Use this structure:

## Quote for [Homeowner Name / Project]

[Standard proposal intro — personalized with homeowner name and project specifics]

### Project Scope
[2-3 sentences describing what's included]

### Estimated Range
**$XX,000 – $XX,000**
(includes materials, labor, subcontractors, permits, and [10/15]% contingency)

### What's Included
- [Line item 1]
- [Line item 2]
- ...

### Timeline
Estimated [X–X weeks] from start date.
[Note any scheduling constraints, e.g., tile sub availability]

### Payment Terms
- 30% deposit to book ($X,XXX – $X,XXX)
- 40% at rough-in/midpoint
- 30% on completion

### Next Steps
We'd love to schedule a site visit to refine this estimate. [Include early-bird discount mention if applicable — 5% off if booking 6+ weeks out.]

— Mike Dalton
Summit Home Renovations

Step 5 — Post the Quote Back to ClickUp

5a. Ensure a Quotes list exists

Use clickup_get_list with list_name: "Quotes". If it doesn't exist, create it:

clickup_create_list:
  name: "Quotes"
  space_id: "90144901598"
  content: "Generated quotes pending human review before sending to homeowner."

5b. Create the quote task with READY TO REVIEW status

clickup_create_task:
  list_id: [Quotes list ID]
  name: "Quote — [Lead Name / Project Description]"
  markdown_description: [the full proposal from Step 4f]
  priority: "normal"
  status: "ready to review"

The status: "ready to review" is critical — this is how Mike knows which quotes need his attention. He can filter the Quotes list by this status and see exactly what's waiting for him.

5c. Link the quote to the original lead

clickup_add_task_link:
  task_id: [new quote task ID]
  links_to: [original lead task ID]

5d. Update the original lead's status

Update the lead to reflect what happened:

If a quote was generated:

clickup_update_task:
  task_id: [original lead task ID]
  status: "quoted"

If the lead needs qualifying (vague description, missing info):

clickup_update_task:
  task_id: [original lead task ID]
  status: "needs qualifying"

Also add a comment with the specific questions that need answers.

If the lead was declined (outside scope, too small, commercial, etc.):

clickup_update_task:
  task_id: [original lead task ID]
  status: "declined"

Also add a comment with the reason and a drafted polite decline email.

If any of these status values aren't valid for the Leads Pipeline list, add a comment to the lead instead explaining the outcome, and set whatever active/in-progress status is available.

Step 6 — Generate the Action Report

After processing all leads, generate a markdown file called summit-action-report.md and save it to /mnt/user-data/outputs/. This is Mike's at-a-glance dashboard — what needs his attention right now, in priority order.

Use this template:

# Summit Home Renovations — Action Report
**Generated: [today's date]**

---

## 🔴 Needs Your Action Now

### Quotes to Review & Send
[For each quote posted with READY TO REVIEW status:]
- **[Lead/Project Name]** — [project type] — **$XX,000–$XX,000**
  - [1-line scope summary]
  - ClickUp: [quote task URL]
  - ⏱️ Suggested follow-up: within 24 hours

### Leads Needing Qualifying Calls
[For each lead marked "needs qualifying":]
- **[Lead Name]** — missing: [what info is needed]
  - Questions to ask: [the specific questions drafted]
  - ClickUp: [lead task URL]
  - ⏱️ Call within 24 hours to stay responsive

### Declines to Confirm
[For each lead marked "declined":]
- **[Lead Name]** — reason: [why it was declined]
  - Draft decline email is in the ClickUp comments — review and send
  - ClickUp: [lead task URL]

---

## 🟡 Scheduling & Awareness

- **Tile jobs**: Ray is booked through May 2026. Any tile-heavy quotes have June+ timelines noted.
- **Early-bird discounts**: Any quotes where the homeowner could book 6+ weeks out have the 5% discount mentioned.
- **[Any other scheduling notes from the leads processed]**

---

## 📊 Pipeline Summary

| Metric | Count |
|--------|-------|
| Leads processed | [N] |
| Quotes generated | [N] |
| Needs qualifying | [N] |
| Declined | [N] |
| Estimated pipeline value | $XX,000–$XX,000 |

---

*Quotes are in the **Quotes** list in ClickUp → filter by **READY TO REVIEW**.*
*Qualifying leads are in **Leads Pipeline** → filter by **needs qualifying**.*

Present this file to the user using present_files so they can download it or view it immediately. Also paste the highlights (the "Needs Your Action Now" section) directly in the chat so Mike doesn't even have to open the file for the urgent stuff.

Step 7 — Chat Summary

After presenting the report file, give a quick conversational summary in chat:

✅ Processed [N] leads from the pipeline:

1. [Lead name] — [Project type] — Range: $XX,000–$XX,000 — Quote posted → READY TO REVIEW
2. [Lead name] — Declined (reason) — Polite decline drafted → lead marked "declined"
3. [Lead name] — Needs qualifying — Follow-up questions posted → lead marked "needs qualifying"

📋 Full action report is attached — your top priority is [N] quote(s) to review and send.

Edge Cases

• Lead description is vague: Draft qualifying questions instead of a quote. Post them as a comment on the lead task and set status to "needs qualifying." Do NOT create a quote task — the human needs to get more info first.
• Multiple project types in one lead (e.g., "kitchen and two bathrooms"): Build a combined quote. Sum the line items across project types. Apply contingency once to the total, not per-project. Still post as a single quote task with status "ready to review."
• Lead mentions a specific budget: If their budget is below our typical range for that project type, note the mismatch in the quote and suggest a scaled-down scope. Still post the quote as "ready to review" so Mike can decide how to handle the conversation.
• Tile-heavy job: Note in the timeline that Ray (tile sub) is booked through May 2026 and earliest tile start is June.