Tutorial 08: Legal Automation with ChatGPT (OpenAI)

I have uploaded a batch of NDAs. For each NDA:

1. Run NDA triage (standard/counsel review/full review)
2. Create a summary table with columns:
   - Filename
   - Counterparty
   - Type (mutual/one-way)
   - Triage Result
   - Key Issues Flagged
   - Recommended Action
3. Generate an Excel file (or CSV) with all data
4. Generate a brief email summary I can send to the team

Save the Excel/CSV as "NDA_Triage_[today's date].xlsx" (or .csv)
Provide the email draft in the response.

I have uploaded 5 vendor agreements. Compare them and generate a report:

1. For each agreement, extract:
   - Vendor name
   - Annual cost
   - Term length
   - Liability cap
   - Indemnification scope
   - Data rights
   - SLA commitments
   - Notable unusual terms

2. Create a comparison matrix (Excel or table) with:
   - Side-by-side comparison
   - Color coding suggestions (green=favorable, yellow=neutral, red=unfavorable)
   - Our standard position for reference

3. Generate an executive summary (1 page) and detailed analysis with recommendations.

I need to process these contracts from the data room. For each contract, extract and log:

- Contract type
- Counterparty
- Effective date
- Term/expiration
- Annual value (if stated)
- Auto-renewal terms
- Change of control provisions
- Assignment restrictions
- Termination rights
- Key risk flags

Create a master Excel/CSV tracker with all data. Flag contracts requiring follow-up:
- Approaching expiration (next 12 months)
- Change of control consent required
- Assignment restricted
- Non-standard terms

Generate a summary memo for the deal team.

I have uploaded discovery documents for trial prep. For each document:

1. Extract:
   - Document date
   - Document type
   - Key parties involved
   - Summary of content
   - Relevance to our case theory
   - Helpful/harmful assessment

2. Create chronological timeline in Excel with columns:
   - Date
   - Event description
   - Document reference
   - Key quote (if applicable)
   - Our assessment (helps/hurts/neutral)

3. Generate a Word document (or formatted text) with:
   - Narrative chronology (suitable for mediation brief)
   - Key events highlighted
   - Supporting document citations

4. Create a PowerPoint outline or slide structure for:
   - Visual timeline for trial
   - Key dates marked
   - Clean professional design

Save the Excel as "Timeline_Master.xlsx"
Provide the narrative and slide outline in the response.

Process these contracts and create portfolio analytics:

1. For each contract, extract:
   - Contract ID, name, counterparty, type
   - Execution/effective/expiration dates
   - Annual value, liability cap, indemnity scope
   - Termination notice, auto-renewal terms
   - Key risk flags, status

2. Create an Excel workbook with:
   - Sheet 1: Dashboard (counts, totals, expiring soon)
   - Sheet 2: Master data table (sortable, filterable)
   - Sheet 3: Renewal calendar
   - Sheet 4: Risk analysis

3. Generate a summary memo with top risks and recommended actions.

For the Portfolio_Analytics workbook, add:
- Sheet 5: Vendor Spend Analysis (by vendor: contract count, total spend, renewal dates)
- Sheet 6: Compliance Checklist (insurance requirements, SOW sign-offs, approvals)
- Generate compliance report with audit trail and upcoming deadlines.

I have uploaded:
1. Vendor_MSA_Draft.docx - the vendor's proposed agreement
2. Standard_MSA_Template.docx - our standard terms

Generate a redlined version showing our position:

1. Compare the vendor draft to our template
2. Identify differences for: liability cap, IP indemnity, data protection, payment terms, confidentiality
3. Create a new document with:
   - Track changes showing deletions (struck through) and additions (in red)
   - Comments explaining each significant change and our rationale
4. Add a cover memo (first page) with:
   - Executive summary of changes
   - Key negotiation points
   - Red-line positions vs. nice-to-haves
   - Suggested response strategy

Save as "Vendor_MSA_OurRedlines.docx"

Generate detailed Word comments for this contract review.

Add comments for:
1. Definitions: ambiguous terms, suggested clarifications
2. Liability: cap amounts vs. industry standard, mutual vs. one-sided caps
3. IP Rights: scope of assignment, background IP carveouts
4. Termination: notice periods, change of control, renewal mechanics

Include a summary comment at the top with: overall assessment, top 3 issues to negotiate, estimated timeline.

Save as "Contract_ReviewComments.docx"

Apply firm standard formatting to these contracts:

1. Apply styles:
   - Heading 1 for article titles
   - Heading 2 for subsections
   - Normal for body text
   - Emphasis for defined terms

2. Format consistently:
   - 1-inch margins
   - Times New Roman 12pt body
   - 1.15 line spacing
   - No tabs (use tables for structured content)
   - Page breaks before new articles
   - Headers with firm name/matter name
   - Footers with date and page numbers

3. Generate a style sheet with:
   - Required styles defined
   - Formatting guidelines
   - Examples of proper formatting
   - Common mistakes to avoid

Save formatted contracts with "_Formatted" suffix.

I have a legal document library with inconsistent naming. Here are sample filenames/paths.

For each, suggest:
- Document type
- Key parties
- Date
- Suggested new filename
- Suggested folder structure

Create a CSV with: Current path, Suggested new folder, Suggested new filename, Rationale.
Provide an implementation guide for safe vs. manual-review moves.

I have a contract portfolio with potential duplicates. Analyze the uploaded file list/metadata:

1. Identify exact duplicates (same content hash if available, or same filename+size+date)
2. Flag near-duplicates (same document, minor variations)
3. Identify multiple versions of the same agreement
4. Create Excel with: Filename, Path, Size, Date, Match type, Action recommended, Risk if deleted
5. Create archive checklist: safe to archive, review first, do not archive

Provide recommendations for consolidation and version control.

Translate these contracts to Spanish while preserving legal terminology:

1. For each document:
   - Translate maintaining legal formality
   - Keep defined terms consistent
   - Flag ambiguous phrases for human review

2. Create a bilingual glossary of defined terms (English → Spanish)

3. Provide translation notes for QA and proofreading

I have uploaded Spanish translations. Analyze for consistency:

1. Extract defined terms and terminology from each
2. Create master terminology database (English term, Spanish translation, sources, frequency)
3. Flag inconsistencies: same English term with different Spanish translations
4. Generate revision guide with recommendations for standardizing terminology
5. Create terminology style guide with approved pairings and rationale

Output as Excel glossary and Word revision guide.

I have uploaded documents for a client deliverable package. Create:

1. Document index: name, purpose, action required, execution requirements
2. Client-facing cover memo: overview, required actions, timeline, key dates, return instructions
3. Execution checklist: which documents need signatures, who signs, witness/notary requirements
4. Tracking spreadsheet: document name, date sent, status, date received, signature status

Save the cover memo, checklist, and tracking spreadsheet. Provide the folder structure recommendation.

Create a monthly client status report from the uploaded activity summary:

1. Executive summary (1 page)
2. Detailed activity summary (what we did)
3. Current status (where we stand)
4. Next steps and pending client actions
5. Timeline for next phase
6. Budget status
7. Action items with deadlines and impact if missed

Output as formatted memo. Also create a parallel internal memo with risk flags and strategic notes not shared with client.

Review the uploaded contract and generate a redlined version with track changes showing:
- Deletions struck through
- Additions in red
- Comments explaining each significant change
Save as "Draft_MSA_OurRedlines.docx"

Analyze all uploaded contracts and create an Excel workbook with:

Sheet 1: Summary Dashboard
- Total contract value
- Contracts by type (pie chart)
- Expiration calendar (next 12 months)
- Risk distribution

Sheet 2: Detailed Log
- All extracted contract data
- Conditional formatting for expiration dates
- Risk flags highlighted

Sheet 3: Renewal Calendar
- Contracts requiring action by month
- Responsible party assignment column

Save as "Contract_Portfolio_Analysis.xlsx"

Generate a board presentation outline covering Q1 legal matters:

Slide 1: Title - "Legal Department Q1 Update"
Slide 2: Key Metrics (contracts closed, disputes resolved, spend)
Slide 3: Major Matters Summary (table format)
Slide 4: Litigation Status (timeline visual)
Slide 5: Regulatory Developments (bullet points)
Slide 6: Looking Ahead Q2 (priorities)
Slide 7: Questions

Include speaker notes with key talking points.
Provide structured text for copy-paste into PowerPoint.

I have uploaded a list of active contracts. Generate a monitoring workflow:

1. Identify contracts expiring in next 90 days
2. Flag auto-renewals with notice deadlines approaching
3. List contracts requiring annual compliance actions
4. Create weekly report template with:
   - List of approaching deadlines
   - Required actions
   - Responsible parties
5. Draft reminder email templates for each deadline type

Search for recent regulatory developments in [practice area] and generate a client alert:

1. Research recent [FDA/SEC/FTC/etc.] announcements
2. Summarize key developments
3. Analyze impact on our clients
4. Draft client alert memo
5. Create short version for LinkedIn post

Save as "Client_Alert_[Topic].docx" and "LinkedIn_Post_[Topic].txt"

Process the new vendor agreement I've uploaded:

1. Run NDA triage first (if applicable) to categorize urgency
2. If RED or YELLOW, run full contract review
3. Based on review, generate:
   - Internal memo summarizing issues
   - Redlined contract with suggested changes (or change summary)
   - Email to business team with summary
4. Provide a tracking log entry for our spreadsheet

Save all outputs with clear filenames.

Compare Version A and Version B of the uploaded agreement.
Return:
1) Clause-by-clause delta matrix (added/removed/changed)
2) Risk impact (high/medium/low)
3) Suggested fallback wording for each high-risk delta
4) Negotiation note for business stakeholders

Review the uploaded contract set and draft an evidence-first memo with:
- issue summary
- exact citation to source clause text
- recommended action
- escalation trigger for attorney review

For each [document type] in the uploaded files:
[list of actions]
Save results as Excel/CSV with columns: [X, Y, Z]
Provide [email/memo summary] in the response.

Analyze [uploaded documents] and create:
1. Excel tracker with columns: [X, Y, Z]
2. Word document (or formatted memo) with sections: [A, B, C]
3. Executive summary
Save files with descriptive names. Provide download links.

Extract from [uploaded documents]:
[list of data points]
Create Excel/CSV with columns: [X, Y, Z]
Add conditional formatting for [expiration/risk flags]

Translate [uploaded documents]: [source] to [target]
Preserve legal terminology and formality
Create bilingual glossary
Flag ambiguous phrases for human review
Output: translated files + glossary + QA notes