Free tools

You Already Have Automation. You Just Haven't Turned It On.

How to set up your first real business automation in under an hour: free, no Zapier, no subscriptions, no code.

Small business owner using a simple Google Forms automation notification

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

Simple workflow diagram from Google Form to Google Sheets to Gmail notification
A simple first automation: collect the inquiry, save it automatically, and get notified.

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.

1

Customer submits a Google Form from your site, Facebook bio, email signature, or direct link.

2

The response is saved to a linked Google Sheet automatically.

3

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:

Keep it short. The goal is to capture enough information to follow up, not to replace a full intake process.

Google Forms editor with a customer inquiry form and four basic fields
A short inquiry form is easier for customers to finish and easier for your team to act on.

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.

Google Forms Responses tab showing the option to link responses to Google Sheets
Google Forms can send responses into a spreadsheet without any third-party automation tool.

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.

Google Sheet created from a Google Form with inquiry response columns
The spreadsheet becomes your first simple lead table: timestamp, customer details, service needed, and message.

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.

Google Forms menu showing Get email notifications for new responses
This tiny setting is what turns the form and sheet into a usable notification workflow.

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.

Gmail notification and Google Sheet showing a matching form response
The useful part is not the email design. It is that the inquiry is stored and someone gets alerted.

If everything works, your automation is live.

What you have now

You built a working automation without a paid automation tool:

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.

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.

Simple business workflow being turned on like a switch
A first automation should feel boring, useful, and easy to explain.

Sources

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