Add Icons To Your Sheets With a Domain Name

Members-only tutorial

Watch the video and get the practice sheet with membership.

Unlock tutorials
Practice sheet Copy sheet Preview Open Sheet resources unlock with membership.
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!)
23 formulas linked inline Click any highlighted terms to learn more.

<div>&nbsp;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.<br><br>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. How to Easily Add Company Logos to Your Google Sheets Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet Link In Image in Google Sheets

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.<br><br>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. How to Easily Add Company Logos to Your Google Sheets Hand-Designed Elements Button Styles 5 Google Sheet Templates You’ll Get as a Better Sheets Member

You have a link to this sheet.<br><br>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.<br><br>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. How to Easily Add Company Logos to Your Google Sheets Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet Link to Another Sheet in Google Sheets

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.<br><br>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.<br><br>But you can also use this, it's just the image function or formula . . How to Change Font Size

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.<br><br>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. How to Easily Add Company Logos to Your Google Sheets Automatic Screenshot in Google Sheets

And maybe this adds a really cool visual element to like, what did you select ?<br><br>So we'll select this as a range . We'll hit okay. , I have to move my face.&nbsp; 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.<br><br>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. How to Easily Add Company Logos to Your Google Sheets MESSIEST SPREADSHEET MISTAKE

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.<br><br>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.</div> How to Easily Add Company Logos to Your Google Sheets Download Sheet by Clicking Image in Google Sheets

Better Than Happy | Redesign of The Feelings Wheel Best Header Font Ever Learn to Love Your Sheets How Starter Story Designs Data 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 00:05:10 Create Drop Shadows! This makes your dashboards pretty. 00:12:04 10 Things I Hate About Your Spreadsheets Merge Cells for Dashboards 00:05:29 Dark Mode / Better Font Color 00:09:35 Better Font Colors 00:02:45 Magical Things You Can do with Checkboxes in Google Sheets 00:12:31 How To Export Your Beautiful Sheets to PDF 00:04:06 Consider Labels as Opposed to Headers 00:04:02 Add Icons To Your Sheets With a Domain Name 00:04:21 How To Color Cell Blocks So Others Enter Data Easily 00:10:30 Great Sheets! Corona Hiring Sheet 00:10:43 Great Sheets! Community Information Board by Seedtable.com 00:07:35 Roast: Hotel PPC Channel Cost Calculator 00:11:25 Better Header Fonts - Best Fonts To Use In Google Sheets Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell 00:09:49 Basic Keyboard Shortcuts To Speed Up Your Productivity 00:13:44 Basics - 5 Ways to Change Row Height 00:05:08 How to Refer to Other Cells - A1 and R1C1 Explained 00:13:22 Anders Asks: Can I Highlight Whole Row if Certain Columns have text? 00:09:31 Change the Default Font 00:03:33 Biggest Flaw In Dashboards with Dark Colors 00:07:45 Basics - 4 Ways to Change Column Width 00:05:48 Basics - Structure of a Sheet: Index() Row() and Column() 00:06:49 Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets 00:08:55 Use Cmd + Y To Do It Again, and Again, and Again 00:03:03 Create an Auto-Update Sales Chart: Trailing 12 Months 00:09:57 Google Sheet Basics - The Absolute Basics 00:09:48 Secure Your Sheets by BetterSheets.co 00:11:07 How To Create An AutoFill in Google Sheets 00:06:07 Build a Thermometer for Savings Goals Make Your Lists Spicy Hot in Google Sheets 00:01:47 Restrict Access to a Cell if Another Cell is Blank How to Use Smarket 00:03:28 Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets! 00:06:23 Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement! 00:53:31