function showSidebar() { var authorizationUrl = "..."; var template = HtmlService.createTemplate( 'Click <a href="<?= authorizationUrl ?>" target="_blank">Authorize</a>.'); template.authorizationUrl = authorizationUrl; var page = template.evaluate(); SpreadsheetApp.getUi().showSidebar(page);}function closeSidebar() { var html = HtmlService.createHtmlOutput("<script>google.script.host.close();</script>"); SpreadsheetApp.getUi().showSidebar(html);}
❤️ Is this article helpful?
Buy me a coffee ☕ or support my work via PayPal to keep this space 🖖 and ad-free.
Do send some 💖 to @d_luaz or share this article.
✨ By Desmond Lua
A dream boy who enjoys making apps, travelling and making youtube videos. Follow me on @d_luaz
👶 Apps I built
Travelopy - discover travel places in Malaysia, Singapore, Taiwan, Japan.