How to Replace Google Sheets with Automated Provider Scheduling
As Summit Cancer Care grew, managing provider schedules in Google Sheets became increasingly complex and time-consuming. By implementing PerfectServe Lightning Bolt, the organization automated scheduling, improved shift equity, enabled year-long schedule visibility, and streamlined hundreds of schedule changes annually.

Executive Summary
For years, Summit Cancer Care relied on Google Sheets to manage physician and APP scheduling across multiple locations. As the organization grew, maintaining equitable schedules, accommodating provider preferences, tracking schedule changes, and keeping hospital partners informed became increasingly difficult.
After implementing PerfectServe Lightning Bolt, Summit Cancer Care transformed its scheduling operations. What once required hours of manual work each month is now largely automated, giving providers greater schedule transparency while reducing administrative burden for leadership.
Challenges
- Manual provider scheduling in Google Sheets
- Difficult to balance shifts across 26 providers
- Frequent schedule changes and call disruptions
- Limited schedule visibility
Results
- Saved 5–10 hours per month
- Generated schedules up to 1 year in advance
- More than 300 schedule changes automated annually, including PTO requests and shift swaps
- Improved provider satisfaction and schedule transparency
The Challenge
Summit Cancer Care has served communities throughout Southeast Georgia for more than 40 years. As the practice expanded to include 9 physicians and 17 advanced practice providers, scheduling became increasingly complex.
Each month, CEO Alex Sandberg spent hours manually creating schedules in Google Sheets while balancing provider preferences, PTO requests, clinic assignments, hospital coverage, and call responsibilities.
Any schedule change created a ripple effect. PTO requests, shift swaps, and provider absences often required the entire schedule to be rebuilt and redistributed to multiple stakeholders, including hospital partners, PSA teams, and call service providers.
As the organization continued to grow, the scheduling process became difficult to sustain.
"The manual process took approximately 5 to 10 hours every month and became increasingly challenging as the practice expanded."
The Solution
Summit Cancer Care implemented PerfectServe Lightning Bolt to automate provider scheduling and create a centralized source of truth for schedules across the organization.
Using Lightning Bolt's automated scheduling engine, the organization can now account for:
- Provider work locations
- Physician and APP pairing rules
- Equitable shift distribution
- PTO requests
- Specialized call assignments
- Night, hospital, and late-call coverage
Most schedules are generated automatically, significantly reducing administrative effort while improving schedule quality and fairness.
According to Sandberg, approximately 90% of schedules are created correctly through auto-generation, requiring only minimal adjustments.
Building Fair Schedules Without the Administrative Burden
One of Summit's biggest challenges was fairly distributing shifts across a growing provider team.
Previously, balancing workloads required extensive manual review and calculations. Lightning Bolt now automatically accounts for provider preferences, scheduling rules, and equity requirements when generating schedules.
What once took hours can now be completed in minutes, allowing Summit to publish schedules as far as one year in advance.
The longer planning horizon gives providers more predictability and flexibility while reducing last-minute scheduling conflicts.

Giving Providers More Control
Before Lightning Bolt, PTO requests and schedule changes were largely managed through emails, phone calls, and manual updates.
Today, providers can submit and manage shift swaps directly through the platform using Lightning Bolt's "Swapportunity" functionality.
When approved, schedules update automatically and notifications are distributed instantly.
Since implementation, Summit averages approximately 35 schedule change requests per month, all managed through an automated workflow rather than extensive administrative oversight.
Improving Communication Accuracy
Accurate schedules are critical because Summit relies on call services and healthcare partners to connect patients and clinicians.
Prior to Lightning Bolt, outdated schedules occasionally resulted in calls being routed to the wrong provider, creating frustration for clinicians and delays for patients.
With real-time schedule updates now serving as the system of record, schedules remain accurate across all stakeholders, helping ensure calls reach the correct provider the first time.
Enhancing Visibility Across the Organization
Google Sheets made it difficult to manage and communicate a highly complex schedule that included:
- Four clinic locations
- Hospital rotations
- Infusion center coverage
- APP and physician pairings
- Day, late-call, and night-call assignments
Lightning Bolt provides a centralized, real-time schedule accessible through both web and mobile applications.
Color-coded views, filters, and role-specific notifications make schedules easier to understand and manage while reducing confusion across the organization.
Streamlining Reporting and Payroll
Scheduling wasn't the only challenge.
Summit also spent considerable time tracking late-call assignments, workload distribution, and payroll calculations manually.
Lightning Bolt's reporting capabilities now allow leaders to generate custom reports that summarize call shifts, workload distribution, and compensation data.
The result is a faster, more accurate process that saves administrative time while improving confidence in payroll and reporting data.
A Scheduling Foundation for Future Growth
Summit Cancer Care wasn't simply looking for a better scheduling tool. The organization needed a sustainable scheduling operation that could support continued growth without increasing administrative complexity.
With Lightning Bolt, Summit now creates equitable schedules faster, gives providers greater visibility and flexibility, automates hundreds of schedule changes each year, and maintains real-time accuracy across the care team.
For an organization where provider availability directly impacts patient care, the result is more than operational efficiency. It's a scalable scheduling foundation that helps clinicians stay focused on what matters most: caring for patients.
Outcomes at a Glance
- 5-10 hours saved per month
- 1-year schedule visibility
- 300+ annual schedule changes automated
- 35 schedule changes managed monthly through automated workflows
- Improved provider satisfaction
- Fewer contact disruptions
- Accurate, real-time schedules across the organization
- Streamlined reporting and payroll processes
Discover the latest from PerfectServe

Bring us the workflow that [hurts most]
We'll show you how it runs on PerfectServe, with your teams, your sites and your EHR.








.jpg)
.png)
