“A four thousand dollar quote. One follow up. Then nothing, for ten days.”

Quote still unanswered on day 10 → one last "should I close this?" email

Now every quote ends with an answer, not a maybe.

A quote still silent 10 days after it went out, follow-up included, gets one last short email offering to close it. The row is closed; you get an alert.

MakeGoogle SheetsGmailTelegram4 operations / run✓ Imported successfully into our Make account

Get the ready-to-import blueprint by email

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: LAST FOLLOW-UP

Short answer

A quote still silent 10 days after it went out, follow-up included, gets one last short email offering to close it. The row is closed; you get an alert.

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

The problem

After one follow-up, most people stop, and the quote sits in limbo: not won, not lost, still counted in the pipeline. A last message that offers to close the file gets the answer either way, and clears the list.

What happens when it runs

  1. Every morning: search the quotes sheet for status "followed up" and a sent date more than 10 days ago
  2. For each: one short last email that asks whether to keep the quote open or close it
  3. The row moves to status "closed - no reply", so it never goes out twice
  4. A Telegram message to you: which client, which amount, closed

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 quotes spreadsheet id (the same sheet as the 3-day follow-up)
  • Columns A–E: client, email, amount, sent_date (YYYY-MM-DD), status
  • 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.

  • Quotes sheet · client | email | amount | sent_date | status (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.

The video

Read more

What does not work in it

  • It only picks up quotes the 3-day follow-up has already marked "followed up". Without that scenario on the same sheet, it finds nothing.
  • Both scenarios count from the sent date. If you switch them on over a sheet full of old quotes, the follow-up and the last email can reach the same client on consecutive days; start with recent quotes, or mark the old ones "closed" by hand first.
  • A reply lands in your Gmail, not in the sheet. Change the status as soon as a client answers, or the last email still goes out.

Questions

What does not work in "Quote still unanswered on day 10 → one last "should I close this?" email"?

It only picks up quotes the 3-day follow-up has already marked "followed up". Without that scenario on the same sheet, it finds nothing. Both scenarios count from the sent date. If you switch them on over a sheet full of old quotes, the follow-up and the last email can reach the same client on consecutive days; start with recent quotes, or mark the old ones "closed" by hand first. A reply lands in your Gmail, not in the sheet. Change the status as soon as a client answers, or the last email still goes out.

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

The quotes spreadsheet id (the same sheet as the 3-day follow-up); Columns A–E: client, email, amount, sent_date (YYYY-MM-DD), status; 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.

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