Apps Script Site Navigation Fix and optimization

Заказчик: AI | Опубликовано: 21.02.2026

My website is built entirely on Google Sheets as the data layer, with Google Apps Script powering the front-end pages. On the main menu page the navigation refuses to route consistently—sometimes the links load the wrong view, other times nothing happens at all. I need that bug traced and eliminated so every menu item loads the correct content on the first click, across modern desktop and mobile browsers. While you are inside the code, I would also like a light performance tune-up: streamline any redundant calls to the spreadsheet, cache results where it makes sense, and trim unnecessary on-load functions so pages feel snappier. No redesign is required; the focus is clean, reliable navigation and leaner script execution. Deliverable: an updated Google Apps Script project (or specific script files) that plug straight back into my current spreadsheet, with the navigation menu working flawlessly and observable speed improvement in normal use. I will test by opening each menu item several times and timing the initial load—everything should resolve without errors and faster than it does now.