Form arrives incomplete → an email asking for exactly what is missing

The problem

Forms arrive incomplete all the time — an optional field, a half-typed entry, a form sent by mistake. Someone has to notice, write an email, and remember to check for a reply. Usually nobody does.

What happens when it runs

1. A webhook receives the form
2. Check which required fields are empty (phone, address, amount — as needed)
3. A row in the log with status "missing: phone, address"
4. An email to the client: "to continue we need: …" — a list, not a guess

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 →

• Make — the automation engine · Sign up (one month of Core free) → paid link · we earn a commission
• Google Sheets — log and lists
• Gmail — email
• Tally — the form that fires the webhook (free; any form tool works) · Create a free form → paid link · we earn a commission

Before you start

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

• The webhook address
• The list of required fields
• Spreadsheet id
• The email wording

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.

• Leads log · timestamp | name | email | phone | missing (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 →

The video

Watch on YouTube → · Subscribe to BuilderStack · Telegram channel

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.