Blog / Construction Operations

OAC Meeting Minutes That Turn into Tracked Action Items

By Keyona Meeks, Founder, ReRev Labs · Oct 31, 2026 · 9 min read

The short answer: Meeting minutes only help if every decision and every "someone will look into that" ends up as one line with one owner and one due date. Keep those lines in a Google Sheet, one row per action. A Flag formula shows each row as Open, Overdue or Done, so the next meeting starts from the overdue list instead of from memory. Minutes can be written by hand or drafted by an LLM from your notes, and a person must check every line. I tested the formula in LibreOffice, not in Google Sheets. This is a tracking aid, not a legal record.

By the end of this post, you'll be able to:

• Write minutes in a form that produces tracked action items.
• Set up an action log with a Flag column.
• Start each meeting from the overdue list.
• Use an LLM on the messy part, with a person checking it.

I sell build work, so weigh this post with that in mind. Your contract and project manual decide who must keep minutes, who may correct them and what they mean. Check with an attorney, insurer or safety professional before you rely on any log for any contract or legal question. This post is about tracking action items. It is not safety, insurance or legal advice.

Which rules cover meeting minutes?

I looked for an official rule on what owner-architect-contractor meeting minutes must contain, and I did not find one. The one primary source I could read, a free sample of the AIA A201-2017 general conditions from AIA Contract Documents, was returned to me as excerpts: the first 15 of 38 pages. I found no mention of meetings or minutes in the part I could read, so I cannot say what the full document requires. If your contract or specifications describe minutes, follow them. I make no claim that this sheet meets any contract.

What makes an action item trackable?

An action item is trackable when it has four parts:

1. What. One verb and one result. "Send revised door schedule."
2. Who. One person or one company, not "the team."
3. By when. A date, not "soon."
4. Where it came from. The meeting date and an item number.

If a line has no owner or no date, it is a topic, not an action. Log it with a blank due date. The Flag column will say "No due date," so someone has to decide.

How do you set up the action log?

Row 1 holds headings. Use a tab named Actions.

Put this in G2 and fill it down:

=IF(A2="","",IF(F2="Done","Done",IF(E2="","No due date",IF(E2<TODAY(),"Overdue "&(TODAY()-E2)&" days","Open"))))

To count overdue lines, use =COUNTIF(G2:G200,"Overdue*").

I tested both in LibreOffice with five made-up rows: overdue by 4 days, done, due today, due in 6 days and no due date. They returned "Overdue 4 days," "Done," "Open," "Open" and "No due date," and the count was 1. A line due today shows Open. I did not run them in Google Sheets. If Overdue shows a date instead of a number of days, I would check the cell format, but I could not confirm the menu steps, so test with your own rows.

How do you run the next meeting from the log?

Sort or filter the Flag column so that Overdue and No due date lines come first. I could not confirm the menu steps for sorting or filtering in Google Sheets, so use Google's own help for that. Read the overdue lines out first. For each one, the owner says done, new date or dropped. Change the row. Do not delete rows, because a deleted row leaves no trace of what was asked.

How should the minutes be written?

Short. After each meeting, send the people who attended the action list, not a transcript. Say that corrections are due by a date you choose. I do not give a default, because your contract may set one. Keep the original minutes and the log together, so a later reader can see who asked for what.

Where does an LLM fit in this?

An LLM can read raw meeting notes or a transcript and suggest a list of candidate action items, each with a likely owner and due date. That is the messy input. A person then checks every line against what was actually said, because an LLM can invent an owner, miss a decision or turn a question into a commitment, and sound sure. Do not paste confidential project documents into an LLM tool unless your contract and your own rules allow it. The Flag formula, the sorting and the overdue count are plain rules. My stance: AI writes the code, plain automation runs it, and an LLM shows up only where the input is messy and a person checks the result. For where to start with your own automations, see what to automate first.

How do you test it?

1. Enter five test lines: one overdue, one done, one due today, one due next week and one with no due date.
2. Check the Flag column against your own reading of each line.
3. Check the overdue count.
4. Set a status to Done and check the Flag changes.
5. Delete the test lines.

Where this has limits

• It is a tracking aid, not a legal record. I give no legal advice. Check with an attorney, insurer or safety professional before you rely on any log for any contract or legal question.
• I found no official rule for minutes. I read only excerpts of one AIA sample, and it did not mention minutes in the part I saw.
• The formulas were tested in LibreOffice, not Google Sheets.
• The log shows what someone typed. It does not show that a task was done.
• Anyone who can edit the sheet can change it. I did not confirm how Sheets records edits, so I make no claim about it.
• No ReRev prices and no promises about results. I have no data on time saved.

If you want help running this kind of follow-through for your project team, see our fractional chief of staff service or tell us how your meetings run now. Do not send contracts, drawings, passwords or login details.

Frequently asked questions

What should OAC meeting minutes include?

Your contract and project manual decide. For tracking, each action needs a what, a who, a date and a source. I found no official rule that sets the contents.

Can a Google Sheet track meeting action items?

Yes, as a tracking aid. One row per action and a Flag formula are enough to start.

Can an LLM write the minutes?

It can draft a list from your notes. A person must check every line before it goes out.

Should I delete finished items?

No. Mark them Done. A record of what was asked is useful later.

Does the sheet send reminders?

Not in this post. It shows the overdue list when you open it.

Is this a legal record?

No. Ask an attorney what counts as a record under your contract.

Read next: The weekly owner report is where the action items from minutes like these get summarized for the owner.