Combine team updates into one project status report, separating facts from gaps
A reviewed status report draft that separates facts, risks and missing updates, checked against the original inputs.
Choose one of three approaches. The steps for that option appear below.
Choose an option above. On a phone, swipe the tabs left or right to see all options →
Gemini: drafts the table and report, you check both
Gemini builds the update table and drafts the status report in one chat. You check both against the originals.
You
You: Get inputs ready
Gemini
Gemini: Build update table
You
You: Check the table
Gemini
Gemini: Draft the report
You
You: Check and decide
Get the inputs ready
Use:You
Have ready: the team reports, milestone baseline and reporting definitions. Paste the set into one new Gemini chat.
Check
Check your plan terms allow this data, and every source ID matches the originals.
Build the update table
Use:Gemini
Ask Gemini to build the source-dated update table from the pasted inputs, flagging ambiguous items as unresolved.
Details
What to paste into the tool
From the pasted team reports, milestone baseline and reporting definitions, build normalised source-dated update table. Output a structured table. Keep every source identifier, relevant date and explicit uncertainty exactly as supplied; mark anything ambiguous as unresolved rather than guessing; use only the supplied operating rules, do not invent policy; minimise personal and personnel data in the output.
Check the table against the originals
Use:You
Compare the table with the original reports, baseline and definitions; ask Gemini for corrections in the same chat.
Check
Check each source ID, date and uncertainty marker against the originals.
Draft the status report
Use:Gemini
Ask Gemini to draft the status report from the checked table, facts, risks and missing updates separated, with unresolved questions listed.
Details
What to paste into the tool
Using the corrected normalised source-dated update table and the supplied rules, prepare project status draft with facts, risks and missing updates separated. Keep every source reference visible, keep disputed or uncertain items explicitly marked, and list unresolved questions with their source references. Draft wording only: do not add facts that are not in the corrected table or the supplied inputs. Keep facts, risks and missing updates in separate sections; flag stale claims.
Check the report and decide
Use:You
Check the draft report and unresolved questions against the original inputs; the workflow ends at this checked draft.
Check
Check every milestone has current evidence or a missing-data flag, and check stale claims. Decide any next action separately.
Claude: drafts the report from your hand-built table
You build and check the update table by hand; no AI is used. Claude only words the final draft.
You
You: Build table by hand
Claude
Claude: Draft the report
You
You: Check and decide
Build and check the table by hand
Use:You
Have ready: team reports, milestone baseline and reporting definitions. Enter each row in a local sheet with its source ID, date and uncertainty.
Check
Check each row against the originals, and check your plan terms allow pasting the table into Claude.
Draft the status report
Use:Claude
Ask Claude to draft the status report from the checked table and supplied rules, facts, risks and missing updates separated.
Details
What to paste into the tool
Draft the project status draft with facts, risks and missing updates separated from the checked normalized source-dated update table pasted below and the supplied rules. Wording only: do not add facts, sources or decisions that are not in the checked table. Keep every source reference visible and list unresolved questions with their source references. Keep facts, risks and missing updates in separate sections; flag stale claims.
Check the report and decide
Use:You
Check the draft report and unresolved questions against the original inputs; the workflow ends at this checked draft.
Check
Check every milestone has current evidence or a missing-data flag, and check stale claims. Decide any next action separately.
Gemini Notebook: builds the cited table and drafts the report
Gemini Notebook builds the cited table and writes the status report. You check both against the originals and decide.
You
You: Set up notebook
Gemini Notebook
Gemini Notebook: Build cited table
You
You: Check the table
Gemini Notebook
Gemini Notebook: Write the report
You
You: Check and decide
Set up the notebook and sources
Use:You
Have ready: team reports, milestone baseline and reporting definitions. Upload them to a new notebook in Gemini Notebook as named sources, so citations stay attributable.
Check
Check your plan terms allow the upload and the set is complete; free notebooks allow up to 50 sources.
Build and export the cited table
Use:Gemini Notebook
Ask Gemini Notebook to build the cited update table, then export it to Google Sheets; citations land on the second tab.
Details
What to paste into the tool
Using only the uploaded sources, build the normalized source-dated update table. Produce it as a data table; describe the rows and columns so each row keeps its source citation, relevant date and any uncertainty. Mark anything ambiguous as unresolved rather than guessing; use only the supplied operating rules. Nothing is sent or published.
Check the exported table
Use:You
Check the exported table against the original inputs and correct it. Mark anything you cannot settle as unresolved.
Check
Check each row has a source reference; check missing ones directly against the originals.
Write the report from the notebook
Use:Gemini Notebook
Ask Gemini Notebook to write the status report from the checked table and uploaded sources, keeping a source reference next to each item.
Details
What to paste into the tool
Using only the uploaded sources and the checked normalized source-dated update table below, draft the project status draft with facts, risks and missing updates separated. Keep one source reference next to each item. Mark anything ambiguous as unresolved rather than guessing; list unresolved questions with their source references. Use only the supplied operating rules; do not invent policy, facts or names. Nothing is sent or published. Checked table: [paste the checked table].
Check the report and decide
Use:You
Check the draft wording against the checked table and originals; do not add unsupported facts or settle ambiguity by inference.
Check
Check every milestone has current evidence or a missing-data flag, and check stale claims. Decide any next action separately.
Compare the three approaches
Option A: Gemini: drafts the table and report, you check both
Best when: You want one Gemini chat to structure and draft both artefacts
What it does: Gemini builds the table and drafts; you check both
Strong at: One chat holds both stages; no re-explaining
Limit: Source IDs may not survive; re-check every identifier against originals
Free plan: Yes
Option B: Claude: drafts the report from your hand-built table
Best when: The extraction must stay with people; AI only words the draft
What it does: You build the table by hand; Claude drafts the report
Strong at: No AI touches the table before you check it
Limit: A shared misunderstanding of a source can pass both steps
Free plan: Yes
Option C: Gemini Notebook: builds the cited table and drafts the report
Best when: You want cited answers grounded only in your uploaded sources
What it does: Gemini Notebook builds the table and writes; you check
Strong at: Citations are direct quotes; the table exports to Sheets
Limit: Citations point to uploaded files, not your own source IDs
Free plan: Yes
Before you paste into any AI tool, remove any confidential information. Put it back at the end.
Compare the source identifiers, definitions, dates and ambiguous claims against the original inputs; correct the normalised source-dated update table before handoff.
Every milestone has current evidence or a missing-data flag; coordinator checks stale claims. Confirm any next action separately; this workflow ends at a reviewed draft.
Suggestions and draft artefacts only. Do not send, publish, update records, assign people, reserve resources, buy goods or authorise work.
Any safety, legal or employment requirement needs the responsible qualified human; this output is not certification.
Check the result against your original inputs. Approve it before sharing or acting.
What still needs checking
Whether the supplied inputs already carry stable source IDs or the reviewer must assign them during preparation.
How stale an update may be before it counts as missing; the draft flags stale claims, the coordinator applies the reporting definitions.