HtmlService

What it does

Serve HTML, CSS, and client JavaScript for dialogs, sidebars, and web apps.

Methods used

.createHtmlOutput() .setHeight() .setWidth()

Related snippets

Official Google docs

Explore

Related methods

.createHtmlOutput()
Builds HTML output from a string for dialogs or sidebars.
.evaluate()
Renders a template into final HTML output.
.createTemplate()
Creates an HTML template from a string with scriptlets.
.setTitle()
Sets the title shown on a dialog or sidebar.
.setHeight()
Sets the height of a dialog in pixels.

More Apps Script

Better Sheets tutorials

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

Create a click Edit: Google changed how the redirect is handled. It no l...

Advanced

HYPERLINK()

Big Year - a Whole Year in One Google Sheets Tab

Get "Big Year" for free via Gumroad. Get perspective on your 2024 plan ...

Create Navigation Buttons in Sheets to Other Sheets

Add a button to go to another sheet inside your sheet.

Intermediate

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

There was a stories craze. Every app/platform/business was adding 24 hou...

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

LinkTree in a Google Sheet

This tool will allows you to share multiple links on your social media.

Advanced

Proof of Life

Create a script that sends an email to ask for proof of life every month...

Advanced

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

Revolutionary Method to Manage Your Video Stories! Learn how to delete o...

Advanced

CONCATENATE() IF() IMAGE() INDEX() ISBLANK() +1 more

Related blog posts

Written guides about HtmlService in Google Apps Script.

Browse the blog

How to Use Google Sheets as a Website Database

Did you know you can use Google Apps Script to turn a Google Sheet into a free, auto-syncing database for your website? This guide shows you exactly how to set it up. You’ll prepare your spreadsheet, write a few lines of code and publish your site. Don’t worry if you’re not a developer, we’ll walk you through it. Why Use Google Sheets as a Database? For small projects, Google Sheets offers many advantages over traditional databases: * Free hosting and storage * Easy to edit data without...

Extract URLs from Google Sheets

Extract url from hyperlink google sheets.Skip the Command K. This Google Sheet tutorial will make it easier for you to extract URLS from Google Sheets.