Local Visibility & Client Communication System
Let Us Clean MN
A connected digital and operations project for a Minnesota cleaning service, combining a new web presence, local SEO, Google Business Profile support, reviews, short-form video, and a custom Google Calendar-to-Quo SMS automation system for client communication.
A connected local visibility and client communication system combining web, Google Business, video, and appointment-driven SMS automation.
Problem
The business needed both a stronger public presence and a more reliable way to manage recurring client communication around scheduled cleanings. Appointments lived in Google Calendar, while reminders and follow-up texts required repetitive manual work.
Approach
I created the business’s web and local-search foundation, then built a Next.js automation app that syncs Google Calendar events into MongoDB on a 15-minute cadence. Events with a Phone: field in the calendar description are eligible for automation, while other events can still sync without triggering messages. Quo powers the SMS workflow for day-before, day-of, and completion messages. The system tracks send state, cancellations, disabled records, and a rolling seven-day active window so calendar changes can be reflected without blindly sending texts.
Result
The project connected visibility work with operations. The business gained a clearer website and Google presence while also getting a custom communication workflow designed to reduce repetitive reminder texting and keep scheduled client messages tied to the calendar. The automation work reached implementation before the broader project was paused as the business situation changed.
Capabilities
What this project included
Web Presence From Scratch
Created the business’s initial online presence so potential customers could find, understand, and contact the cleaning service.
Calendar-Driven SMS Automation
Built a Next.js workflow connecting Google Calendar, MongoDB, and Quo. Upcoming appointments sync on a 15-minute cadence, a Phone: field in the calendar description gates SMS automation, and message state supports day-before, day-of, and completion communication with cancellation and outage safeguards.
Google Business Profile Setup
Set up the Google Business Profile and aligned the business information around local cleaning service searches.
Review & Rating Strategy
Helped the business begin using Google ratings and reviews as trust signals that support credibility and local search visibility.
Short-Form Video & Reels Editing
Edited video content for social platforms, helping turn cleaning work, brand personality, and service proof into usable short-form content.