Make.com to Google Sheets: Automated Lead Nurturing Flow

Manually copying and pasting customer lead details from form submissions into your spreadsheets is a major bottleneck for modern builders. If you wait longer than 15 minutes to follow up on a fresh contact lead, your chances of converting them drop by over 80%.

In this guide, we'll build a 100% automated lead capture system using Make.com (formerly Integromat) and Google Sheets to capture leads, store records, and trigger immediate, personalized email responses.

What We're Building

We will design a three-stage automation scenario inside Make.com:

<rect width="800" height="240" rx="16" fill="var(--bg-secondary)" stroke="var(--border-glass)" stroke-width="1" />

<!-- Step 1: Webhook -->
<rect x="40" y="70" width="180" height="100" rx="12" fill="var(--bg-primary)" stroke="url(#grad-webhook)" stroke-width="2" />
<text x="130" y="110" font-size="15" fill="var(--text-primary)" font-weight="700" text-anchor="middle">1. Webhook</text>
<text x="130" y="132" font-size="11" fill="var(--accent-cyan)" font-weight="600" text-anchor="middle">JSON Listener</text>
<text x="130" y="150" font-size="11" fill="var(--text-dimmed)" text-anchor="middle">Instant Capture</text>

<!-- Arrow 1 -->
<path d="M 220 120 L 300 120" stroke="var(--border-focus)" stroke-width="2" stroke-dasharray="4" />

<!-- Step 2: Google Sheets -->
<rect x="300" y="70" width="200" height="100" rx="12" fill="var(--bg-primary)" stroke="url(#grad-sheets)" stroke-width="2" />
<text x="400" y="110" font-size="15" fill="var(--text-primary)" font-weight="700" text-anchor="middle">2. Google Sheets</text>
<text x="400" y="132" font-size="11" fill="#0f9d58" font-weight="600" text-anchor="middle">add_row_operation</text>
<text x="400" y="150" font-size="11" fill="var(--text-dimmed)" text-anchor="middle">Structured Storage</text>

<!-- Arrow 2 -->
<path d="M 500 120 L 580 120" stroke="var(--border-focus)" stroke-width="2" stroke-dasharray="4" />

<!-- Step 3: Gmail Follow-up -->
<rect x="580" y="70" width="180" height="100" rx="12" fill="var(--bg-primary)" stroke="url(#grad-email)" stroke-width="2" />
<text x="670" y="110" font-size="15" fill="var(--text-primary)" font-weight="700" text-anchor="middle">3. Autoresponder</text>
<text x="670" y="132" font-size="11" fill="var(--accent-purple)" font-weight="600" text-anchor="middle">send_email_action</text>
<text x="670" y="150" font-size="11" fill="var(--text-dimmed)" text-anchor="middle">Dynamic Follow-up</text>

[Webhook Trigger] ──> [Google Sheets: Add Row] ──> [Gmail: Send Dynamic Email]

This scenario runs completely within Make.com's free tier, which offers 1,000 free operations per month—ample bandwidth for starting blogs, newsletter funnels, or micro-SaaS landing pages.

Step 1: Set Up the Custom Webhook Trigger

First, log in to your Make.com dashboard and initialize a new scenario:

1. Click the Create a new scenario button in the top right corner.
2. Click the central plus icon and search for the Webhooks module.
3. Select Custom Webhook as the trigger action.
4. Click Add to generate a new hook, name it "Incoming Lead Form", and save.
5. Make will generate a unique URL endpoint (e.g., https://hook.us1.make.com/...). Copy this URL.

[!WARNING] Keep your Webhook URL private. Anyone with access to this endpoint can insert arbitrary data rows into your connected spreadsheets.

To establish the data schema, open your terminal and send a sample payload using curl:

curl -X POST -H "Content-Type: application/json" -d '{"name":"John Doe", "email":"john@example.com", "company":"Acme Corp"}' https://hook.us1.make.com/your-custom-webhook-id

If the Make interface displays Successfully determined, the schema structure has been parsed correctly.

Step 2: Configure the Google Sheets Database

Create a blank Google Sheet, name it "Lead Records", and populate the header row with the following column fields:

• A1: Timestamp
• B1: Name
• C1: Email
• D1: Company
• E1: Status

Return to your Make scenario canvas, add a new step after the Webhooks module, and search for Google Sheets:

1. Select the Add a Row action.
2. Connect and authorize your Google account.
3. Choose your spreadsheet file and select the target worksheet tab.
4. Map the webhook parameters to the sheet columns:
   • For Timestamp, map Make's built-in variable {{now}}.
   • Map name from the webhook to the Name column.
   • Map email from the webhook to the Email column.
   • Map company from the webhook to the Company column.
   • Set the Status column to a static string: "New Lead".

Step 3: Connect the Automated Email Responder

Once the lead is recorded, we'll trigger an automated welcome email to keep the lead warm:

1. Add another module on the canvas and choose Gmail.
2. Select the Send an Email action.
3. In the To input field, map the email variable from your Google Sheet or Webhook step.
4. Set the subject line to: Welcome to Merivo, {{name}}!
5. Compose your body content, inserting dynamic parameters:

Hi {{name}},

Thanks for reaching out! We are excited to learn more about your work at {{company}}.

We have received your request and our team will get back to you within 24 hours. In the meantime, feel free to explore our local AI integration guides on our homepage: https://www.merivo.org

Best regards,
Mehmet

Troubleshooting & Best Practices

• Date and Time Formatting: If timestamps inside Google Sheets look unreadable, format the target column inside Google Sheets as "Plain Text" or select a standard "Date Time" formatting style.
• Gmail Authorization Expiring: Google's API security policies may require you to re-authenticate your Google workspace connection in Make every 90 days. Check your scenario logs regularly to ensure operations run without interruption.
• API Outages and Rate Limits: To handle unexpected API outages or rate limit barriers without stopping your integration flows, read our guide on advanced error handling in Make.com.

Frequently Asked Questions