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
정보 업데이트:2024년 11월 13일
호환 기기:
31만+
개요
➤ ➤ ➤ 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 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
리뷰
언어:
정렬 기준:
Google에서는 리뷰나 평점을 확인하지 않습니다. 리뷰에 대해 자세히 알아보기
Profile Picture
Hyun-Kyu Kim
2024년 6월 9일
Awesome work! It perfectly works and easy to handle!
이 리뷰가 도움이 되었나요?
아니요
1-1 / 1
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴