Most small businesses get a steady trickle of work from word of mouth, but almost none of them know exactly who is sending it. Ask a typical owner "who referred your last five customers?" and you'll get a shrug. That's a problem, because you can't say thank you to someone you can't identify, and you can't double down on a referral source you haven't noticed. This weekend's build fixes that with a simple intake form, a tracking sheet, and an automatic thank-you email — no new software subscription required.
Why a spreadsheet beats doing nothing
You don't need referral software to start. A university extension guide on word-of-mouth marketing makes the point plainly: tracking how customers find you is what lets you tell which of your efforts are actually working, so you can spend more time on the ones that pay off and less on the ones that don't. The Duct Tape Marketing team frames referral marketing the same way — it only compounds if you're paying attention to where it's coming from. A free spreadsheet, built once, will tell you that. Dedicated referral software can come later if volume ever justifies it.
What you're building
Three pieces, all inside tools you likely already have:
- A short Google Form (or a field added to your existing quote/booking form) that asks new customers one extra question: "Who should we thank for sending you our way?"
- A Google Sheet that collects those responses automatically, with a second tab listing your regular referral sources (past customers, trade partners, the neighbor who won't stop recommending you) and their email addresses.
- A small Apps Script that watches for new form submissions and, when the referrer matches someone on your contacts tab, fires off a short personalized thank-you email automatically.
Step-by-step
1. Add the one question that matters
If you already send customers a quote request or intake form, add a single field: "How did you hear about us?" with free text, or a dropdown pre-filled with your regular referral sources plus an "Other" option. Point the form's responses at a new Google Sheet (Forms does this automatically when you open the Responses tab and click the Sheets icon).
2. Build a referrer directory
On a second tab in that same spreadsheet, keep a simple list: referrer name, email, and a running count of how many customers they've sent you. This is the lookup table your script will check against.
3. Wire up the thank-you email
In the Sheet, open Extensions > Apps Script and write a short function that runs whenever a form response lands. Google's own documentation on installable triggers covers the exact trigger type you need — a form-submit trigger tied to the spreadsheet, which fires automatically each time a new row is added. Inside that function, look up the submitted referrer name against your directory tab, and if it matches, call MailApp.sendEmail with a short, genuine note: "Hey [name], just had [customer] mention you sent them our way — really appreciate it." Nothing fancy, no template that reads like a form letter.
One detail worth knowing before you build this: installable triggers run under the authorization of whoever created them, so set the trigger up from the account you want the thank-you emails to come from, and check the script's execution log if a run doesn't fire the way you expect.
4. Add a monthly glance
Add a small pivot table or a few SUMIF formulas that total referrals by source for the current month. Five minutes once a month tells you whether your best referral sources are trade partners, a particular past customer, or a specific platform — information you've probably never had in one place before.
Where to stop
Keep this version simple. Don't wire up automatic discounts or referral payouts inside the script — if you want to reward referrers with money off their next job or a gift card, handle that decision and any tax or bookkeeping implications yourself rather than automating it, at least until the manual version has run for a few months and you trust it. The goal this weekend is visibility and a genuine thank-you, not a full referral program.
The payoff
This isn't a big system. It's one extra form field, one lookup tab, and a script you'll spend an afternoon writing and testing. What it buys you is something most small businesses never get: a running, honest record of who actually sends you work, and a reason for those people to keep doing it.