Easy web scraping: Yahoo Finance, Stock Market, Amazon, YouTube™, Dividend Data, Stock Price Data, Crypto Price, Facebook, Nasdaq, Binance, Bloomberg - Scraper to crawl website data into Google Sheets
Adatlap frissítve:2024. november 13.
A következőkkel működik:
315 E+
Áttekintés
➤ ➤ ➤ FEATURES ➤ ➤ ➤ 

This add-on is broadly applicable like a Swiss army knife! You have data outside of Google Spreadsheet™ which should be imported? You have found the perfect companion.

Our addon consists of multiple modules, each one dedicated to a specific data import task:

1) SCRAPER
Use the web scraping formula: =SCRAPE(url, selector, options) to scrape data from any website.

The big advantage over =IMPORTXML(), IMPORTHTML(), IMPORTFEED() and IMPORTDATA() is that CSS selectors can be used. CSS selectors are more popular than XPath selectors. It is also a good alternative to GOOGLEFINANCE().

You can import any data from any website with this formula, for example: Amazon, Google Search™, Yahoo Finance, Google Maps™, Instagram, Bloomberg, Nasdaq, YouTube™, Reddit, Twitter (X), TikTok, NSE India, Facebook, Seeking Alpha, Market Watch, LinkedIn, Zillow - any public web data can be scraped!

Many users are especially interested in crawling the following crypto websites: CoinMarketCap / Coin Market Cap, MercadoBitcoin, Poloniex, Block, Coinigy, CoinLayer, Livecoin, Blockchain, Cryptonator, Nexchange, Zloader, CoinRanking, Coinlore, Coinlib, CoinDesk, ICObench, Binance, BitcoinAverage, Coinbase, CryptoStandardizer, IEX, Bitfinex, Coinpaprika, BitcoinCharts, Coinbase Pro, CoinGecko, WorldCoinIndex, NiceHash, Bitmex, Bittrex, Gemini, CoinAPI, Messari, CryptUnit, WhatToMine, Nomics, CryptoCompare, Paradigm, The Block, Coinmetrics, Cointracking, Shrimpy, CCXT, Chainz, Crypto51, Earn, Etherscan, Ethplorer, OpenFIGI, Cryptowatch, FOAM, Amberdata, Cryptosheets, Bloxy, Bitwise, Kryptocal, Tokeninsight, Kaiko, Flipside Crypto, Huobi, LocalBitcoins, Kraken, Covalent, TokenAnalyst, DeFi Pulse, Compound, Alethio, Decred Data, Kyber Network, LoanScan, CryptoRank.io, CoinCodex, LedgerX, Deribit, ContractMarketCap, Dapp.review, StableCoinIndex, FTX, DEX.AG, Lunarcrush, dYdX, CryptoQuant, Coinbase Prime, GlassNode, TzStats, Binance Dex, TronScan, 1inch, XRP Ledger, 0xTracker, Radar Relay, Cryptocontrol, Binance US, Coinbase Custody, Smartable Coronavirus API, EOD Historical Data, Bybit, ByteTree, Covidtracking, Bitstamp, Bitflyer, itBit, OKEX, Paraswap, QUME, OmniAPI, Delta Exchange, CoinCodeCap, Crypto.com, 0xAPI, Blocklytics, Blockset, AdaEx, Equos, Paxful, Blockstream, CrossTower, Minerstat, The Graph, Yearn API, QTUM, Infura, IntoTheBlock, Vantage Crypto, Xangle, Iconomi, Blockcypher, Masternodes, IDEX, Uniswap, Coindar, Cryptohopper, KuCoin, DragonGlass, NeoScan, Stellar, TokenView, CryptoAPIs.io, Beaconchain, WAVES, Bonfida, OpenSea, Decentraland, GrinMint, Polkascan, TokenLists, Uniswap.

Extract data from any website with the help of our crawler like: dividend, price, market cap, title, sale price, stock price, crypto data, customer reviews etc.

Our addon is especially helpful for the following fields: SEO, e-Commerce (e.g. scrape Amazon), trend monitoring, eCommerce competitor analysis, stock trader (e.g. scrape dividend data, scrape stock price), Social Media marketing (e.g. scrape Facebook), crypto trader (e.g. scrape crypto price, create your own cryptosheet and cryptoreports) - import data from any website!

Users of ImportFromWeb, ImportJSON, Supermetrics, Mixed Analytics, KPI bees, DataConnector, SheetGo, Google Analytics™, Autocrat and Power Tools also love our addon.

2) CALENDAR TEMPLATES
Programmatically import calendar templates into your Google Spreadsheet™.

The following templates are available:
-) For the previous year
-) For the current year
-) For the next year

Each template displays:
-) Month
-) The weekday names
-) The calendar week
-) Day of the month

In addition you can choose your country and get the local holidays highlighted.

3) CODA
Sync your tables directly from Coda into your Google Sheets™.

Also the reversed way - from Google Sheets™ to Coda - can be handled.


➤ ➤ ➤ ISSUES ➤ ➤ ➤ 

1) Only the "Help" menu item does show up
Just reload the page or wait a couple of seconds more, then all menu items will show up.

2) The error message "drive.google.com refuses to connect" shows up within the sidebar
The cause for this error message is that multiple users are logged in within the browser.
Solution 1:
Just log out with all users, except the one which should be used to work with the addon.
Solution 2:
Use a different browser or the incognito mode.

3) The sidebar is completely blank
The cause for this error message is that multiple users are logged in within the browser.
Solution 1:
Just log out with all users, except the one which should be used to work with the addon.
Solution 2:
Use a different browser or the incognito mode.


➤ ➤ ➤ SUPPORT ➤ ➤ ➤ 

Our website offers a FAQ section, with answered questions from other users. In addition you will find a contact form, to get in touch with us.

We are grateful for any feedback and feature requests :)


➤ ➤ ➤ TECHNOLOGY ➤ ➤ ➤ 

The addon uses proxies all over the world to avoid getting blocked. In addition the addon offers the ability to render JavaScript. Currently there is no AI involved but it might be added in the future.
Kiegészítő adatok
ÁrakDíjmentes próbaidőszak
Fejlesztő
Nem végez kereskedelmi tevékenységet
Adatvédelmi irányelvek
Általános Szerződési Feltételek
A(z) SCRABY scrape Yahoo Finance, Amazon, Crypto, Stock az alább látható engedélyeket fogja kérni. További információ
A(z) SCRABY scrape Yahoo Finance, Amazon, Crypto, Stock alkalmazásnak hozzá kell férnie az Ön Google-fiókjához
Ezzel engedélyezi a(z) SCRABY scrape Yahoo Finance, Amazon, Crypto, Stock számára a következőt:
Megtekintheti és kezelheti azokat a táblázatokat, amelyekben ez az alkalmazás telepítve van
Külső webes tartalmak megjelenítése és futtatása a Google-alkalmazásokon belüli kérésekben és oldalsávokban
Kapcsolódás külső szolgáltatáshoz
Alkalmazás engedélyezése, hogy az Ön jelenléte nélkül is fusson
Az Ön elsődleges Google-fiókjához tartozó e-mail-cím megtekintése
Személyes adatainak megtekintése, beleértve azokat a személyes adatokat is, amelyeket Ön nyilvánosan közzétett
Vélemények
Nyelv:
Rendezés alapja:
A Google nem ellenőrzi a véleményeket és az értékeléseket. További információ a véleményekről
Nincs megjegyzés
Keresés
Keresés törlése
A keresés bezárása
Google-alkalmazások
Főmenü