Blog Workflow Automation Guides
Create daily site reports from Google Sheets
Ask a Midpoint worker to turn approved Google Sheets rows into draft Google Docs, link each daily site report and bring unclear facts back to you.

Tomas Okafor manages three commercial construction jobs: a medical office fit-out, a warehouse extension and a school roof. Site supervisors record the day's work in a shared Google Sheet. The notes are there, but turning them into readable daily reports still takes his evening.
He gives that job to his Midpoint worker: “Use each approved site-and-date row to prepare a draft Google Doc in our report layout. Keep the recorded work, labor, deliveries and blockers. Put the document link beside its source row, and bring unclear facts to me. Don't send the reports.”
Tomas gets draft reports he can open from the sheet, plus a short list of questions. Each document stays tied to one site and date. An approved row with an unclear site or date gets no report until he answers.
From site notes to a readable report
For the Northgate warehouse, the approved row reads:
Site: Northgate warehouse. Date: October 28, 2026. Labor: 6 steel erectors, 2 laborers, 1 crane operator. Notes: bays C to F done up to second purlin, delayed 1 hr am (wind). Deliveries: 14 roof panels, plus 1 pallet fixings, sign-in 07:40. Blockers: paint spec not confirmed for office block. Waiting on architect reply, asked Oct 25.
The worker sorts that into the headings Tomas uses in his daily report:
Northgate warehouse, October 28, 2026
Work and labor: The supervisor recorded bays C to F as done up to the second purlin. The crew was 6 steel erectors, 2 laborers and 1 crane operator. Wind delayed work for 1 hour in the morning.
Deliveries: 14 roof panels and 1 pallet of fixings were signed in at 07:40.
Blockers: The paint specification for the office block is not confirmed. The architect hasn't yet answered the October 25 request.
The notes now read as a report, and the crew numbers, delivery quantities, time and delay are unchanged. “Delayed 1 hr am” stays a 1-hour delay in the morning, with no start time added. The worker adds no percentage complete and no claim that the job is on schedule.
The Doc link goes beside the Northgate row, so Tomas can read the report next to the original notes without searching a folder. The report is a draft for his review. It doesn't certify safety, inspection results, completion or anything under a contract.
Hold the row that needs an answer
Another approved row says “Site: North Gate. Date: 10/9.” The site name might mean the Northgate warehouse, and the date might mean October 9 or September 10.
The worker leaves that row without a Doc and asks: “Does North Gate mean the Northgate warehouse? Which full date should this report use?” An approved row still needs a clear site and date before the worker writes its report.
Tomas can answer in the sheet. When he asks the worker to continue, it uses the site and date he gave. If labor or delivery notes conflict, the worker returns both entries and asks which is correct. Anything missing is left out of the report and listed as a question.
Set up the daily reports
Tomas gives the worker the sheet, the column that marks rows approved, a report layout and the destination folder. The worker prepares the documents and writes each link back to the right row. Sharing and emailing the reports stay with Tomas.
On later days, the worker checks the links already in the sheet before creating anything, and leaves rows that already have a report alone. If a supervisor changes the notes after a report exists, the worker tells Tomas and leaves the report as it is. He decides whether the draft should be revised.
If he wants reports every afternoon, he asks the worker to set up a schedule and they agree on a time. Until then, each request covers one day's reports.
Tomas gets a result he can open, with the open questions beside it. Other operations jobs you can delegate work the same way: a clear request, and a finished result to check.
Use a merge tool when the words are already finished
Document Studio and Autocrat already create documents from spreadsheet data. Document Studio supports template fields, file naming, destination folders, conditions and scheduled runs.
If the row already contains the final report text, a merge tool may be all you need. A worker helps when the notes are shorthand: it writes them up as a report and brings unclear facts to the person who knows the site.
Give your worker the site log
Your Midpoint worker already has its own computer and browser. Connect the Google apps it needs, including access to the report folder, and give it the approved sheet and report layout. Ask it to set up the job and agree where you'll review the reports.
Turn today's approved site-log rows into draft Google Docs. Use our report layout, keep the recorded numbers and put each document link beside its source row. Bring unclear site names, dates or facts to me. Don't send or certify anything.


