A draft row-level import diagnosis with safe correction examples citing schema rules.
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: extracts the failures and drafts, you check
Gemini builds the failure worksheet, then drafts the diagnosis. You check the worksheet first, then the draft.
You
Collect the case material
Gemini
Compare rows with schema
You
Check the worksheet
Gemini
Draft the diagnosis
You
Check the draft
Have ready: file sample, import schema, error text
Use:You
A file sample (not live customer data), the approved import schema and the validation error text.
Check
Check your organisation's rules before uploading case material to any tool; this record does not establish that upload is permitted. Never paste credentials or full payment details.
Compare each failed row with the schema rules
Use:Gemini
Add the case material to Gemini and ask for a worksheet listing each failed row with field, value, broken rule and rule reference.
Details
What to paste into the tool
Task: Evidence worksheet: one row per failed row with field, value, violated schema rule and rule reference. For each failed row, list the field, the value as given, the schema rule it breaks and the rule reference. If the schema or error text does not explain the failure write not stated. Do not invent missing values. Do not run code, send anything or change any record.
Check the worksheet against the originals
Use:You
Compare every worksheet row with the original material; correct rows and fill gaps with not stated.
Check
Check claims, values, chronology and rule applicability against the originals for this case: Date formats and required identifiers fail validation. Do not fill missing or contradictory facts by inference.
Draft the diagnosis and corrections
Use:Gemini
Give the corrected worksheet to Gemini and ask for a row-level diagnosis and correction examples, each citing a schema rule, without importing or overwriting.
Details
What to paste into the tool
Task: Draft row-level diagnosis and correction examples that each cite a schema rule. Using only the corrected worksheet and the approved import schema, draft a row-level diagnosis and one correction example per failed row, each citing its schema rule. Where data is missing write not stated. Do not import, overwrite or invent data. Do not run code, send anything or change any record.
Check the draft and share as draft only
Use:You
Mark open questions and hand the draft to its owner as a draft only.
Check
Check every proposed correction cites a schema rule and no missing data is invented. Check recipient scope and required authority before later use; the draft is not approval. Preparation only.
Gemini Notebook: drafts from your hand-built worksheet
You read the sources and build the worksheet. Gemini Notebook drafts the diagnosis from it; you check every statement.
You
Collect the case material
You
Build the worksheet
Gemini Notebook
Draft the diagnosis
You
Check the draft
Have ready: file sample, import schema, error text
Use:You
A file sample (not live customer data), the approved import schema and the validation error text.
Check
Check your organisation's rules before uploading case material to any tool; this record does not establish that upload is permitted. Never paste credentials or full payment details.
Build the worksheet by hand
Use:You
Compare the failed rows with the field and format rules; write a worksheet listing each failed row, value, broken rule and reference.
Check
Check claims, values, chronology and rule applicability against the originals for this case: Date formats and required identifiers fail validation. Do not fill missing or contradictory facts by inference.
Draft the diagnosis and corrections
Use:Gemini Notebook
Give the worksheet to Gemini Notebook and ask for a row-level diagnosis and correction examples, each citing a schema rule, without importing or overwriting.
Details
What to paste into the tool
Task: Draft row-level diagnosis and correction examples that each cite a schema rule. Using only the worksheet and the approved import schema, draft a row-level diagnosis and one correction example per failed row, each citing its schema rule. Where data is missing write not stated. Do not import, overwrite or invent data. Do not run code, send anything or change any record.
Check the draft and share as draft only
Use:You
Check every statement in the draft against the worksheet and the original material; hand it to its owner as a draft only.
Check
Preparation only.
Coda: extracts the failures, you write the diagnosis
Coda builds the failure worksheet. You check it and write the diagnosis yourself.
You
Collect the case material
Coda
Compare rows with schema
You
Check the worksheet
You
Write the diagnosis
You
Check the draft
Have ready: file sample, import schema, error text
Use:You
A file sample (not live customer data), the approved import schema and the validation error text.
Check
Check your organisation's rules before uploading case material to any tool; this record does not establish that upload is permitted. Never paste credentials or full payment details.
Compare each failed row with the schema rules
Use:Coda
Add the case material to Coda and ask for a worksheet listing each failed row with field, value, broken rule and rule reference.
Details
What to paste into the tool
Task: Evidence worksheet: one row per failed row with field, value, violated schema rule and rule reference. For each failed row, list the field, the value as given, the schema rule it breaks and the rule reference. If the schema or error text does not explain the failure write not stated. Do not invent missing values. Do not run code, send anything or change any record.
Check the worksheet against the originals
Use:You
Compare every worksheet row with the original material; correct rows and fill gaps with not stated.
Check
Check claims, values, chronology and rule applicability against the originals for this case: Date formats and required identifiers fail validation. Do not fill missing or contradictory facts by inference.
Write the diagnosis by hand
Use:You
Write the row-level diagnosis and correction examples by hand from the corrected worksheet, each citing a schema rule, without importing or overwriting.
Check
Check every proposed correction cites a schema rule and no missing data is invented.
Check the draft and share as draft only
Use:You
Mark open questions and hand the draft to its owner as a draft only.
Check
Preparation only.
Compare the three approaches
Option A: Gemini: extracts the failures and drafts, you check
Best when: Inputs are spreadsheets; you want structured rows
What it does: Gemini extracts rows and drafts; you check both
Strong at: Extracts data from documents and merges datasets
Limit: Extraction accuracy not stated; check each row
Free plan: Yes
Option B: Gemini Notebook: drafts from your hand-built worksheet
Best when: You want to read the sources and own the worksheet
What it does: You build the worksheet; Gemini Notebook drafts
Strong at: Answers cite quotes from the loaded sources
Limit: Vendor says the tool can make mistakes; check everything
Free plan: Yes
Option C: Coda: extracts the failures, you write the diagnosis
Best when: Case rows sit in a linked table with AI columns
What it does: Coda extracts; you check and write the draft
Strong at: AI columns generate content from table data
Limit: Product also named Superhuman Docs; confirm current name
Free plan: Yes
Before you paste into any AI tool, remove any confidential information. Put it back at the end.