You can send every lead from your website form straight into a Google Sheet, automatically and for free, using Google Apps Script. No Zapier subscription, no Make.com fees, just your form talking to your Sheet. Here is how it works and why it beats paying monthly.
Why your inbox is the wrong place for leads
Right now, most small businesses get website leads as emails. That means leads are:
- ▸Buried in an inbox with everything else.
- ▸Impossible to sort, filter, or track by status.
- ▸Easy to miss, forget, or lose when things get busy.
A Google Sheet fixes all of that. Every lead becomes a row you can sort, tag, follow up on, and never lose. And you can build reminders and dashboards on top of it later.
A lead sitting unseen in your inbox is a sale you are quietly giving to a competitor. Get them into one organized list you actually work from.
How it works, without paid tools
The setup is simpler than people expect:
- ▸A Google Apps Script web app acts as the receiver. It is free and runs on your Google account.
- ▸Your website form posts to it when someone hits submit.
- ▸The script writes a new row into your Google Sheet with the name, email, message, date, and anything else you capture.
- ▸Optional extras: it can also email you an alert, send an auto-reply to the lead, or post to Google Chat, all for free.
Zapier and similar tools charge every month to do roughly this. Apps Script does it natively inside the Google tools you already pay for, with no task limits.
What you can add once leads are in Sheets
The Sheet is just the start. From there you can:
- ▸Track status: New, Contacted, Quoted, Won, Lost, in a simple column.
- ▸Get instant alerts: an email or WhatsApp ping the moment a lead arrives.
- ▸Auto-reply: send the lead a friendly "we got your message" email automatically.
- ▸Build a dashboard: see leads per week, sources, and conversion at a glance.
Things to get right
- ▸Validate and filter: add a basic check so bot spam does not fill your Sheet (a honeypot field and simple rules do the job).
- ▸Protect the Sheet: keep it in your own Drive with access limited to your team.
- ▸Test the flow: submit a real test lead end to end before you rely on it.
The bottom line
If your website leads land in your inbox, you are losing some of them, and maybe paying a monthly tool you do not need. Apps Script sends every submission straight into a Google Sheet for free, organized and ready to work, with alerts and auto-replies if you want them.
We build these lead-capture automations to match exactly how you follow up, no monthly fees, just your own Google tools working harder. Want your leads flowing into one clean list? Let's set it up.
Want this set up for your business?
VB Easy does this for clients every week. Let's talk about your setup — no obligation.