Free speed to lead setup with Make.com and Google Sheets

Every industry guide on this blog makes the same point: the business that replies first usually wins the lead. If you are not ready for a full system yet, this free setup is the fastest way to stop leads from waiting. Pick the guide for your industry on the blog to see the numbers, the qualifying questions and the follow-up that come after this first reply.

The setup, step by step

Make.com is a free website that connects your apps so they pass information to each other without any coding. In this setup, Make.com sends a friendly email from your own Gmail within about a minute of a new lead landing in your Google Sheet, and it keeps doing that after you set it up once.

Make.com's free plan includes up to 1,000 credits a month (Make.com pricing, 2026), and each lead uses about 2 credits, so the free plan covers a few hundred leads a month. To set it up you need a Google account for Gmail and Google Sheets, a free Make.com account and about 20 minutes.

Why this setup Make.com also offers a "Watch rows" option for Google Sheets, but it checks your sheet on a timer and spends credits even when no lead has arrived, which can use up the free plan. The setup in this guide spends credits only when a real lead comes in.

Part 1: Make the Google Sheet (5 minutes)

1. Go to sheets.google.com and sign in with your Google account.
2. Click Blank spreadsheet, which shows as a large plus sign.
3. At the bottom left, right-click the tab called Sheet1, choose Rename and type Leads.
4. In row 1, type these headings, one per cell from A to F: Name, Email, Phone, Service, Created, Sent. Leave the cells under the Sent heading empty, because the script fills them in for you.
5. From now on, add every new lead on a new row. A Google Form linked to this sheet can add the rows for you, and so can most website form tools.

Part 2: Create your Make.com account and webhook (5 minutes)

1. Go to make.com/en/register and sign up for free, using your Google account to save time.
2. In Make.com, click Scenarios on the left, then Create a new scenario.
3. Click the large purple plus sign in the middle of the screen.
4. In the search box, type Webhooks, click it, then choose Custom webhook.
5. Click Add, give it a name like New lead and click Save.
6. Make.com shows a web address that starts with https://hook. Click Copy address to clipboard and keep this page open for the next part.

Part 3: Connect the sheet to Make.com (5 minutes)

1. Go back to your Google Sheet. In the top menu, click Extensions and then Apps Script, which opens in a new tab.
2. Delete any code you see in the code area so it is empty.
3. Click Copy on the "Google Apps Script" box below and paste it into that code area.
4. In the third line, replace PASTE_YOUR_MAKE_WEBHOOK_URL_HERE with the address you copied from Make.com. Keep the quote marks on both sides of the address.
5. Click the Save icon, which looks like a floppy disk.
6. At the top, next to Run, pick setup from the drop-down, then click Run.
7. When Google asks for permission, click Review permissions, choose your account, click Advanced, then click Go to project (unsafe) and Allow. Google shows this warning for any script you add yourself, and the script runs only inside your own account.

Part 4: Send a test lead (2 minutes)

1. In your sheet, add a test row with your own name and email, and a service like "test".
2. Wait about a minute, and column F should change to Sent followed by the date.
3. Back in Make.com, the webhook shows Successfully determined, which means Make.com now knows the name, email, phone and service fields from your sheet.

Part 5: Add the email and turn it on (5 minutes)

1. In Make.com, move your mouse to the right side of the webhook circle and click the small plus (Add another module).
2. Search for Gmail and choose Send an email.
3. Click Create a connection and sign in with the Gmail account you want to send from.
4. Click the To box, and when the list of fields from your webhook appears, click email.
5. Copy the subject line from the "Email template" box below into Subject, and the rest into Content. Where the template says {{1.name}} or {{1.service}}, delete it and click name or service from the list instead.
6. Replace the parts in square brackets, like [Your business] and [your booking link], with your own details. Then click OK.
7. At the bottom left, click the clock icon and choose Immediately as data arrives. Then switch the scenario ON and click Save to start it.
8. Add one more test row in your sheet with your email. The email should reach your inbox within about a minute, which means the setup works.

Subject: Thanks {{1.name}}, quick question about your roof

Hi {{1.name}},

Thanks for reaching out to [Your business] about {{1.service}}. I'm [Your name].

So we can help you fast: what is the best time for a short call today?
Or book your roof inspection here: [your booking link]

Talk soon,
[Your name]
[Your business] · [Your phone]
[Your business address]

Not interested? Reply "stop" and we won't email again.

// JitterSystem free speed to lead: sends every new lead row to your Make webhook
// Sheet tab "Leads", columns: A Name | B Email | C Phone | D Service | E Created | F Sent
const WEBHOOK_URL = 'PASTE_YOUR_MAKE_WEBHOOK_URL_HERE';
const SHEET_NAME = 'Leads';
const SENT_COL = 6; // column F

function checkNewLeads() {
  const lock = LockService.getScriptLock();
  if (!lock.tryLock(5000)) return;
  try {
    const sheet = SpreadsheetApp.getActive().getSheetByName(SHEET_NAME);
    const rows = sheet.getDataRange().getValues();
    for (let i = 1; i < rows.length; i++) {
      const r = rows[i];
      if (!r[1] || r[SENT_COL - 1]) continue; // no email yet, or already sent
      const lead = { name: String(r[0] || 'there'), email: String(r[1]), phone: String(r[2] || ''),
                     service: String(r[3] || 'your request'), created: String(r[4] || new Date()) };
      const res = UrlFetchApp.fetch(WEBHOOK_URL, { method: 'post', contentType: 'application/json',
                                                   payload: JSON.stringify(lead), muteHttpExceptions: true });
      if (res.getResponseCode() < 300) sheet.getRange(i + 1, SENT_COL).setValue('Sent ' + new Date().toLocaleString());
    }
  } finally { lock.releaseLock(); }
}

// Run this once. It checks the sheet every minute.
function setup() {
  ScriptApp.getProjectTriggers().forEach(t => ScriptApp.deleteTrigger(t));
  ScriptApp.newTrigger('checkNewLeads').timeBased().everyMinutes(1).create();
}

• To get an alert yourself, add a second Gmail > Send an email step that sends to your own address, so you can call the lead while they are still on your website.
• Follow the rules on every message. The CAN-SPAM Act requires your business address and an easy way to opt out in every email, and the TCPA requires consent before you send texts or make automated calls.
• Treat the email as the first step. The email buys you a few minutes, but the call, the qualifying questions and the follow-up are what close the sale. JitterSystem runs that part for you with text and voice AI that sounds like your business.

About this setup guide

Written by Prajith, founder of JitterSystem

Prajith runs JitterSystem, a full-funnel client acquisition agency for US service businesses. He plans and runs Meta and Google ad campaigns built on competitor research, and builds the AI text and voice follow-up that qualifies each lead and books the appointment. His work combines performance marketing, consumer psychology, sales strategy and automation, and he writes these guides from the systems he builds for clients.

About PrajithLinkedInYouTube

Last reviewed: October 24, 2026. We update this guide when cost benchmarks, platform rules or laws change.

Disclosure: JitterSystem sells a done-for-you version of the system in this guide, but every step here works without us, and no company paid to appear in it.

Corrections: if you spot something out of date, email office@jittersystem.com and we will check it.

This guide shares general information and does not replace legal, medical, tax or financial advice for your situation.