> Source: https://mywaypoint.ai/docs/examples/contract-renewal-alerts
> Documentation index: https://mywaypoint.ai/llms.txt


# Contract renewal alerts

**A daily automation that finds the contracts coming due & emails the account owner ahead of time, built from one request & a spreadsheet.**


## For

- [For Revenue](https://mywaypoint.ai/for-revenue)
- [Stalled case notification](https://mywaypoint.ai/use-cases/stalled-case-notification)
- [B2B Software](https://mywaypoint.ai/industries/b2b-software)

## In

- [Salesforce](https://mywaypoint.ai/docs/integrations#salesforce)
- [Email](https://mywaypoint.ai/docs/integrations#email)
- [Microsoft 365](https://mywaypoint.ai/docs/integrations#microsoft-365)

## Use case

```prompt-request
We need to know when service contracts are about to expire. We keep missing renewal dates and finding out from the client, which is embarrassing.
```

## What Chip builds

- **A contracts table.** One row per contract, imported from the spreadsheet, that remembers which warnings have gone out so nobody is nagged twice.
- **A daily automation.** Every morning it finds the contracts coming due, skips any already warned & emails the account owner.
- **A contracts list** sorted by end date, soonest first, with filters on status & owner.
- **Documents that explain it**, including why those warning points & how to change them.

Chip rehearses it against your real contracts with sending switched off, then activates it.

![The pipeline editor toolbar, with a draft badge, Test Run, Save Draft & Activate](https://mywaypoint.ai/static/assets/chip-build/pipeline-editor-toolbar-activate.png "Figure: where a scheduled automation is switched on.")

**How it runs now.** Every morning the account owner hears about each contract a month out & again a week out. Nobody finds out from the client. Change the timing, the recipient or the channel with one more sentence.