Reading time: 14 min | Skill level: Beginner | Tools: Make.com (free) + Google Forms + Gmail + Google Sheets
If you’re a small business owner who’s tired of doing the same manual tasks on repeat — copying data, sending the same emails, chasing leads you forgot to follow up — this guide is for you.
Not for developers. Not for enterprise IT teams. For you.
We’re going to build a real, working automation using Make.com’s free tier. By the end, when a customer fills out your contact form, your business will automatically log their info, send them a professional confirmation email, and ping you with an instant alert — all without you lifting a finger.
No code. No shortcuts. Just a step-by-step walkthrough you can follow today.
What Is Workflow Automation? (And Why Most Explainers Get It Wrong)
Every article on workflow automation starts with the same definition: “A workflow is a series of steps that accomplish a process.”
Helpful. Thanks.
Here’s a cleaner way to think about it: automation is a standing order you give your software. Instead of you doing something every time X happens, you set up a rule once — and the software handles it forever.
- Customer fills out your inquiry form → they get a response in seconds, not hours
- You finish a job → the customer gets a review request automatically
- Invoice arrives in Gmail → it’s saved to Google Drive and logged in a spreadsheet before you’ve even opened the email
That’s it. Cause and effect, running on autopilot.
The reason most small businesses haven’t done this yet isn’t complexity — it’s that nobody’s walked them through a real example. That’s what this article is for. If you want a broader overview first, check out our breakdown of 10 tasks you can automate with AI today — it’s a good companion piece to what we’re building here.
Why Make.com (Not Zapier) for Your First Automation
Zapier is the name most people know. It’s well-marketed and genuinely easy to start. But for small business owners who want real control without paying premium prices, Make.com wins on almost every measure:
| Make.com | Zapier | |
|---|---|---|
| Free tier credits/month | 1,000 | 100 tasks |
| Multi-step workflows | ✅ Unlimited | ❌ Paid only |
| Visual flow builder | ✅ Yes | ❌ Linear list |
| Data transformation | ✅ Built-in | ❌ Limited |
| Price at entry paid tier | $9–$10.59/month | $19.99/month |
We’ve done a full deep-dive on this exact question over at Make.com vs Zapier: Which Automation Platform is Better in 2026? — worth a read once you’ve got this first automation running. The short version: Make’s visual canvas makes it far easier to build, debug, and grow your automations over time.
Quick note on Make’s pricing model: Make recently shifted from “operations” to “credits” as its billing unit — but for simple workflows like the one we’re building, it’s still 1 credit per module action. The free plan gives you 1,000 credits per month, which is plenty for most small businesses just starting out.
What We’re Building
Here’s the scenario: You’re a service business. A potential customer fills out your Google Form. Here’s what happens automatically:
- Their info is logged in a Google Sheet (your new auto-updating CRM)
- They receive a personalized confirmation email from your Gmail within seconds
- You receive an internal alert with their full details so you can follow up fast
This is the foundation automation every service business should have running. Let’s build it.
Before You Start: What You’ll Need
- A Google account with access to Gmail, Google Forms, and Google Sheets
- A Make.com account — sign up free (no credit card required)
- Your Google Form ready with these fields: Name, Email, Phone, Service Needed
- A Google Sheet with matching column headers: Name | Email | Phone | Service Needed | Date Submitted
- 30–45 minutes
Step 1: Create Your Scenario in Make.com
Log into Make.com and click “Create a new scenario” from your dashboard.
You’ll land on a blank canvas with a single grey circle in the middle. This is where your automation lives — a visual map you can see, edit, and expand over time.
Click the circle to add your first module (Make’s term for a connected app or action).
Set up your trigger:
- In the module search bar, type “Google Forms”
- Select “Watch Responses” — this tells Make to monitor your form for new submissions
- Click “Add” to connect your Google account (standard Google authorization flow)
- Select your form from the dropdown
- Set “Maximum number of results” to 1 (processes one response at a time)
- Click OK
Your trigger is live. Make will now watch that form.
Do this before moving on: Submit a test entry in your Google Form right now. Then hit “Run once” in the bottom toolbar. If Make picks up your test submission and shows the data in the panel on the right, you’re good. If not, check that you selected the correct Google account and form.
Step 2: Log the Data in Google Sheets
Click the small “+” icon that appears to the right of your Google Forms module. This adds the next step in your automation chain.
- Search for “Google Sheets” → select “Add a Row”
- Connect your Google account
- Select your spreadsheet and the correct sheet tab
- Map your fields — click inside the “Name” field and you’ll see available data from your form appear on the right. Click “Name” to map it. Repeat for each column.
- For “Date Submitted”, type
{{now}}— Make auto-inserts the timestamp each time the automation runs
Click OK.
What’s happening: every time someone submits the form, Make grabs their data and writes it to a new row in your spreadsheet. You now have a live, auto-updating record of every inquiry — no manual data entry ever again.
Step 3: Send the Customer a Confirmation Email
This step is worth more than it looks. A customer who submits a contact form and hears nothing for hours starts to wonder if you’re real. A customer who gets a professional response within 60 seconds assumes you run a tight operation.
Click “+” after the Google Sheets module.
- Search “Gmail” → select “Send an Email”
- Connect your Gmail account
- Fill in the fields:
To: Click the field and select the Email variable from your form data.
Subject:
Thanks for reaching out, [Name] — here’s what happens next
Content type: Select HTML.
Body:
html
<p>Thanks for reaching out about <strong>{{Service Needed}}</strong>.
We received your inquiry and will follow up within 1 business day
(usually much faster).</p>
<p>If it’s urgent, call us directly: <strong>[YOUR PHONE NUMBER]</strong></p>
<p>Talk soon,<br>
[YOUR NAME]<br>
[BUSINESS NAME]</p>
“`
Replace the bracketed placeholders with your real info. Leave `{{Name}}` and `{{Service Needed}}` exactly as written — those pull live from the form.
Click **OK**.
—
Step 4: Alert Yourself the Moment a Lead Comes In
Add one final module — this one goes to you, not the customer.
1. Click **”+”** → search **”Gmail”** → select **”Send an Email”**
2. **To:** Type your own email address directly (hardcoded — always goes to you)
3. **Subject:**
“`
🔔 New Lead: {{Name}} — {{Service Needed}}
“`
4. **Body:**
“`
New inquiry received:
Name: {{Name}}
Email: {{Email}}
Phone: {{Phone}}
Service: {{Service Needed}}
Submitted: {{now}}
Click OK.
Step 5: Test the Full Automation End-to-End
Before you go live, run a complete test:
- Click “Run once” in Make’s bottom toolbar
- Submit a test entry in your Google Form using real-sounding dummy data
- Watch the Make canvas — each module should light up green in sequence
- Check your Google Sheet for the new row
- Check your inbox for both the customer confirmation and your internal alert
- Confirm personalization is working — the customer email should show the correct name and service
If all four things check out: click the scheduling toggle in the bottom-left corner to turn the scenario ON.
Your automation is live. On the free plan it runs every 15 minutes. On paid plans, it fires instantly using webhooks.
What to Do When Something Breaks
Make ran but the Google Sheet shows nothing → Re-check your field mapping. Confirm variable names match your column headers exactly — even a trailing space will break it.
The customer email sends but {{Name}} shows blank → Variable names are case-sensitive. Re-map the Name field by clicking it and selecting from the data panel rather than typing manually.
Make stopped running after a few days → Free plan scenarios can go dormant. Log in, find your scenario, and re-activate it. Set a monthly calendar reminder to check it.
The form trigger isn’t picking up new responses → Go back to your Google Forms module, click “Determine data structure,” and resubmit the form. If you’ve added new fields since setup, Make needs to relearn the structure.
3 Ways to Make This Automation Smarter
1. Add Conditional Routing by Job Type
Make’s Router module lets you split your flow based on data. If someone selects “Emergency Service,” route them to a different email template and flag them in a priority spreadsheet tab. Everyone else gets the standard flow.
This is one of the core advantages Make has over Zapier — unlimited routing branches without a price penalty. If you haven’t read our Make.com vs Zapier comparison, the routing section alone is worth the read.
2. Bring AI Into the Loop
Instead of sending the same confirmation email to every lead, route the form data through an AI module — Claude or ChatGPT — and have it draft a personalized response based on the specific service requested.
We covered exactly how to do this in our guide to ChatGPT vs Claude for Business Automation — including which model handles customer-facing copy better and when to use each one.
3. Add a 24-Hour Follow-Up If No Booking
Use Make’s built-in delay function to send a follow-up email exactly 24 hours after the inquiry if the customer hasn’t booked. Non-pushy, but it consistently converts leads that just got distracted. This is one of the 10 high-impact automations we recommend every service business set up in 2026.
The Mindset Shift That Changes Everything
The first automation you build isn’t valuable because it saves you 30 minutes a week. It’s valuable because it changes how you see your business.
Once you’ve set up one flow, you start noticing every manual, repetitive task differently. Instead of just doing it, you ask: “What would need to be true for this to run itself?”
That question — applied consistently — is what separates businesses that scale from businesses that stay stuck. It’s also the core argument we make in the AI Operations Manifesto — worth 5 minutes if you want the bigger picture on where this is all heading.
Start small. Get one thing working perfectly. Then look at the next bottleneck.
Your First Automation Checklist
- Google Form set up with Name, Email, Phone, Service Needed fields
- Google Sheet with matching column headers
- Make.com account created (free, no credit card)
- Google Forms trigger module connected and tested
- Google Sheets “Add a Row” module mapped and tested
- Gmail customer confirmation module with personalization working
- Gmail internal alert module with full lead details
- Full end-to-end test completed with dummy data
- Scenario activated and running
Frequently Asked Questions
Do I need to pay for Make.com to use this automation? No. Everything in this tutorial works on Make’s free plan, which includes 1,000 credits per month. For a business receiving under 250 inquiries a month, that’s more than enough to start.
Can I use this with Typeform or JotForm instead of Google Forms? Yes. Make.com connects with both. Swap the Google Forms trigger module for the Typeform or JotForm equivalent and map the same fields.
What happens if Make goes down? Make stores missed triggers and catches up when it comes back online. You won’t lose submissions.
Can I add more steps to this automation later? Yes. Your existing scenario stays intact. Click “+” after any module to add new actions — including the AI personalization layer mentioned above.
Is my customer data secure in Make.com? Make.com is SOC 2 Type II certified and GDPR compliant. Data passes through their servers during execution but isn’t stored unless you explicitly use their Data Stores feature.
Should I use webhooks instead of polling triggers? Once you’re comfortable with the basics, yes. Webhook-based triggers fire instantly rather than waiting for Make’s polling interval and don’t consume credits on empty checks. Google’s webhook documentation is a solid reference when you’re ready to make that upgrade.