Portal Builder — Web Portals from Google Sheets

Row 1 — column headers

Copy row 1 in Sheets, click below, and paste — columns fill A, B, C…

Sheet options

Sheet tab name

Unique ID column

URL parameter

Used in links like ?id=VALUE. Set from your unique ID column header (lowercase); edit to override.

Column reference

Portal settings Active

Page title

Columns on the portal

Paste headers first

Choose which row fields appear in Page.html. The unique ID column can stay off the page if visitors only open direct links.

HTML sections (on / off)

Toggle optional blocks in Page.html. Row data above is separate from these sections.

Search bar

Custom branding header

Intro text block

In Apps Script, add an HTML file named Page (saved as Page.html) and paste the HTML from the panel below. Code.gs calls createHtmlOutputFromFile('Page') — the filename is fixed and cannot be changed here.

Code.gs and Page.html update live. Copy when the helper checklist is green through page title and at least one portal column. Finalize uses a generation and unlocks deploy actions.

Apps Script — Code.gs Live

Page.html Live

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

Step 1 — Open Apps Script

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

Step 2 — Add your two files

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

Step 3 — Create a web app deployment

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

Step 4 — Copy the Web app URL

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

Step 5 — Paste URL into Code.gs

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

Step 6 — Test your portal

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