Facebook Twitter Instagram
    Saturday, May 28
    Facebook Twitter Instagram Pinterest LinkedIn
    Pure Tips
    • Home
    • Blogging
    • Software
      • Windows
    • Freelancing tips
      • Upwork
      • Fiverr
    • WpGPLFree
      • WordPress Themes
      • WordPress Plugins
    • Hire Freelancer
    Pure Tips
    Home » Autocomplete Company Name And Domain
    freelancing tips

    Autocomplete Company Name And Domain

    October 25, 2021Updated:January 20, 2022No Comments2 Mins Read
    Facebook Twitter Pinterest LinkedIn Tumblr Reddit WhatsApp
    Autocomplete Company Name And Domain In Google Sheet Using Three Simple Steps.
    Share
    Facebook Twitter LinkedIn Pinterest Reddit WhatsApp

    Autocomplete Company Name And Domain In Google Sheet Using 3 Simple Steps. If you manage the contact list, you sometimes get a list without company name OR company URL.

    Now need the company name or company URL right? There are a million reasons you could need this. It takes a lot of time to do these one by one.

    But from today onwards there is no need to waste time. Here are 3 easy steps to do these things using formula and a ready script, on google sheet.

    So here is how it’s done!

    The steps are written below, but if you are not familiar with Sheets or didn’t understand, I suggest you watch this short video:

    STEP 1 :
    Copy this link:
    https://autocomplete.clearbit.com/v1/companies/suggest?query=
    We are going to use the clearbit autocomplete API, which is FREE.

    It’s pretty simple, you feed it a company name/company domain and it gives you back normalised data with the company name/company domain, logo and domain!!

    STEP 2:
    Now it’s time to generate a set of these requests on your sheet:

    https://autocomplete.clearbit.com/v1/companies/suggest?query=pure tips
    https://autocomplete.clearbit.com/v1/companies/suggest?query=google
    https://autocomplete.clearbit.com/v1/companies/suggest?query=facebook
    https://autocomplete.clearbit.com/v1/companies/suggest?query=linkedin

    Use a CONCATENATE Function. And drag-down a whole column of them.

    STEP 3:
    In Google Sheets, open Tools> Script Editor and copy paste this code:

    function FETCH(url) {
    var response = UrlFetchApp.fetch(url);
    Logger.log(response.getContentText());
    var out = JSON.parse(response.getContentText());
    return out[0][‘domain’];
    }
    function FETCH(url) {
    var response = UrlFetchApp.fetch(url);
    Logger.log(response.getContentText());
    var out = JSON.parse(response.getContentText());
    return out[0][‘what you want’];
    }

    Don’t forget to save this code! (shortcut: CTRL+S) Now you are done!

    You can go back to your sheet.
    In an empty column just apply the function: FETCH (url)
    [*url = the cell with your generated request from step 2].

    Apply the formula to all the generated requests and the script will find the domains for you!! Nice & easy. If you need any help contact us will be happy to help you. Have a great day 🙂 Thanks.

    clearbit company name to domain find company website based on name find industry by company name how to find company website how to get website urls for a list of companies in excel
    Share. Facebook Twitter Pinterest LinkedIn Tumblr Reddit WhatsApp

    Related Posts

    Best email finder and scraper tool Skrapp.io

    April 24, 2020

    Leave A Reply Cancel Reply

    Latest Posts

    Mehabooba Hindi Bangla (LYRICS) – KGF Chapter 2

    April 20, 2022

    Dhal Jaun Main Bangla Lyrics

    April 10, 2022

    Listar V-1.5.3 WordPress Directory and Listing Theme GPL Free

    April 5, 2022

    The Voux V-6.8.6 A Comprehensive Magazine Theme GPL Free

    April 4, 2022

    Engitech V-1.4.1 IT Solutions & Services WordPress Theme GPL Free

    April 4, 2022
    Categories
    • Blogging (5)
    • Fiverr (3)
    • freelancing tips (2)
    • Hire Freelancer (7)
    • Software (5)
    • Uncategorized (17)
    • Upwork (1)
    • windows (4)
    • WordPress Plugins (5)
    • WordPress Themes (852)
    About

    Pure Tips providing you which is very important to know in the present age. Such as freelancing, blogging, technology, software, games.

    DMCA.com Protection Status

    Facebook Twitter Instagram Pinterest LinkedIn

    Subscribe to Updates

    Get the latest creative news from FooBar about art, design and business.

    Recent Comments
    • Ittehad Abdullah on Faststone Capture Serial Key Activation And Registration Code
    • Asepanop on Fiverr English Basic Skills Test Answers 2022
    • Robart Ru on Fiverr English Language Test Answers
    • patekphilippe.io on AIO All In One Runtimes Download | Fix Your All Dll Missing Error
    Copyright © 2021 Pure Tips.
    • Home
    • About Us
    • Contact Us
    • Disclaimer
    • DMCA Policy
    • Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.