How to Use ImportXML or ImportHTML for Google Sheets ( CoinGecko Example )
For some reason Google Sheet's IMPORTXML function is broken with some sites. If you are having problems pulling information from CoinGecko, give this a try.
Steps done in this video:
1. Create a new Google Sheet
2. Create a public portfolio on CG
3. Input the formula
RESOURCES
https://twitter.com/nicksnotions/stat...
=IMPORTXML(B1,"//tr") https://support.google.com/docs/answe...
https://www.coingecko.com/en/portfoli...
Be Secure and Buy a Ledger (referral): https://shop.ledger.com?r=83ca99a3bacb
Start with VaporNodes
https://app.vapornodes.finance/nodes?...
#CoinGecko #GoogleSheets #Tutorial