Open Google Sheets, create a new spreadsheet. Name it WN Lead Tracker.
2
Go to Extensions → Apps Script. Delete any existing code and paste the contents of appsscript.gs (provided alongside this file).
3
Click Deploy → New deployment. Type: Web app. Execute as: Me. Who has access: Anyone. Click Deploy and copy the Web app URL.
4
Paste the URL below and click Save. That's it — your app is live!
The URL is saved in your browser. To change it later, use the ⚙ button after logging in.
Sign in
Sign in with your employee code and password. Admin access is determined automatically.
Verifying…
Loading your dashboard…
My pipeline by status
My products in play
Project News Feed
Loading news…
No project news yet. Be the first to share!
Tasks assigned to me
Recent daily reports
Project details
Products in requirement
Commercial & status
Meeting dates
Comments
Saving to Business Vault…
Loading your records…
No records yet. Start by adding your first entry.
Daily report details
Contacts — add up to 5 contacts for this project
Activity & follow-up
Saving to Business Vault…
Enable location for attendance
Wise Neosco would like to record your location when you punch in/out. This helps verify attendance accuracy. Your location is only captured at punch time and stored securely.
--:--:--
--
Punch In
--:--
Punch Out
--:--
Recording...
My attendance history
Loading...
Date
Punch In
Punch Out
Hours
Loading your reports…
No daily reports yet. Submit your first report.
Loading dashboard…
View employee performance:
Pipeline by status
Products in play
Lead records
Recent daily reports
Overall pipeline by status
Top products in pipeline
Pipeline by employee
Project News Feed
Loading news…
No project news yet.
Loading records…
No records match your filters.
Loading reports…
No reports found.
Task Engine
Assign task to employee
Suggested contact
Assigning task…
Loading tasks…
No tasks assigned yet.
Loading attendance...
#
Employee
Name
Date
Punch In
Punch Out
Hours
Status
No attendance records found.
Employee management
Employees are stored in the Employees sheet of your Google Sheet. To add or change passwords, edit that sheet directly. The app reads it on every login.
Sheet columns: A = Employee Code | B = Name | C = Password | D = Role (admin or employee) Row 1 is the header. Set Column D to admin to grant admin access, or employee for standard access.
Quick Task — Card / Screenshot Scan
Upload a business card or screenshot. Claude will extract contact details automatically.
Upload or photograph a business card
JPG, PNG, WEBP — max 5MB
Claude is reading the card…
Details extracted — review and edit below before assigning
Delete this task?
This will permanently remove the task from the sheet.
Complete task
Updating…
Share Project News
Upload screenshot or image
Claude will fetch and summarise the relevant project information.
Claude is analysing…
News extracted — review and edit before sharing
Comma-separated tags for easy filtering
Update Lead
This will be appended with your name and timestamp. Previous comments are preserved.
Saving...
Lead History
Loading history...
Select a lead to view its history.
Delete this daily report?
This cannot be undone.
Delete this record?
This will permanently remove the entry from the Google Sheet. This cannot be undone.
Lead & Prospect Tracker