NoDataNoBusiness
NoDataNoBusiness
  • 44
  • 253 238
How to scrape Phone Numbers from Google Maps?
Are you looking for a Google Maps scraper that enables you to scrape phone numbers?
Learn how to scrape this data using a simple formula on Google Sheets.
This tutorial shows you step-by-step how to collect Google Maps business phone numbers.
▬ Useful Links ▬▬▬▬▬▬▬▬▬▬
Install ImportFromWeb: workspace.google.com/marketplace/app/importfromweb_web_scraping_in_google_she/278587576794
To access the google sheets template: docs.google.com/spreadsheets/d/1Tx4muAvlbnpQeVAzApZ5TR6OilxlcRhtNXgcYRGFKQY/
To get the list of Google Maps selectors: nodatanobusiness.com/resources/importfromweb-google-maps-data-selectors/
▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
00:05 - Install IMPORTFROMWEB
00:19 - Open a new google sheets and activate ImportFromWeb
00:47 - Input the Google Maps Search URL
00:55 - Input the headers
01:05 - Write the =IMPORTFROMWEB() formula
01:30 - Narrow the search results!
#googlesheets #automation #googlemaps #scraping #howto
Переглядів: 172

Відео

How to generate thousands of keywords ideas?
Переглядів 76Місяць тому
Learn how to find thousands of keywords ideas from Google Sheets. This tutorial shows you step-by-step how to extract Google Search suggestions using a simple function. No technical knowledge required! ▬ Google Search Data selectors ▬▬▬▬▬▬▬▬▬▬ In this video, we used the suggestions selectors. Find out the complete list of selectors for any Google Search page: nodatanobusiness.com/resources/impo...
Find hundreds of Social Media Profiles in seconds with Google Sheets
Переглядів 1732 місяці тому
Learn how to find Social Media Profiles with Google Sheets. 2 methods to scrape social media profiles: -Use the Social Media Profiles finder template: docs.google.com/spreadsheets/d/1xQYxYWM3g8mSFghBIaGnVN0KKbb9ENGup8fw1xaBslc/ OR -Follow the step-by-step tutorial video. No technical knowledge required! ▬ Google Search Data selectors ▬▬▬▬▬▬▬▬▬▬ In this video, we used google search queries combi...
How to scrape Walmart Product data?
Переглядів 2102 місяці тому
Learn how to extract Walmart Product data with Google Sheets. 2 methods to scrape Walmart product data: -Use the Walmart Product Scraper template: docs.google.com/spreadsheets/d/1-9DTHHL290MG3jUMEwPqJbpPFp6m58Qn4F2ZG_MlYOU/ OR -Follow the step-by-step tutorial video. No technical knowledge required! ▬ Walmart Data selectors ▬▬▬▬▬▬▬▬▬▬ In this video, we used the title, price, buybox_winner, rati...
Scrape Amazon Product variations using Google Sheets
Переглядів 1643 місяці тому
Learn how to extract Amazon Product variations with Google Sheets. 2 methods to track Amazon variations data: -Use the Amazon Variation Scraper template: docs.google.com/spreadsheets/d/1raGzt8Y0P9PfzKKqWnxFwt6UT5DWuNVEf2O0ricG870/ OR -Follow the step-by-step tutorial video. No technical knowledge required! ▬ Amazon Data selectors ▬▬▬▬▬▬▬▬▬▬ In this video, we used the variations_asins, color_nam...
Get REAL-TIME Amazon Keywords Rankings (with a free template)
Переглядів 2394 місяці тому
Learn how to track live Amazon Keywords Rankings with Google Sheets. 2 methods to track Amazon Keywords rankings: -Use the Amazon Keywords Ranking tracker template: docs.google.com/spreadsheets/d/1nLgaiZ9GqA9UeONYaf5fQ3pLuyRZniaoVT4FjP5a3r8/ OR -Follow the step-by-step tutorial video: 1) Enter your ASINs in A1. 2) Write the keywords in B3:E3. 3) Build the Amazon Search URLs in B2:E2 with the =C...
How to find company domain URL based on company name with Google Sheets
Переглядів 1,7 тис.5 місяців тому
Learn how to extract company domain URLs from company names with Google Sheets. This tutorial shows you step-by-step how to extract domain URLs data using a simple function. No technical knowledge required! Enter a list of company in A2:A, then write the link selector. Below the selector, write the =IMPORTFROMGOOGLE() formula. The num_results option narrow the function to retrieve only the firs...
How to extract Amazon Product Ratings | [2024 Web Scraping Tutorial]
Переглядів 67410 місяців тому
Learn how to extract Amazon Ratings data to Google Sheets. This tutorial shows you step-by-step how to collect Amazon Ratings using a simple function. No technical knowledge required! ▬ Amazon Data selectors ▬▬▬▬▬▬▬▬▬▬ In this video, we used the rating and reviews_count selectors. Find out the complete list of selectors for any Amazon Product page: nodatanobusiness.com/resources/importfromweb-a...
How to extract data from Google Maps | How to extract Google Maps Leads
Переглядів 4,3 тис.10 місяців тому
Are you looking for a Google Maps scraper that enables you to scrape businesses and additional information such as phone numbers and addresses? Learn how to scrape these data using a simple formula on Google Sheets. This tutorial shows you step-by-step how to collect Google Maps business data. ▬ About ▬▬▬▬▬▬▬▬▬▬ Google Maps has become the default go to website for getting useful information abo...
Monitor Google My Business Ratings from Google Maps
Переглядів 13611 місяців тому
Learn how to scrape Google My Business Ratings using a simple formula on Google Sheets. This tutorial shows you step-by-step how to collect business ratings data. ▬ About ▬▬▬▬▬▬▬▬▬▬ Google Maps has become the default go to website for getting useful information about all sorts of locations. It holds a massive amount of accurate data and useful information and that is the reason why it is used b...
Extract product listings of any Amazon search directly from Google Sheets
Переглядів 89911 місяців тому
Learn how to extract Amazon search page data to Google Sheets. This tutorial shows you step-by-step how to collect Amazon search data using a simple function. No technical knowledge required! ▬ Amazon Data selectors ▬▬▬▬▬▬▬▬▬▬ In this video, we used the asin, title, price, rating and reviews_count selectors. Find out the complete list of selectors for any Amazon Product page: nodatanobusiness.c...
Monitor real-time Amazon prices from Google Sheets
Переглядів 2,5 тис.11 місяців тому
Monitor real-time Amazon prices from Google Sheets
Monitor hundreds of Amazon BSR directly from Google Sheets
Переглядів 76711 місяців тому
Monitor hundreds of Amazon BSR directly from Google Sheets
Copy a Table from a Webpage
Переглядів 205Рік тому
Copy a Table from a Webpage
Monitor Amazon Product reviews directly from Google Sheets
Переглядів 312Рік тому
Monitor Amazon Product reviews directly from Google Sheets
Scrape Google Search results (no coding skills required!)
Переглядів 445Рік тому
Scrape Google Search results (no coding skills required!)
Collect the opening hours on a list of stores
Переглядів 382Рік тому
Collect the opening hours on a list of stores
Extract hundreds of Instagram profiles to Google Sheets
Переглядів 2 тис.Рік тому
Extract hundreds of Instagram profiles to Google Sheets
Extract Google People Also Ask questions into Google Sheets.
Переглядів 989Рік тому
Extract Google People Also Ask questions into Google Sheets.
Extract hundreds of Amazon product images directly to Google Sheets
Переглядів 1,7 тис.Рік тому
Extract hundreds of Amazon product images directly to Google Sheets
Collect and monitor the BuyBox winner on hundreds of Amazon products
Переглядів 425Рік тому
Collect and monitor the BuyBox winner on hundreds of Amazon products
Collect real-time PPC data on Amazon with Google Sheets
Переглядів 442Рік тому
Collect real-time PPC data on Amazon with Google Sheets
Extract data from multiple YouTube videos into Google Sheets
Переглядів 2,4 тис.Рік тому
Extract data from multiple UA-cam videos into Google Sheets
🚀 Extract Amazon Reviews into Google Sheets - Amazon Reviews scraper
Переглядів 3,5 тис.Рік тому
🚀 Extract Amazon Reviews into Google Sheets - Amazon Reviews scraper
🚀 Extract any Amazon Search into Google Sheets - Amazon Search scraper
Переглядів 6 тис.Рік тому
🚀 Extract any Amazon Search into Google Sheets - Amazon Search scraper
🚀 Extract Google Maps places into Google Sheets - Google Maps scraper
Переглядів 29 тис.Рік тому
🚀 Extract Google Maps places into Google Sheets - Google Maps scraper
🚀 Tutorial: Get Started with ImportFromWeb
Переглядів 11 тис.Рік тому
🚀 Tutorial: Get Started with ImportFromWeb
🚀 Extract Google search results into Google Sheets
Переглядів 18 тис.2 роки тому
🚀 Extract Google search results into Google Sheets
Import hundreds of Amazon products in a spreadsheet
Переглядів 12 тис.2 роки тому
Import hundreds of Amazon products in a spreadsheet
How to scrape Amazon data easily into Google Sheets | Amazon Scraper
Переглядів 9 тис.3 роки тому
How to scrape Amazon data easily into Google Sheets | Amazon Scraper

КОМЕНТАРІ

  • @mostafamahmoudabdelaziz9470
    @mostafamahmoudabdelaziz9470 Годину тому

    Every refreshing will consume credits for the same url how can prevent it

  • @mostafamahmoudabdelaziz9470
    @mostafamahmoudabdelaziz9470 День тому

    Can we monitor the buy box winner?

    • @nodatanobusiness
      @nodatanobusiness День тому

      sure you can! check this out: nodatanobusiness.com/solutions/amazon-buybox-winner_collector/

    • @mostafamahmoudabdelaziz9470
      @mostafamahmoudabdelaziz9470 20 годин тому

      @@nodatanobusiness Hi i did not know that every refreshing of amazon buy box winner will consume a credit and that will not suitable for me because i need to check it every 1 hour and i have 400 asin that will need a huge credit for the same urls , can you help me with this

  • @ManjiriSrivastava
    @ManjiriSrivastava 7 днів тому

    Hi, this is very user friendly dashboard. I tried it by adding views and count columns and it providing data for verified profiles successfully. Similarly I tried this for not verified instagram profiles by doing same setting in glossary tabs. it seems not working. If possible check it. Thankyou.🙂👍

    • @nodatanobusiness
      @nodatanobusiness 5 днів тому

      Thank you for your feedback! Our support team can assist you: wuld you mind sharing your use case here? nodatanobusiness.com/contact-us/

  • @mujeerkhan8543
    @mujeerkhan8543 11 днів тому

    How can I download the prices of books sold on Amazon on a excel sheet?

    • @nodatanobusiness
      @nodatanobusiness 11 днів тому

      You can use the Google Sheets template that we release on this page: nodatanobusiness.com/solutions/amazon-price-observatory-tool/

  • @DieEineSalzstange
    @DieEineSalzstange 16 днів тому

    Is this still working? To import many products from search pages like in this video?

    • @nodatanobusiness
      @nodatanobusiness 15 днів тому

      Of course it works!! If you need any help, feel free to reach out to us: nodatanobusiness.com/contact-us/

  • @pradeeprajha
    @pradeeprajha 22 дні тому

    not working

  • @TheGamerboy1911
    @TheGamerboy1911 29 днів тому

    its not working its saying all slectors are NULL

  • @applicationsreviews
    @applicationsreviews Місяць тому

    I'm an avid fan of your application and love how you have a link to each one of the templates for us to use.

  • @TJ_Biz
    @TJ_Biz Місяць тому

    How large of a dataset can this extension process?

  • @melowmelowclub2329
    @melowmelowclub2329 Місяць тому

    wow.. thanks!

  • @cupricrafts
    @cupricrafts Місяць тому

    all I get is ERROR following your vid exactly

  • @RajeshJain-z1e
    @RajeshJain-z1e Місяць тому

    How can I extract email please let me know 😅 trying since a very long

    • @nodatanobusiness
      @nodatanobusiness Місяць тому

      You can extract emails from websites with this solution: nodatanobusiness.com/solutions/email-finder/ Or you can contact us here to build a custom solution to extract emails from social media profiles: nodatanobusiness.com/contact-us/

  • @gianlucatronyta
    @gianlucatronyta Місяць тому

    For price search

  • @inesprovac8644
    @inesprovac8644 Місяць тому

    merci

  • @patrickprospa3136
    @patrickprospa3136 Місяць тому

    merci

  • @chrisder1814
    @chrisder1814 Місяць тому

    Hello can I only import "Title view_counts likes_count published_date views_count" ?

    • @nodatanobusiness
      @nodatanobusiness Місяць тому

      You have the full list of selectors on this page: nodatanobusiness.com/resources/importfromweb-youtube-video-selectors/#1-video-information

    • @chrisder1814
      @chrisder1814 Місяць тому

      @@nodatanobusiness When I'm in free mode, do I have one request limited per day or is it a request limited for life?

  • @chrisder1814
    @chrisder1814 Місяць тому

    Hello can I only import : Title Description Thumbnail Playlist Audience Age restriction Related Video this 7 metadata?

  • @Kieranerrington
    @Kieranerrington 2 місяці тому

    What's the maximum it's able to scrape from a google search? I just made num_result = 1000 but it only listed 200, how can i continue this?

    • @nodatanobusiness
      @nodatanobusiness 2 місяці тому

      Google Search narrows to 300 results maximum for each query. Unfortunately this limit is set by Google and cannot be altered. We invite you to see our FAQ: nodatanobusiness.com/faq/how-can-i-extract-more-google-search-results-than-the-first-10-results/ However, if you still get 200 results, it means that Google itself gives 200 results, so we can't do anything about this problem. You can vary the query and test some additional words to get more results.

  • @CrazyAznKTGuides
    @CrazyAznKTGuides 2 місяці тому

    Any idea why sale_price would return two numbers? How do I fix that?

    • @nodatanobusiness
      @nodatanobusiness 2 місяці тому

      Can you send the product URL with this problem please ? So we'll make some tests and see 😉

  • @patrickprospa3136
    @patrickprospa3136 2 місяці тому

    merci

  • @ShelliG
    @ShelliG 2 місяці тому

    30-day trial with 200 credits for free. After that, lowest plan is Starter $19 per month, billed monthly.

  • @aryarajeev9033
    @aryarajeev9033 2 місяці тому

    As a beginner i cant understand anything

  • @niketpandey6566
    @niketpandey6566 2 місяці тому

    Great Video

  • @AlexClark-tp8pf
    @AlexClark-tp8pf 2 місяці тому

    Legendary!

  • @ashleywallis3499
    @ashleywallis3499 3 місяці тому

    Bonjour, très interssant comme video. Sommes nous en mesure d'isoler les paramètres: adresse, ville , province, code postal, pays et numero de telephone ?

    • @nodatanobusiness
      @nodatanobusiness 3 місяці тому

      Oui bien sûr, nous vous invitons à aller voir comment faire directement sur notre page solution: nodatanobusiness.com/solutions/google-maps-scraper/

  • @james.svetec
    @james.svetec 3 місяці тому

    How frequently does the data get refreshed?

    • @nodatanobusiness
      @nodatanobusiness 3 місяці тому

      We extract live data, and each time you run the function, data are updated. You can see more information on this page: nodatanobusiness.com/resources/importfromweb-how-to-control-when-the-data-updates/

  • @kafilurrahman
    @kafilurrahman 3 місяці тому

    Can you please make a video on AliExpress product listing to Google sheet.

    • @nodatanobusiness
      @nodatanobusiness 3 місяці тому

      Stay tuned! It's on our roadmap. You can also use the AliExpress Product scraper from the website : nodatanobusiness.com/solutions/aliexpress-product-scraper/

  • @kafilurrahman
    @kafilurrahman 3 місяці тому

    Amazon store link is not working when i try to list of a store products. Can you please tell me how to make a product list of a store.

    • @nodatanobusiness
      @nodatanobusiness 3 місяці тому

      Please share your spreadsheet with our client support and we'll have a look! nodatanobusiness.com/contact-us/

  • @EcommerceConsultation
    @EcommerceConsultation 3 місяці тому

    which version of excel is this

    • @nodatanobusiness
      @nodatanobusiness 3 місяці тому

      this is made with Google Sheets (the "Google excel"). More info here: nodatanobusiness.com/

  • @samuelhamblin7535
    @samuelhamblin7535 3 місяці тому

    Why is zombie invasion listed in your terms of service?

  • @MovieManiaVault
    @MovieManiaVault 4 місяці тому

    How to go for specific data like i want to find zip code on a website and there are multiples services but i need the data of specific service and want that data on sheet on a condition if service availability rate is equal to or more than 96%

    • @nodatanobusiness
      @nodatanobusiness 4 місяці тому

      Interesting question and use case: we would be pleased to help you if you contact our support sharing your spreadsheet and all the details you have: nodatanobusiness.com/contact-us/

    • @MovieManiaVault
      @MovieManiaVault 4 місяці тому

      @@nodatanobusiness i tried to reach you but didn't got email verification code.

    • @nodatanobusiness
      @nodatanobusiness 4 місяці тому

      @@MovieManiaVault What verification code are you refering to? If you post your question on your form, we'll receive it and get back to you

    • @MovieManiaVault
      @MovieManiaVault 3 місяці тому

      @@nodatanobusiness ok you reached but not with solution

  • @前田日明-w8u
    @前田日明-w8u 4 місяці тому

    Thank you for the useful software. I'm trying to use this add-in in Japan, and when I use the ”full_adress” variable, the evaluation comes back in English instead of local language Japanese, so I'm having trouble. Can you help us please.

    • @前田日明-w8u
      @前田日明-w8u 4 місяці тому

      Nesting your function with a Google translate function solved the problem. Thank you.

    • @nodatanobusiness
      @nodatanobusiness 4 місяці тому

      @@前田日明-w8u awesome, thanks for letting us know!

  • @fs3662
    @fs3662 4 місяці тому

    I don't see the option =IMPORTFROMWEB

  • @RashidAslam-kw6qf
    @RashidAslam-kw6qf 4 місяці тому

    Is this Formula applicable with Email Extractor???

  • @worldofgame7002
    @worldofgame7002 4 місяці тому

    Its pop up 'Total_Quota_Reached' ... I just used 2 days.. and i used for 200 links only... Because it's said 1 month free trial... Can you help on this 😢

    • @nodatanobusiness
      @nodatanobusiness 4 місяці тому

      For Google Maps, 1 request costs you 10 credits, so with a free trial you can scrape 100 Google Maps URLs. Thus, 200 Google Maps equals to 2000 credits. Don't hesitate to look at the pricing grid according to your needs here : nodatanobusiness.com/importfromweb-pricing/

  • @vishakhanehe6508
    @vishakhanehe6508 4 місяці тому

    Throws error only while installing

    • @nodatanobusiness
      @nodatanobusiness 4 місяці тому

      please share your spreadsheet with our team and we will help you: nodatanobusiness.com/contact-us/

  • @Monika-ku1jw
    @Monika-ku1jw 4 місяці тому

    how can we convert these scrapped data's in excel sheet

    • @nodatanobusiness
      @nodatanobusiness 4 місяці тому

      here's how to export your data set from google sheets to excel: nodatanobusiness.com/faq/how-can-i-extract-the-results-to-excel-how-can-i-extract-my-data-set-to-excel/

  • @phuonghua2644
    @phuonghua2644 4 місяці тому

    It's so helpful with me, but when i try, i fill with Link GG map, it's loading very long and the result is "#URL_NOT_VALID". I don't know how to fix it

  • @ArkStone-co4oy
    @ArkStone-co4oy 4 місяці тому

    dosen work

  • @OvaisFareed
    @OvaisFareed 4 місяці тому

    How to get the prices for any other ecommerce platform?

    • @nodatanobusiness
      @nodatanobusiness 4 місяці тому

      all our e-commerce ready to use solutions can be found on this page: nodatanobusiness.com/needs/e-commerce/ For other platforms, we can create a custom solution (please reach out to us here: nodatanobusiness.com/contact-us/)

  • @019GARGIADHIKARI
    @019GARGIADHIKARI 4 місяці тому

    CAN YOU GIVE THE FILTER

  • @babarAli-le5qv
    @babarAli-le5qv 5 місяців тому

    I'm facing parsing fail error when I try to importfromweb, how to solve?

  • @babarAli-le5qv
    @babarAli-le5qv 5 місяців тому

    I'm facing parsing fail error when I try to importfromweb, how to solve?

  • @babarAli-le5qv
    @babarAli-le5qv 5 місяців тому

    I'm facing parsing fail error when I try to importfromweb, how to solve?

  • @babarAli-le5qv
    @babarAli-le5qv 5 місяців тому

    I'm facing parsing fail error when I try to importfromweb, how to solve?

    • @nodatanobusiness
      @nodatanobusiness 5 місяців тому

      You can reach out our customer support at this address: support@nodatanobusiness.com Please share the link to your spreadsheet in the email so we can have a close look at your =IMPORTFROMWEB() formula

    • @MessageofIslam17
      @MessageofIslam17 15 днів тому

      Iimit

  • @babarAli-le5qv
    @babarAli-le5qv 5 місяців тому

    I'm using this regularly but now I'm facing "PARSING FAIL", How to solve?

    • @nodatanobusiness
      @nodatanobusiness 5 місяців тому

      You can reach out our customer support at this address: support@nodatanobusiness.com Please share the link to your spreadsheet in the email so we can have a close look at your =IMPORTFROMWEB() formula

  • @enzogustiliano4253
    @enzogustiliano4253 5 місяців тому

    Why I've the error #parsing_field ???

    • @nodatanobusiness
      @nodatanobusiness 5 місяців тому

      This error may arise sometimes when the scraper fail at fetching the webpage. In that case, if you have the ImportFromWeb sidebar open, the formula will be triggered till it succeeds.

  • @weezhengcher9766
    @weezhengcher9766 5 місяців тому

    do I need to manually input the urls? or is there an automated way to just put in all the urls

    • @nodatanobusiness
      @nodatanobusiness 5 місяців тому

      you have to manually input the URLs. But you can also use this scraper so you input a query and get back all the associated places: nodatanobusiness.com/solutions/google-maps-scraper/

  • @amarantarodriguez748
    @amarantarodriguez748 5 місяців тому

    Hello! thank you very much!! Explanation and getting the extension and the add on, excellent! But when I tried to use it it in my sheet, I got the error #ALL SELECTORS RETURN NULL when all of them are right. I carefully did the formula, adding each cell, etc and yet even just with one selector I got this error. =(,,, Can you please help?

    • @nodatanobusiness
      @nodatanobusiness 5 місяців тому

      we can help for sure! Can you please write to us using this form: nodatanobusiness.com/contact-us/ And please make sure to share your spreadsheet so we can easily detect what's going on

  • @syednoor1230
    @syednoor1230 5 місяців тому

    can i pull out channel country origin?