Portal Builder

Configure your sheet — code and preview update on the right

Column headers

Row 1 — column headers

Copy row 1 in Google Sheets, click the grid, and paste.

Settings

Sheet

Sheet tab name

Unique ID column

Each portal link uses one value from this column (order ID, email, etc.).

Portal page

Page title

Shown in the browser tab and as the main heading on the portal.

Columns on the portal

Paste headers first

Advanced options

URL parameter

Links look like ?id=VALUE. Auto-filled from your ID column header.

Column reference

Optional HTML sections

Search bar

Custom branding header

Intro text block

In Apps Script, add an HTML file named Page (Page.html) and paste from the panel below. Code.gs uses createHtmlOutputFromFile('Page').

Apps Script — Code.gs

Page.html

Preview

Sample data — deployed portals show real sheet rows.

Before you start: copy Code.gs and Page.html from this builder (or use Copy all).

In your spreadsheet: Extensions → Apps Script. The Script Editor opens bound to this sheet.

Replace Code.gs with the builder output.
Add an HTML file named Page (Page.html) and paste the HTML from the builder.

Deploy → New deployment → gear icon → Web app. Execute as: Me. Who has access: Anyone (for public portals). Deploy and authorize if prompted.

Copy the URL ending in /exec. Do not share the /dev test URL.

Replace PASTE_DEPLOYMENT_URL_HERE at the top of Code.gs with your Web app URL. Save.

Open the Web app URL with ?id=VALUE where VALUE matches a row in your lookup column.