Hi Reader,

Welcome to the Google Sheets Tips newsletter #382, your Monday morning espresso, in spreadsheet form!

If you feel like the AI wave is moving faster than you can keep up with, you aren't alone.

The gap between "playing with a chatbot" and "building reliable AI systems" feels wider than ever, and that feeling is only increasing with every new AI announcement.

For the past couple of months, I’ve been working on a new course to help address this challenge.

Next Monday, I’m opening enrollment for my new course, 28 Days to Gemini Mastery, that gives you a structured roadmap to help you catch up and lead with AI. The course takes you on a complete transformation journey: moving from treating Gemini as a simple search tool to building reusable systems with custom Gems, NotebookLM, Agents, and more.

I’m currently 80% through recording the video lessons and on track to launch next week. Keep an eye on your inbox for more details.

➜ News

I.
​It's been 10 years since Google's DeepMind AlphaGo program beat the world's best Go player in a competitive match. (By the way, the documentary about it is well worth watching.)

This recent post from DeepMind celebrates how the AlphaGo technology has laid the foundations for many of Google's most impressive AI breakthroughs.

​Read more here >>​

II.
In his "Gassypedia" article, Google Developer Expert Bruce Mcpherson shares his findings from tracking Google Apps Script on GitHub, sharing valuable insights into how developers are using it.

​Read more here >>​

➜ Sheets Tip #382: Your spreadsheet, but make it a website 🌐

Most of us have used the standard "Share" button in Google Sheets. It’s an easy and reliable way to share a Sheet with colleagues for collaborating on a project.

But sometimes, you don't want people viewing the working tabs. You just want them to see the final, polished result as a clean webpage.

Publish to the Web creates a lightweight, read-only version of your sheet that stays synced with your data but lives on its own URL.

Go to the menu: File > Share > Publish to web

It's ideal for public dashboards, sports league tables, or price trackers.

Benefits of publishing a Google Sheet to the web

• Massive Scalability Can handle thousands of simultaneous viewers.
• Lightweight Performance Loads instantly by removing the heavy editing tools.
• Automatic Syncing Updates the public view every five minutes automatically.
• Granular Privacy Publish one specific tab; keep your "working" sheets hidden.
• No Login Required Viewers don't need a Google account to see your data.
• Mobile-Friendly Renders as a clean webpage.
• Easy Web Embedding Embed your data neatly into any website or blog.

Dashboard Example

Here's an example of a dashboard published to the web:

I also use this technique to share my newsletter archive publicly.

The newsletter archive web page is a published Google Sheet.

Pro Tip: Add a dynamic "Last updated" stamp

Sometimes, you might want to add a title that tells the viewer exactly when the data was last refreshed. For example, a comment on the published web page that says "Last updated 2:21 PM 20 March 2026".

We want it to be "live" so we need to use a dynamic formula.

Step 1: We start with the NOW() function to get the current date and time.

Step 2: We wrap that in TEXT() function to make it look pretty.

Step 3: Finally, we join it with a text string (known as concatenation) using the ampersand (&):

In our Sheet, it looks like this:

Now, whenever our sheet recalculates, the published web page shows exactly how fresh the data is.

A Word of Caution

Once a link is published to the web, anyone with that specific URL can see the data. So only publish data that you're comfortable sharing publicly.

You can unpublish a Sheet anytime by going back to the menu: File > Share > Publish to web

And then selecting Stop publishing at the bottom of the publishing menu.

There we have it, that's how turn your Sheet into a website!

If you enjoyed this newsletter, please forward it to a friend who might enjoy it.

Have a great week!

Cheers,
Ben

P.S. Why loading bars take so long 🟩🟩🟩🟩⬜⬜⬜⬜⬜⬜