Google Sheets App Scripts: Show and Close Sidebar

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.