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 event table between the two steps.
You: Get sources ready
Gemini Notebook: Build quoted table
You: Correct the table
Gemini Notebook: Draft corrections
You: Check and decide
Use: You
Have ready: the period boundaries, completion events and submitted reports, as text files. Give every source a short ID and date.
Check every source behind each event has an ID and a date; check your organisation's rules permit the upload.
Use: Gemini Notebook
Upload the sources to one notebook and ask for the event-to-period table with late reports marked, 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: event ID, timestamp, timezone, report ID, submitted date. Quote each source passage exactly and give its source ID and date. Write NOT STATED where the sources do not say. Do not assign a period, do not convert timezones and do not fill a value that the text does not state.
Use: You
Correct the table by hand: settle which period each event belongs to, 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 reporting corrections from the corrected table and sources, listing unresolved questions with references.
What to paste into the tool
Task: produce Draft reporting corrections with included, excluded and ambiguous events 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 assign a period, do not convert timezones and do not fill a value that the text does 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 timezones and that no event is counted in two periods. 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 events
Gemini: Add check column
You: Write corrections by hand
Use: Gemini
Ask Gemini in Sheets to create the empty table with the five event columns.
What to paste into the tool
Task: produce Empty Sheet table for each event. Create a table with exactly these columns: event ID, timestamp, timezone, report ID, submitted date. Leave every row empty.
Use: You
Read the period boundaries, events and reports; type each event in, 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 timestamp or timezone 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 timestamp or timezone cell for the row is empty and otherwise returns that cell value.
Use: You
Write the draft corrections 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 timezones and that no event is counted twice. Confirm any next action separately; this workflow ends at a reviewed draft.
ChatGPT pulls the event fields out. You check values and fill periods by hand. ChatGPT drafts; you decide.
You: Paste report, add columns
ChatGPT: Extract event fields
You: Check values, fill periods
ChatGPT: Draft the corrections
You: Check and decide
Use: You
Paste the report text into a sheet and add empty columns: event ID, timestamp, timezone, report ID, submitted date, period.
Check your organisation's rules before uploading; this record does not establish that upload is permitted.
Use: ChatGPT
Paste the report text into ChatGPT and ask it to extract the event fields as a table, leaving the period and unstated cells empty; copy the returned table into the sheet columns yourself.
What to paste into the tool
Task: produce Table with extracted fields. From the pasted text extract these fields for each event: event ID, timestamp, timezone, report ID, submitted date. Leave the period column empty. Leave any other cell empty when the text does not state it. Do not assign a period, do not convert timezones and do not fill a value that the text does not state.
Use: You
Check each extracted value against the report text and fill the period column by hand from the supplied period boundaries.
Fix or clear any value the text does not state.
Use: ChatGPT
Paste the checked sheet rows into the same chat and ask ChatGPT to draft the reporting corrections from those rows only, listing unresolved questions with source references. In the paste box, "Use only the rows of the sheet." becomes "Use only the rows pasted below."
What to paste into the tool
Task: produce Draft reporting corrections with included, excluded and ambiguous events and Unresolved questions with source references. Use only the rows of the sheet. Keep the source ID beside every statement. Do not assign a period, do not convert timezones and do not fill a value that the text does 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 timezones and that no event is counted in two periods. 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 to settle each period
What it does: Gemini sets up columns and a formula; you fill and write
Strong at: Every event entry comes from your own reading
Limit: Gemini in Sheets may refuse some requests; check the table and formula by hand
Free plan: Yes
Best when: You want AI to pull fields from a report; you assign periods
What it does: ChatGPT extracts and drafts; you check values and assign periods
Strong at: The period column stays with you, not the AI
Limit: Extraction accuracy for times and timezones is not shown
Free plan: Yes
Before you paste into any AI tool, remove any confidential information. Put it back at the end.
Deciding between ChatGPT and Gemini for this? See the comparison.
Each event keeps its timestamp and timezone so double counting across periods can be checked.
Items the sources do not settle stay marked UNKNOWN and go to the programme coordinator.
The programme coordinator 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.