# Give clients a live open-spots page that updates from your sheet > The link refreshes when your sheet changes, so a booked seat drops off the page without you touching it. Turn your class or session sign-up sheet into a clean schedule page with Gemini, then publish it as its own link. Clients see open spots live but never see your spreadsheet. - Page: https://thesolocreators.com/prompts/live-open-spots-board-from-your-bookings-sheet/ - Category: Wow your clients - Made for: Coaches, Small business owners, Creators - Works in: Gemini - Time: About 20 minutes to set up, then it updates itself - Effort: A few steps - Note: Sheets on the web only. Needs Google AI Pro or Ultra, or Workspace Business Standard or Plus. Rolling out from Nov 11, 2026. - Published: 2026-11-15 ## How do I share a live class schedule without sharing my spreadsheet? Build a canvas from your bookings sheet with Gemini in Google Sheets, then publish it as its own link. As of November 2026, the published link is separate from the spreadsheet, so viewers only get read-only access to the page. Pick automatic republish if seats change daily, or a static snapshot if you just want to share one week's schedule. Hide any columns with client names or emails before you publish. ## The prompt Fill in the parts in [square brackets], or leave them and the AI will ask you for them. ```text Build a canvas from this sheet that shows my upcoming [WHAT YOU OFFER, e.g. small-group yoga classes] as a simple weekly schedule for clients. Use the columns for date, time, session name, total seats and seats booked. For each session, show the open spots in large type, and label it "Full" when no seats are left. Put full sessions at the bottom of each day in a lighter color. Add a short welcome line at the top that says [WELCOME LINE, e.g. Grab a spot and reply to book]. Hide every column with client names, emails or payment details, because this page will be shared publicly. Keep it clean, mobile-friendly and in [BRAND COLORS, e.g. navy and warm white]. ``` ## Step by step 1. Open your bookings sheet in Google Sheets on the web 2. Ask Gemini in Sheets to build a canvas and paste the prompt below 3. Click Publish canvas in the canvas toolbar and turn on automatic republish 4. Copy the link and put it in your email signature or booking page ## What you'll get A client-facing schedule page with live open-spot counts, published on its own link that never exposes the spreadsheet behind it. ## Good to know **How do I share a live class schedule without sharing my spreadsheet?** Build a canvas from your bookings sheet with Gemini in Google Sheets, then publish it as its own link. As of November 2026, the published link is separate from the spreadsheet, so viewers only get read-only access to the page. Pick automatic republish if seats change daily, or a static snapshot if you just want to share one week's schedule. Hide any columns with client names or emails before you publish. **Which AI tools does this work in?** It works in Gemini. On this page, one tap copies the prompt and opens the app, so you just paste. Sheets on the web only. Needs Google AI Pro or Ultra, or Workspace Business Standard or Plus. Rolling out from Nov 11, 2026. **How long does it take?** About 20 minutes to set up, then it updates itself. It's rated "A few steps". There are 4 steps, listed above. **What do I need before I start?** Just your details for 3 blanks: what you offer, welcome line and brand colors. You can skip any, and your AI will ask for them. **What will I get back?** A client-facing schedule page with live open-spot counts, published on its own link that never exposes the spreadsheet behind it. Idea spotted on the official docs, shared by Google Workspace Updates: https://workspaceupdates.googleblog.com/2026/11/publish-sheets-canvas-as-standalone-link.html. The prompt is The Solo Creators' own version. ## Go further Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Website Audit (An evidence-cited, branded audit of any site, ready to hand a client); Slide Deck Designer (A blog post or an idea into a beautiful, on-brand deck. No Canva, no Gamma, no designer). From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.