Import Cryptocurrency Live Data In Google Sheets (Template Free Download)

Описание: Important: Giving this method is outdated I have came with a more robust, stable, and flexible solution:    • Import Live Cryptocurrency Price (And More...  

From one of my previous video "Import Cryptocurrency Price In Real Time In Google Sheets (   • Import Cryptocurrency Price In Real Time I...  )", I shared how we can use IMPORTXML function to import cryptocurrency price in real life. However, after some feedback, I noticed there were a couple of limitations need to be added. In this follow up web scraping crypto data in Google Sheets tutorial, we will 1) build a more complete crypto scraper template for re-usability, 2) create a macro to update crypto data, and 3) insert a time trigger to automatically update crypto information.

PS: Looks like the API is broken, please see updated video here:    • Import Live Cryptocurrency Price (And More...  

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: https://www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we'll both get a free stock: https://bit.ly/3iWr7LC

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
🌳 Becoming a Patreon supporter:   / jiejenn  
🛒 By shopping on Amazon → https://amzn.to/2JkGeMD
📘 Facebook Page →   / madeinpython  
📘 More tutorial videos on my website → https://LearnDataAnalysis.org
✉️ Business Inquiring: [email protected]

⏰ Timestamp:
00:00 - Intro & Agenda
01:10 - Crypto Scraper Template Demo
04:45 - Dive Into The Tutorial
14:40 - App Script Code To Update Crypto Data
21:00 - Add Time Trigger To Auto Refresh Crypto Data

#Sheets #GoogleSheets #Cryptocurrency #Crypto #webscraping