How to easily find company domain URL based off company name in Google Sheets

Step 3: Tap on "Tools" then "Script Editor"

Step 4: Enter in this script and then save it...

function FETCH(url) {
return out[0]['domain'];

Step 5: In a cell to the right, enter in =FETCH(URL)

That's it! Weeee!

[mehdifieloux]

works very fine for me, including names with spaces (600 urls retrieved)... it won't work when the company name does not match the real company name (ie, commercial name versus registred name, this kind of things) ... great tutorial anyway

[treyw]

Thank you for taking the time out of your day to post this and help other people out 💯

[campero_mg]

This was such a helpful video! I love learning tricks/tips as an emerging IT professional.

[emiljohansson]

As others have pointed out, the function you are using is called CONCATENATE and not CONCENTRATE. Just if anybody else should wonder why they don't have that function.

[jessicapigwinsica]

doesn't work. my error says
TypeError: Cannot read properties of undefined (reading 'domain') (line 5).

[KushVyas-mc]

It works like a charm. Thank you so much for sharing this.

[jaapjanlammers]

Ha dude, this is perfect!! Awesome solution. A lifesaver !!

[rajsayyad]

How to get the company's address, phone number listed on Google?

[MrCiako]

Thanks, still up
Don't forget to write "=Concatenate" and to save your code
Test on famous company

[TJGottfried]

Anyone else not see FETCH as a function in their Sheets?

[bestprintfactorytonercartr]

realy need help brother ....


#ERROR!

[maamunmazrui]

Hi,
I tried to run the code in script editor but I got an error. According to the debug feature, it was in the second line

[sumanthiyengar]

FETCH doesn't work anymore I guess, what else should we do?

[muitasaudade]

Why do you say concentrate and then you write concatenate?

[jacks-wrfd]

Its very useful and how can I go for it get email id's

[dubaholic-lr]

Thank you for the video, however i am getting an error message (Syntax error: SyntaxError: Unexpected end of input line: 5 file: Code.gs)

I added a ) at the end, that didn't work. Then i deleted that and added a } at the end, but still the same results. Is there a way to solve this?

Maybe important to note also: i do not have the option to choose "Script Editor" under the Tools section.

Thanks again!

[babablacksheep-hh]

its not concentrate its concatenate which means to link together

[neerajvp]

Thanks for the video. However, I'm unable to find the script editor option in my account. Is this available only for Google Workplace accounts?

[fadelellaherrami]

good, but code editor, in 2024 exist in extensions, not in tools, thak you,

[introducerimpressor]

some companies and domains are not matching