Reconcile exported records by identifier

Compare two de-identified text tables record by record, checking nulls, duplicate keys and field changes even when totals match.

適用情境 / When to use

Answer.AI reports a Devin transfer from Notion to Google Sheets alongside failures on other tasks. This exercise only reconciles supplied text copies.

步驟 / Steps

1. Open an ordinary text chat at gemini.google.com with an eligible account. Prepare shareable or fictional plain text using the prompt parameters; transcribe it yourself and mark ambiguities. Do not upload source files or connect accounts.
2. Paste the text and prompt; request only a draft, comparison or plan, not tool execution.
3. Check every output against supplied sources, references and unknowns. A human decides next steps; no automatic publishing, payment or deployment.

提示詞 / Prompt

Compare [de-identified source and exported text tables: row IDs, fields and values] using [expected field mappings, types, date/timezone, multivalue and null rules]. Draft additions, omissions, duplicate IDs and changed values by ID. Flag ambiguous duplicates rather than matching them arbitrarily. Distinguish blank, null, zero and missing input; retain original dates without guessing timezones or truncating multivalues. Equal totals do not establish parity. Identify source rows for human checks. Process pasted text only, without reading files, calling APIs, changing records, connecting accounts or sharing.

留意事項 / Cautions

• The source does not expose complete reproducible data; one successful transfer does not establish lossless exports generally.
• Checked 2026-10-31: official Gemini web lists Hong Kong, Macau, Taiwan, Traditional/Simplified Chinese and English; account and age eligibility apply. Limited use is available without a paid AI plan and varies by account and workload. Taiwan’s public subscription page lists Free at NT$0/month; no paid plan is required for this exercise. HK/Macau paid prices and local taxes, offers and final quotes are unverified. Output quality in all three languages is untested. Web eligibility does not establish App/API eligibility; neither is needed here. Original-tool regional features, devices and paid eligibility are unconfirmed; do not bypass restrictions. Android’s official region list also includes HK/Macau/Taiwan. The iOS and AI Studio/Gemini API lists include Taiwan, not Hong Kong or Macau; feature and device restrictions still apply.

來源限制 / Evidence limits

The source does not expose complete reproducible data; one successful transfer does not establish lossless exports generally.

流程說明 / Workflow note

Original, untested text-only exercise by this site; it does not reproduce source devices, agents or integrations. Checked 2026-10-31: official Gemini web lists Hong Kong, Macau, Taiwan, Traditional/Simplified Chinese and English; account and age eligibility apply. Limited use is available without a paid AI plan and varies by account and workload. Taiwan’s public subscription page lists Free at NT$0/month; no paid plan is required for this exercise. HK/Macau paid prices and local taxes, offers and final quotes are unverified. Output quality in all three languages is untested. Web eligibility does not establish App/API eligibility; neither is needed here. Original-tool regional features, devices and paid eligibility are unconfirmed; do not bypass restrictions. Android’s official region list also includes HK/Macau/Taiwan. The iOS and AI Studio/Gemini API lists include Taiwan, not Hong Kong or Macau; feature and device restrictions still apply.

原始工具組合 / Original tool stack

Devin; Notion API; Google Sheets API; Python; Slack

Source publication date: 2025-01-08

Source checked: 2026-10-31

Thoughts On A Month With Devin