App Icon
ImportFromWeb imports data from any websites into your spreadsheet using a simple function. It's like ImportXML but on steroids 💥
Informações atualizadas:20 de maio de 2022
Compatível com:
54.802
Visão geral
Write =IMPORTFROMWEB( url, path_to_content ) in your spreadsheet and import any data from any website !

ImportFromWeb is a simple function that extracts data from any website directly into your spreadsheets in real time. It’s web scraping directly in Google Sheets… no technical knowledge required!

ImportFromWeb is a good alternative to ImportXML, ImportHTML, ImportFeed, and ImportData. 
Our add-on overcomes ImportXML limits offering to load Javascript-powered websites and to scrape most websites with ease. Additionally, it supports up to 50 URLs per function with as many data points as you want.
ImportFromWeb, your perfect scraper for Yahoo Finance, Google, Instagram or Amazon !

📌 HOW DOES IT WORK ?

All you have to do is to describe the URL and the path to the data you want to output and then simply call the function this way =IMPORTFROMWEB( url, path_to_data ) 

As with ImportXML, the data to extract can be described using XPath or CSS selectors. We also offer you built-in selectors so that you don’t have to struggle with the page source code.  

Here are 2 nice examples : 
Scrape market data from Yahoo Finance typing =IMPORTFROMWEB(“https://finance.yahoo.com/quote/AAPL”,  "dividend, price, marketCap")
Scrape product data from Amazon typing =IMPORTFROMWEB(“https://www.amazon.com/dp/B018TE4Q30”, "image, title, sale_price")

📌 MAIN FEATURES

✓ High compatibility - scrapes JavaScript-rendered websites
✓ Powerful - uses proxy rotation to scrape the tough-to-scrape websites
✓ High volume - supports thousands of data points per spreadsheet
✓ Scalable - ready to be used hundreds of times per sheet 
✓ Flexible - works with CSS selectors or XPath queries to describe the data to be captured OR with our built-in selectors for major websites (Amazon, Google, Yahoo Finance, Instagram…)
✓ Customizable caching - stores results to prevent constant recalculations
✓ Localization - fetches results displayed in other countries via our built-in proxies
✓ Extras - compatible with regular expressions to extract/replace data
✓ Tries to automatically convert data as numbers and dates when possible 
✓ Easy onboarding thanks to our ready-to-use templates
✓ and much more to come ! 

📌 POPULAR USE CASES

With Import From Web you can easily :
✓ Import and monitor stock values from Yahoo Finance, Bloomberg or Nasdaq
✓ Access and aggregate crypto data from Binance, Coinbase or CoinMarketCap 
✓ Scrape search results in Amazon, Google, YouTube, Reddit, and more
✓ Analyze website links for SEO
✓ Extract e-commerce data such as prices and customer reviews
✓ Track the latest trends and influencers on Twitter, Tiktok or Instagram 
✓ Gather data from Wikipedia pages

... and import any other public web data. The sky’s the limit!

Here are some websites our users love to import data from : Yahoo Finance, Bloomberg, Google, Amazon, Instagram, Youtube, NSE India, Facebook, Seeking Alpha, Market Watch, Linkedin, Zillow, Coin Market Cap…

📌 PRIVACY

ImportFromWeb is a Google Workspace add-on that has successfully passed Google’s security review. The add-on requires minimal permissions. Your data remain at all times your own property and ImportFromWeb will never transfer nor sell them to 3d parties. 
We will never save the content of your Google Sheets.

📌 PRICING

Enjoy for free the add-on the 1st month with 1000 requests.
Then, choose between our different plans according to your needs. 

📌 SUPPORT

✓ Have a look at our repository of resources and demos at https://nodatanobusiness.com/resources/importfromweb/
✓ Check out our ready-to-use templates for the most popular platforms
✓ Browse our tutorials on our Youtube channel 
✓ Contact us and we’ll help you to get the most of our add-on ! support@nodatanobusiness.com 
 

--------------

Many users of Import JSON, Supermetrics, Mixed Analytics, KPI bees, DataConnector, SheetGo, Google Analytics, Autocrat and Power Tools already love our scraper.

ImportFromWeb, among the best add-ons for Google Sheets !

Read more at https://nodatanobusiness.com/importfromweb/
Informações adicionais
PreçosPago com teste gratuito
Política de Privacidade
Termos de Serviço
O ImportFromWeb | Web scraping in Google Sheets pedirá as permissões abaixo. Saiba mais
O ImportFromWeb | Web scraping in Google Sheets precisará de acesso à sua Conta do Google
Isso permite que o ImportFromWeb | Web scraping in Google Sheets faça o seguinte:
Ver e gerenciar planilhas nas quais este aplicativo foi instalado
Exiba e execute conteúdo da Web de terceiros em prompts e barras laterais dentro dos aplicativos do Google
Conectar a um serviço externo
Permitir que este aplicativo seja executado quando você não estiver presente
Ver o endereço de e-mail principal da sua Conta do Google
Ver suas informações pessoais, inclusive aquelas que você disponibilizou publicamente
Comentários
Idioma:
Ordenar por:
Profile Picture
Felipe Verissimo
18 de fevereiro de 2022
é caro, mas utilidade deste recurso é fantástica. recentemente tive problemas com algumas formulas, e fui atendido muito rapidamente pelo suporte, que resolveu prontamente.
Esta avaliação foi útil?
Sim
Não
Profile Picture
DANIEL CERDEIRA
14 de outubro de 2020
Good but expensive. Should increase the daily request on free mode.
Esta avaliação foi útil?
Sim
Não
Profile Picture
Alexandre Sampaio
17 de março de 2021
SOLVE ALL MY PROBLEMS!!!!
Esta avaliação foi útil?
Sim
Não
Profile Picture
Um usuário do ImportFromWeb | Web scraping in Google Sheets
5 de junho de 2020
Very productive tool.
Esta avaliação foi útil?
Sim
Não
Profile Picture
Conversa sobre a Vida do Zé
26 de setembro de 2020
Not free. It does good but the month price is still high.
Esta avaliação foi útil?
Sim
Não
Profile Picture
Bwhy _
22 de dezembro de 2020
A Lot expensive in Brazil.
Esta avaliação foi útil?
Sim
Não
1-6 de 6
Pesquisa
Limpar pesquisa
Fechar pesquisa
Google Apps
Menu principal