Keep a contract register and track deadlines

Logistics manager · Time: 30 min · Spreadsheets

Tools that fit this task

• Copilot in Excel $20/mo
• Gemini in Google Sheets $14/mo
• Notion AI $10/mo
• Gemini in Google Drive $14/mo
• Make $9/mo
• Airtable AI $20/mo

Prompt

Role: you are a corporate lawyer who controls contract deadlines.
Context: a contract register in the selected range with columns number | counterparty | type | signing date | valid until | amount | status | owner | auto-renewal | days to expiry. Today is {{date}}.
Task: identify 1) overdue contracts, 2) those expiring within 30 days, 3) open-ended and auto-renewing contracts worth reviewing, 4) possible duplicates or anomalies in amounts and dates. For each give a recommended action and a priority.
Format: a table number | counterparty | valid until | days | category | action | priority (high, medium, low). At the end, a plan for the week for the three highest-priority contracts.

Steps

1. Create a table with columns number, counterparty, type, signing date, valid until, amount, status, owner, auto-renewal
2. Make sure the "valid until" column contains dates rather than text, and add a days-to-expiry column with a TODAY() formula
3. Add conditional formatting: overdue in red, under 30 days in yellow
4. Give the assistant the range with a prompt to list overdue, expiring, open-ended and possibly duplicate contracts with a recommended action
5. Recalculate the term of one contract by hand and compare with the result
6. Enter the confirmed actions in an "action" column and set reminders for the owners

How to check the result

Every contract expiring within 30 days has an owner and an action, the manual check of one term matched, and the register is updated weekly

Pitfalls

• Dates stored as text break the days calculation and the model quietly produces nonsense: check the column format first
• A register with real counterparty names and amounts in a personal account of a third-party service is a leak of trade secrets, so keep it in the corporate workspace

Data that stays out of public AI tools

• Routes, schedules and storage locations of cargo: security-sensitive information, into a service only in general terms
• Carrier prices and contract terms: a trade secret, refer to the carrier as [Carrier 1]
• Driver names, passport data and vehicle plates: personal data, anonymize them

• Contract register with deadline tracking in Gemini for Sheets

Other tasks for logistics managers

• Get a spreadsheet formula from a plain-language request
• Write a business letter
• Write a formal claim letter to a counterparty
• Run a quick counterparty check before a deal
• Write an email to a foreign partner in their language
• Translate a contract and keep the terminology consistent
• Analyze customer reviews by topic
• Write a weekly report to your manager
• Check a source document for required fields

AI tools for logistics managers · Prompt: Keep a contract register and track deadlines