Web3 Sheets is an add-on for Google Sheets™ that empowers users to query Ethereum data directly into their sheets and supports all data types and historical data.
Listing updated:October 31, 2023
Works with:
582
Overview
Web3 Sheets makes utilizing Ethereum data easily accessible from within Google Sheets™. Featuring full historical data for all data types and does not require contracts to be verified on Etherscan.

🔶Web3 Sheets applications 🔶
✅ Multi-chain data in one place
✅ Portfolio tracking
✅ Yield farming calculations
✅ Historical address token balances
✅ Track DAO revenues
✅ Tax preparations
✅ Analyze borrow/lend protocols
✅ Pull current token balances
✅ Onchain asset prices 
✅ Compare oracles
✅ Onchain liquidity analysis
✅ Monitor AMM positions

🔶Supported chains 🔶
➤ Ethereum
➤ Polygon
➤ Optimism
➤ Arbitrum
➤ Gnosis
➤ Binance Chain
➤ Canto
➤ Fantom
➤ Polygon ZK EVM
➤ Arbitrum Nova
➤ Avalanche
➤ Goerli

🔶Multi-chain support function 🔶
➤ EthBalance: for getting the Ether balance of an address
➤ CurrentBlock: returns the current block number
➤ BlockToTimestamp: returns the timestamp of a block
➤ TimestampToBlock: returns the block nearest to a timestamp
➤ CallInt: for functions that return an integer
➤ CallAddress: for functions that return an address
➤ CallStr: for functions that return a string
➤ CallCstr: for functions that return a string
➤ TokenAddressByName: returns the token address
➤ TokenDecimalsByName: returns the token decimals
➤ TokenAddressBySymbol: returns the token address
➤ TokenDecimalsBySymbol: returns the token decimals

🔶Web3 Sheets functions 🔶
➤ Web3SheetsUsage: returns the number of requests made by the owner of the sheet in a month
➤ Web3SheetsCredits: returns the number of requests that the owner of the sheets can make in a month
➤ GfxSheetsVersion: returns the software version of the Add-on

🔶Installing Web3 Sheets 🔶
After having installed our Add-on for Google Sheets™:
1) Install the Add-on
2) Navigate to the spreadsheet you want to use the add-on in
3) Go to Extensions > Add-ons > Manage Add-ons
4) You should see Web3 Sheets. Click the three dots in the top right and select “Use in this document”
Done!

🔶Getting started with Web3 Sheets 🔶
🔹=CurrentBlock() will return the current Ethereum block
🔹=EthBalance(address) will return the ETH balance of the specific address
🔹=CallInt(path, target address, function signature, argument) will return an integer from the target contract and function
🔹=CallAddress(path, target address, function signature, argument) will return an address from the target contract and function
🔹=CallString(path, target address, function signature, argument) will return a string from the target contract and function

🔶Options 🔶
🔹 Any target field can be replaced with COPS(target, blockNumber/latest, chain) to query historical data and non-ethereum calls.
🔹 If you have more than one argument, you simply add it on. For example =callIInt(“”,target address, “getPastVotes(address,uint256)”,  address, blocknumber)
🔹If the function returns an array, utilize the pathing to navigate. =CallInt(“0”, Uniswap v3 Pool address, “observations(uint256)”, observation number)

🔶Pricing 🔶
➤ First 100 requests are free and don’t require sign-up
➤ Free 7-day trials are available
➤ More info available on our site - https://sheets.gfx.xyz/

______________________________________________________________________________________________

❓Need some help?

➤Get started with Web3 Sheets
https://docs.sheets.gfx.xyz/docs/intro

➤ Aave v3 Demo
https://docs.google.com/spreadsheets/d/1SEPA_EKbUD3A7G-2CsmC0Jv247dcZiQWOkzhKPt3cKI/edit?usp=sharing

➤ Many other examples available here: 
https://docs.sheets.gfx.xyz/docs/tutorial/google-sheets

➤ Join our Discord for support or to make feature requests: 
https://discord.gg/RcGZB3X4q9

______________________________________________________________________________________________

Crypto, DeFi, NFT, Bitcoin, BTC, Decentralized
Additional information
PricingFree of charge with paid features
Developer
Non-trader
Privacy policy
Terms of service
Web3 Sheets will ask for the permissions shown below. Learn more
Web3 Sheets will need access to your Google account
This will allow Web3 Sheets to :
See, edit, create, and delete only the specific Google Drive files you use with this app
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Associate you with your personal info on Google
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Getty Hill
December 12, 2022
awesome!
Is this review helpful?
Yes
No
1-1 of 1
Search
Clear search
Close search
Google apps
Main menu