🚀 Extract Google search results into Google Sheets

Поделиться
HTML-код
  • Опубликовано: 31 янв 2025

Комментарии • 26

  • @naushadshaikh1598
    @naushadshaikh1598 Год назад +3

    Great! How do we get the phone numbers of the businesses in the google sheets?

    • @nodatanobusiness
      @nodatanobusiness  Год назад

      better use our Gmaps solution then: ruclips.net/video/9XGJ8efxmLI/видео.html

  • @bradsherman1563
    @bradsherman1563 Месяц назад

    My Google Search did not pull any Email Addresses and therefore no Chat GPT useable table, why is that?

    • @nodatanobusiness
      @nodatanobusiness  Месяц назад

      we suggest you try this template: nodatanobusiness.com/solutions/email-finder/
      Or you can reach out to us and share your spreadsheet: nodatanobusiness.com/contact-us/

  • @goldendays4873
    @goldendays4873 2 года назад +1

    This great, can you create a image search template variant as well that would keep my subscription!

  • @abilashls007
    @abilashls007 9 месяцев назад

    Great tool, thanks for creating it. I am only able to extract 300 records, is that the limit? I see close to 68K results for my search on Google, how do I pull the rest?

    • @nodatanobusiness
      @nodatanobusiness  9 месяцев назад

      This 300 records cap is set by Google itself (by the way, when you serach on Google, you get a maximum of 30 pages with up to 10 records per page).

  • @nt9616
    @nt9616 Год назад

    good stuff! thanks

  • @isolatedphantom7354
    @isolatedphantom7354 Год назад

    Hi
    This video is very informative and I haven't seen anyone sharing this type of information publicly. Hats of to you
    My question is how can we add email to this. I mean I don't want website link just the email of it. Can we do that?

    • @nodatanobusiness
      @nodatanobusiness  Год назад

      this can be achieved using a boolen search: =IMPORTFROMGOOGLE("xxxx @gmail.com","email","numResults:200")

    • @hadalakitchenequipment7563
      @hadalakitchenequipment7563 Год назад

      @@nodatanobusiness not working..

    • @nodatanobusiness
      @nodatanobusiness  Год назад

      @@hadalakitchenequipment7563 sorry I meant "emails": =IMPORTFROMGOOGLE("xxxx @gmail.com","emails","numResults:200")

  • @manishdhadve7705
    @manishdhadve7705 2 года назад +1

    Thanks for shared this 👌👌👍

  • @BharadwajGiridhar
    @BharadwajGiridhar Год назад

    How do I scrape the next page if I've maxed out the first page with 300 results?

    • @nodatanobusiness
      @nodatanobusiness  Год назад

      no way to go over the first 300 results. Even manually, Google will not let you go over page 30

  • @passionboy7542
    @passionboy7542 Год назад

    nice video !!
    can you extrac term in description ?

    • @nodatanobusiness
      @nodatanobusiness  Год назад

      regex! nodatanobusiness.com/resources/importfromweb-regex-rules-to-clean-up-your-imported-data/

    • @passionboy7542
      @passionboy7542 Год назад

      @@nodatanobusiness thx🙏🙏
      how to update data in excel? think all 2 days there is a MAJ data in excel ?

  • @adrianochan6691
    @adrianochan6691 Год назад

    heyy how do i scrape the industry of a company name? i have to scrape at least 2-3 thousand companies

  • @dhahamthi
    @dhahamthi 2 месяца назад

    I used it just now but I dont understand why the title is not coming

    • @nodatanobusiness
      @nodatanobusiness  2 месяца назад

      Google made a update on its SERP, so we had to review the title selector. It works well now!

  • @jiuzhouyuan6578
    @jiuzhouyuan6578 Год назад

    what are the maximum number of keywords can be searched? can we go in 100k?

    • @nodatanobusiness
      @nodatanobusiness  Год назад

      as much as you want, but google sheets has some limitations: number of functions exectued in parallel is limited. Our advice is to extract up to 3000 queries per day

  • @jsfernald
    @jsfernald 2 года назад

    I keep running into "#PARSING_FAILED" any suggestions?

  • @inesprovac8644
    @inesprovac8644 5 месяцев назад

    merci