Skip to content

Vendor Contract Tracker

Example prompt: "Check our contracts spreadsheet daily. If any vendor contract is expiring within 30 days, send a Slack alert to #operations and email the contract owner."

How to automate vendor contract tracking with GloriaMundo

The Problem

Most businesses manage vendor contracts in a spreadsheet or shared document, and the renewal dates live quietly in a column that nobody checks until it is too late. A contract auto-renews for another year at an inflated rate, or an important service lapses because nobody noticed the expiry. The cost of a missed renewal is rarely dramatic enough to justify hiring someone to monitor a spreadsheet daily — but it adds up quickly across 20-50 active vendor agreements. It is the kind of task that falls between the cracks because it is not urgent on any given day, until suddenly it is.

How GloriaMundo Solves It

We build a workflow that runs on a daily schedule. An integration step reads your contracts Google Sheet, pulling vendor names, contract values, renewal dates, auto-renewal terms, and the assigned contract owner for each entry. A conditional step checks whether any contract has a renewal or expiry date within the next 30 days. For any that do, an integration step posts an alert to your #operations Slack channel with the vendor name, contract details, days remaining, and whether it will auto-renew or lapse. A second integration step emails the contract owner directly via Gmail with the same details and a prompt to review the terms. Glass Box preview shows you every alert and email that will be sent, so you can verify the data and adjust the look-ahead window.

Example Workflow Steps

  1. Trigger (scheduled): Runs daily at 9am.
  2. Step 1 (integration): Read the contracts Google Sheet — vendor name, contract value, renewal/expiry date, auto-renewal terms, and contract owner.
  3. Step 2 (conditional): Check whether any contract has a renewal or expiry date within the next 30 days. If none, the workflow ends.
  4. Step 3 (integration): Post an alert to #operations on Slack listing each upcoming contract with vendor name, value, expiry date, days remaining, and auto-renewal status.
  5. Step 4 (integration): Email the assigned contract owner via Gmail with the contract details and a prompt to review and decide before the deadline.

Integrations Used

  • Google Sheets — source of contract data, renewal dates, and owner assignments
  • Slack — delivers team-wide alerts to the operations channel
  • Gmail — notifies individual contract owners with specific action required

Who This Is For

Operations managers, procurement leads, and finance teams who manage vendor relationships across a spreadsheet and need a reliable daily check to prevent costly auto-renewals or unexpected service lapses.

Time & Cost Saved

The direct time saving is modest — perhaps 15-20 minutes per day that would otherwise be spent scanning a spreadsheet. The real value is in preventing missed renewals. A single unwanted auto-renewal on a mid-tier SaaS contract can cost thousands of pounds. This workflow ensures you always have at least 30 days' notice to negotiate, cancel, or renew on your own terms. The workflow uses integration and conditional steps only, costing minimal credits per daily run.