Customized Roof-Leads Python Tool Development

Job ID: 40574377

Budget: $250 – $750 USD

Title: Build a Local B2C Homeowner Lead Alert Tool (Fixed Budget: $200)

Project Overview:
I am a roof restoration and rejuvenation contractor looking for an expert Python developer to build a lightweight, custom lead-generation tool that I can run locally on my own Windows/Mac computer.

The goal of this tool is to identify local B2C homeowners who need roof work, roof maintenance, or want to extend the lifespan of their shingles. Because many homeowners look for cost-effective alternatives to a massive $15,000 roof replacement, my business offers roof rejuvenation treatments. This tool will help me intercept homeowners on public forums who are complaining about aging roofs, budget constraints, or minor leaks, so I can offer them a restoration solution.

I want to own this script entirely to run locally on my PC and avoid ongoing monthly software subscription fees or third-party API costs.

Core Requirements:
1. Target Sources: Public local community forums, public neighborhood Facebook groups, and public city-specific message boards.
2. Filtering Logic: The tool must scan these sources based on local city/zip codes for specific homeowner keywords. The search must be case-insensitive and support partial phrase matching (e.g., catching "my roof is leaking" because it contains "roof" and "leak").
3. Keyword Library to Include:
- Direct Restoration Targets: "roof rejuvenation", "roof restoration", "extend roof life", "roof coating", "roof treatment", "roof maintenance", "roof cleaning"
- Aging/Budget Targets: "old roof", "roof aging", "curling shingles", "brittle shingles", "roof budget", "roof replacement cost"
- General Volume: "recommend roofer", "local roofing", "need roof work", "roof inspection"
4. Anti-Blocking Configuration: Must include random sleep delays and stealth libraries (e.g., undetected-chromedriver or playwright-stealth) to mimic human browsing behavior and prevent local IP bans or bot-detection blocks.
5. De-duplication: The script must check existing rows in the output sheet and automatically filter out/skip duplicate posts from previous scans so I do not contact the same person twice.
6. Data Fields Needed: The script must extract the Date, the Link to the active post, the Name of the user, and the Text snippet of the post.
7. Output Deliverable: A simple local Python script that saves these results cleanly into a local Excel/CSV file on my computer. A plain text file (README.txt) with simple, step-by-step installation instructions for a non-technical user must be included. No external databases or cloud hosting required.

Required Skills:
- Python
- Web Scraping / Automation (Selenium, Playwright, or BeautifulSoup)
- Social Media / Public Forum Data Extraction

To apply, please start your message with the word "REJUVENATE" so I know you read the description. Briefly explain what framework you would use to build this and confirm it can run locally without recurring API fees.