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
Разработчик:
Данные обновлены:13 ноября 2024 г.
Совместимо с:
315 тыс.+
Общие сведения
➤ ➤ ➤ 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.
Дополнительная информация
ЦеныДоступен бесплатный пробный период.
Разработчик
Не продавец
Политика конфиденциальности
Условия использования
Приложение "SCRABY scrape Yahoo Finance, Amazon, Crypto, Stock" запросит указанные ниже разрешения. Подробнее…
Приложению "SCRABY scrape Yahoo Finance, Amazon, Crypto, Stock" потребуется доступ к вашему аккаунту Google.
Приложение SCRABY scrape Yahoo Finance, Amazon, Crypto, Stock сможет:
Просмотр электронных таблиц, в которые встроено данное приложение, и управление ими
Отображение и выполнение внешнего веб-контента в уведомлениях и на боковых панелях приложений Google
Подключение к внешнему сервису
Работа приложения во время отсутствия пользователя
Просмотр основного адреса электронной почты вашего аккаунта Google
Просмотр ваших личных данных, в том числе общедоступных
Loading
Поиск
Очистить поле поиска
Закрыть поиск
Приложения Google
Главное меню