Setup guide — Mini Roadmap

1

Create the Google Sheet

Create a copy of the template Google Sheet. Keep tab name roadmap (lowercase, exact match) and these columns:

A

Phase

[Optional group. Blank cells inherit the row above]

B

Task

[Rows with no task are skipped]

C

Description

[Short summary, or leave blank]

D

Owner

[Name or blank. "Client" shows the client name]

E

Status

[Use only 'not started', 'in progress', 'complete', 'blocked', 'overdue']

F

Due date

Use DD/MM/YYYY format, or leave blank.

G

Notes

[Optional freetext visible to the client, including links]

Then share the sheet publicly: File → Share → Anyone with the link → Viewer.

Copy the Sheet ID from the URL – it's the long string between /d/ and /edit.

2

Generate a password hash

Choose a password for the client, then use the hash helper to convert it to a SHA-256 hash. You'll paste this into the CONFIG block – the plain-text password is never stored in the file.

Open hash helper

3

Configure the roadmap file

Duplicate demo.html and rename it for the project (e.g. acme-roadmap.html). Open it in a text editor and update the CONFIG block at the top – it's the only thing that needs changing between projects.

const CONFIG = {
  sheetId:      'YOUR_SHEET_ID',
  apiKey:       'YOUR_GOOGLE_API_KEY',  // same key for all projects
  projectName:  'Project name',
  clientName:   'Client name',
  passwordHash: 'PASTE_HASH_FROM_STEP_2',
};

The API key is shared across all projects – you only need one.

4

Deploy and share

Deploy the project on Netlify by uploading the folder

Send the client the URL and password. That's it – update the Sheet any time, client refreshes the page to see changes.