➤ ➤ ➤ 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 :)