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.
Overview
What changed
Let Us Clean MN grew from a local-search foundation into a broader digital operations project. I created the business’s web presence, set up its Google Business Profile, supported review and rating strategy, edited short-form video, and built a custom client communication system that used Google Calendar as the scheduling source, MongoDB as the job-state layer, and Quo for automated SMS. The automation was designed around the way the business already scheduled cleanings, so client communication could follow calendar changes instead of creating a second scheduling system.
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.
Media
Project assets
