Give clients a live project timeline without sharing your sheet
Your client opens one link and sees what's done, what's next and exactly what's waiting on them.
Published . Steps as of November 2026.
How can I show clients project progress without sharing my spreadsheet?
Ask Gemini to turn your tracker into a Sheets canvas timeline, then publish the canvas as its own read-only link. Choose automatic republishing if you update the sheet often, so the client always sees current status. Choose a static view for a one-time snapshot, like an end-of-month report. The client never gets access to your source sheet, so rates and notes stay private. As of November 2026, publishing works in Sheets on the web for Google AI Pro and Ultra and some Workspace plans.
A sketch of what you'll get back.
Your prompt
Fill in your details. Skip any you like.
This AI can't be filled in from a link, so the button copies your prompt: paste it into the new chat.
The prompt that gets copied
Build a Sheets canvas from this tracker that I can share with my client, [CLIENT NAME, e.g. Harbor Lane Bakery], as a read-only project timeline for [PROJECT NAME, e.g. their website refresh]. The columns are [YOUR COLUMNS, e.g. milestone, owner, due date, status]. Show a simple timeline from start to launch, with each milestone as a card showing its due date and status: done, in progress, or waiting on client. Put a clear 'Waiting on you' box at the top listing only the items the client owes me, with due dates. Show overall progress as a percentage of milestones done. Leave out [PRIVATE COLUMNS, e.g. hours, rates and internal notes], since the client will see this. Use calm colors and plain words, and make it easy to read on a phone.
Turn your project tracker sheet into a Sheets canvas timeline and publish it as a read-only link. Your client sees milestones, dates and what's waiting on them, but not your rates or notes.
Step by step
- Open your project tracker in Google Sheets on the web.
- Ask Gemini to build a Sheets canvas with the prompt below.
- Click the publish icon in the canvas toolbar, then click Publish canvas.
- Choose automatic republishing, set the audience, then copy the link.
- Send the link to your client once, and keep updating the sheet.
What you'll get
A read-only timeline page with a 'Waiting on you' box and a progress percentage, published from your own sheet so it stays current.
Publishing works in Sheets on the web for Google AI Pro, Ultra and some Workspace plans. Rolling out from November 11, 2026.
- Made for
- Consultants, Coaches, Small business owners, Creators
- Works in
- Gemini
