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
Listing updated:November 13, 2024
Works with:
313K+
Overview
➤ ➤ ➤ 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.
Additional information
PricingFree of charge trial
Developer
Non-trader
Privacy policy
Terms of service
SCRABY scrape Yahoo Finance, Amazon, Crypto, Stock will ask for the permissions shown below. Learn more
SCRABY scrape Yahoo Finance, Amazon, Crypto, Stock will need access to your Google account
This will allow SCRABY scrape Yahoo Finance, Amazon, Crypto, Stock to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Loading
Search
Clear search
Close search
Google apps
Main menu