Write =SCRAPE(url, selector) in your spreadsheet and import any data from any website! SCRAPE 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! SCRAPE 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 20 URLs per function with as many data points as you want. SCRAPE, 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 =SCRAPE(url, selector) As with SCRAPE, the data to extract needs to be described using CSS selectors. We also are working on offering 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 =SCRAPE(“https://finance.yahoo.com/quote/AAPL”, ".dividend.price.marketCap") Scrape product data from Amazon typing =SCRAPE(“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 / queries to describe the data to be captured OR soon 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 MOLE 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 MOLE will never transfer nor sell them to 3d parties. We will never save the content of your Google Sheets. PRICING Try the add-on for free for 1 month with 1000 credits (currently free to use). No credit card required ! Then, choose between our plans according to the number of requests you need. No risk, we offer a 7-day money back guarantee ! SUPPORT ✓ Have a look at our repository of resources and demos at our website ✓ Check out our ready-to-use templates for the most popular platforms (soon to come) ✓ Browse our tutorials on our Youtube channel ✓ Contact us and we’ll help you to get the most of our add-on -------------- Many users of ImportFromWeb, Import JSON, Supermetrics, Mixed Analytics, KPI bees, DataConnector, SheetGo, Google Analytics, Autocrat and Power Tools already love our scraper. MOLE is among the best add-ons for Google Sheets ! ➤ ➤ ➤ 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 scraping 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 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. Amazon scrape), trend monitoring, eCommerce competitor analysis (e.g. scrape Amazon), stock trader (e.g. scrape dividend data, scrape stock price), Social Media marketing (e.g. scrape Facebook), crypto trader (e.g. scrape crypto price) - 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 :)