Fetch Google Sheet Data to HTML – Free Apps Script Starter

The building block underneath every lookup app: type an ID, get that person's record out of a Google Sheet and onto a web page. Small on purpose, and the thing you will reuse most.

What it does

Your sheet holds rows — ID, full name, city, age, and whatever else you put there. The page takes an ID, finds the matching row, and prints its values. That is the whole mechanism, and it is the one every result portal, every tracking page and every customer lookup is built on top of.

Adding your own fields

Add a column to the sheet, add the matching line in the code, save and redeploy — and the new field appears in the output with whatever label you give it. The walkthrough does exactly that on camera, adding a column and showing it come through, so you can see which part of the code to copy when your own data has twelve fields rather than four.

Why start here

If you have never connected Apps Script to a sheet, this is the build where it makes sense: create the sheet, paste two files, replace the sheet URL, run it, grant permission, deploy. Nothing else is in the way. Once you can pull one row reliably, filtering, printing, emailing and building a table on top of it are all small steps.

What it is not

There is no login, no editing and no writing back — it reads and displays. If you need those, the CRUD and result-portal builds start from this same idea with the rest added.