Lead tracking with a face attached. Every lead carries a photo stored in Google Drive and shown in the list, alongside the contact details, the company and where the deal has reached.
Adding a lead captures name, email, phone, company, status, a start and end date, free-text notes, and an image uploaded straight to Drive. The newest lead sits at the top of the list, so the most recent work is what you see first. Editing a lead includes replacing its image — a detail most builds skip, leaving you with a record you can update except for the one field that needs a re-upload.
Two filters do the work. Status cuts the list to new, contacted, demo sent, negotiating, converted or lost — so "who is waiting on a demo" is one click. The date range filter cuts by when leads started, which is how you review a month or a campaign. Both work on the same table.
The status options are a list in the HTML, for both the form and the filter, and there is no limit on how many you add. If your pipeline has seven stages with your own names, it takes a minute — no code logic changes.
Any lead can be viewed in detail and printed. The whole table copies, exports to Excel or PDF, or prints — which covers the weekly report without anyone rebuilding it by hand.
| Version | v1.0 |
| Published | Aug 22, 2025 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | CRM & Sales |
| Tags | |
| Video | Watch walkthrough |
| License | Regular License |
Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.
What you get
Not subscribed yet? Subscribe to our channel
Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.
20–30% advance to start · Clear quote before work begins · Support after delivery
What we customize
Paid picks from the same category
Full Source Code: Google Sheets CRM with Kanban Board, Deals, Contacts & RBAC Admin
152 views this month
Free AI CRM in Google Sheets — Full Lead Management System with Apps Script | E39
216 views this month
Lead Management Web App With Admin , Manager & Team Login Using Google Spreadsheet data | B51
42 views this month
What buyers and YouTube viewers say about this project.