BarbagalloDigital

Client project Automation: Lead tracker automation

A lead sheet that keeps itself current.

A small business already tracked its leads in a Google Sheet it knew well. I connected its website form and its email to that sheet, without replacing either.

At a glance

Client
A small business. Not named, and the details of its own lead system are left out, at its request.
Tools
A website form, Google Sheets, Gmail and Google Apps Script, all in the client’s own accounts.
Scope
New website enquiries into the sheet, contact dates kept up to date from email, and a list of follow-ups that are due.
Status
Installed and checked on the client’s live sheet and email.
Who replies
The owner. The automation sends no messages to customers.

The challenge

New enquiries, email conversations and follow-up dates all had to stay in line with the sheet. That meant copying details in by hand, updating contact dates and checking which leads were due.

The goal wasn’t to replace the business’s tools or to automate personal communication. It was to connect what was already there, so the sheet stayed useful as the work moved on.

What I built

Three routines, each running in the client’s own Google account and website.

The three routines, in general terms

A new enquiry

  1. Website form
  2. A connector passes it on
  3. New lead in the sheet

An email to or from a lead

  1. Email activity
  2. Matched to a lead
  3. Contact date updated

A follow-up date

  1. The date comes due
  2. A scheduled check
  3. Lead added to the follow-up list
  4. The owner follows up
Illustrative Common integration patterns, drawn for this page. Not the client’s actual setup, and no client data.

1. Website enquiries go straight into the sheet

A website form submission becomes a new lead in the existing sheet, with no copying by hand.

If the enquiry clearly belongs to an existing lead, it’s added to that lead. If the match isn’t clear, it’s held for a person to check rather than guessed.

2. Email keeps the contact date current

A scheduled check looks at the business’s connected email for messages to and from existing leads, and updates that lead’s last-contact date.

Tracking started at installation; older messages weren’t imported.

3. Due follow-ups collect in one list

The owner sets a follow-up date on a lead.

Once the date comes due, a scheduled check adds the lead to a follow-up list. The owner works through that list and follows up personally.

What changed

Three recurring admin jobs now feed one review process, in the tools the business already used. The owner still handles every conversation with a customer.

Each admin task before the project, and how it works now
BeforeNow
Copy each new enquiry into the sheetThe website form feeds the existing sheet
Update contact dates by handEmail to and from a lead updates the date
Search the sheet for follow-ups that are dueDue leads appear in one follow-up list

How it was checked

Before and after it went live, using test entries and test messages sent with permission, never real leads’ mail.

  • Built and tested on a copy of the sheet first, then installed on the live one, with a full backup taken before.
  • A real submission through the public website form created one correctly filled lead. Sending it again didn’t create a second.
  • Incoming and outgoing contact-date updates were checked with test messages sent with permission. No message went to a real lead.
  • After the checks, every existing lead was compared field by field with the backup: none missing, added or changed.

Why this approach

This was a tailored integration, not an off-the-shelf CRM. It kept the spreadsheet the business already knew and fitted the automation to the way the work was already done.

What this doesn’t show

The limits, stated plainly, so you can weigh the evidence.

  • No time-saved, sales or response figures. None were measured, so none are claimed.
  • The scheduled checks ran correctly when installed. They run on Google’s and the web host’s schedules and limits, so this says nothing about uptime.
  • The client and the details of its own lead system are left out at its request, and no screenshots of its systems are shown. This describes my work; it isn’t an endorsement by the client.
  • Your setup would be scoped and quoted on its own.

Have a website form, inbox and spreadsheet that should work together?

Tell me what you do by hand. I’ll tell you whether it can be automated reliably, and quote it before any work starts.

Free, one page, no login.

Get a free website check