Start hereAutomationsGuidesYour planThe stackAboutWeekly email▶ YouTubeTelegram

“Picture a six thousand dollar support plan that ends on Friday, and nobody remembered the date.”

Contract ends in 30 days → renewal email to the client → alert to you

By · Updated · Get guides by email

Now a renewal is a conversation a month early, not an apology.

Every morning Make checks the contracts sheet. A contract ending within 30 days gets one renewal email to the client, the row is stamped, you get an alert.

MakeGoogle SheetsGmailTelegram4 operations / run

Get the ready-to-import blueprint by email

Yes — email me BuilderStack's weekly issue: one new Make automation or guide a week, from O.S. Maintenance Buildings Ltd (Israel). It may include paid links. Unsubscribe anytime. Optional. We use your address only to send this email; it is stored by Brevo (EU) until you unsubscribe. You can access or delete it at any time — see the privacy policy.

We use your address only to email you this file. Without the box ticked, that is the only email you get, and the address is deleted after 30 days. Privacy policy.

The full build is on this page, free, no email needed.

Video cover: RENEWAL NOTICE

Short answer

Every morning Make checks the contracts sheet. A contract ending within 30 days gets one renewal email to the client, the row is stamped, you get an alert.

Tools
Make, Google Sheets, Gmail, Telegram
Cost to run
4 Make credits (operations) per run

The problem

A retainer, a maintenance plan or a yearly licence ends on a date someone wrote down once. Nobody looks at that column until the client asks why the service stopped, or quietly does not renew. Thirty days of notice turns a lapse into a conversation.

What happens when it runs

  1. Every morning: search the contracts sheet for status "active", an end date in the next 30 days and an empty notice_sent
  2. For each: one short email to the client with the service and the end date, asking whether to renew
  3. Today's date goes into notice_sent, so the same contract never gets a second notice
  4. A Telegram message to you: which client, which service, which date

The tools inside

Disclosure: links marked "paid link" pay us a commission from the vendor if you sign up. Your price is unchanged, and every file here works without them. How we choose tools →

Before you start

Three things to have ready before importing, or Make will ask and you will have to leave halfway:

  • The contracts spreadsheet id
  • Columns A–G: client, email, service, end_date (YYYY-MM-DD), status, notice_sent, notes
  • Your name for the signature
  • Chat ID

Sheet templates

The file maps columns by position. Start from exactly these headers, in this order — a column in the wrong place writes a phone number into the email column.

  • Contracts sheet · client | email | service | end_date | status | notice_sent | notes (Sent with the blueprint by email)

How to import (2 minutes)

  1. In Make: Scenarios → Create a new scenario
  2. At the bottom, the three dots (⋯) → Import Blueprint → choose the file you downloaded
  3. Click every module with an exclamation mark: choose your connection (Google, Telegram) — Make creates one in a click if you have none
  4. Replace every value in double curly braces ({{…}}) with your own from the list above
  5. Run once with a test row in the sheet. Only when it passes — Schedule and ON

New to Make? Start here →

No Make account yet?The file imports only into Make. Signing up through the link gives you one month of Core free, and us a commission. The file works without the link.
Sign up for Make →paid link · we earn a commissionPaid link. If you sign up through it we earn a commission from Make; your price is the same, and the link gives you one month of Core free.

Read more

What does not work in it

  • It sends one notice per contract. When the client renews, write the new end date, set status back to "active" and clear notice_sent, or next year's notice never goes out.
  • A contract that already ends in less than 30 days gets its notice the first morning, so switching it on over an old sheet can send several emails at once. Check the list first.
  • It does not renew anything and does not read the reply. The reply lands in your Gmail; the status in the sheet is yours to change.

Questions

What does not work in "Contract ends in 30 days → renewal email to the client → alert to you"?

It sends one notice per contract. When the client renews, write the new end date, set status back to "active" and clear notice_sent, or next year's notice never goes out. A contract that already ends in less than 30 days gets its notice the first morning, so switching it on over an old sheet can send several emails at once. Check the list first. It does not renew anything and does not read the reply. The reply lands in your Gmail; the status in the sheet is yours to change.

What do I have to fill in after importing the blueprint?

The contracts spreadsheet id; Columns A–G: client, email, service, end_date (YYYY-MM-DD), status, notice_sent, notes; Your name for the signature; Chat ID.

Which tools does it use, and what does a run cost?

Make, Google Sheets, Gmail, Telegram. Each run uses 4 Make credits (operations).

Is the blueprint free?

Yes. The ready-to-import file is sent free to the email address you enter; the newsletter is a separate box you can leave unticked. The full build is on this page without any email. The file contains no connections and none of our ids, and works whether or not you use the paid Make link on the page.

Build your automation plan →Four questions, three automations ranked for your business.

Paid link. If you sign up through it we earn a commission from Make; your price is the same, and the link gives you one month of Core free.

Next step

All automations →
WEEKLY REPORT

Weekly report → Telegram, every Sunday at eight

The numbers the client asks about every week — leads, open tasks, invoices — reach them on their own, in one message, before they ask.

MakeGoogle SheetsTelegram5 ops/run✓ imported in Make
STATUS EMAIL

Every Thursday: project status → an email to the client, without writing it

Clients ask "what's happening" because nobody wrote. One status word in a sheet becomes a tidy weekly email to the client every Thursday, with no writing.

MakeGoogle SheetsGmail3 ops/run✓ imported in Make
MONTHLY REPORT

On the 1st: the month's summary → an email to the client, without opening a sheet

Clients want the same three numbers every month: leads in, deals closed, invoices open. On the 1st at eight they arrive in one email, from the sheet.

MakeGoogle SheetsGmail5 ops/run✓ imported in Make

What will it cost? Make cost calculator →Build your automation plan →