Businesses that rely on spreadsheets to manage customer contacts lose an average of 20% of their follow-up opportunities due to untracked calls, missed birthdays, and no reminder system. According to Salesforce’s State of Service report, 72% of customers expect agents to know their interaction history — yet most small businesses have no tool to log it. The Customer Address Book Web App solves this gap: it’s a Google Apps Script web application that centralizes contact management, follow-up scheduling, interaction history, and customer segmentation in one secure, multi-user browser interface.
Built for small businesses and service teams already using Google Drive, this web app replaces fragmented spreadsheets and expensive CRM subscriptions with a one-time-purchase tool. It deploys in under 10 minutes, requires no server or IT support, and gives every team member role-based access with their own login credentials.
🚀 Try the Live Demo Before You Buy
We have deployed this web app in our own Google account so you can test every page, every role — with real sample data — before purchasing. No signup, no email required.
🔑 Test Login Credentials
Sign in as Admin1 to manage all contacts, users, and system settings or as User1 to browse, search, and manage assigned address records.
💡 What you get after purchase: The full source code (Code.gs + Index.html) plus a step-by-step deployment guide so you can deploy your own private instance in your own Google account in under 15 minutes.
Key Features of Customer Address Book Web App
- 10 Dashboard KPIs — Total Customers, Active Customers, New This Month, Favorites, With Email, With WhatsApp, Missing Address, Follow-ups Due Today, Overdue Follow-ups, and Upcoming Birthdays tracked in real time.
- Address Book with 7 Smart Filters — Filter your full contact list by Category, Type, City, State, Status, Assigned User, and Tag. One-click quick-actions for Email, WhatsApp, Call, Map, View, Edit, and Delete on each contact row.
- Multi-View Follow-up Calendar — Month, Week, Day, and List views with color-coded events for follow-ups, payments, birthdays, and anniversaries. Filter by Assigned User and Event Type.
- Full Interaction History Log — Every Call, Email, WhatsApp, and Meeting interaction is logged with Date, Customer, Type, Note, and Agent — giving any team member a complete timeline before they contact a customer.
- Customer Master Report — Run and export filtered reports by Date, City, State, Category, Status, Assigned, and Tag — with 10 exportable columns including Customer Code, Company, Mobile, and Email.
- Color-Coded Tags — Segment customers as VIP, Retail, Wholesale, Vendor, Prospect, Service Due, or Important using fully manageable color-coded tags.
- Role-Based User Management — Admin and User roles with full CRUD support. Admins control who can access the app and what they can see.
- Configurable Settings Panel — Company Profile, WhatsApp Country Code, Default Email Subject, and Default WhatsApp Message templates are all configurable from inside the app.
Dashboard Pages Explanation
Click here to Purchase Customer Address Book Web App
Login Page
The web app opens with a secure login screen. Each user signs in with their own username and password to access their private workspace with role-based permissions — ensuring no unauthorized access to customer data.
Login Page
Dashboard
The dashboard displays 10 KPI cards — Total Customers, Active Customers, New This Month, Favorites, With Email, With WhatsApp, Missing Address, Follow-ups Due Today, Overdue Follow-ups, and Upcoming Birthdays — with multiple top filters for instant segmentation of your customer base.
Dashboard
Dashboard Charts
Four built-in charts provide visual breakdowns: Customer Category Summary by Category, Customer Status Summary by Status, Customers by City, and Customers by State — giving management an instant geographic and segmentation overview without needing a separate analytics tool.
Dashboard Charts
Address Book
The complete customer contact list features 7 smart filters (Category, Type, City, State, Status, Assigned, Tag), quick-action buttons for Email, WhatsApp, Call, Map, View, Edit, and Delete on each row, plus Table and Card views, and bulk Import/Export/Add Customer options for managing your full contact database.
Address Book
Click here to Purchase Customer Address Book Web App
Calendar
The calendar view displays follow-ups, birthdays, and anniversaries in Month, Week, Day, and List views. Events are color-coded by type and filterable by Assigned User and Event Type — making it easy to see every upcoming customer touchpoint at a glance. For more on building calendar-based tools in Google Sheets, see Daily Sales Purchase System Web App.
Calendar
Follow-ups
The follow-ups page lists all reminders and tasks with Date, Customer, Type, Assigned, Priority, and Status columns. Tasks are tracked as Completed, Overdue, or Pending — with Search, Export, Mark Done, Edit, and Add Follow-up actions making it easy for any agent to stay on top of their daily workload.
Follow-ups
Click here to Purchase Customer Address Book Web App
Notes and History
The complete interaction timeline for every customer logs Date, Customer, Interaction Type, Note, and Agent — covering Call, Email, WhatsApp, and Meeting interactions — with Search, Export, Edit, and Add Note actions. This is especially useful for the Complaint Management System Web App workflow where history is critical.
Notes and History
Reports
The Customer Master report provides filters for Date, City, State, Category, Status, Assigned User, and Tag — displaying 10 exportable columns including Code, Customer, Company, Mobile, Email, City, State, Category, Status, and Assigned — with Run and Export options for CSV downloads.
Reports
Tags
Customer segmentation tags — VIP, Retail, Wholesale, Vendor, Prospect, Service Due, and Important — are fully color-coded and manageable with Search, Add, Edit, and Delete Tag actions. Custom tags can be added to match your business’s own segmentation logic.
Tags
Click here to Purchase Customer Address Book Web App
User Management
The User Management page lists all app users with Name, Username, Role, Email, Phone, and Region columns. Admin and User roles provide role-based access control — with full Search, Add, Edit, and Delete User functionality that the Admin manages directly from inside the app.
User Management
List Management
The List Management page lets you manage all dropdown values used across the app — Customer Categories, statuses, and other picklists — with a List Type selector and Search, Add, Edit, and Delete Value actions. All data stays in your Google Sheet, giving you full ownership.
Settings
The Settings page configures Company Profile (Name, Phone, Email, Website, Address, Logo), Contact Action Defaults (WhatsApp Country Code, Default Email Subject, Default WhatsApp Message), with Test Reminder and Save Settings functionality — so every outbound action is pre-configured for your business.
Settings
Customer Address Book Web App vs. Google Sheets CRM vs. HubSpot CRM — Feature Comparison
| Feature | Customer Address Book Web App | Plain Google Sheets CRM | HubSpot CRM Free/Paid |
|---|---|---|---|
| Cost | $14.99 one-time | Free but manual setup | Free tier / $45–$800+/mo paid |
| Platform | Google Apps Script (browser) | Google Sheets | Web SaaS |
| Setup time | Under 10 minutes | 3–5 hours custom build | 30–120 min onboarding |
| Built-in login system | ✅ Yes — multi-user | ❌ No | ✅ Yes |
| Follow-up calendar | ✅ Month/Week/Day/List | ❌ Manual only | ✅ Yes |
| Interaction history log | ✅ Call/Email/WhatsApp/Meeting | ❌ No | ✅ Yes |
| Export contacts/reports | ✅ Yes — CSV/Export | Manual copy-paste | ✅ Paid plan only |
| Year-1 cost at 5 users | $14.99 total | $0 but 15+ hours setup | $540–$9,600+ |
| WhatsApp quick action | ✅ Yes — one-click | ❌ No | ❌ No (integration needed) |
For small businesses that need a structured customer contact system without paying $45–$800/month per HubSpot seat, the Customer Address Book Web App sits in the sweet spot.
Who Should Use This Template
✅ Perfect for:
- Small business owners managing 50–2,000 customer contacts without a CRM subscription
- Sales reps and field agents who need WhatsApp, call, and email quick-actions from a contact list
- Service businesses (salons, clinics, repair shops, retail) tracking birthdays, anniversaries, and follow-ups
- Teams already using Google Drive who want a zero-infrastructure multi-user contact system
- Operations managers who want full data ownership without a third-party SaaS vendor
❌ Not a fit if:
- Your enterprise team needs Salesforce-level automation, API integrations, or SOC 2 compliance
- You manage 10,000+ contacts requiring a dedicated database backend
- You need native iOS/Android apps (this runs in a browser)
- You need AI-powered lead scoring or email marketing automation built in
Real-World Use Cases
Click here to Purchase Customer Address Book Web App
Priya runs a 12-person salon and beauty services business. She uses the Customer Address Book Web App to track every client’s birthday, service due date, and last WhatsApp conversation. Her team logs follow-up tasks after each appointment and the calendar reminds them of anniversary discounts — without paying for a monthly CRM subscription. The Tags page helps her segment clients by service category for targeted campaigns.
Carlos manages field sales for a wholesale distributor. He tracks 800 retail customers across 4 cities using Address Book filters for City, Category, and Status to prioritize daily visits. The interaction history log captures every call note so nothing is lost between handoffs when accounts change hands. His manager runs the Customer Master report each Monday morning for a full filtered export.
Meera heads operations at a dental clinic. The web app serves as her patient contact book with follow-up reminders for treatment schedules and birthday greetings sent via WhatsApp quick-action. The Google Apps Script deployment means the entire tool lives in Google Drive — fully under her clinic’s ownership with no vendor lock-in. Learn more about building similar systems at Google Apps Script documentation.
Advantages of Customer Address Book Web App
- Zero infrastructure cost — Runs entirely on Google’s servers via Apps Script. No hosting fees, no database setup, no IT team required.
- One-time price of $14.99 — Compared to HubSpot’s $45–$800/month, the lifetime savings at 5 users can exceed $9,000 in Year 1 alone.
- Full data ownership — All customer data stays in your Google Sheet. No vendor lock-in, no data portability issues.
- WhatsApp-first design — One-click WhatsApp quick-action with pre-configured country code and message template is built specifically for markets where WhatsApp is the primary business communication channel.
- Deployable in 10 minutes — Follow the included PDF guide, click the copy link, deploy via the script editor, and share the URL. No coding required.
Opportunities for Improvement
- The app currently does not include automated email or WhatsApp message sending — the quick-action opens a pre-filled draft that the user sends manually.
- The calendar does not sync with Google Calendar or Outlook; events are stored within the app’s Google Sheet only.
- Import function expects a specific column format — users with non-standard existing spreadsheets may need to reformat before bulk import.
- The app is browser-based and not optimized for very small phone screens; a responsive mobile layout is recommended for future versions.
Best Practices
- Change default Admin credentials (Admin1/abcd) immediately after first login to protect your customer data.
- Use the List Management page to configure your own Customer Categories and Tags before importing contacts — this makes filtering far more effective.
- Set WhatsApp Country Code and Default Message templates in Settings before your team starts using the app to ensure consistent outbound communication.
- Run a Customer Master report weekly as a team review artifact — filter by Overdue Follow-ups to identify which contacts need immediate attention.
- Use Tags for lifecycle segmentation: mark new leads as Prospect, active buyers as Retail or Wholesale, and high-value accounts as VIP to differentiate your outreach approach.
Explore Relevant Templates
Looking for more Google Apps Script Web App Templates? These related products pair well with the Customer Address Book Web App:
- CRM and Sales Pipeline Management System Web App — Full sales pipeline with lead tracking, deal stages, and revenue forecasting
- Complaint Management System Web App — Log, track, and resolve customer complaints with SLA tracking and escalation workflows
- Daily Sales Purchase System Web App — Track daily sales and purchase transactions with multi-user access and reports
Frequently Asked Questions
Click here to Purchase Customer Address Book Web App
What KPIs does the Customer Address Book Web App track?
The Customer Address Book Web App tracks 10 KPIs including Total Customers, Active Customers, New This Month, Favorites, With Email, With WhatsApp, Missing Address, Follow-ups Due Today, Overdue Follow-ups, and Upcoming Birthdays — all visible on the main dashboard with real-time data from your Google Sheet.
Does this work without coding knowledge?
Yes. The Customer Address Book Web App deploys in under 10 minutes following the included PDF guide. No coding is required — the Google Apps Script is pre-built. You only need to click Deploy in the script editor, choose the access settings, and share the URL with your team.
How does this compare to HubSpot CRM?
HubSpot CRM costs $45–$800+ per month for paid features. The Customer Address Book Web App is a one-time $14.99 purchase. It covers core contact management, follow-up tracking, interaction history, calendar, and reporting — without monthly fees, per-user pricing, or vendor lock-in.
Can multiple users access it at the same time?
Yes. The Customer Address Book Web App supports multiple simultaneous users with role-based access (Admin and User roles). Each user logs in with their own credentials and permissions are controlled centrally by the Admin through the User Management page.
How long does setup take?
Setup takes under 10 minutes. Download the ZIP, open the PDF guide, click the Google Sheets copy link, deploy the script as a web app (Execute as: Me / Access: Anyone), and share the URL. No server, hosting, or IT support required.
Can I import my existing customer list?
Yes. The Address Book page includes an Import button for bulk-loading your existing contacts. The template expects a standard column format — check the included PDF guide for the required structure before importing.
Where does my data live?
All data is stored in your own Google Sheet in your Google Drive. The Customer Address Book Web App has no external database or server — your data stays entirely under your Google account, giving you full ownership and control at all times.
About the Author
Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@NeoTechNavigators, @PK-AnExcelExpert, @NextGenTemplates). Every template is hand-built and tested before release.
Conclusion
The Customer Address Book Web App gives small businesses and service teams a structured, multi-user contact management system that lives entirely in Google Drive — without any CRM subscription fees. It tracks 10 KPIs, logs every customer interaction, schedules follow-ups with a calendar, and exports filtered reports — all for a one-time price of $14.99.
Click here to Purchase Customer Address Book Web App
Instant download · One-time payment · No subscription
Last updated: June 2026
👉 Youtube.com/@NeoTechNavigators
