Most people think automation means signing up for Zapier, connecting APIs, and paying monthly for something their team will never fully understand.
It does not.
The most useful automation a small business can set up today does not require a new subscription, technical skill, or automation platform. It is already sitting inside Google, waiting to be turned on.
This guide walks through one workflow: a customer fills out a Google Form, their details appear automatically in a Google Sheet, and you get an email alert when it happens.
No Zapier. No paid automation tool. No code.
If you have a Gmail account, you already have enough to start.
Why this matters more than any Zapier workflow
Before building anything complicated, it helps to understand what automation actually is.
Automation is not a tool. It is a decision: something that used to require a human action now happens on its own.
Google Forms has been doing this quietly for years. When someone submits your form, Google Sheets records it. That is automation.
You just have to turn on the notification step. Google Forms can do that too.
The first useful automation is usually not impressive. It is the small workflow that stops a lead, request, or customer message from getting missed.
The result: a customer fills out your inquiry form, the response appears in a spreadsheet, and you receive an email alert.
No manual copying. No checking the form every hour. No waiting until someone remembers to open the responses tab.
That is a real workflow. And it takes about 45 minutes to build from scratch.
What you will build
A customer fills out a contact or inquiry form on your website or through a shared link.
Their name, contact details, and message are saved automatically to a Google Sheet.
You receive an email notification when the response is submitted.
Customer submits a Google Form from your site, Facebook bio, email signature, or direct link.
The response is saved to a linked Google Sheet automatically.
You get an email alert so the inquiry does not sit unseen.
That is the entire workflow. Three steps. Zero cost.
Step 1: Create your Google Form
Go to forms.google.com and create a new form.
For a basic inquiry form, add these fields:
- Full name
- Phone number or email
- What service are you looking for?
- Message or additional details
Keep it short. The goal is to capture enough information to follow up, not to replace a full intake process.
When the form is ready, click the share or send option to get a link. You can put this link in your Facebook bio, website, email signature, or send it directly to customers.
Step 2: Connect it to Google Sheets
This part is already built into Google Forms. You do not need Zapier or any connector.
Inside your form, click the Responses tab at the top. Then click the green Sheets icon or the option to link responses to a spreadsheet.
Choose the option to create a new spreadsheet, unless you already have a sheet where these responses should go.
Google will create a new spreadsheet and link it to your form automatically. Every future submission will appear as a new row, with a timestamp and one column for each question.
That is it for the Sheets connection. It is live immediately.
Test it by submitting your own form and watching the row appear.
Step 3: Turn on email notifications
Now for the part most people miss.
Google Forms can send you an email notification when someone submits a new response.
Go back to the Responses tab in your form. Open the three-dot menu and choose Get email notifications for new responses.
From this point on, each new form submission should trigger an email alert to your Gmail.
The default notification is simple. It tells you that a new response was submitted and gives you a way back to the form or response data.
It is not the most beautiful notification in the world. But it works, it is fast, and it costs nothing.
Test the whole workflow
Before sharing the form with customers, test the whole workflow yourself.
- Open your form link in a new browser tab or private window.
- Fill it in as if you were a customer.
- Submit it.
- Check your Google Sheet. The row should appear within a few seconds.
- Check your Gmail. The notification should arrive shortly after.
If everything works, your automation is live.
What you have now
You built a working automation without a paid automation tool:
- A customer fills out your form.
- Their details are saved automatically to a spreadsheet.
- You get an email alert when it happens.
This is not a demo. This is a real system you can share with customers today.
Where to go from here
This workflow is a foundation. Once it is running, you can extend it without adding much complexity.
- Add a Status column to the Sheet: new, contacted, booked, closed, or not a fit.
- Add an Owner column if more than one person follows up.
- Add a Follow-up date column for simple manual tracking.
- Add a booking link to your form confirmation message.
- Share the Sheet with the team member who needs to reply.
None of these require Zapier. They are all inside Google.
If the next problem is tracking who replied, what status each lead has, and which inquiries are going cold, read the guide on starting small business automation with lead follow-up.
The bigger point
Zapier, Make, and n8n are useful. For complex workflows, multi-step logic, or connecting tools that do not talk to each other natively, they are worth learning.
I also wrote a separate guide comparing Zapier, Make, and n8n pricing with a real lead form example, because the cost depends on how each platform counts usage.
But for a first automation, especially the one that stops you from missing inquiries, you do not need any of them.
Google Forms, Google Sheets, and Gmail are already connected.
The automation is already there. You just have to turn it on.
Sources
- Google Docs Editors Help: Choose where to save form responses
- Google Docs Editors Help: View and manage form responses
Want to turn this into a real lead tracker?
Send me your form fields, who needs to follow up, and what statuses matter. I can map the smallest lead tracker worth building first.
Get the map