79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

Add Icons To Your Sheets With a Domain Name

About this Tutorial

Add visual flair to your Google Sheets when sharing company domain information. You’ll learn how to use an undocumented Google API. ( Easier than you think!)

Video Transcript

 Hello. I wanted to share this really cool little thing that I discovered on Twitter actually from my friend James Ivans over on Twitter. He said that Google has this secret, a p i, that you can use to show any website's icon, your site. And he had this U R L here. Well, I tried it in Google Sheets and it works.

So this is a really cool, very simple way to add an icon of any website to your Google Sheets. It adds a visual flare, adds a visual element. You can use it in a lot of different things, maybe for some Instead of using something like Clearbit to grab icons of sales teams or sales prospects, you can use it to design really cool, funky visual elements for your sort of information.

If you want, if you're sharing information, you can create your own social profiles here, links to. Really, really interesting stuff. I'm gonna share this with you right now. If you are watching this video anywhere, if you're watching it as a Better Sheets member, go to the description. You have a link to this sheet.

If you are watching this on YouTube, you get a link in the description as well. All better Sheets members get. Links to every sheet that I ever talk about in any video. So if you're watching on YouTube and there's another video that you're like, I wish I had access to that, become a Better Sheets member now.

But here's the The url. Url, it's just H sheet https s two.google user content.com/s two slash favas. Question mark domain. And then what I'm doing here is I'm adding the domain of any web website and adding the size of 32. You can change this to like 10 or something. Let's see what does that does. But what is really gonna be bounded by is this this, the height of this row here.

So if we increase the height of this row, it will increase this si the size. Icon, but we can do this and see it all is the same, very similar. Even if we do 100, your size doesn't really matter here because it's gonna be bounded by the size of the cell. So I haven't done anything to that. I've just inserted this domain.

But you can also use this, it's just the image function or formula. . What I wanna show you too is that this works even if you just type in the domain. So we're just gonna go here instead of using this formatting this we're just gonna take out these quotes and put in better sheets.co and write.

There you get the icon. Oh. I forgot the s. Better sheets get the same exact icon if you just type in that domain there or if you put it in another cell, sometimes you might want to just get the image, sometimes you want to programmatically. We can also add, say a dropdown menu. And maybe this adds a really cool visual element to like, what did you select?

So we'll select this as a range. We'll hit okay. , I have to move my face.  made my face a little too big today. Okay. All right. So we have this dropdown menu, and I'm just gonna copy and paste this same formula here. And again, it's just gonna take this a 10, whatever is an A 10. It'll pop up here and you'll see how fast it goes.

So if I selected, say twitter.com, boom. It's there. If I select better sheets. There we go. And this logo changes and that adds a really cool little element. This icon just with a domain name. You can use this in a lot of different ways. If you are using this in your Google sheet. After you watch this, please share that with me.

Just email it to me. Des put it in the description not to you. Don't put it in the description, put it in the comments below. If you're using this, share your sheet with the world. Share your use case with the world. I'd really like to see how you use this. I think this is a really fun way to add a nice little, touch that icon to your domain name to your Google Sheet with just the domain name by.




Better Than Happy | Redesign of The Feelings Wheel

Best Header Font Ever


Learn to Love Your Sheets


Sheet Review! 150 Active VCs by LemonIO

Anika Asks: How To Set Text Overflow All The Time


Introducing: Brutal Calendar

Add a Checkbox to Turn on Dark Mode


Create Drop Shadows! This makes your dashboards pretty.



Merge Cells for Dashboards


Dark Mode / Better Font Color



Better Font Colors


Magical Things You Can do with Checkboxes - Google Sheets


Export Your Beautiful Sheets to PDF


Consider Labels as Opposed to Headers



Add Icons To Your Sheets With a Domain Name



Coloring Cell Blocks for Others to Enter Data



Great Sheets! Corona Hiring Sheet



Great Sheets! Community Information Board by Seedtable.com


Roast: Hotel PPC Channel Cost Calculator


Better Header Fonts - Best Fonts To Use In Google Sheets

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell


Basic Keyboard Shortcuts To Speed Up Your Productivity



Basics - 5 Ways to Change Row Height


Anders Asks: Can I Highlight Whole Row if Certain Columns have text?


How to Refer to Other Cells - A1 and R1C1 Explained



Change the Default Font


Biggest Flaw In Dashboards with Dark Colors



Basics - 4 Ways to Change Column Width



Basics - Structure of a Sheet: Index() Row() and Column()


Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets



Use Cmd + Y To Do It Again, and Again, and Again


Create an Auto-Update Sales Chart: Trailing 12 Months



Google Sheet Basics - The Absolute Basics



Secure Your Sheets by BetterSheets.co


How To Create An AutoFill in Google Sheets


Build a Thermometer for Savings Goals


Make Your Lists Spicy Hot in Google Sheets


Restrict Access to a Cell if Another Cell is Blank


How to Use Smarket


Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!