Cuiar
Sign inDownload

List renewal dates from your vendor contracts

End date, notice period and auto-renewal of each contract in a sheet, the next deadline first.

  • You start it: When you start it
Use in CuiarRun from your AI agent

What it does

The task

Read the contracts in the Google Drive folder folder and the completed envelopes in DocuSign. For each contract, find the vendor, the end date, the notice period, the auto-renewal term and the price. Calculate the last date to give notice. Put the results in the Google Sheet sheet url, sorted by that date, and mark the rows with a notice date in the next 60 days. Write 'not found' when a contract does not give a value.

  • It works in Google Drive, DocuSign and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • It runs once, when you start it.

What you give it

BlankWhat to giveExample
folderThe Google Drive folder with your contractsLegal/Vendor contracts
sheet urlThe Google Sheet for the listhttps://docs.google.com/spreadsheets/d/1ContractRenewals

What you get back

An example run with the example values above. Your run uses your own data.

18 contracts read, 3 notice dates in the next 60 days

VendorEnd dateNoticeAuto-renewPriceGive notice by
Officeline Leasing28 Feb 202790 days12 months980 EUR a month30 Nov 2026
Printwell31 Dec 202630 daysNo1,150 EUR a quarter1 Dec 2026
Northport Freight31 Jan 202760 days12 months4,200 EUR a month2 Dec 2026
Talkbox Phones30 Jun 2027not found24 months310 EUR a monthnot found

Saved to "Contract renewals", sorted by the notice date.

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 2 blanks

    Type folder and sheet url. Tab moves to the next blank.

  3. 03

    Run it

    Run sends it to the agent. Follow each step in the panel, and stop it at any time.

From the terminal

cuiar exec "Read the contracts in the Google Drive folder Legal/Vendor contracts and the completed envelopes in DocuSign. For each contract, find the vendor, the end date, the notice period, the auto-renewal term and the price. Calculate the last date to give notice. Put the results in the Google Sheet https://docs.google.com/spreadsheets/d/1ContractRenewals, sorted by that date, and mark the rows with a notice date in the next 60 days. Write 'not found' when a contract does not give a value."

Run it from your AI agent

Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.

1. Add Cuiar to Claude Code

claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp

2. Ask your agent

Use the Cuiar tool run_task to run my "List renewal dates from your vendor contracts" template with folder = Legal/Vendor contracts; sheet url = https://docs.google.com/spreadsheets/d/1ContractRenewals.

Setup for other agents: AI agents.

The tool call

{
  "name": "run_task",
  "arguments": {
    "task": "Read the contracts in the Google Drive folder Legal/Vendor contracts and the completed envelopes in DocuSign. For each contract, find the vendor, the end date, the notice period, the auto-renewal term and the price. Calculate the last date to give notice. Put the results in the Google Sheet https://docs.google.com/spreadsheets/d/1ContractRenewals, sorted by that date, and mark the rows with a notice date in the next 60 days. Write 'not found' when a contract does not give a value."
  }
}

Related templates

All ops templates

  • OpsAsks first

    Find files shared publicly from your Google Drive

    Every file that anyone with the link can open, with its owner and last edit. Access changes after you approve.

    You start it: When you start it
    • Google Drive
    • Google Sheets

  • Sales

    Answer an RFP or a security questionnaire

    A draft answer for each question from your own documents, with the source and the gaps marked.

    You start it: When you start it
    • Google Sheets
    • Confluence
    • Google Drive

  • Data

    Pull tables from PDFs into a spreadsheet

    Each matching table from your PDFs and scans in one sheet, with numbers as numbers and the page noted.

    You start it: When you start it
    • Google Drive
    • Google Sheets

  • Data

    Combine many CSV files into one sheet

    All files from a folder in one table, with the columns lined up and the source file on each row.

    You start it: When you start it
    • Google Drive
    • Google Sheets
    • Dropbox

  • Finance

    Find card payments that have no receipt

    Each card payment matched to a receipt from your inbox or folder, with the missing ones listed first.

    You start it: When you start it
    • Any bank site
    • Gmail
    • Google Drive
    • +1 more: Google Sheets

  • Finance

    Check supplier invoices against purchase orders

    Each invoice matched to its PO and delivery note, with price, quantity and duplicate problems marked.

    You start it: When you start it
    • Google Drive
    • Google Sheets
    • Xero