Tracking Plowing & Invoices

Curious if any of you could share how you track your plowing services and in particular invoice them out. We use Google sheets and Quickbooks online. Here’s the dilemma/how we currently operate:

-Google sheets for every day of the month and for every sector of plowing -Sectors of plowing: 1. Main town area (about 80 businesses) 2. Sidewalks of main town (About 20) 3. Residential area in the mountains (About 75) 4. Subcontractors for other sidewalks and ice melt (about 15 businesses) 5. Then there is sand, equipment (grading, pile push backs etc)

So I manually make all the sheets for all of the above. Then, once they input the data I make estimates within quickbooks online and update as the days go (****this business takes place in Montana so there is a lot to input)

Now I know you can upload a google sheet into QBO but only into an invoice so I believe you could only do this at the end of the month, and the owner likes things updated more often to see our numbers and where we are at.

This has become extremely time consuming and repetitive. Does anyone have a suggestion to automate this more or other platforms you use for tracking plowing that can easily upload into QBO??? We briefly looked at snow plowing apps but they all seemed pretty expensive but we need to change something for next season.

Thank you