Automation Emailer for Free: How I Built a Self-Running Follow-Up System Without Coding

There was a time when every new inquiry felt like another item added to my never-ending to-do list. A new lead would come in, and I’d find myself opening emails, copying details, updating a sheet, drafting a reply… and if I got busy, a few leads slipped through the cracks. Losing potential clients because I couldn’t reply fast enough felt frustrating—and unnecessary.

That’s when I decided to build my own automation emailer. I didn’t want to pay for Zapier, didn’t want complicated integrations, and definitely didn’t want to learn a full programming language. What I eventually created surprised me: a complete, free automation system built using only Google Forms, Google Sheets, Gmail, and a small script.

In this guide, I want to walk you through exactly how I built it—step-by-step—just like I wish someone had shown me earlier.

Table of Contents

• Why Manual Lead Handling Fails
• What an Automation Emailer Really Is
• The Simple Workflow Behind Automatic Emails
• Step-by-Step Setup Guide
• Code You’ll Use (Copy & Paste)
• Setting Up the Trigger
• Common Errors and Simple Fixes
• Practical Use Cases
• Why This Is the Best Free Automation Emailer
• Key Takeaways
• Final Thoughts

Why Manual Lead Handling Fails

If your business depends on leads—even a small number—you probably know the painful cycle well:

• Checking emails or form submissions again and again
• Copying names and contact details into a spreadsheet
• Sending a polite follow-up message manually
• Trying to remember whom you already replied to

This system isn’t just slow—it’s risky. A single missed lead could mean a lost customer. And when your response time decides whether a lead chooses you or someone else, every minute matters.

That’s what pushed me to automate my process. I wanted a system that worked even while I slept. A system that sent personalized follow-up emails instantly, every time.

What Is an Automation Emailer?

An automation emailer is simply a setup where emails are triggered automatically when something happens. In my case, the “trigger” is a form submission. When someone fills out a Google Form, their details flow into a Google Sheet, and the system immediately sends them a customized follow-up email.

No clicking. No typing. No delays.

The beautiful part? You don’t need any expensive tools. Google already gives you everything you need for free.

The Simple Workflow That Makes It All Work

This is the exact flow I use:

1. User fills out a Google Form
2. Details automatically appear in a Google Sheet
3. Google Apps Script detects a new submission
4. Gmail sends a personalized follow-up email instantly

It’s simple, fast, and surprisingly powerful.

Step-by-Step Setup Guide

Here’s how I built the entire automation system from scratch.

Step 1: Create a Google Form

Start by creating a Google Form that collects the details you need. I keep it simple with just three fields:

• Name
• Email
• A custom message or inquiry line

This last field helps make your automated email feel more personal instead of robotic.

Step 2: Connect the Form to Google Sheets

Inside your form:

• Click Responses
• Click the green Sheets icon

Google creates and links a spreadsheet automatically. You’ll see all form fields appear as columns—this is where your automation script will pull information from.

Step 3: Open Google Apps Script

In the linked Google Sheet:

1. Click Extensions
2. Select Apps Script
3. Delete any code inside and prepare to paste your script

Step 4: Add the Automation Script

Here is the exact script I use, and it works perfectly for sending follow-up emails automatically:

 function sendAutoFollowUp(e) { var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet(); var lastRow = sheet.getLastRow(); var name = sheet.getRange(lastRow, 2).getValue(); var email = sheet.getRange(lastRow, 3).getValue(); var customLine = sheet.getRange(lastRow, 4).getValue(); var subject = "Thanks for connecting with us, " + name + "!"; var body = ` Hi ${name}, Thank you for reaching out. Your message: "${customLine}" We will get back to you shortly. Regards, Techthaastu Team https://techthaastu.com `; MailApp.sendEmail(email, subject, body); } 

This script pulls the latest form entry, formats a simple email, and sends it through Gmail without delay.

Step 5: Set Your Automation Trigger

Now we make the script run automatically whenever a new form submission arrives:

1. Go to Apps Script
2. Click Triggers (clock icon)
3. Click Add Trigger
4. Choose the function: sendAutoFollowUp
5. Select event type: On form submit
6. Save and authorize it

You're done. Your automation emailer is officially live.

Common Errors and Simple Fixes

Email Not Sending

Make sure your trigger is set to On Form Submit.

Authorization Issues

Run the script once manually and allow permissions.

Wrong Name or Email in the Follow-Up Message

The script reads specific columns. If your Google Sheet columns move, update the script’s column numbers accordingly.

Where You Can Use This Automation Emailer

This small system works beautifully in many scenarios:

• Lead follow-ups
• Service inquiry confirmations
• Demo or consultation bookings
• Customer support responses
• Newsletter or workshop sign-ups

It’s almost like having a silent assistant who never forgets, never delays, and works 24/7.

Why This Is the Best Free Automation Emailer

• Costs absolutely nothing
• No coding expertise required
• Completely customizable
• Runs automatically without monitoring
• Handles unlimited form submissions
• Uses tools you already have: Gmail, Forms, and Sheets

Once you set it up, it feels like magic.

Key Takeaways

• You can build a professional automation emailer without spending money.
• Google Forms + Sheets + Apps Script = a complete automation stack.
• Instant replies improve trust and conversion rates.
• This setup works for any kind of business.
• The system runs quietly in the background 24/7.

Final Thoughts

Building this automation emailer transformed the way I handle inquiries. Instead of worrying about delayed replies or missed leads, I now have a simple system that responds instantly, logs everything neatly, and feels wonderfully reliable. If you’ve been thinking about automating your business but didn’t know where to start, this free method is the perfect first step.

Once you set it up, you’ll wonder how you ever worked without it.