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 Notebook drafts from the corrected table. You correct the first table between the two steps.
You: Get sources ready
Gemini Notebook: Build quoted table
You: Correct the table
Gemini Notebook: Draft the history
You: Check and decide
Use: You
Have ready: the prior decision log, later transcript and amendment rules as text files. Give every source a short ID and note its date.
Check each source carries its short ID and date before the upload.
Use: Gemini Notebook
Upload the sources to one notebook and ask for the old-to-new comparison table, quoting each source with its ID and date.
What to paste into the tool
Task: produce Table of quoted source passages with IDs, dates and NOT STATED markers. Using only the selected sources, use these columns: old decision wording, new decision wording, source ID, meeting date, effective date, authority for the change. Quote each source passage exactly and give its source ID and date. Write NOT STATED where the sources do not say. Do not decide which wording is active and do not fill an effective date that the sources do not state.
Use: You
Correct the table by hand: settle the active wording after each meeting, keep unsettled NOT STATED markers, record corrections with source IDs.
Compare identifiers, dates and ambiguous claims against the original inputs.
Use: Gemini Notebook
Ask Gemini Notebook to draft the decision history from the corrected table and sources, listing unresolved questions with references.
What to paste into the tool
Task: produce Draft decision history preserving superseded wording and unresolved effective dates and Unresolved questions with source references. Use only the corrected table and the selected sources. Keep the source ID beside every statement. List each open question with its source reference. Do not decide which wording is active and do not fill an effective date that the sources do not state. Do not propose or perform next actions.
Use: You
Read the draft against the original sources, resolve or keep each open question, and decide whether it is ready to hand on.
Check supersession authority and active wording; the original decision stays traceable. Decide any next action separately.
Gemini sets up the table and a check column. You read the sources, fill rows and write the draft.
Gemini: Set up table
You: Type in decisions
Gemini: Add check column
You: Write history by hand
Use: Gemini
Ask Gemini in Sheets to create the empty table with the six decision columns.
What to paste into the tool
Task: produce Empty Sheet table for each decision. Create a table with exactly these columns: old decision wording, new decision wording, source ID, meeting date, effective date, authority for the change. Leave every row empty.
Use: You
Read the sources and type each decision into the table, leaving a cell blank when the sources do not state it.
Check your organisation's rules before pasting this data into any tool; this record does not establish that it is permitted.
Use: Gemini
Ask Gemini in Sheets for a formula that flags a row NOT STATED when its effective date cell is blank.
What to paste into the tool
Task: produce Sheet with check column showing the row value or NOT STATED. Write a Google Sheets formula for a new column that returns the text NOT STATED when the effective date cell for the row is empty and otherwise returns that cell value.
Use: You
Write the decision history by hand from the Sheet, copying each source ID beside its statement; list unresolved questions with references.
Test the check column on three hand-filled rows first. Check supersession authority and active wording; decide any next action separately.
You enter the decision rows. Coda writes entries from them and drafts from the corrected rows. You check throughout.
You: Enter decision rows
Coda: Write one-line entries
You: Correct each entry
Coda: Draft the history
You: Check and decide
Use: You
Enter each decision into a Coda table: old decision wording, new decision wording, source ID, meeting date, effective date, authority for the change.
Check your organisation's rules before uploading; this record does not establish that upload is permitted.
Use: Coda
Ask Coda AI to write a one-line entry for each decision from its row, writing NOT STATED where a cell is empty.
What to paste into the tool
Task: produce Coda table with AI entries. For each row write one line that states the decision and its source ID using only the cells in that row. Write NOT STATED for any empty cell. Do not decide which wording is active and do not fill an effective date that the sources do not state.
Use: You
Check each entry against its row cells and the sources, correct it, and fill any blank cell the sources state.
Fix or delete any entry that adds a fact.
Use: Coda
Ask Coda AI to draft the decision history from the Coda table only, listing unresolved questions with source references.
What to paste into the tool
Task: produce Draft decision history preserving superseded wording and unresolved effective dates and Unresolved questions with source references. Use only the rows of the Coda table. Keep the source ID beside every statement. Do not decide which wording is active and do not fill an effective date that the sources do not state. Do not propose or perform next actions.
Use: You
Read the draft against the original sources, resolve or keep each open question, and decide whether it is ready to hand on.
Check supersession authority and active wording; the original decision stays traceable. Decide any next action separately.
Best when: Sources are text files and you want a quoted first table
What it does: Gemini Notebook builds the table and drafts; you correct and check
Strong at: Answers cite quotes you can open for each row
Limit: Vendor tells users to double check output; check every row
Free plan: Yes
Best when: You want to read every source yourself and settle the active wording
What it does: Gemini sets up columns and a formula; you fill and write
Strong at: Every decision entry comes from your own reading
Limit: Gemini may not support a request; check table and formula by hand
Free plan: Yes
Best when: You want to enter the data yourself; AI writes from corrected rows
What it does: Coda writes entries and drafts; you enter, correct and check
Strong at: The draft is written from rows you corrected, not raw sources
Limit: Not shown how Coda treats source quotes or NOT STATED markers
Free plan: Yes, limited (1 GB attachments per doc)
Before you paste into any AI tool, remove any confidential information. Put it back at the end.
Each old and new wording pair keeps its source ID and meeting date.
Items the sources do not settle stay marked UNKNOWN and go to the meeting chair.
The meeting chair reviews the draft and confirms any next action separately.
Check data-handling rules before uploading or pasting any source.
Check the result against your original inputs. Approve it before sharing or acting.