Brought to you by:

Hi Reader,

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

Redwoods are incredible trees. Not only for their vast size, but also how long they've been alive.

I was fortunate to bike through the redwoods in 2014 with my brother. Such magnificent trees!

But why am I talking about redwoods?

Well, I wanted a nice picture for the example in today's newsletter. Originally, I was going to use company logos, but then I thought that was rather boring.

I figured we could all use a little dose of nature to start the week. So please enjoy the picture of the Grizzly Giant redwood tree, and perhaps take a moment to be grateful for everything the trees do for us.

Find today's Google Sheets tip below.

➜ News

I.
​Google rolls out Gemini 2.5 Pro Preview, their latest AI model. This model excels at coding, so if you're doing anything with Apps Script, be sure to have a Gemini window open.

​Gemini 2.5 Pro Preview announcement >>​

Brought to you by: Retriever Spend less time in QuickBooks Stuck manually updating reports every month?​ We were too. Until we built Retriever. Retriever is a Google Sheets extension that syncs QuickBooks data directly to Sheets. It makes financial reporting a bit less tedious. With Retriever, you can: Generate QuickBooks reports directly from Sheets Create real-time dashboards that never go stale Build forecasts that update throughout the year And so much more Some lovely accountants and fractional CFOs trust Retriever to fetch their financials and they’ve even said some nice things about us. One called Retriever "a game-changer." Whether you’re new to live spreadsheets or an expert looking for modern features at an affordable price, install Retriever from the Google Marketplace today! Try Retriever for free

➜ Sheets Tip #347: How to create clickable images in your Sheets

This is a tip I first shared in newsletter #81 (way back in December 2019) so it's worth sharing again today. With a new example, of course.

The IMAGE function can be used to display an image in a cell of your Sheet, provided the image is publicly available on the web.

For example, this function displays an image of the Grizzly Giant redwood tree:

The output looks like this in our Sheet:

Now, we can wrap this with a HYPERLINK function to make a clickable image in our Sheet:

The formula is:

Since this is difficult to see with the long URLs, here's a simplified formula to show the setup:

The two URLs don't have to be the same.

Example Use Case

This method is a nice way to include clickable links into a table.

For example, this table of the largest tech companies has clickable logos:

The formula in cell F2 is:

Bonus

A nice way to create these clickable company logos is to combine today's tip with tip #148, which shows you how to generate company logos with formulas.

The formula in column F is:

where the company name is in cell B2.

Happy clicking!

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

Have a great week!

Cheers,
Ben

P.S. Who wants an ice cream? 😂