How to Automate Lead Capture with Make (Step by Step)

If you want to automate lead capture, the first win is simple: reply in minutes, not days, and never lose a contact in a busy inbox.

Mike runs a landscaping company in Denver. His website form sends leads to an inbox he checks at night. By the time he replies, many of those people have already booked someone else. He does not need a CRM or a developer. He needs every new lead to get an instant reply, land in one organized list, and ping him right away.

This tutorial builds exactly that, using free tools: Google Forms, Google Sheets, Gmail and Make. It takes about 30 minutes, and you do not need to write any code.

Disclosure: some links on this page are affiliate links. If you sign up through them, we may earn a commission at no extra cost to you. It never changes our assessment.

What you will build

The automation has four parts. Only the last three run in Make.

Lead capture is the first process on our list of 7 business processes every SMB should automate first, because it is simple and it brings money in faster.

Before you start

• A Google account for Forms, Sheets and Gmail.
• A free Make account. The Free plan includes 1,000 credits a month, which is enough for this tutorial. If you create your account through our Make link, you also get the Core plan free for 1 month, with 10,000 credits.
• About 30 minutes.

Step-by-step tutorial

Step 1: Create the form and link it to a spreadsheet

In Google Forms, create a new form with four questions: Name, Email, Company and How can we help?. Make Name and Email required, and set the Email question to validate email addresses.

Then open the Responses tab and click Link to Sheets. Google creates a spreadsheet where every new answer becomes a row. Open that spreadsheet and add one extra column header at the end: Status.

Before moving on, submit one test answer yourself. Make needs at least one row to read the column names.

Step 2: Watch the spreadsheet for new leads

In Make, click Create scenario, search for Google Sheets and choose Watch New Rows. Connect your Google account and fill in the fields:

• Spreadsheet: the one created by your form.
• Sheet name: usually "Form Responses 1".
• Table contains headers: Yes.
• Limit: 10 is fine for a small business.

When Make asks where to start, choose From now on, so old test rows are not processed again.

Step 3: Send the welcome email to the lead

Click the + after the first module, choose Gmail and then Send an email. In the To field, map the Email column from the spreadsheet. Use the lead's name in the subject and the body. Here is a template you can adapt:

Subject: Thanks, {{Name}}! We got your request

Hi {{Name}},

Thanks for reaching out. We received your message and
will get back to you within one business day.

If it's urgent, just reply to this email.

Best,
Mike
Denver Green Landscaping

In Make, replace {{Name}} by clicking the field and choosing the Name column from the list. Keep the email short and personal. Plain, friendly messages are less likely to land in spam than heavy designs.

Step 4: Send yourself an alert

Add another Gmail > Send an email module. This time, send it to your own address, with a subject such as New lead: {{Name}} ({{Company}}). In the body, map all four answers. Now you get every lead in your inbox with the details in one place, and you can reply directly.

Step 5: Mark the lead as "Welcomed"

Add a last module: Google Sheets > Update a Row. Choose the same spreadsheet and sheet. In Row number, map the row number from the first module. In the Status column, type Welcomed. Your spreadsheet now shows which leads already got a reply.

Step 6: Test the whole flow

Click Run once at the bottom of the scenario, then submit a new answer in your form with your own email. Go back to Make and wait for the run. Each module should show a small bubble with the number 1. Check your inbox for both emails and look at the spreadsheet: the new row should say "Welcomed".

Step 7: Set the schedule and turn it on

Click the clock icon on the first module to set how often Make checks for new rows. On the Free plan, every 60 minutes is the safest choice, for the reason explained in the next section. Then switch the scenario ON.

How many credits this uses (the part most tutorials skip)

In Make, a trigger that watches for new data uses one credit every time it checks, even when there is nothing new. Make's own help center gives the numbers: running every 5 minutes uses 288 credits a day, every hour uses 720 credits a month, and once a day uses 30 credits a month, before counting the other modules.

Each new lead also uses 3 more credits in this scenario: two emails and one spreadsheet update. For a business with 50 leads a month:

If you keep the default 15-minute schedule, the Free plan runs out in about ten days, and the scenario stops until the next month. That is why step 7 uses 60 minutes. With more leads, or if you need faster replies, the Core plan starts at $9 per month with annual billing and includes 10,000 credits. To compare Make with other tools on cost, see Zapier vs Make vs n8n.

Common problems and quick fixes

Who this setup is for

Use it if...

You receive up to a few hundred leads a month through a website or a shared form, and replies currently depend on someone checking an inbox.

Upgrade later if...

Leads come from many sources (ads, marketplaces, chat) or your sales team needs pipelines and reminders. At that point, a real CRM makes sense, and Make can still feed it.

Skip it if...

You get only a few leads a month and always answer the same day. The time you would save is too small to matter.

In our assessment, this is the best first automation for most service businesses. It is free to start, it takes half an hour, and it directly protects revenue. Before you build it, you can estimate what slow replies cost you with our cost of not automating calculator.

FAQ

Can I automate lead capture for free?

Yes. Google Forms, Google Sheets and Gmail are free, and the Make Free plan includes 1,000 credits a month. With an hourly schedule, this scenario handles around 50 leads a month within the free limit.

Why does my Make scenario use credits when no leads arrive?

Triggers that watch for new data use one credit every time they check, even when they find nothing. A scenario checking every 15 minutes uses about 2,880 credits a month just to check. A longer interval reduces that cost.

Can I use my website form instead of Google Forms?

Yes. If your form can send data to Google Sheets or to a webhook, Make can watch it the same way. Webhooks are even better, because they only run when a lead actually arrives.

How fast will leads get the welcome email?

It depends on the schedule. With an hourly check, a lead gets the email within 60 minutes. Paid Make plans let the scenario check more often.

Is Gmail enough to send automated emails?

For small volumes, yes. Personal Gmail accounts can send about 500 emails a day. For higher volume or a professional sender address, use Google Workspace or a dedicated email service.