Most teams waste hours chasing people for End-of-Day reports.
We don’t.
We built Riley, a custom GPT that handles daily check-ins automatically. Riley checks Basecamp, updates our tracker, and generates a clean summary image.
Why We Built Riley
Every day, our team members are expected to submit a quick EOD report in Basecamp.
Before Riley, someone had to manually:
- Open Basecamp.
- Check who replied.
- Update an Excel sheet.
- Make an image.
- Post the summary.
It worked, but it was tedious.
So we turned the entire process into an automated system.
What Riley Does
Riley’s job is to verify who submitted their EOD report, update the records, and prepare a clean, shareable image for the Basecamp thread.
Here’s the workflow:
- Check Basecamp
Riley reviews the “End-of-Day Report” thread and confirms who submitted for the current date. - Update the Excel Tracker
The GPT adds a new column for today’s date in both the “Daily” and “Weekly” sheets, marks ✓ for submitted and ✘ for missing, and keeps any existing notes (like scheduled leave). - Create the Summary Image
It generates a PNG table with a green header, white background, left-aligned names, centered ✓/✘ symbols, and proper spacing so it looks neat when shared. - Deliver the Results
Riley returns the updated Excel file and image, ready to share in Basecamp.
What It Looks Like
Here’s an example output from September 24, 2025; everyone submitted that day:
Riley’s output is clean, consistent, and easy to read at a glance.
Why It Matters
This small automation solved a big operational annoyance:
- Saves time: Managers don’t waste 15 minutes checking threads daily.
- Improves accountability: Nobody can say “I thought I submitted.”
- Keeps records clean: We now have a running history of who submitted and when.
- Looks professional: The formatted image makes our Basecamp updates look sharp.
Most importantly, it keeps everyone focused on real work instead of routine admin.
How to Use Riley
Ask Riley things like:
- “Check today’s EOD reports and update the tracker.”
- “Generate the EOD summary for [date].”
- “Who hasn’t submitted their EOD this week?”
Riley handles the rest.
Behind the Scenes
Riley runs on ChatGPT’s Custom GPT platform with clear instructions:
- Never ask for or store passwords.
- Always request a takeover for Basecamp login.
- Update the Excel file and image only.
- Follow PST time for accuracy.
- Keep formatting tight and visually balanced.
This makes it safe, predictable, and repeatable across teams.
The Bigger Picture
Riley is one of several custom GPTs we use to automate operations, alongside assistants like Jennifer (our article grader), Brandon (our blog post builder), and Stephanie (our operations specialist).
Each one replaces repetitive tasks with consistent systems, freeing our team to focus on strategy, not busywork.
If you run a remote team or manage multiple VAs, Riley’s blueprint is easy to replicate.
All you need is a consistent reporting process, a shared tracker, and clear GPT instructions.
Dennis Yu
Dennis Yu is the CEO of Local Service Spotlight, a platform that amplifies the reputations of contractors and local service businesses using the Content Factory process. He is a former search engine engineer who has spent a billion dollars on Google and Facebook ads for Nike, Quiznos, Ashley Furniture, Red Bull, State Farm, and other brands.
Dennis has achieved 25% of his goal of creating a million digital marketing jobs by partnering with universities, professional organizations, and agencies. Through Local Service Spotlight, he teaches the Dollar a Day strategy and Content Factory training to help local service businesses enhance their existing local reputation and make the phone ring.
Dennis coaches young adult agency owners serving plumbers, AC technicians, landscapers, roofers, electricians, and believes there should be a standard in measuring local marketing efforts, much like doctors and plumbers must be certified.