I built two lead capture tools using Google Apps Script that cost exactly $0 per month to run. They capture leads, send automated emails, log everything to Google Sheets, and I own them forever. No subscription fees. No feature gates. No platform holding my data hostage.
Watch the videos below to see exactly how they work, then try them yourself.
You can build these yourself!
Simple Lead Capture Form
This isn’t just another contact form. It’s a spam-protected lead capture that automatically emails you when someone submits, sends them a customized confirmation message, and logs everything to a Google Sheet you control. Built with honeypot protection to block bots and clean design. Perfect for lead magnets, newsletter signups, or basic lead capture. You build it once using tools you can access for free, and it runs forever.
Self-Qualifying Business Quiz
This quiz does what you used to do manually over multiple email exchanges. It asks prospects about their goals, pain points, and current setup, then automatically sends them personalized product recommendations with direct purchase links based on their answers. You get an admin email telling you if they’re “just curious” or actively looking to buy, plus tracking on which offers they clicked and which they ignored. Everything flows into Google Sheets so you can see patterns, export to your CRM, or follow up strategically. It’s not lead capture, it’s lead qualification on autopilot. And of course, this quiz can be customized to ask different questions and provide different results based on the inputs.