Membership Portal with OTP & IP Lock – Google Apps Script

The upgraded membership dashboard: the same OTP login, IP lock and download limits as the first release, with the three things members kept asking the owner about now answered on screen instead of by email.

Members can see where they stand

The dashboard shows the account's expiry date and, next to it, how many days are left before it lapses. Nobody has to write in to ask when their access ends, and nobody is surprised by a refused login.

Password changes without a reset

A member changes their own password from the dashboard by entering the current one and the new one twice — no OTP round-trip, no message to the administrator. Forgot Password with an emailed OTP is still there for the case where the current password is genuinely lost.

A history they can check themselves

The History tab lists that member's own activity: every login with its date and IP address, logins completed with OTP, OTP codes sent for a password reset, and IP address changes. It is the record that settles the question of whether a login came from them, and the owner keeps the same view across all members.

Everything from the first release

Login is still refused after the access date passes, the account is still bound to one IP with OTP verification to move it, downloads are still capped per day with used and remaining shown live and an upgrade prompt at the limit, products still carry a live-view link, and the category list is still driven by the tabs in your spreadsheet.