Gemini Google Workspace Source Synthesis Memo with Contradiction Log

Combines your Docs, Sheets, meeting notes, and outside sources into one decision memo. Separates internal evidence from external research and logs conflicts, gaps, and next actions.

You get: Decision and recommendation, internal evidence table and external query plan

More like this

The prompt

gemini-google-workspace-source-synthesis-memo-with-contradiction-log.md
Role: You are a research synthesis lead working in Gemini with Google ecosystem workflows. You merge internal documents and public sources into one decision memo without overstating what you can access.

Context: The job-to-be-done is to produce a memo that helps {decision_owner} decide {decision} by {deadline}. Internal materials: {internal_sources} (for example Google Docs, Sheets, Slides, meeting notes, or files I paste or attach). External topic: {topic}. Only use Google Workspace extensions or Drive access if they are enabled in my Gemini session and I reference specific files. If they are not, ask me to paste the relevant text. Do not claim live browsing unless search or Deep Research is enabled.

Task: Synthesize internal and external evidence into a decision memo with a contradiction log, confidence levels, and a concrete action plan.

Inputs (ask for anything missing before writing, then list assumptions separately):
- Decision, options, and the decision owner
- Internal sources and their dates, authors, and how reliable they are
- Success metrics {success_metrics} and constraints {constraints} such as budget, time, policy, or privacy
- Public source types to prioritize: {external_source_types}
- Recency window: {recency_window}

Workflow:
1. Restate the decision and the question the memo must answer. List assumptions.
2. Internal evidence pass: extract facts, numbers, owners, and dates from each internal source. Quote key lines. Mark outdated or conflicting items.
3. External source discovery: provide 6-10 search queries I can run, grouped by source type (primary data, official documentation, regulators or standards, reputable industry or academic publications). If search is enabled, run them and cite results.
4. Evidence review: tag each finding as Internal, External, or Both. Tag claims as Evidence, Inference, or Opinion.
5. Contradiction log: list each conflict between internal and external sources, or within one set, with the likely cause (date gap, definition mismatch, sample size, bias) and how to resolve it.
6. Synthesis: weigh the options against {success_metrics}. State confidence High, Medium, or Low for each conclusion and the evidence that drives it.
7. Decision support: recommend an option, state the conditions under which the recommendation changes, and propose a lightweight validation step.

Constraints:
- Do not include private personal data in the memo. Refer to roles instead of names where possible.
- Do not fabricate sources, figures, or quotes. Use 'not found' or 'unverified'.
- Keep the memo scannable. Use tables and short bullets. Keep the main memo under 900 words, excluding tables.
- Make it ready to paste into Google Docs, with Sheets-ready tables.

Output format:
1. Decision and recommendation (max 80 words)
2. Assumptions and missing information
3. Internal evidence table (source, date, key fact, reliability)
4. External query plan (query, purpose, preferred source type)
5. Citation table (#, title, publisher, URL, publication date, date checked, source type)
6. Contradiction log (conflict, sources, likely cause, resolution step)
7. Option comparison (option, evidence for, evidence against, confidence)
8. Risks and mitigations
9. Next actions (owner, action, due date, success signal)
10. Open questions for stakeholders

Acceptance criteria:
- The recommendation traces to cited internal or external evidence.
- All conflicts are logged with a proposed resolution.
- Each next action has an owner role, due date, and success signal.
- Items I did not supply are named as missing.

Quality checks:
- Did I separate internal facts from external facts and inference?
- Are all sources dated, or marked 'date not found'?
- Did I avoid claiming access to files or the web that I do not have?
- Would a stakeholder know what to do next after reading only sections 1 and 9?

Example output

AI-written example

Memo: AI-Assisted Ticket Triage Decision

Access note: Search and Deep Research are not enabled in this session. I used only the pasted internal text. External findings are unverified until the queries in section 4 are run.

1. Decision and recommendation
The Director of Customer Support must decide by March 14 whether to roll out AI triage to all queues. Recommendation: run a 4-week pilot on the Billing and Account queues only. Internal data shows a likely gain, but the security review is incomplete and no external benchmark has been checked. Confidence: Medium.

2. Assumptions and missing information

  • Assumed: the success metric is first-response time under 4h with CSAT at or above 88%.
  • Missing: vendor contract price, the security review's final sign-off, and agent headcount for Q2.

3. Internal evidence

SourceDateKey factReliability
Q4 Support Metrics (Sheet)Jan 8Median first response 6.2h; Billing is 41% of volumeHigh
Vendor Pilot Notes (Doc)Feb 2"Triage accuracy 91% on 300 tickets"Medium (small sample, vendor-run)
Security Review (Doc)Feb 19Data retention terms "pending legal"Medium (incomplete)

4. External query plan

QueryPurposeSource type
"AI ticket triage accuracy benchmark 2023..2025"Test the 91% claimAcademic/industry
"customer support automation CSAT impact study"Quality riskIndustry
"GDPR automated processing customer support guidance"ComplianceRegulator
Vendor data retention documentationCheck against the legal gapOfficial docs

5. Citation table

#TitlePublisherURLPub. dateDate checkedType
–Not found: search not run–––––

6. Contradiction log

ConflictSourcesLikely causeResolution
91% accuracy vs. the team's informal "feels like 80%" notePilot Notes vs. Feb 5 meeting notesDefinition mismatch (category vs. priority accuracy)Re-score 100 tickets with the agreed definition
Retention "30 days" vs. "pending"Vendor deck vs. Security ReviewDate gapAsk legal for written confirmation

7. Option comparison

OptionForAgainstConfidence
Full rolloutPossible response-time gain (Inference)Privacy unresolved, small sampleLow
Limited pilotLimits risk, tests the metricDelays the benefit by about 4 weeksMedium
Do nothingNo riskResponse time stays above targetMedium

8. Risks and mitigations

  • Misrouted urgent tickets: add a human-review rule for "outage" keywords.
  • Compliance exposure: block go-live until legal signs off.

9. Next actions

OwnerActionDueSuccess signal
Support Ops LeadRe-score 100 pilot ticketsMar 4Accuracy measured under one definition
Legal CounselConfirm retention termsMar 7Written sign-off
Research AnalystRun the section 4 queries and fill the citationsMar 6At least 4 dated sources
Decision OwnerApprove or reject the pilotMar 14Decision logged

10. Open questions

Generated from this prompt by AI. Your results will vary.

Tips and common edits

Best when Workspace extensions are enabled and you name specific files. Otherwise paste excerpts. After Gemini drafts the memo, export it to Google Docs and have an owner confirm the internal facts. Re-run the external queries before finalizing if the memo will be reused later.

Questions about this prompt

More in Gemini

AI Visibility Audit: Brand Mention and Citation Test Plan for AI Answer Engines

Design and analyze a repeatable prompt test set that checks how AI answer engines mention and cite your brand. It turns results into a citation table, evidence-based gap findings, and prioritized page and entity fixes.

Evidence Review Plan for a Classroom Teaching Strategy Decision

Guides source discovery, evidence review, a citation table, synthesis, and a recommendation on whether to adopt a teaching strategy. It does not claim live browsing and marks every unverified item for you to check.

Long-Form Article Brief With Source Discovery Plan and Citation Table

Creates an editorial brief and outline for a researched article. It includes a source discovery plan, an evidence review template, and a citation table, without pretending any live browsing took place.

Pricing Change Decision Memo with Scenario Math and Test Plan

Turns current pricing, cost, and customer data into a decision memo comparing hold, adjust, and repackage options, with scenario math, risks, and a controlled pricing test plan.

Productivity Tool Selection: Source Discovery, Evidence Review, and Citation Table

A research workflow to choose between candidate productivity or automation tools. It plans online source discovery, structures evidence review in a citation table, and ends in a decision memo without claiming live browsing took place.

Trending

Developmental Edit Memo for an Essay Draft With Revise-or-Cut Decisions

Gives a draft essay a structured developmental edit: thesis check, paragraph-by-paragraph audit, and a prioritized revision plan so you can decide what to keep, rewrite, or cut before line editing.

30-Minute Moderated Usability Test Script with Tasks and Notes Template

Produces a timed 30-minute moderated usability script with task scenarios, neutral follow-up questions and a ready-to-use notes template.

4-Week Small Business Launch Plan: $0 and Small-Budget Versions

Builds a 4-week launch plan for a product or service in a specific market, with channels and weekly tasks in a $0 version and a small-budget version.

60-Minute Lesson Plan with Checks for Understanding and Differentiation

Builds a timed, objective-aligned lesson plan with formative checks, differentiation, and a teach-or-revise readiness verdict. It asks for missing inputs first and keeps assumptions separate.

90-Day Lifecycle Marketing Diagnostic and Experiment Roadmap for Onboarding and Retention

Diagnoses drop-off across the customer lifecycle from your funnel data and produces a prioritized 90-day plan of messages, triggers, and experiments with metrics so teams can decide where to invest first.

Above-the-Fold Landing Page Critique with 3 Headline, Subhead, and CTA Variants

Critiques landing page copy for clarity and conversion, then rewrites the headline, subhead, and CTA in three distinct variants.

Adaptive Quiz from My Notes with Weak-Spot Summary

Quizzes you one question at a time from your own notes, adjusts difficulty after each answer, and ends with a ranked list of weak spots.