How to Auto Refresh the ImportXML formula in Google Sheets with Apps Script Trigger
Using the ImportXML function is great in Google Sheets, but at the request of a user, I'm adding an additional tutorial on how to automate the formula and get the latest prices.
Steps done in this video:
1. Use a macro for Google Sheets
2. View the macro in Apps Script
3. Set up a trigger to refresh hourly
RESOURCES
=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